sqlcgen

type AppState struct {
	Key   string
	Value string
}

type Category struct {
	ID         int64
	Name       string
	Color      string
	Icon       sql.NullString
	CreatedAt  int64
	IsArchived int64
}

type ClearLedgerOnExpensesParams struct {
	UpdatedAt int64
	LedgerID  sql.NullInt64
}

type CreateCategoryParams struct {
	Name      string
	Color     string
	Icon      sql.NullString
	CreatedAt int64
}

type CreateExpenseParams struct {
	Amount      int64
	Description string
	Notes       sql.NullString
	SpentAt     int64
	CategoryID  sql.NullInt64
	LedgerID    sql.NullInt64
	CreatedAt   int64
	UpdatedAt   int64
}

type CreateLedgerParams struct {
	Name         string
	Description  sql.NullString
	BudgetAmount sql.NullInt64
	StartDate    sql.NullInt64
	EndDate      sql.NullInt64
	CreatedAt    int64
	UpdatedAt    int64
}

type CreateOwnerParams struct {
	Email          string
	PasswordHash   string
	DisplayName    string
	CurrencyCode   string
	CurrencySymbol string
	Timezone       string
	CreatedAt      int64
	UpdatedAt      int64
}

type CreateSessionParams struct {
	ID        string
	CreatedAt int64
	ExpiresAt int64
	UserAgent sql.NullString
	IpAddress sql.NullString
}

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 DailySpendingBetweenParams struct {
	SpentAt   int64
	SpentAt_2 int64
}

type DailySpendingBetweenRow struct {
	Day   int64
	Total int64
}

type DailySpendingForLedgerRow struct {
	Day   int64
	Total int64
}

type Expense struct {
	ID          int64
	Amount      int64
	Description string
	Notes       sql.NullString
	SpentAt     int64
	CategoryID  sql.NullInt64
	LedgerID    sql.NullInt64
	CreatedAt   int64
	UpdatedAt   int64
	DeletedAt   sql.NullInt64
}

type GetSessionParams struct {
	ID        string
	ExpiresAt int64
}

type InsertLLMCallLogParams struct {
	Provider     string
	Model        string
	Purpose      string
	LatencyMs    int64
	InputTokens  sql.NullInt64
	OutputTokens sql.NullInt64
	Success      int64
	ErrorMessage sql.NullString
	CreatedAt    int64
}

type Ledger struct {
	ID           int64
	Name         string
	Description  sql.NullString
	BudgetAmount sql.NullInt64
	StartDate    sql.NullInt64
	EndDate      sql.NullInt64
	IsArchived   int64
	CreatedAt    int64
	UpdatedAt    int64
}

type ListDeletedExpensesParams struct {
	Limit  int64
	Offset int64
}

type ListDeletedExpensesRow struct {
	ID            int64
	Amount        int64
	Description   string
	Notes         sql.NullString
	SpentAt       int64
	CategoryID    sql.NullInt64
	LedgerID      sql.NullInt64
	CreatedAt     int64
	UpdatedAt     int64
	DeletedAt     sql.NullInt64
	CategoryName  sql.NullString
	CategoryColor sql.NullString
	LedgerName    sql.NullString
}

type ListExpensesByLedgerRow struct {
	ID            int64
	Amount        int64
	Description   string
	Notes         sql.NullString
	SpentAt       int64
	CategoryID    sql.NullInt64
	LedgerID      sql.NullInt64
	CreatedAt     int64
	UpdatedAt     int64
	CategoryName  sql.NullString
	CategoryColor sql.NullString
}

type ListRecentExpensesRow struct {
	ID            int64
	Amount        int64
	Description   string
	Notes         sql.NullString
	SpentAt       int64
	CategoryID    sql.NullInt64
	LedgerID      sql.NullInt64
	CreatedAt     int64
	UpdatedAt     int64
	CategoryName  sql.NullString
	CategoryColor sql.NullString
	LedgerName    sql.NullString
}

type LlmCallLog struct {
	ID           int64
	Provider     string
	Model        string
	Purpose      string
	LatencyMs    int64
	InputTokens  sql.NullInt64
	OutputTokens sql.NullInt64
	Success      int64
	ErrorMessage sql.NullString
	CreatedAt    int64
}

