Model Showdown: Benchmarking Local vs Cloud LLMs on a Real Coding Task

while True:
    action = input("Enter a command (add, list, complete, delete): ")

print("Todo App Menu:")
print("               ---")
print("add - Add a new todo      ")
print("list - List all todos     ")
cmd = input("Enter command: ").strip().lower()

        print(f"{'ID':<5} {'Status':<8} {'Title':<40} {'Created At'}")
        print('-' * 70)
        for row in rows:
            id_, title, created_at, completed = row
            status = "[X]" if completed else "[ ]"
            print(f"{

class TodoApp:
    def __init__(self, db_path: str = "todos.db"):
        self.db_path = db_path
        self.init_database()

    def add_todo(self, title: str):
        # ...
        print(f"✅ Added todo #{todo_id}: {title.strip()}")

class TodoApp:
    def __init__(self, db_path: str = "todos.db"):
        self.conn = sqlite3.connect(db_path)
        self.conn.row_factory = sqlite3.Row
        self.create_table()

def list_todos():
    # ...
    for row in rows:
        status = "[x]" if row[3] else "[ ]"
        print(f"{row[0]:<3} {status} {row[1]} (created at: {row[2]})")

import sqlite3
import argparse
import datetime
from typing import List, Tuple

class TodoApp:
    def __init__(self, db_path: str = "todos.db"):
        self.db_path = db_path
        self.init_database()

    def init_database(self):
        """Initialize the SQLite database and create the todos table if it doesn't exist."""
        conn = sqlite3.connect(self.db_path)
        cursor = conn.cursor()
        cursor.execute("""
            CREATE TABLE IF NOT EXISTS todos (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                title TEXT NOT NULL,
                created_at TEXT NOT NULL,
                completed INTEGER NOT NULL DEFAULT 0
            )
        """)
        conn.commit()
        conn.close()

    def add_todo(self, title: str):
        """Add a new todo item."""
        if not title.strip():
            print("❌ Error: Todo title cannot be empty")
            return

        conn = sqlite3.connect(self.db_path)
        cursor = conn.cursor()
        created_at = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
        cursor.execute(
            "INSERT INTO todos (title, created_at, completed) VALUES (?, ?, 0)",
            (title.strip(), created_at)
        )
        conn.commit()
        todo_id = cursor.lastrowid
        conn.close()
        print(f"✅ Added todo #{todo_id}: {title.strip()}")

    def list_todos(self):
        """List all todo items."""
        conn = sqlite3.connect(self.db_path)
        cursor = conn.cursor()
        cursor.execute("SELECT id, title, created_at, completed FROM todos ORDER BY id")
        todos = cursor.fetchall()
        conn.close()

        if not todos:
            print("📝 No todos found. Add some with: python todo.py add \"Your task\"")
            return

        print("\n📋 Your Todos:")
        print("-" * 60)
        for todo_id, title, created_at, completed in todos:
            status = "✓" if completed else "○"
            status_text = "DONE" if completed else "TODO"
            print(f"{status} #{todo_id:<3} [{status_text}] {title}")
            print(f"    📅 Created: {created_at}")
        print("-" * 60)
        print(f"Total: {len(todos)} todos")

    def complete_todo(self, todo_id: int):
        """Mark a todo as completed."""
        conn = sqlite3.connect(self.db_path)
        cursor = conn.cursor()

        cursor.execute("SELECT id, title, completed FROM todos WHERE id = ?", (todo_id,))
        todo = cursor.fetchone()

        if not todo:
            print(f"❌ Error: Todo #{todo_id} not found")
            conn.close()
            return

        if todo[2]:
            print(f"ℹ️  Todo #{todo_id} is already completed")
            conn.close()
            return

        cursor.execute("UPDATE todos SET completed = 1 WHERE id = ?", (todo_id,))
        conn.commit()
        conn.close()
        print(f"✅ Completed todo #{todo_id}: {todo[1]}")

    def delete_todo(self, todo_id: int):
        """Delete a todo item."""
        conn = sqlite3.connect(self.db_path)
        cursor = conn.cursor()

        cursor.execute("SELECT id, title FROM todos WHERE id = ?", (todo_id,))
        todo = cursor.fetchone()

        if not todo:
            print(f"❌ Error: Todo #{todo_id} not found")
            conn.close()
            return

        cursor.execute("DELETE FROM todos WHERE id = ?", (todo_id,))
        conn.commit()
        conn.close()
        print(f"🗑️  Deleted todo #{todo_id}: {todo[1]}")

def main():
    app = TodoApp()

    parser = argparse.ArgumentParser(description="A simple command-line todo application")
    subparsers = parser.add_subparsers(dest="command", help="Available commands")

    add_parser = subparsers.add_parser("add", help="Add a new todo")
    add_parser.add_argument("title", help="Todo title")

    list_parser = subparsers.add_parser("list", help="List all todos")

    complete_parser = subparsers.add_parser("complete", help="Mark a todo as completed")
    complete_parser.add_argument("id", type=int, help="Todo ID to complete")

    delete_parser = subparsers.add_parser("delete", help="Delete a todo")
    delete_parser.add_argument("id", type=int, help="Todo ID to delete")

    args = parser.parse_args()

    try:
        if args.command == "add":
            app.add_todo(args.title)
        elif args.command == "list":
            app.list_todos()
        elif args.command == "complete":
            app.complete_todo(args.id)
        elif args.command == "delete":
            app.delete_todo(args.id)
        else:
            parser.print_help()
    except Exception as e:
        print(f"❌ Error: {str(e)}")

if __name__ == "__main__":
    main()

import sqlite3
import sys
from datetime import datetime
from typing import List, Tuple

class TodoApp:
    def __init__(self, db_path: str = "todos.db"):
        self.conn = sqlite3.connect(db_path)
        self.conn.row_factory = sqlite3.Row
        self.create_table()

    def create_table(self):
        self.conn.execute("""
            CREATE TABLE IF NOT EXISTS todos (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                title TEXT NOT NULL,
                created_at TIMESTAMP NOT NULL,
                completed BOOLEAN NOT NULL DEFAULT 0
            )
        """)
        self.conn.commit()

    def add(self, title: str) -> None:
        if not title.strip():
            print("Error: Todo title cannot be empty")
            return

        try:
            self.conn.execute(
                "INSERT INTO todos (title, created_at) VALUES (?, ?)",
                (title, datetime.now())
            )
            self.conn.commit()
            print(f"✓ Added todo: '{title}'")
        except Exception as e:
            print(f"Error: Failed to add todo - {e}")

    def list(self) -> None:
        try:
            cursor = self.conn.execute(
                "SELECT * FROM todos ORDER BY created_at DESC"
            )
            todos = cursor.fetchall()

            if not todos:
                print("No todos found. Add one with 'add <title>'")
                return

            print("\n" + "="*60)
            print("TODO LIST")
            print("="*60)

            for todo in todos:
                status = "✓" if todo["completed"] else "○"
                created = datetime.fromisoformat(todo["created_at"]).strftime("%Y-%m-%d %H:%M")
                print(f"{status} [{todo['id']}] {todo['title']}")
                print(f"   Created: {created}")
                print("-"*60)
        except Exception as e:
            print(f"Error: Failed to list todos - {e}")

    def complete(self, todo_id: str) -> None:
        try:
            todo_id = int(todo_id)
        except ValueError:
            print("Error: Invalid todo ID. Must be a number.")
            return

        try:
            cursor = self.conn.execute(
                "UPDATE todos SET completed = 1 WHERE id = ?",
                (todo_id,)
            )

            if cursor.rowcount == 0:
                print(f"Error: Todo with ID {todo_id} not found")
            else:
                self.conn.commit()
                print(f"✓ Completed todo {todo_id}")
        except Exception as e:
            print(f"Error: Failed to complete todo - {e}")

    def delete(self, todo_id: str) -> None:
        try:
            todo_id = int(todo_id)
        except ValueError:
            print("Error: Invalid todo ID. Must be a number.")
            return

        try:
            cursor = self.conn.execute(
                "DELETE FROM todos WHERE id = ?",
                (todo_id,)
            )

            if cursor.rowcount == 0:
                print(f"Error: Todo with ID {todo_id} not found")
            else:
                self.conn.commit()
                print(f"✓ Deleted todo {todo_id}")
        except Exception as e:
            print(f"Error: Failed to delete todo - {e}")

    def close(self):
        self.conn.close()

def print_usage():
    print("""
Usage:
    python todo.py add <title>      - Add a new todo
    python todo.py list             - List all todos
    python todo.py complete <id>    - Mark a todo as completed
    python todo.py delete <id>      - Delete a todo
    """)

if __name__ == "__main__":
    app = TodoApp()

    if len(sys.argv) < 2:
        print_usage()
        sys.exit(1)

    command = sys.argv[1].lower()

    try:
        if command == "add":
            if len(sys.argv) < 3:
                print("Error: Please provide a todo title")
                print("Usage: python todo.py add <title>")
            else:
                title = " ".join(sys.argv[2:])
                app.add(title)

        elif command == "list":
            app.list()

        elif command == "complete":
            if len(sys.argv) < 3:
                print("Error: Please provide a todo ID")
                print("Usage: python todo.py complete <id>")
            else:
                app.complete(sys.argv[2])

        elif command == "delete":
            if len(sys.argv) < 3:
                print("Error: Please provide a todo ID")
                print("Usage: python todo.py delete <id>")
            else:
                app.delete(sys.argv[2])

        else:
            print(f"Error: Unknown command '{command}'")
            print_usage()
            sys.exit(1)

    finally:
        app.close()

import sqlite3
from datetime import datetime
import argparse
import sys

DATABASE = 'todos.db'

def init_db():
    conn = sqlite3.connect(DATABASE)
    c = conn.cursor()
    c.execute('''CREATE TABLE IF NOT EXISTS todos (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                title TEXT NOT NULL,
                created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                completed BOOLEAN NOT NULL CHECK (completed IN (0, 1))
              )''')
    conn.commit()
    conn.close()

def add_todo(title):
    conn = sqlite3.connect(DATABASE)
    c = conn.cursor()
    c.execute("INSERT INTO todos (title, completed) VALUES (?, ?)", (title, False))
    conn.commit()
    conn.close()

def list_todos():
    conn = sqlite3.connect(DATABASE)
    c = conn.cursor()
    c.execute("SELECT id, title, created_at, completed FROM todos ORDER BY completed, created_at")
    rows = c.fetchall()
    conn.close()

    for row in rows:
        status = "[x]" if row[3] else "[ ]"
        print(f"{row[0]:<3} {status} {row[1]} (created at: {row[2]})")

def complete_todo(id):
    conn = sqlite3.connect(DATABASE)
    c = conn.cursor()
    c.execute("UPDATE todos SET completed = 1 WHERE id = ?", (id,))
    rows_affected = c.rowcount
    conn.commit()
    conn.close()

    if rows_affected == 0:
        raise ValueError(f"Todo with ID {id} not found.")

def delete_todo(id):
    conn = sqlite3.connect(DATABASE)
    c = conn.cursor()
    c.execute("DELETE FROM todos WHERE id = ?", (id,))
    rows_affected = c.rowcount
    conn.commit()
    conn.close()

    if rows_affected == 0:
        raise ValueError(f"Todo with ID {id} not found.")

def main():
    parser = argparse.ArgumentParser(description='CLI todo application')
    subparsers = parser.add_subparsers(dest='command')

    add_parser = subparsers.add_parser('add', help='Add a new todo')
    add_parser.add_argument('title', type=str, help='Todo title')

    list_parser = subparsers.add_parser('list', help='List all todos')

    complete_parser = subparsers.add_parser('complete', help='Mark a todo as completed')
    complete_parser.add_argument('id', type=int, help='TODO ID to mark as completed')

    delete_parser = subparsers.add_parser('delete', help='Delete a todo')
    delete_parser.add_argument('id', type=int, help='TODO ID to delete')

    args = parser.parse_args()

    init_db()

    try:
        if args.command == 'add':
            add_todo(args.title)
        elif args.command == 'list':
            list_todos()
        elif args.command == 'complete':
            complete_todo(args.id)
        elif args.command == 'delete':
            delete_todo(args.id)
        else:
            parser.print_help()
    except Exception as e:
        print(f"Error: {e}")
        sys.exit(1)

if __name__ == '__main__':
    main()