sqlc/internal/endtoend/testdata/upsert_named_params/sqlite/go/query.sql.go at 4c7db803d585a395742e86daa2ad6c47731c0c07 · sqlc-dev/sqlc · GitHub

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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
// Code generated by sqlc. DO NOT EDIT.
// versions:
//   sqlc v1.31.1
// source: query.sql

package querytest

import (
	"context"
	"database/sql"
)

const upsertAuthor = `-- name: UpsertAuthor :one
INSERT INTO authors (
  id,
  name,
  bio
) VALUES (
  ?1,
  ?2,
  ?3
) ON CONFLICT(id) DO UPDATE SET
  name = ?2,
  bio = ?3
RETURNING id, name, bio
`

type UpsertAuthorParams struct {
	ID   string
	Name string
	Bio  sql.NullString
}

func (q *Queries) UpsertAuthor(ctx context.Context, arg UpsertAuthorParams) (Author, error) {
	row := q.db.QueryRowContext(ctx, upsertAuthor, arg.ID, arg.Name, arg.Bio)
	var i Author
	err := row.Scan(&i.ID, &i.Name, &i.Bio)
	return i, err
}

const upsertAuthorBothWhere = `-- name: UpsertAuthorBothWhere :one
INSERT INTO authors (
  id,
  name,
  bio
) VALUES (
  ?1,
  ?2,
  ?3
) ON CONFLICT(id) DO UPDATE SET
  name = ?2,
  bio = ?3
WHERE excluded.name != ?2
AND excluded.bio != ?3
RETURNING id, name, bio
`

type UpsertAuthorBothWhereParams struct {
	ID   string
	Name string
	Bio  sql.NullString
}

func (q *Queries) UpsertAuthorBothWhere(ctx context.Context, arg UpsertAuthorBothWhereParams) (Author, error) {
	row := q.db.QueryRowContext(ctx, upsertAuthorBothWhere, arg.ID, arg.Name, arg.Bio)
	var i Author
	err := row.Scan(&i.ID, &i.Name, &i.Bio)
	return i, err
}

const upsertAuthorConflictWhere = `-- name: UpsertAuthorConflictWhere :one
INSERT INTO authors (
  id,
  name,
  bio
) VALUES (
  ?1,
  ?2,
  ?3
) ON CONFLICT(id) DO UPDATE SET
  name = ?2,
  bio = ?3
WHERE excluded.bio != ?3
RETURNING id, name, bio
`

type UpsertAuthorConflictWhereParams struct {
	ID   string
	Name string
	Bio  sql.NullString
}

func (q *Queries) UpsertAuthorConflictWhere(ctx context.Context, arg UpsertAuthorConflictWhereParams) (Author, error) {
	row := q.db.QueryRowContext(ctx, upsertAuthorConflictWhere, arg.ID, arg.Name, arg.Bio)
	var i Author
	err := row.Scan(&i.ID, &i.Name, &i.Bio)
	return i, err
}

const upsertAuthorDoUpdateWhere = `-- name: UpsertAuthorDoUpdateWhere :one
INSERT INTO authors (
  id,
  name,
  bio
) VALUES (
  ?1,
  ?2,
  ?3
) ON CONFLICT(id) DO UPDATE SET
  name = ?2,
  bio = ?3
WHERE excluded.name != ?2
RETURNING id, name, bio
`

type UpsertAuthorDoUpdateWhereParams struct {
	ID   string
	Name string
	Bio  sql.NullString
}

func (q *Queries) UpsertAuthorDoUpdateWhere(ctx context.Context, arg UpsertAuthorDoUpdateWhereParams) (Author, error) {
	row := q.db.QueryRowContext(ctx, upsertAuthorDoUpdateWhere, arg.ID, arg.Name, arg.Bio)
	var i Author
	err := row.Scan(&i.ID, &i.Name, &i.Bio)
	return i, err
}