type LlmConfig struct {
	ID              int64
	Provider        string
	ApiKeyEncrypted sql.NullString
	TextModel       string
	Enabled         int64
	LastTestAt      sql.NullInt64
	LastTestSuccess int64
	LastTestError   sql.NullString
	CreatedAt       int64
	UpdatedAt       int64
}

type Owner struct {
	ID                 int64
	Email              string
	PasswordHash       string
	DisplayName        string
	CurrencyCode       string
	CurrencySymbol     string
	Timezone           string
	CreatedAt          int64
	UpdatedAt          int64
	TrashRetentionDays int64
	DashboardUrl       string
}

type Querier interface {
	// Counts active (non-trashed) expenses only.
	CategoryExpenseCount(ctx context.Context, categoryID sql.NullInt64) (int64, error)
	ClearLedgerOnExpenses(ctx context.Context, arg ClearLedgerOnExpensesParams) error
	// Disconnecting a chat keeps the bot polling so the user can re-pair from a
	// different Telegram account. The "Disable" button (SetTelegramEnabled) is
	// the only path that flips enabled to 0.
	ClearTelegramChatID(ctx context.Context, updatedAt int64) error
	ClearTelegramPairingCode(ctx context.Context, updatedAt int64) error
	CountDeletedExpenses(ctx context.Context) (int64, error)
	CreateCategory(ctx context.Context, arg CreateCategoryParams) (int64, error)
	CreateExpense(ctx context.Context, arg CreateExpenseParams) (int64, error)
	CreateLedger(ctx context.Context, arg CreateLedgerParams) (int64, error)
	CreateOwner(ctx context.Context, arg CreateOwnerParams) error
	CreateSession(ctx context.Context, arg CreateSessionParams) error
	DailySpendingBetween(ctx context.Context, arg DailySpendingBetweenParams) ([]DailySpendingBetweenRow, error)
	DailySpendingForLedger(ctx context.Context, ledgerID sql.NullInt64) ([]DailySpendingForLedgerRow, error)
	DeleteAllSessions(ctx context.Context) error
	DeleteExpiredSessions(ctx context.Context, expiresAt int64) (int64, error)
	DeleteLLMConfig(ctx context.Context) error
	DeleteLedger(ctx context.Context, id int64) error
	DeleteOldLLMCallLog(ctx context.Context, createdAt int64) (int64, error)
	DeleteSession(ctx context.Context, id string) error
	DeleteTelegramConfig(ctx context.Context) error
	// Hard-deletes every currently soft-deleted row.
	EmptyTrash(ctx context.Context) (int64, error)
	GetAppState(ctx context.Context, key string) (string, error)
	GetCategory(ctx context.Context, id int64) (Category, error)
	// Trash-only fetch: returns the row regardless of state, used by Restore /
	// HardDelete handlers that need to read a soft-deleted row.
	GetDeletedExpense(ctx context.Context, id int64) (Expense, error)
	// Returns only active rows. Trash UI uses GetDeletedExpense for the trash side.
	GetExpense(ctx context.Context, id int64) (Expense, error)
	GetLLMConfig(ctx context.Context) (LlmConfig, error)
	GetLedger(ctx context.Context, id int64) (Ledger, error)
	// Column order matches the table (post-migration: trash_retention_days
	// was ALTER-appended last) so sqlc emits the canonical Owner struct
	// rather than a one-off GetOwnerRow.
	GetOwner(ctx context.Context) (Owner, error)
	GetSession(ctx context.Context, arg GetSessionParams) (Session, error)
	GetTelegramConfig(ctx context.Context) (TelegramConfig, error)
	// Permanent delete. Used by the trash UI's "Delete forever" and by the
	// maintenance sweeper. Restricted to already-trashed rows so a stray call
	// can't bypass the trash.
	HardDeleteExpense(ctx context.Context, id int64) error
	InsertLLMCallLog(ctx context.Context, arg InsertLLMCallLogParams) error
	// Counts active (non-trashed) expenses only.
	LedgerExpenseCount(ctx context.Context, ledgerID sql.NullInt64) (int64, error)
	// Sums active (non-trashed) expenses only.
	LedgerTotalSpent(ctx context.Context, ledgerID sql.NullInt64) (int64, error)
	ListActiveCategories(ctx context.Context) ([]Category, error)
	ListActiveLedgers(ctx context.Context) ([]Ledger, error)
	ListAllCategories(ctx context.Context) ([]Category, error)
	ListAllLedgers(ctx context.Context) ([]Ledger, error)
	ListArchivedLedgers(ctx context.Context) ([]Ledger, error)
	// Trash listing, newest-deleted first.
	ListDeletedExpenses(ctx context.Context, arg ListDeletedExpensesParams) ([]ListDeletedExpensesRow, error)
	ListExpensesByLedger(ctx context.Context, ledgerID sql.NullInt64) ([]ListExpensesByLedgerRow, error)
	ListRecentExpenses(ctx context.Context, limit int64) ([]ListRecentExpensesRow, error)
	// Hard-deletes any soft-deleted rows older than the cutoff. Backs the
	// trash sweeper.
	PurgeOldDeletedExpenses(ctx context.Context, deletedAt sql.NullInt64) (int64, error)
	RecentLLMCallLog(ctx context.Context, limit int64) ([]LlmCallLog, error)
	// Brings a trashed row back. No-op for active rows.
	RestoreExpense(ctx context.Context, arg RestoreExpenseParams) error
	SetAppState(ctx context.Context, arg SetAppStateParams) error
	SetCategoryArchived(ctx context.Context, arg SetCategoryArchivedParams) error
	SetLLMEnabled(ctx context.Context, arg SetLLMEnabledParams) error
	SetLedgerArchived(ctx context.Context, arg SetLedgerArchivedParams) error
	SetTelegramActiveLedger(ctx context.Context, arg SetTelegramActiveLedgerParams) error
	SetTelegramChatID(ctx context.Context, arg SetTelegramChatIDParams) error
	SetTelegramEnabled(ctx context.Context, arg SetTelegramEnabledParams) error
	SetTelegramLastUpdateID(ctx context.Context, arg SetTelegramLastUpdateIDParams) error
	SetTelegramPairingCode(ctx context.Context, arg SetTelegramPairingCodeParams) error
	// Moves the row to trash. Idempotent: deleting an already-deleted row is a no-op.
	SoftDeleteExpense(ctx context.Context, arg SoftDeleteExpenseParams) error
	SpendingByCategoryBetween(ctx context.Context, arg SpendingByCategoryBetweenParams) ([]SpendingByCategoryBetweenRow, error)
	SpendingByCategoryForLedger(ctx context.Context, ledgerID sql.NullInt64) ([]SpendingByCategoryForLedgerRow, error)
	SpendingByLedgerBetween(ctx context.Context, arg SpendingByLedgerBetweenParams) ([]SpendingByLedgerBetweenRow, error)
	SummaryBetween(ctx context.Context, arg SummaryBetweenParams) (SummaryBetweenRow, error)
	TopExpensesBetween(ctx context.Context, arg TopExpensesBetweenParams) ([]TopExpensesBetweenRow, error)
	TotalSpentBetween(ctx context.Context, arg TotalSpentBetweenParams) (int64, error)
	UpdateCategory(ctx context.Context, arg UpdateCategoryParams) error
	UpdateExpense(ctx context.Context, arg UpdateExpenseParams) error
	UpdateLLMTestResult(ctx context.Context, arg UpdateLLMTestResultParams) error
	UpdateLedger(ctx context.Context, arg UpdateLedgerParams) error
	UpdateOwnerPassword(ctx context.Context, arg UpdateOwnerPasswordParams) error
	UpdateOwnerPreferences(ctx context.Context, arg UpdateOwnerPreferencesParams) error
	UpdateOwnerProfile(ctx context.Context, arg UpdateOwnerProfileParams) error
	UpdateOwnerTrashRetention(ctx context.Context, arg UpdateOwnerTrashRetentionParams) error
	UpsertLLMConfig(ctx context.Context, arg UpsertLLMConfigParams) error
	// Saving a bot token enables polling immediately so the bot can RECEIVE the
	// /start <pairing_code> message that completes the pairing. Without this,
	// the supervisor would never start the bot and pairing could never finish.
	UpsertTelegramBot(ctx context.Context, arg UpsertTelegramBotParams) error
}

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

