repos / pico

commit

31cd1e1

parent

59aba61

author

Eric Bower

date

2025-12-15 09:18:46 -0500 EST

chore(db): remove unused queries

 1@@ -225,8 +225,7 @@ const (
 2 	sqlSelectTagsForPost     = `SELECT name FROM post_tags WHERE post_id=$1`
 3 	sqlSelectFeedItemsByPost = `SELECT id, post_id, guid, data, created_at FROM feed_items WHERE post_id=$1`
 4 
 5-	sqlInsertPublicKey = `INSERT INTO public_keys (user_id, public_key) VALUES ($1, $2)`
 6-	sqlInsertPost      = `
 7+	sqlInsertPost = `
 8 	INSERT INTO posts
 9 		(user_id, filename, slug, title, text, description, publish_at, hidden, cur_space,
10 		file_size, mime_type, shasum, data, expires_at, updated_at)
11@@ -243,7 +242,6 @@ const (
12 		file_size = $7, shasum = $8, data = $9, hidden = $11, expires_at = $12
13 	WHERE id = $10`
14 	sqlUpdateUserName = `UPDATE app_users SET name = $1 WHERE id = $2`
15-	sqlIncrementViews = `UPDATE posts SET views = views + 1 WHERE id = $1 RETURNING views`
16 
17 	sqlRemoveAliasesByPost = `DELETE FROM post_aliases WHERE post_id = $1`
18 	sqlRemoveTagsByPost    = `DELETE FROM post_tags WHERE post_id = $1`
19@@ -251,15 +249,9 @@ const (
20 	sqlRemoveKeys          = `DELETE FROM public_keys WHERE id = ANY($1::uuid[])`
21 	sqlRemoveUsers         = `DELETE FROM app_users WHERE id = ANY($1::uuid[])`
22 
23-	sqlInsertProject        = `INSERT INTO projects (user_id, name, project_dir) VALUES ($1, $2, $3) RETURNING id;`
24-	sqlUpdateProject        = `UPDATE projects SET updated_at = $3 WHERE user_id = $1 AND name = $2;`
25-	sqlFindProjectByName    = `SELECT id, user_id, name, project_dir, acl, blocked, created_at, updated_at FROM projects WHERE user_id = $1 AND name = $2;`
26-	sqlSelectProjectCount   = `SELECT count(id) FROM projects`
27-	sqlFindProjectsByUser   = `SELECT id, user_id, name, project_dir, acl, blocked, created_at, updated_at FROM projects WHERE user_id = $1 ORDER BY name ASC, updated_at DESC;`
28-	sqlFindProjectsByPrefix = `SELECT id, user_id, name, project_dir, acl, blocked, created_at, updated_at FROM projects WHERE user_id = $1 AND name = project_dir AND name ILIKE $2 ORDER BY updated_at ASC, name ASC;`
29-	sqlFindProjectLinks     = `SELECT id, user_id, name, project_dir, acl, blocked, created_at, updated_at FROM projects WHERE user_id = $1 AND name != project_dir AND project_dir = $2 ORDER BY name ASC;`
30-	sqlLinkToProject        = `UPDATE projects SET project_dir = $1, updated_at = $2 WHERE id = $3;`
31-	sqlRemoveProject        = `DELETE FROM projects WHERE id = $1;`
32+	sqlInsertProject     = `INSERT INTO projects (user_id, name, project_dir) VALUES ($1, $2, $3) RETURNING id;`
33+	sqlUpdateProject     = `UPDATE projects SET updated_at = $3 WHERE user_id = $1 AND name = $2;`
34+	sqlFindProjectByName = `SELECT id, user_id, name, project_dir, acl, blocked, created_at, updated_at FROM projects WHERE user_id = $1 AND name = $2;`
35 )
36 
37 type PsqlDB struct {