Task Store Lab

Build a simple task store backed by database/sql. A minimal mock driver is provided in the starter code so your solution runs in the Go Playground without a real database.

What to implement

1. createTable(db *sql.DB) — execute a CREATE TABLE IF NOT EXISTS statement for the tasks table:

2. insertTask(db *sql.DB, title string) int64 — insert a new task with the given title (done=0). Return the ID from result.LastInsertId().

3. listTasks(db *sql.DB) []Task — query all rows, iterate with rows.Next(), scan each into a Task, and return the slice. Use defer rows.Close().

4. markDone(db *sql.DB, id int64) — update the task's done column to 1.

Task struct

main()

The main function should:

1. Open the mock DB with sql.Open("mock", "mock://")
2. Call createTable
3. Insert two tasks: "Buy groceries" and "Write tests"
4. List all tasks and print each one
5. Mark the first task done
6. List again and print updated results

Expected output (approximate)

The mock driver returns deterministic results — see the starter code. Your SQL strings are validated by pattern matching; the mock driver accepts any query.