Function main

scripts_python/extract_task_details.py:163–263

Main function to extract task details and generate CSV. Args: output_file: Optional path to save the TSV file to quiet: If True, suppress verbose output

(output_file: Path | None = None, quiet: bool = False)

def main(output_file: Path | None = None, quiet: bool = False):
    """Main function to extract task details and generate CSV.

    Args:
        output_file: Optional path to save the TSV file to
        quiet: If True, suppress verbose output
    """
    # Get the tasks directory
    script_dir = Path(__file__).parent
    project_root = script_dir.parent
    tasks_dir = project_root / "tasks"

    if not tasks_dir.exists():
        print(f"Error: Tasks directory not found at {tasks_dir}")
        sys.exit(1)

    if not quiet:
        print(f"Extracting task details from {tasks_dir}...")

    # Extract task details
    task_details = extract_task_details(tasks_dir)

    if not task_details:
        print("No task details found!")
        sys.exit(1)

    # Create DataFrame
    df = pd.DataFrame(task_details)

    # Reorder columns as requested
    column_order = [
        "status",
        "task_id",
        "database_types",
        "project_types",
        "project_name",
        "database_name",
        "key",
        "description",
        "prompt",
        "notes",
        "difficulty",
        "tags",
    ]

    df = df[column_order]

    # Sort by task_id and key
    df = df.sort_values(["task_id", "key"])

    # Generate TSV for clipboard (better for Google Sheets)
    tsv_content = df.to_csv(index=False, sep="\t")

    # Save to file if output_file is provided
    if output_file:
        output_file.parent.mkdir(parents=True, exist_ok=True)
        with open(output_file, "w", encoding="utf-8") as f:
            f.write(tsv_content)