peert/protastim - Change F7GINXIOPOJ3XYCVADCLWPMVYWFE7NQ7HGOBSJJMCS6O6TAHLQQQC

Updated schema with start_at, due_at, completed_at

Created by peert on April 15, 2025

F7GINXIOPOJ3XYCVADCLWPMVYWFE7NQ7HGOBSJJMCS6O6TAHLQQQC

Dependencies

In channels

main

Change contents

Insertion in internal/sql/schema/0003_create_time_entries_table.sql at line 3 [3.1389]
[3.1431]
[3.1431]
```
  id INTEGER PRIMARY KEY,
```

Replacement in internal/sql/schema/0002_create_tasks_table.sql at line 6 [3.708]

B:BD[3.811] → [3.811:890]

  status TEXT NOT NULL DEFAULT 'N' CHECK(status IN ('N', 'P', 'C', 'H', 'D')),

[3.811]

[3.890]

  start_at DATE,
  due_at DATE,
  completed_at DATE,

Replacement in internal/sql/schema/0001_create_projects_table.sql at line 6 [3.55]

B:BD[3.161] → [3.161:240]

  status TEXT NOT NULL DEFAULT 'N' CHECK(status IN ('N', 'P', 'C', 'H', 'D')),

[3.161]

[3.240]

  start_at DATE,
  due_at DATE,
  completed_at DATE,

File deletion: task.sql

BF:BFD[5.17] → [6.3638:3670]

BF:BFD[6.3670] → [6.3671:3671]

B:BD[6.3671] → [6.3672:3776]

∅:D[4.93] → [6.3776:4356]

B:BD[6.3776] → [6.3776:4356]

B:BD[6.3776] → [4.0:93]

-- name: GetTask :one
SELECT * FROM tasks WHERE id = ?;
-- name: ListTasks :many
SELECT * FROM tasks;
-- name: CreateTask :one
INSERT INTO tasks (name, description, status, project_id)
VALUES (?, ?, ?, ?)
RETURNING *;
-- name: UpdateTask :one
UPDATE tasks
SET
  name = IIF(CAST(@set_name AS BOOLEAN), CAST(@name AS TEXT), name),
  description = IIF(CAST(@set_description AS BOOLEAN), CAST(sqlc.narg('description') AS TEXT), description),
  status = IIF(CAST(@set_status AS BOOLEAN), CAST(@status AS TEXT), status)
WHERE id = ?
RETURNING *;
-- name: MoveTask :one
UPDATE tasks
SET project_id = ?
WHERE id = ?
RETURNING *;
-- name: DeleteTask :exec
DELETE FROM tasks WHERE id = ?;
-- name: ListTasksByProject :many
SELECT * FROM tasks WHERE project_id = ? ORDER BY status;

Insertion in internal/sql/query/projects.sql at line 6 [5.56]

[5.172]


-- name: ListProjectsStarted :many
SELECT *
FROM projects
WHERE start_at <= DATE() AND (completed_at IS NULL OR completed_at >= date('now', '-7 days'))
ORDER BY due_at;

Insertion in internal/sql/query/projects.sql at line 13 [5.56]

[5.173]

-- name: ListProjectsOverdue :many
SELECT * FROM projects WHERE due_at <= DATE() AND completed_at IS NULL;

Replacement in internal/sql/query/projects.sql at line 17 [5.56]

B:BD[5.201] → [2.0:66]

INSERT INTO projects (name, description, status)
VALUES (?, ?, ?)

[5.201]

[5.345]

INSERT INTO projects (name, description, start_at, due_at, completed_at)
VALUES (?, ?, ?, ?, ?)

Replacement in internal/sql/query/projects.sql at line 24 [5.56]

B:BD[5.407] → [5.407:585]

B:BD[5.585] → [2.67:143]

  name = IIF(CAST(@set_name AS BOOLEAN), CAST(@name AS TEXT), name),
  description = IIF(CAST(@set_description AS BOOLEAN), CAST(sqlc.narg('description') AS TEXT), description),
  status = IIF(CAST(@set_status AS BOOLEAN), CAST(@status AS TEXT), status)

