coder
diff --git a/‎database/databasefake/databasefake.go
Lines changed: 4 additions & 3 deletions b/‎database/databasefake/databasefake.go
Lines changed: 4 additions & 3 deletions
diff --git a/‎database/dump.sql
Lines changed: 5 additions & 4 deletions b/‎database/dump.sql
Lines changed: 5 additions & 4 deletions
diff --git a/‎database/migrations/000002_projects.up.sql
Lines changed: 3 additions & 2 deletions b/‎database/migrations/000002_projects.up.sql
Lines changed: 3 additions & 2 deletions
diff --git a/‎database/models.go
Lines changed: 2 additions & 1 deletion b/‎database/models.go
Lines changed: 2 additions & 1 deletion
diff --git a/‎database/querier.go
Lines changed: 1 addition & 1 deletion b/‎database/querier.go
Lines changed: 1 addition & 1 deletion
diff --git a/‎database/query.sql
Lines changed: 5 additions & 5 deletions b/‎database/query.sql
Lines changed: 5 additions & 5 deletions
diff --git a/‎database/query.sql.go
Lines changed: 28 additions & 12 deletions b/‎database/query.sql.go
Lines changed: 28 additions & 12 deletions
@@ -104,12 +104,12 @@ func (q *fakeQuerier) GetAPIKeyByID(_ context.Context, id string) (database.APIK
 	return database.APIKey{}, sql.ErrNoRows
 }
 
-func (q *fakeQuerier) GetFileByID(_ context.Context, id uuid.UUID) (database.File, error) {
+func (q *fakeQuerier) GetFileByHash(_ context.Context, hash string) (database.File, error) {
 	q.mutex.Lock()
 	defer q.mutex.Unlock()
 
 	for _, file := range q.files {
-		if file.ID.String() == id.String() {
+		if file.Hash == hash {
 			return file, nil
 		}
 	}
@@ -588,8 +588,9 @@ func (q *fakeQuerier) InsertFile(_ context.Context, arg database.InsertFileParam
 
 	//nolint:gosimple
 	file := database.File{
-		ID:        arg.ID,
+		Hash:      arg.Hash,
 		CreatedAt: arg.CreatedAt,
+		Mimetype:  arg.Mimetype,
 		Data:      arg.Data,
 	}
 	q.files = append(q.files, file)
 
@@ -1,7 +1,8 @@
 -- Store arbitrary data like project source code or avatars.
-CREATE TABLE files (
-    id uuid NOT NULL UNIQUE,
+CREATE TABLE file (
+    hash varchar(32) NOT NULL UNIQUE,
     created_at timestamptz NOT NULL,
+    mimetype varchar(64) NOT NULL,
     data bytea NOT NULL
 );
 
 
@@ -46,13 +46,13 @@ WHERE
 LIMIT
   1;
 
--- name: GetFileByID :one
+-- name: GetFileByHash :one
 SELECT
   *
 FROM
-  files
+  file
 WHERE
-  id = $1
+  hash = $1
 LIMIT
   1;
 
@@ -364,9 +364,9 @@ VALUES
 
 -- name: InsertFile :one
 INSERT INTO
-  files (id, created_at, data)
+  file (hash, created_at, mimetype, data)
 VALUES
-  ($1, $2, $3) RETURNING *;
+  ($1, $2, $3, $4) RETURNING *;
 
 -- name: InsertProvisionerJobLogs :many
 INSERT INTO
Original file line number	Diff line number	Diff line change
`@@ -104,12 +104,12 @@ func (q *fakeQuerier) GetAPIKeyByID(_ context.Context, id string) (database.APIK`
`104`	`104`	`return database.APIKey{}, sql.ErrNoRows`
`105`	`105`	`}`
`106`	`106`
`107`		`-func (q *fakeQuerier) GetFileByID(_ context.Context, id uuid.UUID) (database.File, error) {`
	`107`	`+func (q *fakeQuerier) GetFileByHash(_ context.Context, hash string) (database.File, error) {`
`108`	`108`	`q.mutex.Lock()`
`109`	`109`	`defer q.mutex.Unlock()`
`110`	`110`
`111`	`111`	`for _, file := range q.files {`
`112`		`- if file.ID.String() == id.String() {`
	`112`	`+ if file.Hash == hash {`
`113`	`113`	`return file, nil`
`114`	`114`	`}`
`115`	`115`	`}`
`@@ -588,8 +588,9 @@ func (q *fakeQuerier) InsertFile(_ context.Context, arg database.InsertFileParam`
`588`	`588`
`589`	`589`	`//nolint:gosimple`
`590`	`590`	`file := database.File{`
`591`		`- ID: arg.ID,`
	`591`	`+ Hash: arg.Hash,`
`592`	`592`	`CreatedAt: arg.CreatedAt,`
	`593`	`+ Mimetype: arg.Mimetype,`
`593`	`594`	`Data: arg.Data,`
`594`	`595`	`}`
`595`	`596`	`q.files = append(q.files, file)`