gostart/data/queries.sql.go

587 lines
12 KiB
Go

// Code generated by sqlc. DO NOT EDIT.
// versions:
// sqlc v1.26.0
// source: queries.sql
package data
import (
"context"
)
const addIcon = `-- name: AddIcon :exec
insert
into icons (owner_id, link_id, content_type, data)
values (?, ?, ?, ?) on conflict(link_id) do
update set data = excluded.data, content_type = excluded.content_type
`
type AddIconParams struct {
OwnerID int64 `json:"owner_id"`
LinkID int64 `json:"link_id"`
ContentType string `json:"content_type"`
Data []byte `json:"data"`
}
func (q *Queries) AddIcon(ctx context.Context, arg AddIconParams) error {
_, err := q.db.ExecContext(ctx, addIcon,
arg.OwnerID,
arg.LinkID,
arg.ContentType,
arg.Data,
)
return err
}
const addLink = `-- name: AddLink :one
insert into links (owner_id, url, name, logo_url, shared)
values (?, ?, ?, ?, ?) returning id, owner_id, created_at, url, name, clicked, logo_url, shared
`
type AddLinkParams struct {
OwnerID int64 `json:"owner_id"`
Url string `json:"url"`
Name string `json:"name"`
LogoUrl string `json:"logo_url"`
Shared bool `json:"shared"`
}
func (q *Queries) AddLink(ctx context.Context, arg AddLinkParams) (Link, error) {
row := q.db.QueryRowContext(ctx, addLink,
arg.OwnerID,
arg.Url,
arg.Name,
arg.LogoUrl,
arg.Shared,
)
var i Link
err := row.Scan(
&i.ID,
&i.OwnerID,
&i.CreatedAt,
&i.Url,
&i.Name,
&i.Clicked,
&i.LogoUrl,
&i.Shared,
)
return i, err
}
const addOwner = `-- name: AddOwner :one
insert into owners (id, name, show_shared)
values (?, ?, ?) returning id, created_at, last_used, name, show_shared
`
type AddOwnerParams struct {
ID int64 `json:"id"`
Name string `json:"name"`
ShowShared bool `json:"show_shared"`
}
func (q *Queries) AddOwner(ctx context.Context, arg AddOwnerParams) (Owner, error) {
row := q.db.QueryRowContext(ctx, addOwner, arg.ID, arg.Name, arg.ShowShared)
var i Owner
err := row.Scan(
&i.ID,
&i.CreatedAt,
&i.LastUsed,
&i.Name,
&i.ShowShared,
)
return i, err
}
const addPullRequest = `-- name: AddPullRequest :one
insert into pull_requests (owner_id, number, repo, description, url)
values (?, ?, ?, ?, ?) returning id, owner_id, created_at, number, repo, url, description, commitid
`
type AddPullRequestParams struct {
OwnerID int64 `json:"owner_id"`
Number int64 `json:"number"`
Repo string `json:"repo"`
Description string `json:"description"`
Url string `json:"url"`
}
func (q *Queries) AddPullRequest(ctx context.Context, arg AddPullRequestParams) (PullRequest, error) {
row := q.db.QueryRowContext(ctx, addPullRequest,
arg.OwnerID,
arg.Number,
arg.Repo,
arg.Description,
arg.Url,
)
var i PullRequest
err := row.Scan(
&i.ID,
&i.OwnerID,
&i.CreatedAt,
&i.Number,
&i.Repo,
&i.Url,
&i.Description,
&i.Commitid,
)
return i, err
}
const addPullRequestIgnore = `-- name: AddPullRequestIgnore :one
insert into pull_request_ignores (owner_id, number, repo)
values (?, ?, ?) returning id, owner_id, created_at, number, repo
`
type AddPullRequestIgnoreParams struct {
OwnerID int64 `json:"owner_id"`
Number int64 `json:"number"`
Repo string `json:"repo"`
}
func (q *Queries) AddPullRequestIgnore(ctx context.Context, arg AddPullRequestIgnoreParams) (PullRequestIgnore, error) {
row := q.db.QueryRowContext(ctx, addPullRequestIgnore, arg.OwnerID, arg.Number, arg.Repo)
var i PullRequestIgnore
err := row.Scan(
&i.ID,
&i.OwnerID,
&i.CreatedAt,
&i.Number,
&i.Repo,
)
return i, err
}
const addWatchItem = `-- name: AddWatchItem :one
insert into watch_items (owner_id, name, repo)
values (?, ?, ?) returning id, owner_id, created_at, name, repo
`
type AddWatchItemParams struct {
OwnerID int64 `json:"owner_id"`
Name string `json:"name"`
Repo string `json:"repo"`
}
func (q *Queries) AddWatchItem(ctx context.Context, arg AddWatchItemParams) (WatchItem, error) {
row := q.db.QueryRowContext(ctx, addWatchItem, arg.OwnerID, arg.Name, arg.Repo)
var i WatchItem
err := row.Scan(
&i.ID,
&i.OwnerID,
&i.CreatedAt,
&i.Name,
&i.Repo,
)
return i, err
}
const deleteIgnore = `-- name: DeleteIgnore :exec
delete
from pull_request_ignores
where id = ?
and owner_id = ?
`
type DeleteIgnoreParams struct {
ID int64 `json:"id"`
OwnerID int64 `json:"owner_id"`
}
func (q *Queries) DeleteIgnore(ctx context.Context, arg DeleteIgnoreParams) error {
_, err := q.db.ExecContext(ctx, deleteIgnore, arg.ID, arg.OwnerID)
return err
}
const deleteLink = `-- name: DeleteLink :exec
delete
from links
where id = ?
and owner_id = ?
`
type DeleteLinkParams struct {
ID int64 `json:"id"`
OwnerID int64 `json:"owner_id"`
}
func (q *Queries) DeleteLink(ctx context.Context, arg DeleteLinkParams) error {
_, err := q.db.ExecContext(ctx, deleteLink, arg.ID, arg.OwnerID)
return err
}
const deletePullRequest = `-- name: DeletePullRequest :exec
delete
from pull_requests
where id = ?
and owner_id = ?
`
type DeletePullRequestParams struct {
ID int64 `json:"id"`
OwnerID int64 `json:"owner_id"`
}
func (q *Queries) DeletePullRequest(ctx context.Context, arg DeletePullRequestParams) error {
_, err := q.db.ExecContext(ctx, deletePullRequest, arg.ID, arg.OwnerID)
return err
}
const deleteWatchItem = `-- name: DeleteWatchItem :exec
delete
from watch_items
where id = ?
and owner_id = ?
`
type DeleteWatchItemParams struct {
ID int64 `json:"id"`
OwnerID int64 `json:"owner_id"`
}
func (q *Queries) DeleteWatchItem(ctx context.Context, arg DeleteWatchItemParams) error {
_, err := q.db.ExecContext(ctx, deleteWatchItem, arg.ID, arg.OwnerID)
return err
}
const getAllIcons = `-- name: GetAllIcons :many
select owner_id, link_id, created_at, content_type, data
from icons
where owner_id = ?
`
func (q *Queries) GetAllIcons(ctx context.Context, ownerID int64) ([]Icon, error) {
rows, err := q.db.QueryContext(ctx, getAllIcons, ownerID)
if err != nil {
return nil, err
}
defer rows.Close()
items := []Icon{}
for rows.Next() {
var i Icon
if err := rows.Scan(
&i.OwnerID,
&i.LinkID,
&i.CreatedAt,
&i.ContentType,
&i.Data,
); err != nil {
return nil, err
}
items = append(items, i)
}
if err := rows.Close(); err != nil {
return nil, err
}
if err := rows.Err(); err != nil {
return nil, err
}
return items, nil
}
const getAllLinks = `-- name: GetAllLinks :many
select id, owner_id, created_at, url, name, clicked, logo_url, shared
from links
`
func (q *Queries) GetAllLinks(ctx context.Context) ([]Link, error) {
rows, err := q.db.QueryContext(ctx, getAllLinks)
if err != nil {
return nil, err
}
defer rows.Close()
items := []Link{}
for rows.Next() {
var i Link
if err := rows.Scan(
&i.ID,
&i.OwnerID,
&i.CreatedAt,
&i.Url,
&i.Name,
&i.Clicked,
&i.LogoUrl,
&i.Shared,
); err != nil {
return nil, err
}
items = append(items, i)
}
if err := rows.Close(); err != nil {
return nil, err
}
if err := rows.Err(); err != nil {
return nil, err
}
return items, nil
}
const getAllLinksForOwner = `-- name: GetAllLinksForOwner :many
select id, owner_id, created_at, url, name, clicked, logo_url, shared
from links
where owner_id = ?
or shared = true
order by clicked desc
`
func (q *Queries) GetAllLinksForOwner(ctx context.Context, ownerID int64) ([]Link, error) {
rows, err := q.db.QueryContext(ctx, getAllLinksForOwner, ownerID)
if err != nil {
return nil, err
}
defer rows.Close()
items := []Link{}
for rows.Next() {
var i Link
if err := rows.Scan(
&i.ID,
&i.OwnerID,
&i.CreatedAt,
&i.Url,
&i.Name,
&i.Clicked,
&i.LogoUrl,
&i.Shared,
); err != nil {
return nil, err
}
items = append(items, i)
}
if err := rows.Close(); err != nil {
return nil, err
}
if err := rows.Err(); err != nil {
return nil, err
}
return items, nil
}
const getAllPullRequestIgnores = `-- name: GetAllPullRequestIgnores :many
select id, owner_id, created_at, number, repo
from pull_request_ignores
where owner_id = ?
`
func (q *Queries) GetAllPullRequestIgnores(ctx context.Context, ownerID int64) ([]PullRequestIgnore, error) {
rows, err := q.db.QueryContext(ctx, getAllPullRequestIgnores, ownerID)
if err != nil {
return nil, err
}
defer rows.Close()
items := []PullRequestIgnore{}
for rows.Next() {
var i PullRequestIgnore
if err := rows.Scan(
&i.ID,
&i.OwnerID,
&i.CreatedAt,
&i.Number,
&i.Repo,
); err != nil {
return nil, err
}
items = append(items, i)
}
if err := rows.Close(); err != nil {
return nil, err
}
if err := rows.Err(); err != nil {
return nil, err
}
return items, nil
}
const getAllPullRequests = `-- name: GetAllPullRequests :many
select id, owner_id, created_at, number, repo, url, description, commitid
from pull_requests
where owner_id = ?
`
func (q *Queries) GetAllPullRequests(ctx context.Context, ownerID int64) ([]PullRequest, error) {
rows, err := q.db.QueryContext(ctx, getAllPullRequests, ownerID)
if err != nil {
return nil, err
}
defer rows.Close()
items := []PullRequest{}
for rows.Next() {
var i PullRequest
if err := rows.Scan(
&i.ID,
&i.OwnerID,
&i.CreatedAt,
&i.Number,
&i.Repo,
&i.Url,
&i.Description,
&i.Commitid,
); err != nil {
return nil, err
}
items = append(items, i)
}
if err := rows.Close(); err != nil {
return nil, err
}
if err := rows.Err(); err != nil {
return nil, err
}
return items, nil
}
const getAllWatchItems = `-- name: GetAllWatchItems :many
select id, owner_id, created_at, name, repo
from watch_items
`
func (q *Queries) GetAllWatchItems(ctx context.Context) ([]WatchItem, error) {
rows, err := q.db.QueryContext(ctx, getAllWatchItems)
if err != nil {
return nil, err
}
defer rows.Close()
items := []WatchItem{}
for rows.Next() {
var i WatchItem
if err := rows.Scan(
&i.ID,
&i.OwnerID,
&i.CreatedAt,
&i.Name,
&i.Repo,
); err != nil {
return nil, err
}
items = append(items, i)
}
if err := rows.Close(); err != nil {
return nil, err
}
if err := rows.Err(); err != nil {
return nil, err
}
return items, nil
}
const getAllWatchItemsByOwner = `-- name: GetAllWatchItemsByOwner :many
select id, owner_id, created_at, name, repo
from watch_items
where owner_id = ?
`
func (q *Queries) GetAllWatchItemsByOwner(ctx context.Context, ownerID int64) ([]WatchItem, error) {
rows, err := q.db.QueryContext(ctx, getAllWatchItemsByOwner, ownerID)
if err != nil {
return nil, err
}
defer rows.Close()
items := []WatchItem{}
for rows.Next() {
var i WatchItem
if err := rows.Scan(
&i.ID,
&i.OwnerID,
&i.CreatedAt,
&i.Name,
&i.Repo,
); err != nil {
return nil, err
}
items = append(items, i)
}
if err := rows.Close(); err != nil {
return nil, err
}
if err := rows.Err(); err != nil {
return nil, err
}
return items, nil
}
const getIconByLinkID = `-- name: GetIconByLinkID :one
select owner_id, link_id, created_at, content_type, data
from icons
where link_id = ?
`
func (q *Queries) GetIconByLinkID(ctx context.Context, linkID int64) (Icon, error) {
row := q.db.QueryRowContext(ctx, getIconByLinkID, linkID)
var i Icon
err := row.Scan(
&i.OwnerID,
&i.LinkID,
&i.CreatedAt,
&i.ContentType,
&i.Data,
)
return i, err
}
const getLinkByID = `-- name: GetLinkByID :one
select id, owner_id, created_at, url, name, clicked, logo_url, shared
from links
where id = ?
`
func (q *Queries) GetLinkByID(ctx context.Context, id int64) (Link, error) {
row := q.db.QueryRowContext(ctx, getLinkByID, id)
var i Link
err := row.Scan(
&i.ID,
&i.OwnerID,
&i.CreatedAt,
&i.Url,
&i.Name,
&i.Clicked,
&i.LogoUrl,
&i.Shared,
)
return i, err
}
const getOwner = `-- name: GetOwner :one
select id, created_at, last_used, name, show_shared
from owners
where id = ?
`
func (q *Queries) GetOwner(ctx context.Context, id int64) (Owner, error) {
row := q.db.QueryRowContext(ctx, getOwner, id)
var i Owner
err := row.Scan(
&i.ID,
&i.CreatedAt,
&i.LastUsed,
&i.Name,
&i.ShowShared,
)
return i, err
}
const incrementLink = `-- name: IncrementLink :one
update links set
clicked = clicked + 1
where id = ?
and owner_id = ? returning id, owner_id, created_at, url, name, clicked, logo_url, shared
`
type IncrementLinkParams struct {
ID int64 `json:"id"`
OwnerID int64 `json:"owner_id"`
}
func (q *Queries) IncrementLink(ctx context.Context, arg IncrementLinkParams) (Link, error) {
row := q.db.QueryRowContext(ctx, incrementLink, arg.ID, arg.OwnerID)
var i Link
err := row.Scan(
&i.ID,
&i.OwnerID,
&i.CreatedAt,
&i.Url,
&i.Name,
&i.Clicked,
&i.LogoUrl,
&i.Shared,
)
return i, err
}