98 lines
2.3 KiB
Go
98 lines
2.3 KiB
Go
// Code generated by sqlc. DO NOT EDIT.
|
|
// versions:
|
|
// sqlc v1.29.0
|
|
// source: queries.sql
|
|
|
|
package db
|
|
|
|
import (
|
|
"context"
|
|
)
|
|
|
|
const deleteAllConfig = `-- name: DeleteAllConfig :exec
|
|
DELETE FROM config
|
|
`
|
|
|
|
func (q *Queries) DeleteAllConfig(ctx context.Context) error {
|
|
_, err := q.db.ExecContext(ctx, deleteAllConfig)
|
|
return err
|
|
}
|
|
|
|
const getConfig = `-- name: GetConfig :one
|
|
SELECT api_token, zone_id, domain, update_period FROM config LIMIT 1
|
|
`
|
|
|
|
func (q *Queries) GetConfig(ctx context.Context) (Config, error) {
|
|
row := q.db.QueryRowContext(ctx, getConfig)
|
|
var i Config
|
|
err := row.Scan(
|
|
&i.ApiToken,
|
|
&i.ZoneID,
|
|
&i.Domain,
|
|
&i.UpdatePeriod,
|
|
)
|
|
return i, err
|
|
}
|
|
|
|
const initSchema = `-- name: InitSchema :exec
|
|
CREATE TABLE IF NOT EXISTS config (
|
|
api_token TEXT NOT NULL DEFAULT '',
|
|
zone_id TEXT NOT NULL DEFAULT '',
|
|
domain TEXT NOT NULL DEFAULT 'mz.uy',
|
|
update_period TEXT NOT NULL DEFAULT '0 */6 * * *'
|
|
)
|
|
`
|
|
|
|
func (q *Queries) InitSchema(ctx context.Context) error {
|
|
_, err := q.db.ExecContext(ctx, initSchema)
|
|
return err
|
|
}
|
|
|
|
const insertConfig = `-- name: InsertConfig :exec
|
|
INSERT INTO config (api_token, zone_id, domain, update_period)
|
|
VALUES (?, ?, ?, ?)
|
|
`
|
|
|
|
type InsertConfigParams struct {
|
|
ApiToken string `json:"api_token"`
|
|
ZoneID string `json:"zone_id"`
|
|
Domain string `json:"domain"`
|
|
UpdatePeriod string `json:"update_period"`
|
|
}
|
|
|
|
func (q *Queries) InsertConfig(ctx context.Context, arg InsertConfigParams) error {
|
|
_, err := q.db.ExecContext(ctx, insertConfig,
|
|
arg.ApiToken,
|
|
arg.ZoneID,
|
|
arg.Domain,
|
|
arg.UpdatePeriod,
|
|
)
|
|
return err
|
|
}
|
|
|
|
const upsertConfig = `-- name: UpsertConfig :exec
|
|
INSERT INTO config (api_token, zone_id, domain, update_period)
|
|
VALUES (?, ?, ?, ?)
|
|
ON CONFLICT DO UPDATE SET
|
|
api_token = excluded.api_token,
|
|
zone_id = excluded.zone_id,
|
|
domain = excluded.domain,
|
|
update_period = excluded.update_period
|
|
`
|
|
|
|
type UpsertConfigParams struct {
|
|
ApiToken string `json:"api_token"`
|
|
ZoneID string `json:"zone_id"`
|
|
Domain string `json:"domain"`
|
|
UpdatePeriod string `json:"update_period"`
|
|
}
|
|
|
|
func (q *Queries) UpsertConfig(ctx context.Context, arg UpsertConfigParams) error {
|
|
_, err := q.db.ExecContext(ctx, upsertConfig,
|
|
arg.ApiToken,
|
|
arg.ZoneID,
|
|
arg.Domain,
|
|
arg.UpdatePeriod,
|
|
)
|
|
return err
|
|
}
|