[5.407]

[5.1251]

  name = ?,
  description = ?,
  start_at = ?,
  due_at = ?,
  completed_at = ?

File deletion: task.sql.go

BF:BFD[7.20] → [6.0:35]

BF:BFD[6.35] → [6.36:36]

B:BD[6.36] → [6.37:2171]

∅:D[4.887] → [6.2171:3637]

B:BD[6.2171] → [6.2171:3637]

B:BD[6.2171] → [4.94:887]

// Code generated by sqlc. DO NOT EDIT.
// versions:
//   sqlc v1.28.0
// source: task.sql
package database
import (
	"context"
	"database/sql"
)
const createTask = `-- name: CreateTask :one
INSERT INTO tasks (name, description, status, project_id)
VALUES (?, ?, ?, ?)
RETURNING id, name, description, status, project_id, created_at, updated_at
`
type CreateTaskParams struct {
	Name        string
	Description sql.NullString
	Status      string
	ProjectID   int64
}
func (q *Queries) CreateTask(ctx context.Context, arg CreateTaskParams) (Task, error) {
	row := q.db.QueryRowContext(ctx, createTask,
		arg.Name,
		arg.Description,
		arg.Status,
		arg.ProjectID,
	)
	var i Task
	err := row.Scan(
		&i.ID,
		&i.Name,
		&i.Description,
		&i.Status,
		&i.ProjectID,
		&i.CreatedAt,
		&i.UpdatedAt,
	)
	return i, err
}
const deleteTask = `-- name: DeleteTask :exec
DELETE FROM tasks WHERE id = ?
`
func (q *Queries) DeleteTask(ctx context.Context, id int64) error {
	_, err := q.db.ExecContext(ctx, deleteTask, id)
	return err
}
const getTask = `-- name: GetTask :one
SELECT id, name, description, status, project_id, created_at, updated_at FROM tasks WHERE id = ?
`
func (q *Queries) GetTask(ctx context.Context, id int64) (Task, error) {
	row := q.db.QueryRowContext(ctx, getTask, id)
	var i Task
	err := row.Scan(
		&i.ID,
		&i.Name,
		&i.Description,
		&i.Status,
		&i.ProjectID,
		&i.CreatedAt,
		&i.UpdatedAt,
	)
	return i, err
}
const listTasks = `-- name: ListTasks :many
SELECT id, name, description, status, project_id, created_at, updated_at FROM tasks
`
func (q *Queries) ListTasks(ctx context.Context) ([]Task, error) {
	rows, err := q.db.QueryContext(ctx, listTasks)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []Task
	for rows.Next() {
		var i Task
		if err := rows.Scan(
			&i.ID,
			&i.Name,
			&i.Description,
			&i.Status,
			&i.ProjectID,
			&i.CreatedAt,
			&i.UpdatedAt,
		); err != nil {
			return nil, err
		}
		items = append(items, i)
	}
	if err := rows.Close(); err != nil {
		return nil, err
	}
	if err := rows.Err(); err != nil {
		return nil, err
	}
	return items, nil
}
const moveTask = `-- name: MoveTask :one
UPDATE tasks
SET project_id = ?
WHERE id = ?
RETURNING id, name, description, status, project_id, created_at, updated_at
`
type MoveTaskParams struct {
	ProjectID int64
	ID        int64
}
func (q *Queries) MoveTask(ctx context.Context, arg MoveTaskParams) (Task, error) {
	row := q.db.QueryRowContext(ctx, moveTask, arg.ProjectID, arg.ID)
	var i Task
	err := row.Scan(
		&i.ID,
		&i.Name,
		&i.Description,
		&i.Status,
		&i.ProjectID,
		&i.CreatedAt,
		&i.UpdatedAt,
	)
	return i, err
}
const updateTask = `-- name: UpdateTask :one
UPDATE tasks
SET
  name = IIF(CAST(? AS BOOLEAN), CAST(? AS TEXT), name),
  description = IIF(CAST(? AS BOOLEAN), CAST(?5 AS TEXT), description),
  status = IIF(CAST(? AS BOOLEAN), CAST(? AS TEXT), status)
WHERE id = ?
RETURNING id, name, description, status, project_id, created_at, updated_at
`
type UpdateTaskParams struct {
	SetName        bool
	Name           string
	SetDescription bool
	Description    sql.NullString
	SetStatus      bool
	Status         string
	ID             int64
}
func (q *Queries) UpdateTask(ctx context.Context, arg UpdateTaskParams) (Task, error) {
	row := q.db.QueryRowContext(ctx, updateTask,
		arg.SetName,
		arg.Name,
		arg.SetDescription,
		arg.Description,
		arg.SetStatus,
		arg.Status,
		arg.ID,
	)
	var i Task
	err := row.Scan(
		&i.ID,
		&i.Name,
		&i.Description,
		&i.Status,
		&i.ProjectID,
		&i.CreatedAt,
		&i.UpdatedAt,
	)
	return i, err
}
const listTasksByProject = `-- name: ListTasksByProject :many
SELECT id, name, description, status, project_id, created_at, updated_at FROM tasks WHERE project_id = ? ORDER BY status
`
func (q *Queries) ListTasksByProject(ctx context.Context, projectID int64) ([]Task, error) {
	rows, err := q.db.QueryContext(ctx, listTasksByProject, projectID)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []Task
	for rows.Next() {
		var i Task
		if err := rows.Scan(
			&i.ID,
			&i.Name,
			&i.Description,
			&i.Status,
			&i.ProjectID,
			&i.CreatedAt,
			&i.UpdatedAt,
		); err != nil {
			return nil, err
		}
		items = append(items, i)
	}
	if err := rows.Close(); err != nil {
		return nil, err
	}
	if err := rows.Err(); err != nil {
		return nil, err
	}
	return items, nil
}