type RestoreExpenseParams struct {
	UpdatedAt int64
	ID        int64
}

type Session struct {
	ID        string
	CreatedAt int64
	ExpiresAt int64
	UserAgent sql.NullString
	IpAddress sql.NullString
}

type SetAppStateParams struct {
	Key   string
	Value string
}

type SetCategoryArchivedParams struct {
	IsArchived int64
	ID         int64
}

type SetLLMEnabledParams struct {
	Enabled   int64
	UpdatedAt int64
}

type SetLedgerArchivedParams struct {
	IsArchived int64
	UpdatedAt  int64
	ID         int64
}

type SetTelegramActiveLedgerParams struct {
	ActiveLedgerID sql.NullInt64
	UpdatedAt      int64
}

type SetTelegramChatIDParams struct {
	ChatID    sql.NullInt64
	UpdatedAt int64
}

type SetTelegramEnabledParams struct {
	Enabled   int64
	UpdatedAt int64
}

type SetTelegramLastUpdateIDParams struct {
	LastUpdateID int64
	UpdatedAt    int64
}

type SetTelegramPairingCodeParams struct {
	PairingCode      sql.NullString
	PairingExpiresAt sql.NullInt64
	UpdatedAt        int64
}

type SoftDeleteExpenseParams struct {
	DeletedAt sql.NullInt64
	UpdatedAt int64
	ID        int64
}

