db

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type GetPayloadCacheRow struct {
	PluginID  string
	Payload   string
	FetchedAt int64
}

type InsertPageParams struct {
	Name string
	Ord  int64
}

type InsertPageWithIDParams struct {
	ID   int64
	Name string
	Ord  int64
}

type InsertZoneParams struct {
	ID          string
	PageID      int64
	Ord         int64
	WidthPx     int64
	Plugin      string
	RefreshMs   int64
	Align       string
	OnTap       string
	ChoicesJson string
	ConfigJson  string
	ThemeJson   string
}

type ListZonesForPageRow struct {
	ID          string
	PageID      int64
	Ord         int64
	WidthPx     int64
	Plugin      string
	RefreshMs   int64
	Align       string
	OnTap       string
	ChoicesJson string
	ConfigJson  string
	ThemeJson   string
}

type Page struct {
	ID   int64
	Name string
	Ord  int64
}

type PayloadCache struct {
	ZoneID    string
	PluginID  string
	Payload   string
	FetchedAt int64
}

type Querier interface {
	CountPages(ctx context.Context) (int64, error)
	DeleteAllPages(ctx context.Context) error
	DeletePage(ctx context.Context, id int64) error
	DeletePayloadCache(ctx context.Context, zoneID string) error
	DeleteZone(ctx context.Context, id string) error
	GetAllSettings(ctx context.Context) ([]Setting, error)
	GetPayloadCache(ctx context.Context, zoneID string) (GetPayloadCacheRow, error)
	GetSetting(ctx context.Context, key string) (string, error)
	GetZoneConfigJSON(ctx context.Context, id string) (string, error)
	GetZonePageID(ctx context.Context, id string) (int64, error)
	InsertPage(ctx context.Context, arg InsertPageParams) (int64, error)
	InsertPageWithID(ctx context.Context, arg InsertPageWithIDParams) error
	InsertZone(ctx context.Context, arg InsertZoneParams) error
	ListPages(ctx context.Context) ([]Page, error)
	ListZonesForPage(ctx context.Context, pageID int64) ([]ListZonesForPageRow, error)
	UpdatePage(ctx context.Context, arg UpdatePageParams) error
	UpdatePageOrd(ctx context.Context, arg UpdatePageOrdParams) error
	UpdateZone(ctx context.Context, arg UpdateZoneParams) (sql.Result, error)
	UpdateZoneConfigJSON(ctx context.Context, arg UpdateZoneConfigJSONParams) error
	UpdateZoneOrd(ctx context.Context, arg UpdateZoneOrdParams) error
	UpdateZonePlugin(ctx context.Context, arg UpdateZonePluginParams) error
	UpsertPayloadCache(ctx context.Context, arg UpsertPayloadCacheParams) error
	UpsertSetting(ctx context.Context, arg UpsertSettingParams) error
}

type Queries struct {
	// contains filtered or unexported fields
}

type SchemaVersion struct {
	Version int64
}

type Setting struct {
	Key   string
	Value string
}

type UpdatePageOrdParams struct {
	Ord int64
	ID  int64
}

type UpdatePageParams struct {
	Name string
	Ord  int64
	ID   int64
}

type UpdateZoneConfigJSONParams struct {
	ConfigJson string
	ID         string
}

type UpdateZoneOrdParams struct {
	Ord    int64
	ID     string
	PageID int64
}

type UpdateZoneParams struct {
	PageID      int64
	Ord         int64
	WidthPx     int64
	Plugin      string
	RefreshMs   int64
	Align       string
	OnTap       string
	ChoicesJson string
	ConfigJson  string
	ThemeJson   string
	ID          string
}

type UpdateZonePluginParams struct {
	Plugin string
	ID     string
}

type UpsertPayloadCacheParams struct {
	ZoneID    string
	PluginID  string
	Payload   string
	FetchedAt int64
}

type UpsertSettingParams struct {
	Key   string
	Value string
}

type Zone struct {
	ID          string
	PageID      int64
	Ord         int64
	WidthPx     int64
	Plugin      string
	RefreshMs   int64
	Align       string
	ConfigJson  string
	ThemeJson   string
	OnTap       string
	ChoicesJson string
}