Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commita0672db

Browse files
committed
updated
1 parent73a3899 commita0672db

File tree

15 files changed

+38
-793
lines changed

15 files changed

+38
-793
lines changed

‎controllers/auth.controller.go

Lines changed: 0 additions & 141 deletions
This file was deleted.

‎controllers/user.controller.go

Lines changed: 0 additions & 25 deletions
This file was deleted.

‎db/migrations/000001_init-schema.down.sql

Lines changed: 0 additions & 1 deletion
This file was deleted.

‎db/migrations/000001_init-schema.up.sql

Lines changed: 0 additions & 15 deletions
This file was deleted.

‎db/query/post.sql

Lines changed: 37 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,37 @@
1+
-- name: CreatePost :one
2+
INSERT INTO posts (
3+
title,
4+
content,
5+
category,
6+
image,
7+
created_at,
8+
updated_at
9+
)VALUES (
10+
$1, $2, $3, $4, $5, $6
11+
)
12+
RETURNING*;
13+
14+
-- name: GetPostById :one
15+
SELECT*FROM posts
16+
WHERE id= $1LIMIT1;
17+
18+
-- name: ListPosts :many
19+
SELECT*FROM posts
20+
ORDER BY id
21+
LIMIT $1
22+
OFFSET $2;
23+
24+
-- name: UpdatePost :one
25+
UPDATE posts
26+
set
27+
title= coalesce(sqlc.narg('title'), title),
28+
category= coalesce(sqlc.narg('category'), category),
29+
content= coalesce(sqlc.narg('content'), content) ,
30+
image= coalesce(sqlc.narg('image'), image),
31+
updated_at= coalesce(sqlc.narg('updated_at'), updated_at )
32+
WHERE id=sqlc.arg('id')
33+
RETURNING*;
34+
35+
-- name: DeletePost :exec
36+
DELETEFROM posts
37+
WHERE id= $1;

‎db/query/user.sql

Lines changed: 0 additions & 43 deletions
This file was deleted.

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp