diff options
Diffstat (limited to 'internal/queries')
| -rw-r--r-- | internal/queries/db.go | 2 | ||||
| -rw-r--r-- | internal/queries/models.go | 4 | ||||
| -rw-r--r-- | internal/queries/queries.sql.go | 81 |
3 files changed, 72 insertions, 15 deletions
diff --git a/internal/queries/db.go b/internal/queries/db.go index 85679b3..51576a5 100644 --- a/internal/queries/db.go +++ b/internal/queries/db.go @@ -1,6 +1,6 @@ // Code generated by sqlc. DO NOT EDIT. // versions: -// sqlc v1.29.0 +// sqlc v1.30.0 package queries diff --git a/internal/queries/models.go b/internal/queries/models.go index b42de02..5db918e 100644 --- a/internal/queries/models.go +++ b/internal/queries/models.go @@ -1,6 +1,6 @@ // Code generated by sqlc. DO NOT EDIT. // versions: -// sqlc v1.29.0 +// sqlc v1.30.0 package queries @@ -14,6 +14,7 @@ type Client struct { Name string Email sql.NullString BillableRate sql.NullInt64 + Archived int64 CreatedAt sql.NullTime } @@ -40,6 +41,7 @@ type Project struct { Name string ClientID int64 BillableRate sql.NullInt64 + Archived int64 CreatedAt sql.NullTime } 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 |