-
Notifications
You must be signed in to change notification settings - Fork 1
/
program_message.sql.go
65 lines (56 loc) · 1.87 KB
/
program_message.sql.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
// Code generated by sqlc. DO NOT EDIT.
// versions:
// sqlc v1.17.2
// source: program_message.sql
package db
import (
"context"
)
const getProgramMessageByMessageID = `-- name: GetProgramMessageByMessageID :one
SELECT id, channel_id, message_id, program_id, created_at, updated_at FROM ` + "`" + `program_message` + "`" + ` WHERE ` + "`" + `message_id` + "`" + ` = ?
`
func (q *Queries) GetProgramMessageByMessageID(ctx context.Context, messageID string) (ProgramMessage, error) {
row := q.db.QueryRowContext(ctx, getProgramMessageByMessageID, messageID)
var i ProgramMessage
err := row.Scan(
&i.ID,
&i.ChannelID,
&i.MessageID,
&i.ProgramID,
&i.CreatedAt,
&i.UpdatedAt,
)
return i, err
}
const getProgramMessageByProgramID = `-- name: GetProgramMessageByProgramID :one
SELECT id, channel_id, message_id, program_id, created_at, updated_at FROM ` + "`" + `program_message` + "`" + ` WHERE ` + "`" + `program_id` + "`" + ` = ?
`
func (q *Queries) GetProgramMessageByProgramID(ctx context.Context, programID int64) (ProgramMessage, error) {
row := q.db.QueryRowContext(ctx, getProgramMessageByProgramID, programID)
var i ProgramMessage
err := row.Scan(
&i.ID,
&i.ChannelID,
&i.MessageID,
&i.ProgramID,
&i.CreatedAt,
&i.UpdatedAt,
)
return i, err
}
const insertProgramMessage = `-- name: InsertProgramMessage :exec
INSERT INTO ` + "`" + `program_message` + "`" + ` (
` + "`" + `message_id` + "`" + `,
` + "`" + `program_id` + "`" + `,
` + "`" + `channel_id` + "`" + `
) VALUES (?, ?, ?)
`
type InsertProgramMessageParams struct {
MessageID string `json:"messageID"`
ProgramID int64 `json:"programID"`
ChannelID string `json:"channelID"`
}
func (q *Queries) InsertProgramMessage(ctx context.Context, arg InsertProgramMessageParams) error {
_, err := q.db.ExecContext(ctx, insertProgramMessage, arg.MessageID, arg.ProgramID, arg.ChannelID)
return err
}