Replacement in internal/database/projects.sql.go at line 14 [7.1343]

B:BD[7.1548] → [7.1548:1678]

INSERT INTO projects (name, description, status)
VALUES (?, ?, ?)
RETURNING id, name, description, status, created_at, updated_at

[7.1548]

[7.1678]

INSERT INTO projects (name, description, start_at, due_at, completed_at)
VALUES (?, ?, ?, ?, ?)
RETURNING id, name, description, start_at, due_at, completed_at, created_at, updated_at

Replacement in internal/database/projects.sql.go at line 22 [7.1343]
B:BD[7.1763] → [7.1763:1783]
```
	Status      string
```
[7.1763]
[7.1783]
```
	StartAt     sql.NullTime
	DueAt       sql.NullTime
	CompletedAt sql.NullTime
```

Replacement in internal/database/projects.sql.go at line 28 [7.1343]

B:BD[7.1883] → [7.1883:1971]

	row := q.db.QueryRowContext(ctx, createProject, arg.Name, arg.Description, arg.Status)

[7.1883]

[7.1971]

	row := q.db.QueryRowContext(ctx, createProject,
		arg.Name,
		arg.Description,
		arg.StartAt,
		arg.DueAt,
		arg.CompletedAt,
	)

Replacement in internal/database/projects.sql.go at line 40 [7.1343]
B:BD[7.2042] → [7.2042:2055]
```
		&i.Status,
```
[7.2042]
[7.2055]
```
		&i.StartAt,
		&i.DueAt,
		&i.CompletedAt,
```

Replacement in internal/database/projects.sql.go at line 59 [7.1343]

B:BD[7.2380] → [7.2380:2468]

SELECT id, name, description, status, created_at, updated_at FROM projects WHERE id = ?

[7.2380]

[7.2468]

SELECT id, name, description, start_at, due_at, completed_at, created_at, updated_at FROM projects WHERE id = ?

