Support for archiving clients and projects.HEADmain

1 files changed, 68 insertions, 13 deletions

diff --git a/internal/queries/queries.sql.go b/internal/queries/queries.sql.go
index 4ae940c..035be20 100644
--- a/internal/queries/queries.sql.go
+++ b/internal/queries/queries.sql.go
@@ -1,6 +1,6 @@
 // Code generated by sqlc. DO NOT EDIT.
 // versions:
-//   sqlc v1.29.0
+//   sqlc v1.30.0
 // source: queries.sql
 
 package queries
@@ -11,10 +11,32 @@ import (
 	"time"
 )
 
+const archiveClient = `-- name: ArchiveClient :exec
+update client
+set archived = 1
+where id = ?1
+`
+
+func (q *Queries) ArchiveClient(ctx context.Context, id int64) error {
+	_, err := q.db.ExecContext(ctx, archiveClient, id)
+	return err
+}
+
+const archiveProject = `-- name: ArchiveProject :exec
+update project
+set archived = 1
+where id = ?1
+`
+
+func (q *Queries) ArchiveProject(ctx context.Context, id int64) error {
+	_, err := q.db.ExecContext(ctx, archiveProject, id)
+	return err
+}
+
 const createClient = `-- name: CreateClient :one
 insert into client (name, email, billable_rate)
 values (?1, ?2, ?3)
-returning id, name, email, billable_rate, created_at
+returning id, name, email, billable_rate, archived, created_at
 `
 
 type CreateClientParams struct {
@@ -31,6 +53,7 @@ func (q *Queries) CreateClient(ctx context.Context, arg CreateClientParams) (Cli
 		&i.Name,
 		&i.Email,
 		&i.BillableRate,
+		&i.Archived,
 		&i.CreatedAt,
 	)
 	return i, err
@@ -99,7 +122,7 @@ func (q *Queries) CreateInvoice(ctx context.Context, arg CreateInvoiceParams) (I
 const createProject = `-- name: CreateProject :one
 insert into project (name, client_id, billable_rate)
 values (?1, ?2, ?3)
-returning id, name, client_id, billable_rate, created_at
+returning id, name, client_id, billable_rate, archived, created_at
 `
 
 type CreateProjectParams struct {
@@ -116,6 +139,7 @@ func (q *Queries) CreateProject(ctx context.Context, arg CreateProjectParams) (P
 		&i.Name,
 		&i.ClientID,
 		&i.BillableRate,
+		&i.Archived,
 		&i.CreatedAt,
 	)
 	return i, err
@@ -240,9 +264,9 @@ func (q *Queries) EditTimeEntry(ctx context.Context, arg EditTimeEntryParams) er
 }
 
 const findClient = `-- name: FindClient :many
-select c1.id, c1.name, c1.email, c1.billable_rate, c1.created_at from client c1 where c1.id = cast(?1 as integer)
+select c1.id, c1.name, c1.email, c1.billable_rate, c1.archived, c1.created_at from client c1 where c1.id = cast(?1 as integer)
 union all
-select c2.id, c2.name, c2.email, c2.billable_rate, c2.created_at from client c2 where c2.name = ?2
+select c2.id, c2.name, c2.email, c2.billable_rate, c2.archived, c2.created_at from client c2 where c2.name = ?2
 `
 
 type FindClientParams struct {
@@ -264,6 +288,7 @@ func (q *Queries) FindClient(ctx context.Context, arg FindClientParams) ([]Clien
 			&i.Name,
 			&i.Email,
 			&i.BillableRate,
+			&i.Archived,
 			&i.CreatedAt,
 		); err != nil {
 			return nil, err
@@ -280,9 +305,9 @@ func (q *Queries) FindClient(ctx context.Context, arg FindClientParams) ([]Clien
 }
 
 const findProject = `-- name: FindProject :many
-select p1.id, p1.name, p1.client_id, p1.billable_rate, p1.created_at from project p1 where p1.id = cast(?1 as integer)
+select p1.id, p1.name, p1.client_id, p1.billable_rate, p1.archived, p1.created_at from project p1 where p1.id = cast(?1 as integer)
 union all
-select p2.id, p2.name, p2.client_id, p2.billable_rate, p2.created_at from project p2 where p2.name = ?2
+select p2.id, p2.name, p2.client_id, p2.billable_rate, p2.archived, p2.created_at from project p2 where p2.name = ?2
 `
 
 type FindProjectParams struct {
@@ -304,6 +329,7 @@ func (q *Queries) FindProject(ctx context.Context, arg FindProjectParams) ([]Pro
 			&i.Name,
 			&i.ClientID,
 			&i.BillableRate,
+			&i.Archived,
 			&i.CreatedAt,
 		); err != nil {
 			return nil, err
@@ -342,7 +368,7 @@ func (q *Queries) GetActiveTimeEntry(ctx context.Context) (TimeEntry, error) {
 }
 
 const getClientByName = `-- name: GetClientByName :one
-select id, name, email, billable_rate, created_at from client where name = ?1 limit 1
+select id, name, email, billable_rate, archived, created_at from client where name = ?1 limit 1
 `
 
 func (q *Queries) GetClientByName(ctx context.Context, name string) (Client, error) {
@@ -353,6 +379,7 @@ func (q *Queries) GetClientByName(ctx context.Context, name string) (Client, err
 		&i.Name,
 		&i.Email,
 		&i.BillableRate,
+		&i.Archived,
 		&i.CreatedAt,
 	)
 	return i, err
@@ -712,7 +739,7 @@ func (q *Queries) GetMostRecentTimeEntry(ctx context.Context) (TimeEntry, error)
 }
 
 const getProjectByNameAndClient = `-- name: GetProjectByNameAndClient :one
-select id, name, client_id, billable_rate, created_at from project where name = ?1 and client_id = ?2 limit 1
+select id, name, client_id, billable_rate, archived, created_at from project where name = ?1 and client_id = ?2 limit 1
 `
 
 type GetProjectByNameAndClientParams struct {
@@ -728,6 +755,7 @@ func (q *Queries) GetProjectByNameAndClient(ctx context.Context, arg GetProjectB
 		&i.Name,
 		&i.ClientID,
 		&i.BillableRate,
+		&i.Archived,
 		&i.CreatedAt,
 	)
 	return i, err
@@ -1004,7 +1032,7 @@ func (q *Queries) GetWeekSummaryByProject(ctx context.Context) ([]GetWeekSummary
 }
 
 const listAllClients = `-- name: ListAllClients :many
-select id, name, email, billable_rate, created_at from client
+select id, name, email, billable_rate, archived, created_at from client
 order by name
 `
 
@@ -1022,6 +1050,7 @@ func (q *Queries) ListAllClients(ctx context.Context) ([]Client, error) {
 			&i.Name,
 			&i.Email,
 			&i.BillableRate,
+			&i.Archived,
 			&i.CreatedAt,
 		); err != nil {
 			return nil, err
@@ -1038,7 +1067,7 @@ func (q *Queries) ListAllClients(ctx context.Context) ([]Client, error) {
 }
 
 const listAllProjects = `-- name: ListAllProjects :many
-select p.id, p.name, p.client_id, p.billable_rate, p.created_at, c.name as client_name from project p
+select p.id, p.name, p.client_id, p.billable_rate, p.archived, p.created_at, c.name as client_name from project p
 join client c on p.client_id = c.id
 order by c.name, p.name
 `
@@ -1048,6 +1077,7 @@ type ListAllProjectsRow struct {
 	Name         string
 	ClientID     int64
 	BillableRate sql.NullInt64
+	Archived     int64
 	CreatedAt    sql.NullTime
 	ClientName   string
 }
@@ -1066,6 +1096,7 @@ func (q *Queries) ListAllProjects(ctx context.Context) ([]ListAllProjectsRow, er
 			&i.Name,
 			&i.ClientID,
 			&i.BillableRate,
+			&i.Archived,
 			&i.CreatedAt,
 			&i.ClientName,
 		); err != nil {
@@ -1120,6 +1151,28 @@ func (q *Queries) StopTimeEntry(ctx context.Context) (TimeEntry, error) {
 	return i, err
 }
 
+const unarchiveClient = `-- name: UnarchiveClient :exec
+update client
+set archived = 0
+where id = ?1
+`
+
+func (q *Queries) UnarchiveClient(ctx context.Context, id int64) error {
+	_, err := q.db.ExecContext(ctx, unarchiveClient, id)
+	return err
+}
+
+const unarchiveProject = `-- name: UnarchiveProject :exec
+update project
+set archived = 0
+where id = ?1
+`
+
+func (q *Queries) UnarchiveProject(ctx context.Context, id int64) error {
+	_, err := q.db.ExecContext(ctx, unarchiveProject, id)
+	return err
+}
+
 const updateActiveTimerDescription = `-- name: UpdateActiveTimerDescription :exec
 update time_entry 
 set description = ?1
@@ -1141,7 +1194,7 @@ const updateClient = `-- name: UpdateClient :one
 update client
 set name = ?1, email = ?2, billable_rate = ?3
 where id = ?4
-returning id, name, email, billable_rate, created_at
+returning id, name, email, billable_rate, archived, created_at
 `
 
 type UpdateClientParams struct {
@@ -1164,6 +1217,7 @@ func (q *Queries) UpdateClient(ctx context.Context, arg UpdateClientParams) (Cli
 		&i.Name,
 		&i.Email,
 		&i.BillableRate,
+		&i.Archived,
 		&i.CreatedAt,
 	)
 	return i, err
@@ -1199,7 +1253,7 @@ const updateProject = `-- name: UpdateProject :one
 update project
 set name = ?1, billable_rate = ?2
 where id = ?3
-returning id, name, client_id, billable_rate, created_at
+returning id, name, client_id, billable_rate, archived, created_at
 `
 
 type UpdateProjectParams struct {
@@ -1216,6 +1270,7 @@ func (q *Queries) UpdateProject(ctx context.Context, arg UpdateProjectParams) (P
 		&i.Name,
 		&i.ClientID,
 		&i.BillableRate,
+		&i.Archived,
 		&i.CreatedAt,
 	)
 	return i, err