type SpendingByCategoryBetweenParams struct {
	SpentAt   int64
	SpentAt_2 int64
}

type SpendingByCategoryBetweenRow struct {
	CategoryID    sql.NullInt64
	CategoryName  string
	CategoryColor string
	Total         int64
}

type SpendingByCategoryForLedgerRow struct {
	CategoryID    sql.NullInt64
	CategoryName  string
	CategoryColor string
	Total         int64
}

type SpendingByLedgerBetweenParams struct {
	SpentAt   int64
	SpentAt_2 int64
}

type SpendingByLedgerBetweenRow struct {
	LedgerID   sql.NullInt64
	LedgerName string
	Total      int64
}

type SummaryBetweenParams struct {
	SpentAt   int64
	SpentAt_2 int64
}

type SummaryBetweenRow struct {
	Total        int64
	ExpenseCount int64
}

type TelegramConfig struct {
	ID                int64
	BotTokenEncrypted string
	BotUsername       string
	ChatID            sql.NullInt64
	PairingCode       sql.NullString
	PairingExpiresAt  sql.NullInt64
	LastUpdateID      int64
	ActiveLedgerID    sql.NullInt64
	Enabled           int64
	CreatedAt         int64
	UpdatedAt         int64
}

type TopExpensesBetweenParams struct {
	SpentAt   int64
	SpentAt_2 int64
	Limit     int64
}

type TopExpensesBetweenRow struct {
	ID            int64
	Amount        int64
	Description   string
	SpentAt       int64
	CategoryName  sql.NullString
	CategoryColor sql.NullString
	LedgerName    sql.NullString
}

type TotalSpentBetweenParams struct {
	SpentAt   int64
	SpentAt_2 int64
}

type UpdateCategoryParams struct {
	Name  string
	Color string
	Icon  sql.NullString
	ID    int64
}

type UpdateExpenseParams struct {
	Amount      int64
	Description string
	Notes       sql.NullString
	SpentAt     int64
	CategoryID  sql.NullInt64
	LedgerID    sql.NullInt64
	UpdatedAt   int64
	ID          int64
}

type UpdateLLMTestResultParams struct {
	LastTestAt      sql.NullInt64
	LastTestSuccess int64
	LastTestError   sql.NullString
	UpdatedAt       int64
}

type UpdateLedgerParams struct {
	Name         string
	Description  sql.NullString
	BudgetAmount sql.NullInt64
	StartDate    sql.NullInt64
	EndDate      sql.NullInt64
	UpdatedAt    int64
	ID           int64
}

type UpdateOwnerDashboardURLParams struct {
	DashboardUrl string
	UpdatedAt    int64
}

type UpdateOwnerPasswordParams struct {
	PasswordHash string
	UpdatedAt    int64
}

type UpdateOwnerPreferencesParams struct {
	CurrencyCode   string
	CurrencySymbol string
	Timezone       string
	UpdatedAt      int64
}

type UpdateOwnerProfileParams struct {
	Email       string
	DisplayName string
	UpdatedAt   int64
}

type UpdateOwnerTrashRetentionParams struct {
	TrashRetentionDays int64
	UpdatedAt          int64
}

type UpsertLLMConfigParams struct {
	Provider        string
	ApiKeyEncrypted sql.NullString
	TextModel       string
	CreatedAt       int64
	UpdatedAt       int64
}

type UpsertTelegramBotParams struct {
	BotTokenEncrypted string
	BotUsername       string
	CreatedAt         int64
	UpdatedAt         int64
}