Replacement in internal/database/projects.sql.go at line 69 [7.1343]
B:BD[7.2671] → [7.2671:2684]
```
		&i.Status,
```
[7.2671]
[7.2684]
```
		&i.StartAt,
		&i.DueAt,
		&i.CompletedAt,
```

Replacement in internal/database/projects.sql.go at line 79 [7.1343]

B:BD[7.2787] → [7.2787:2862]

SELECT id, name, description, status, created_at, updated_at FROM projects

[7.2787]

[7.2862]

SELECT id, name, description, start_at, due_at, completed_at, created_at, updated_at FROM projects

Insertion in internal/database/projects.sql.go at line 84 [7.1343]

[7.2989]

	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []Project
	for rows.Next() {
		var i Project
		if err := rows.Scan(
			&i.ID,
			&i.Name,
			&i.Description,
			&i.StartAt,
			&i.DueAt,
			&i.CompletedAt,
			&i.CreatedAt,
			&i.UpdatedAt,
		); err != nil {
			return nil, err
		}
		items = append(items, i)
	}
	if err := rows.Close(); err != nil {
		return nil, err
	}
	if err := rows.Err(); err != nil {
		return nil, err
	}
	return items, nil
}
const listProjectsOverdue = `-- name: ListProjectsOverdue :many
SELECT id, name, description, start_at, due_at, completed_at, created_at, updated_at FROM projects WHERE due_at <= DATE() AND completed_at IS NULL
`
func (q *Queries) ListProjectsOverdue(ctx context.Context) ([]Project, error) {
	rows, err := q.db.QueryContext(ctx, listProjectsOverdue)

Replacement in internal/database/projects.sql.go at line 131 [7.1343]

B:BD[7.3167] → [7.3167:3181]

			&i.Status,

[7.3167]

[7.3181]

			&i.StartAt,
			&i.DueAt,
			&i.CompletedAt,
			&i.CreatedAt,
			&i.UpdatedAt,
		); err != nil {
			return nil, err
		}
		items = append(items, i)
	}
	if err := rows.Close(); err != nil {
		return nil, err
	}
	if err := rows.Err(); err != nil {
		return nil, err
	}
	return items, nil
}
const listProjectsStarted = `-- name: ListProjectsStarted :many
SELECT id, name, description, start_at, due_at, completed_at, created_at, updated_at
FROM projects
WHERE start_at <= DATE() AND (completed_at IS NULL OR completed_at >= date('now', '-7 days'))
ORDER BY due_at
`
func (q *Queries) ListProjectsStarted(ctx context.Context) ([]Project, error) {
	rows, err := q.db.QueryContext(ctx, listProjectsStarted)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []Project
	for rows.Next() {
		var i Project
		if err := rows.Scan(
			&i.ID,
			&i.Name,
			&i.Description,
			&i.StartAt,
			&i.DueAt,
			&i.CompletedAt,

Replacement in internal/database/projects.sql.go at line 192 [7.1343]

B:BD[7.3495] → [7.3495:3684]

  name = IIF(CAST(? AS BOOLEAN), CAST(? AS TEXT), name),
  description = IIF(CAST(? AS BOOLEAN), CAST(?5 AS TEXT), description),
  status = IIF(CAST(? AS BOOLEAN), CAST(? AS TEXT), status)

[7.3495]

[7.3684]

  name = ?,
  description = ?,
  start_at = ?,
  due_at = ?,
  completed_at = ?

Replacement in internal/database/projects.sql.go at line 198 [7.1343]

B:BD[7.3697] → [7.3697:3761]

RETURNING id, name, description, status, created_at, updated_at

[7.3697]

[7.3761]

RETURNING id, name, description, start_at, due_at, completed_at, created_at, updated_at

Replacement in internal/database/projects.sql.go at line 202 [7.1343]

B:BD[7.3798] → [7.3798:3960]

	SetName        bool
	Name           string
	SetDescription bool
	Description    sql.NullString
	SetStatus      bool
	Status         string
	ID             int64

[7.3798]

[7.3960]

	Name        string
	Description sql.NullString
	StartAt     sql.NullTime
	DueAt       sql.NullTime
	CompletedAt sql.NullTime
	ID          int64

Deletion in internal/database/projects.sql.go at line 212 [7.1343]
B:BD[7.4109] → [7.4109:4124]
```
		arg.SetName,
```
Deletion in internal/database/projects.sql.go at line 213 [7.1343]
B:BD[7.4136] → [7.4136:4158]
```
		arg.SetDescription,
```
Replacement in internal/database/projects.sql.go at line 214 [7.1343]
B:BD[7.4177] → [7.4177:4208]
```
		arg.SetStatus,
		arg.Status,
```
[7.4177]
[7.4208]
```
		arg.StartAt,
		arg.DueAt,
		arg.CompletedAt,
```
Replacement in internal/database/projects.sql.go at line 224 [7.1343]
B:BD[7.4292] → [7.4292:4305]
```
		&i.Status,
```
[7.4292]
[7.4305]
```
		&i.StartAt,
		&i.DueAt,
		&i.CompletedAt,
```
Replacement in internal/database/models.go at line 16 [7.689]
B:BD[7.905] → [7.905:925]
```
	Status      string
```
[7.905]
[7.925]
```
	StartAt     sql.NullTime
	DueAt       sql.NullTime
	CompletedAt sql.NullTime
```
Replacement in internal/database/models.go at line 27 [7.689]
B:BD[7.1060] → [7.1060:1080]
```
	Status      string
```
[7.1060]
[7.1080]
```
	StartAt     sql.NullTime
	DueAt       sql.NullTime
	CompletedAt sql.NullTime
```
Insertion in internal/database/models.go at line 36 [7.689]
[7.1172]
[7.1172]
```
	ID        int64
```

Updated schema with start_at, due_at, completed_at

Dependencies

In channels

Change contents

Insertion in internal/sql/schema/0003_create_time_entries_table.sql at line 3 [3.1389]

Replacement in internal/sql/schema/0002_create_tasks_table.sql at line 6 [3.708]

Replacement in internal/sql/schema/0001_create_projects_table.sql at line 6 [3.55]

File deletion: task.sql

Insertion in internal/sql/query/projects.sql at line 6 [5.56]

Insertion in internal/sql/query/projects.sql at line 13 [5.56]

Replacement in internal/sql/query/projects.sql at line 17 [5.56]

Replacement in internal/sql/query/projects.sql at line 24 [5.56]

File deletion: task.sql.go

Replacement in internal/database/projects.sql.go at line 14 [7.1343]

Replacement in internal/database/projects.sql.go at line 22 [7.1343]

Replacement in internal/database/projects.sql.go at line 28 [7.1343]

Replacement in internal/database/projects.sql.go at line 40 [7.1343]

Replacement in internal/database/projects.sql.go at line 59 [7.1343]

Replacement in internal/database/projects.sql.go at line 69 [7.1343]

Replacement in internal/database/projects.sql.go at line 79 [7.1343]

Insertion in internal/database/projects.sql.go at line 84 [7.1343]

Replacement in internal/database/projects.sql.go at line 131 [7.1343]

Replacement in internal/database/projects.sql.go at line 192 [7.1343]

Replacement in internal/database/projects.sql.go at line 198 [7.1343]

Replacement in internal/database/projects.sql.go at line 202 [7.1343]

Deletion in internal/database/projects.sql.go at line 212 [7.1343]

Deletion in internal/database/projects.sql.go at line 213 [7.1343]

Replacement in internal/database/projects.sql.go at line 214 [7.1343]

Replacement in internal/database/projects.sql.go at line 224 [7.1343]

Replacement in internal/database/models.go at line 16 [7.689]

Replacement in internal/database/models.go at line 27 [7.689]

Insertion in internal/database/models.go at line 36 [7.689]