peert/protastim - Change KX5IR77OX7Q7Q46Z23SDGQ5KPYZDHSGGBKCFJ2VD4BAY6WC5ICAAC

Add planned_for for both tasks and projects, and parent_id for project

Created by peert on April 17, 2025

KX5IR77OX7Q7Q46Z23SDGQ5KPYZDHSGGBKCFJ2VD4BAY6WC5ICAAC

Dependencies

In channels

main

Change contents

Insertion in internal/sql/schema/0002_create_tasks_table.sql at line 6 [3.708]
[3.811]
[2.27]
```
  planned_for DATE,
```
Insertion in internal/sql/schema/0001_create_projects_table.sql at line 6 [3.55]
[3.161]
[2.81]
```
  parent_id INTEGER REFERENCES projects(id),
  planned_for DATE,
```

Replacement in internal/sql/query/projects.sql at line 1 [4.56]

B:BD[4.56] → [4.57:119]

-- name: GetProject :one
SELECT * FROM projects WHERE id = ?;

[4.56]

[4.119]

-- name: ProjectShort :one
SELECT id, name, parent_id FROM projects WHERE id = ?;

Replacement in internal/sql/query/projects.sql at line 4 [4.56]

B:BD[4.120] → [4.120:172]

B:BD[4.172] → [2.135:305]

∅:D[2.305] → [4.172:173]

B:BD[4.172] → [4.172:173]

B:BD[4.173] → [2.306:414]

∅:D[2.414] → [4.173:201]

B:BD[4.173] → [4.173:201]

B:BD[4.201] → [2.415:511]

∅:D[5.66] → [4.345:358]

∅:D[2.511] → [4.345:358]

B:BD[4.345] → [4.345:358]

-- name: ListProjects :many
SELECT * FROM projects;
-- 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;
-- name: ListProjectsOverdue :many
SELECT * FROM projects WHERE due_at <= DATE() AND completed_at IS NULL;
-- name: CreateProject :one
INSERT INTO projects (name, description, start_at, due_at, completed_at)
VALUES (?, ?, ?, ?, ?)
RETURNING *;

[4.120]

[4.358]

-- name: ProjectDetail :one
select id, name, description, parent_id, planned_for, start_at, due_at, completed_at FROM projects WHERE id = ?;

Replacement in internal/sql/query/projects.sql at line 7 [4.56]
B:BD[4.359] → [4.359:407]
B:BD[4.407] → [2.512:592]
∅:D[5.143] → [4.1251:1277]
∅:D[2.592] → [4.1251:1277]
B:BD[4.1251] → [4.1251:1277]
```
-- name: UpdateProject :one
UPDATE projects
SET
  name = ?,
  description = ?,
  start_at = ?,
  due_at = ?,
  completed_at = ?
WHERE id = ?
RETURNING *;
```
[4.359]
[4.1277]
```
-- name: ProjectName :one
SELECT name FROM projects WHERE id = ?;
```

Replacement in internal/sql/query/projects.sql at line 10 [4.56]

B:BD[4.1278] → [4.1278:1342]

-- name: DeleteProject :exec
DELETE FROM projects WHERE id = ?;

[4.1278]

-- name: RecProjectName :one
WITH RECURSIVE rec_project_name(id, name) AS (
    SELECT id, name FROM projects WHERE parent_id IS NULL
    UNION ALL
    SELECT projects.id, rec_project_name.name||' > '||projects.name FROM projects JOIN rec_project_name ON projects.parent_id = rec_project_name.id
) SELECT name FROM rec_project_name WHERE projects.id = ?;

Replacement in internal/database/projects.sql.go at line 13 [6.1343]

B:BD[6.1497] → [6.1497:1548]

B:BD[6.1548] → [2.593:777]

const createProject = `-- name: CreateProject :one
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

[6.1497]

[6.1678]

const projectDetail = `-- name: ProjectDetail :one
select id, name, description, parent_id, planned_for, start_at, due_at, completed_at FROM projects WHERE id = ?

Replacement in internal/database/projects.sql.go at line 17 [6.1343]
B:BD[6.1681] → [6.1681:1715]
```
type CreateProjectParams struct {
```
[6.1681]
[6.1715]
```
type ProjectDetailRow struct {
	ID          int64
```
Insertion in internal/database/projects.sql.go at line 21 [6.1343]
[6.1763]
[2.778]
```
	ParentID    sql.NullInt64
	PlannedFor  sql.NullTime
```

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

B:BD[6.1786] → [6.1786:1883]

B:BD[6.1883] → [2.857:987]

∅:D[2.987] → [6.1971:1986]

B:BD[6.1971] → [6.1971:1986]

func (q *Queries) CreateProject(ctx context.Context, arg CreateProjectParams) (Project, error) {
	row := q.db.QueryRowContext(ctx, createProject,
		arg.Name,
		arg.Description,
		arg.StartAt,
		arg.DueAt,
		arg.CompletedAt,
	)
	var i Project

[6.1786]

[6.1986]

func (q *Queries) ProjectDetail(ctx context.Context, id int64) (ProjectDetailRow, error) {
	row := q.db.QueryRowContext(ctx, projectDetail, id)
	var i ProjectDetailRow

Insertion in internal/database/projects.sql.go at line 35 [6.1343]
[6.2042]
[2.988]
```
		&i.ParentID,
		&i.PlannedFor,
```
Deletion in internal/database/projects.sql.go at line 40 [6.1343]
∅:D[2.1032] → [6.2055:2087]
B:BD[6.2055] → [6.2055:2087]
```
		&i.CreatedAt,
		&i.UpdatedAt,
```

Replacement in internal/database/projects.sql.go at line 44 [6.1343]

B:BD[6.2108] → [6.2108:2194]

const deleteProject = `-- name: DeleteProject :exec
DELETE FROM projects WHERE id = ?

[6.2108]

[6.2194]

const projectName = `-- name: ProjectName :one
SELECT name FROM projects WHERE id = ?

Replacement in internal/database/projects.sql.go at line 48 [6.1343]

B:BD[6.2197] → [6.2197:2332]

func (q *Queries) DeleteProject(ctx context.Context, id int64) error {
	_, err := q.db.ExecContext(ctx, deleteProject, id)
	return err

[6.2197]

[6.2332]

func (q *Queries) ProjectName(ctx context.Context, id int64) (string, error) {
	row := q.db.QueryRowContext(ctx, projectName, id)
	var name string
	err := row.Scan(&name)
	return name, err

Replacement in internal/database/projects.sql.go at line 55 [6.1343]

B:BD[6.2335] → [6.2335:2380]

B:BD[6.2380] → [2.1033:1145]

const getProject = `-- name: GetProject :one
SELECT id, name, description, start_at, due_at, completed_at, created_at, updated_at FROM projects WHERE id = ?

[6.2335]

[6.2468]

const projectShort = `-- name: ProjectShort :one
SELECT id, name, parent_id FROM projects WHERE id = ?

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

B:BD[6.2471] → [6.2471:2671]

B:BD[6.2671] → [2.1146:1190]

∅:D[2.1190] → [6.2684:2787]

B:BD[6.2684] → [6.2684:2787]

B:BD[6.2787] → [2.1191:1290]

∅:D[2.1290] → [6.2862:2989]

B:BD[6.2862] → [6.2862:2989]

B:BD[6.2989] → [2.1291:2111]

∅:D[2.2111] → [6.2989:3167]

B:BD[6.2989] → [6.2989:3167]

B:BD[6.3167] → [2.2112:2399]

func (q *Queries) GetProject(ctx context.Context, id int64) (Project, error) {
	row := q.db.QueryRowContext(ctx, getProject, id)
	var i Project
	err := row.Scan(
		&i.ID,
		&i.Name,
		&i.Description,
		&i.StartAt,
		&i.DueAt,
		&i.CompletedAt,
		&i.CreatedAt,
		&i.UpdatedAt,
	)
	return i, err
}
const listProjects = `-- name: ListProjects :many
SELECT id, name, description, start_at, due_at, completed_at, created_at, updated_at FROM projects
`
func (q *Queries) ListProjects(ctx context.Context) ([]Project, error) {
	rows, err := q.db.QueryContext(ctx, listProjects)
	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)
	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

[6.2471]

[2.2399]

type ProjectShortRow struct {
	ID       int64
	Name     string
	ParentID sql.NullInt64

Replacement in internal/database/projects.sql.go at line 65 [6.1343]

B:BD[2.2402] → [2.2402:3041]

∅:D[2.3041] → [6.3181:3421]

B:BD[6.3181] → [6.3181:3421]

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,
			&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

[2.2402]

[6.3421]

func (q *Queries) ProjectShort(ctx context.Context, id int64) (ProjectShortRow, error) {
	row := q.db.QueryRowContext(ctx, projectShort, id)
	var i ProjectShortRow
	err := row.Scan(&i.ID, &i.Name, &i.ParentID)
	return i, err

Replacement in internal/database/projects.sql.go at line 72 [6.1343]

B:BD[6.3424] → [6.3424:3495]

B:BD[6.3495] → [2.3042:3122]

∅:D[2.3122] → [6.3684:3697]

B:BD[6.3684] → [6.3684:3697]

B:BD[6.3697] → [2.3123:3211]

const updateProject = `-- name: UpdateProject :one
UPDATE projects
SET
  name = ?,
  description = ?,
  start_at = ?,
  due_at = ?,
  completed_at = ?
WHERE id = ?
RETURNING id, name, description, start_at, due_at, completed_at, created_at, updated_at

[6.3424]

[6.3761]

const recProjectName = `-- name: RecProjectName :one
WITH RECURSIVE rec_project_name(id, name) AS (
    SELECT id, name FROM projects WHERE parent_id IS NULL
    UNION ALL
    SELECT projects.id, rec_project_name.name||' > '||projects.name FROM projects JOIN rec_project_name ON projects.parent_id = rec_project_name.id
) SELECT name FROM rec_project_name WHERE projects.id = ?

Deletion in internal/database/projects.sql.go at line 79 [6.1343]
B:BD[6.3763] → [6.3763:3798]
B:BD[6.3798] → [2.3212:3357]
∅:D[2.3357] → [6.3960:3962]
B:BD[6.3960] → [6.3960:3962]
```
type UpdateProjectParams struct {
	Name        string
	Description sql.NullString
	StartAt     sql.NullTime
	DueAt       sql.NullTime
	CompletedAt sql.NullTime
	ID          int64
}
```

Replacement in internal/database/projects.sql.go at line 80 [6.1343]

B:BD[6.3963] → [6.3963:4109]

B:BD[6.4124] → [6.4124:4136]

B:BD[6.4158] → [6.4158:4177]

B:BD[6.4177] → [2.3358:3405]

∅:D[2.3405] → [6.4208:4292]

B:BD[6.4208] → [6.4208:4292]

B:BD[6.4292] → [2.3406:3450]

∅:D[2.3450] → [6.4305:4355]

B:BD[6.4305] → [6.4305:4355]

func (q *Queries) UpdateProject(ctx context.Context, arg UpdateProjectParams) (Project, error) {
	row := q.db.QueryRowContext(ctx, updateProject,
		arg.Name,
		arg.Description,
		arg.StartAt,
		arg.DueAt,
		arg.CompletedAt,
		arg.ID,
	)
	var i Project
	err := row.Scan(
		&i.ID,
		&i.Name,
		&i.Description,
		&i.StartAt,
		&i.DueAt,
		&i.CompletedAt,
		&i.CreatedAt,
		&i.UpdatedAt,
	)
	return i, err

[6.3963]

[6.4355]

func (q *Queries) RecProjectName(ctx context.Context, id int64) (string, error) {
	row := q.db.QueryRowContext(ctx, recProjectName, id)
	var name string
	err := row.Scan(&name)
	return name, err

Insertion in internal/database/models.go at line 16 [6.689]
[6.905]
[2.3451]
```
	ParentID    sql.NullInt64
	PlannedFor  sql.NullTime
```
Insertion in internal/database/models.go at line 29 [6.689]
[6.1060]
[2.3530]
```
	PlannedFor  sql.NullTime
```

Add planned_for for both tasks and projects, and parent_id for project

Dependencies

In channels

Change contents

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

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

Replacement in internal/sql/query/projects.sql at line 1 [4.56]

Replacement in internal/sql/query/projects.sql at line 4 [4.56]

Replacement in internal/sql/query/projects.sql at line 7 [4.56]

Replacement in internal/sql/query/projects.sql at line 10 [4.56]

Replacement in internal/database/projects.sql.go at line 13 [6.1343]

Replacement in internal/database/projects.sql.go at line 17 [6.1343]

Insertion in internal/database/projects.sql.go at line 21 [6.1343]

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

Insertion in internal/database/projects.sql.go at line 35 [6.1343]

Deletion in internal/database/projects.sql.go at line 40 [6.1343]