sqlcgen

package
v1.1.2 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: May 29, 2026 License: Apache-2.0 Imports: 2 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Account 

type Account struct {
	ID             string
	Username       string
	Pwhash         string
	Role           string
	SessionID      sql.NullString
	SessionCreated sql.NullInt64
	CreatedAt      int64
	LastLogin      sql.NullInt64
}

type AddSubscriptionParams 

type AddSubscriptionParams struct {
	Username string
	Url      string
	Created  int64
}

type ApiKey 

type ApiKey struct {
	ID        string
	AccountID string
	Name      string
	Prefix    string
	Hash      string
	Role      string
	CreatedAt int64
	LastUsed  sql.NullInt64
}

type CreateAPIKeyParams 

type CreateAPIKeyParams struct {
	ID        string
	AccountID string
	Name      string
	Prefix    string
	Hash      string
	Role      string
	CreatedAt int64
}

type CreateAccountParams 

type CreateAccountParams struct {
	ID        string
	Username  string
	Pwhash    string
	Role      string
	CreatedAt int64
}

type CreateDeviceParams 

type CreateDeviceParams struct {
	ID       string
	Username string
	Caption  sql.NullString
	Type     string
}

type CreateUserParams 

type CreateUserParams struct {
	Username  string
	Pwhash    string
	AccountID string
}

type DBTX 

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 DeleteAPIKeyParams 

type DeleteAPIKeyParams struct {
	ID        string
	AccountID string
}

type DeleteDeviceParams 

type DeleteDeviceParams struct {
	ID       string
	Username string
}

type DeleteSubscriptionParams 

type DeleteSubscriptionParams struct {
	Deleted  sql.NullInt64
	Username string
	Url      string
}

type Device 

type Device struct {
	ID           string
	Username     string
	Caption      sql.NullString
	Type         string
	LastActivity sql.NullInt64
}

type Episode 

type Episode struct {
	Username    string
	Device      sql.NullString
	Podcast     string
	Episode     string
	Timestamp   sql.NullInt64
	Guid        sql.NullString
	Action      string
	Started     sql.NullInt64
	Position    sql.NullInt64
	Total       sql.NullInt64
	Modified    int64
	ContentHash string
}

type GetAccountByIDRow 

type GetAccountByIDRow struct {
	ID        string
	Username  string
	Pwhash    string
	Role      string
	SessionID sql.NullString
}

type GetAccountBySessionRow 

type GetAccountBySessionRow struct {
	ID             string
	Username       string
	Pwhash         string
	Role           string
	SessionID      sql.NullString
	SessionCreated sql.NullInt64
}

type GetAccountByUsernameRow 

type GetAccountByUsernameRow struct {
	ID        string
	Username  string
	Pwhash    string
	Role      string
	SessionID sql.NullString
}

type GetEpisodesByDeviceParams 

type GetEpisodesByDeviceParams struct {
	Username string
	Device   sql.NullString
	Modified int64
}

type GetEpisodesByDeviceRow 

type GetEpisodesByDeviceRow struct {
	Username  string
	Device    sql.NullString
	Podcast   string
	Episode   string
	Timestamp sql.NullInt64
	Guid      sql.NullString
	Action    string
	Started   sql.NullInt64
	Position  sql.NullInt64
	Total     sql.NullInt64
	Modified  int64
}

type GetEpisodesByPodcastAndDeviceParams 

type GetEpisodesByPodcastAndDeviceParams struct {
	Username string
	Podcast  string
	Device   sql.NullString
	Modified int64
}

type GetEpisodesByPodcastAndDeviceRow 

type GetEpisodesByPodcastAndDeviceRow struct {
	Username  string
	Device    sql.NullString
	Podcast   string
	Episode   string
	Timestamp sql.NullInt64
	Guid      sql.NullString
	Action    string
	Started   sql.NullInt64
	Position  sql.NullInt64
	Total     sql.NullInt64
	Modified  int64
}

type GetEpisodesByPodcastParams 

type GetEpisodesByPodcastParams struct {
	Username string
	Podcast  string
	Modified int64
}

type GetEpisodesByPodcastRow 

type GetEpisodesByPodcastRow struct {
	Username  string
	Device    sql.NullString
	Podcast   string
	Episode   string
	Timestamp sql.NullInt64
	Guid      sql.NullString
	Action    string
	Started   sql.NullInt64
	Position  sql.NullInt64
	Total     sql.NullInt64
	Modified  int64
}

type GetEpisodesParams 

type GetEpisodesParams struct {
	Username string
	Modified int64
}

type GetEpisodesRow 

type GetEpisodesRow struct {
	Username  string
	Device    sql.NullString
	Podcast   string
	Episode   string
	Timestamp sql.NullInt64
	Guid      sql.NullString
	Action    string
	Started   sql.NullInt64
	Position  sql.NullInt64
	Total     sql.NullInt64
	Modified  int64
}

type GetSubscriptionsSinceParams 

type GetSubscriptionsSinceParams struct {
	Username string
	Created  int64
	Deleted  sql.NullInt64
}

type GetSubscriptionsSinceRow 

type GetSubscriptionsSinceRow struct {
	Url       string
	IsDeleted int64
}

type GetUserBySessionRow 

type GetUserBySessionRow struct {
	Username       string
	Pwhash         string
	SessionID      sql.NullString
	SessionCreated sql.NullInt64
	AccountID      string
	LastActivity   sql.NullInt64
}

type GetUserByShareTokenRow 

type GetUserByShareTokenRow struct {
	Username   string
	AccountID  string
	ShareToken sql.NullString
}

type GetUserRow 

type GetUserRow struct {
	Username     string
	Pwhash       string
	SessionID    sql.NullString
	AccountID    string
	LastActivity sql.NullInt64
	ShareToken   sql.NullString
}

type ListAPIKeysByAccountRow 

type ListAPIKeysByAccountRow struct {
	ID        string
	AccountID string
	Name      string
	Prefix    string
	Role      string
	CreatedAt int64
	LastUsed  sql.NullInt64
}

type ListAccountsRow 

type ListAccountsRow struct {
	ID           string
	Username     string
	Role         string
	CreatedAt    int64
	LastLogin    sql.NullInt64
	UserCount    int64
	LastActivity interface{}
}

type ListInactiveAccountsRow 

type ListInactiveAccountsRow struct {
	ID        string
	Username  string
	Role      string
	CreatedAt int64
}

type ListUsersByAccountRow 

type ListUsersByAccountRow struct {
	Username     string
	AccountID    string
	LastActivity sql.NullInt64
}

type ListUsersByAccountWithStatsRow 

type ListUsersByAccountWithStatsRow struct {
	Username          string
	AccountID         string
	LastActivity      sql.NullInt64
	DeviceCount       int64
	SubscriptionCount int64
}

type ListUsersRow 

type ListUsersRow struct {
	Username    string
	AccountID   string
	AccountName string
}

type Queries 

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

func New 

func New(db DBTX) *Queries

func (*Queries) AddSubscription 

func (q *Queries) AddSubscription(ctx context.Context, arg AddSubscriptionParams) error

func (*Queries) CountAPIKeysByAccount 

func (q *Queries) CountAPIKeysByAccount(ctx context.Context, accountID string) (int64, error)

func (*Queries) CountAccounts 

func (q *Queries) CountAccounts(ctx context.Context) (int64, error)

func (*Queries) CountActiveSubscriptions 

func (q *Queries) CountActiveSubscriptions(ctx context.Context) (int64, error)

func (*Queries) CountDevices 

func (q *Queries) CountDevices(ctx context.Context) (int64, error)

func (*Queries) CountEpisodes 

func (q *Queries) CountEpisodes(ctx context.Context) (int64, error)

func (*Queries) CountUsers 

func (q *Queries) CountUsers(ctx context.Context) (int64, error)

Stats

func (*Queries) CreateAPIKey 

func (q *Queries) CreateAPIKey(ctx context.Context, arg CreateAPIKeyParams) error

API Keys

func (*Queries) CreateAccount 

func (q *Queries) CreateAccount(ctx context.Context, arg CreateAccountParams) error

func (*Queries) CreateDevice 

func (q *Queries) CreateDevice(ctx context.Context, arg CreateDeviceParams) error

func (*Queries) CreateUser 

func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) error

func (*Queries) DeleteAPIKey 

func (q *Queries) DeleteAPIKey(ctx context.Context, arg DeleteAPIKeyParams) error

func (*Queries) DeleteAPIKeysByAccount 

func (q *Queries) DeleteAPIKeysByAccount(ctx context.Context, accountID string) error

func (*Queries) DeleteAccount 

func (q *Queries) DeleteAccount(ctx context.Context, id string) error

func (*Queries) DeleteAllUserDevices 

func (q *Queries) DeleteAllUserDevices(ctx context.Context, username string) error

func (*Queries) DeleteAllUserEpisodes 

func (q *Queries) DeleteAllUserEpisodes(ctx context.Context, username string) error

func (*Queries) DeleteAllUserSubscriptions 

func (q *Queries) DeleteAllUserSubscriptions(ctx context.Context, username string) error

func (*Queries) DeleteDevice 

func (q *Queries) DeleteDevice(ctx context.Context, arg DeleteDeviceParams) error

func (*Queries) DeleteEpisodesOlderThan 

func (q *Queries) DeleteEpisodesOlderThan(ctx context.Context, modified int64) (sql.Result, error)

func (*Queries) DeleteSubscription 

func (q *Queries) DeleteSubscription(ctx context.Context, arg DeleteSubscriptionParams) error

func (*Queries) DeleteUser 

func (q *Queries) DeleteUser(ctx context.Context, username string) error

func (*Queries) DeleteUsersByAccount 

func (q *Queries) DeleteUsersByAccount(ctx context.Context, accountID string) error

func (*Queries) GetAPIKeysByPrefix 

func (q *Queries) GetAPIKeysByPrefix(ctx context.Context, prefix string) ([]ApiKey, error)

func (*Queries) GetAccountByID 

func (q *Queries) GetAccountByID(ctx context.Context, id string) (GetAccountByIDRow, error)

Accounts

func (*Queries) GetAccountBySession 

func (q *Queries) GetAccountBySession(ctx context.Context, sessionID sql.NullString) (GetAccountBySessionRow, error)

func (*Queries) GetAccountByUsername 

func (q *Queries) GetAccountByUsername(ctx context.Context, username string) (GetAccountByUsernameRow, error)

func (*Queries) GetEpisodes 

func (q *Queries) GetEpisodes(ctx context.Context, arg GetEpisodesParams) ([]GetEpisodesRow, error)

Episodes

func (*Queries) GetEpisodesByDevice 

func (q *Queries) GetEpisodesByDevice(ctx context.Context, arg GetEpisodesByDeviceParams) ([]GetEpisodesByDeviceRow, error)

func (*Queries) GetEpisodesByPodcast 

func (q *Queries) GetEpisodesByPodcast(ctx context.Context, arg GetEpisodesByPodcastParams) ([]GetEpisodesByPodcastRow, error)

func (*Queries) GetEpisodesByPodcastAndDevice 

func (q *Queries) GetEpisodesByPodcastAndDevice(ctx context.Context, arg GetEpisodesByPodcastAndDeviceParams) ([]GetEpisodesByPodcastAndDeviceRow, error)

func (*Queries) GetSetting 

func (q *Queries) GetSetting(ctx context.Context, key string) (string, error)

Settings

func (*Queries) GetSubscriptions 

func (q *Queries) GetSubscriptions(ctx context.Context, username string) ([]string, error)

Subscriptions

func (*Queries) GetSubscriptionsSince 

func (q *Queries) GetSubscriptionsSince(ctx context.Context, arg GetSubscriptionsSinceParams) ([]GetSubscriptionsSinceRow, error)

func (*Queries) GetUser 

func (q *Queries) GetUser(ctx context.Context, username string) (GetUserRow, error)

Users (gPodder API)

func (*Queries) GetUserBySession 

func (q *Queries) GetUserBySession(ctx context.Context, sessionID sql.NullString) (GetUserBySessionRow, error)

func (*Queries) GetUserByShareToken 

func (q *Queries) GetUserByShareToken(ctx context.Context, shareToken sql.NullString) (GetUserByShareTokenRow, error)

func (*Queries) ListAPIKeysByAccount 

func (q *Queries) ListAPIKeysByAccount(ctx context.Context, accountID string) ([]ListAPIKeysByAccountRow, error)

func (*Queries) ListAccounts 

func (q *Queries) ListAccounts(ctx context.Context) ([]ListAccountsRow, error)

func (*Queries) ListDevices 

func (q *Queries) ListDevices(ctx context.Context, username string) ([]Device, error)

Devices

func (*Queries) ListInactiveAccounts 

func (q *Queries) ListInactiveAccounts(ctx context.Context, lastActivity sql.NullInt64) ([]ListInactiveAccountsRow, error)

func (*Queries) ListUsers 

func (q *Queries) ListUsers(ctx context.Context) ([]ListUsersRow, error)

func (*Queries) ListUsersByAccount 

func (q *Queries) ListUsersByAccount(ctx context.Context, accountID string) ([]ListUsersByAccountRow, error)

func (*Queries) ListUsersByAccountWithStats 

func (q *Queries) ListUsersByAccountWithStats(ctx context.Context, accountID string) ([]ListUsersByAccountWithStatsRow, error)

func (*Queries) ReactivateSubscription 

func (q *Queries) ReactivateSubscription(ctx context.Context, arg ReactivateSubscriptionParams) error

func (*Queries) UpdateAPIKeyLastUsed 

func (q *Queries) UpdateAPIKeyLastUsed(ctx context.Context, arg UpdateAPIKeyLastUsedParams) error

func (*Queries) UpdateAccountLastLogin 

func (q *Queries) UpdateAccountLastLogin(ctx context.Context, arg UpdateAccountLastLoginParams) error

func (*Queries) UpdateAccountPassword 

func (q *Queries) UpdateAccountPassword(ctx context.Context, arg UpdateAccountPasswordParams) error

func (*Queries) UpdateAccountRole 

func (q *Queries) UpdateAccountRole(ctx context.Context, arg UpdateAccountRoleParams) error

func (*Queries) UpdateAccountSession 

func (q *Queries) UpdateAccountSession(ctx context.Context, arg UpdateAccountSessionParams) error

func (*Queries) UpdateAccountUsername 

func (q *Queries) UpdateAccountUsername(ctx context.Context, arg UpdateAccountUsernameParams) error

func (*Queries) UpdateDeviceCaption 

func (q *Queries) UpdateDeviceCaption(ctx context.Context, arg UpdateDeviceCaptionParams) error

func (*Queries) UpdateDeviceLastActivity 

func (q *Queries) UpdateDeviceLastActivity(ctx context.Context, arg UpdateDeviceLastActivityParams) error

func (*Queries) UpdateDeviceType 

func (q *Queries) UpdateDeviceType(ctx context.Context, arg UpdateDeviceTypeParams) error

func (*Queries) UpdateUserLastActivity 

func (q *Queries) UpdateUserLastActivity(ctx context.Context, arg UpdateUserLastActivityParams) error

func (*Queries) UpdateUserPassword 

func (q *Queries) UpdateUserPassword(ctx context.Context, arg UpdateUserPasswordParams) error

func (*Queries) UpdateUserSession 

func (q *Queries) UpdateUserSession(ctx context.Context, arg UpdateUserSessionParams) error

func (*Queries) UpdateUserShareToken 

func (q *Queries) UpdateUserShareToken(ctx context.Context, arg UpdateUserShareTokenParams) error

func (*Queries) UpsertEpisode 

func (q *Queries) UpsertEpisode(ctx context.Context, arg UpsertEpisodeParams) error

func (*Queries) UpsertSetting 

func (q *Queries) UpsertSetting(ctx context.Context, arg UpsertSettingParams) error

func (*Queries) WithTx 

func (q *Queries) WithTx(tx *sql.Tx) *Queries

type ReactivateSubscriptionParams 

type ReactivateSubscriptionParams struct {
	Created  int64
	Username string
	Url      string
}

type Setting 

type Setting struct {
	Key   string
	Value string
}

type Subscription 

type Subscription struct {
	Username string
	Url      string
	Created  int64
	Deleted  sql.NullInt64
}

type UpdateAPIKeyLastUsedParams 

type UpdateAPIKeyLastUsedParams struct {
	LastUsed sql.NullInt64
	ID       string
}

type UpdateAccountLastLoginParams 

type UpdateAccountLastLoginParams struct {
	LastLogin sql.NullInt64
	ID        string
}

type UpdateAccountPasswordParams 

type UpdateAccountPasswordParams struct {
	Pwhash string
	ID     string
}

type UpdateAccountRoleParams 

type UpdateAccountRoleParams struct {
	Role string
	ID   string
}

type UpdateAccountSessionParams 

type UpdateAccountSessionParams struct {
	SessionID      sql.NullString
	SessionCreated sql.NullInt64
	ID             string
}

type UpdateAccountUsernameParams 

type UpdateAccountUsernameParams struct {
	Username string
	ID       string
}

type UpdateDeviceCaptionParams 

type UpdateDeviceCaptionParams struct {
	Caption  sql.NullString
	ID       string
	Username string
}

type UpdateDeviceLastActivityParams 

type UpdateDeviceLastActivityParams struct {
	LastActivity sql.NullInt64
	ID           string
	Username     string
}

type UpdateDeviceTypeParams 

type UpdateDeviceTypeParams struct {
	Type     string
	ID       string
	Username string
}

type UpdateUserLastActivityParams 

type UpdateUserLastActivityParams struct {
	LastActivity sql.NullInt64
	Username     string
}

type UpdateUserPasswordParams 

type UpdateUserPasswordParams struct {
	Pwhash   string
	Username string
}

type UpdateUserSessionParams 

type UpdateUserSessionParams struct {
	SessionID      sql.NullString
	SessionCreated sql.NullInt64
	Username       string
}

type UpdateUserShareTokenParams 

type UpdateUserShareTokenParams struct {
	ShareToken sql.NullString
	Username   string
}

type UpsertEpisodeParams 

type UpsertEpisodeParams struct {
	Username    string
	Device      sql.NullString
	Podcast     string
	Episode     string
	Timestamp   sql.NullInt64
	Guid        sql.NullString
	Action      string
	Started     sql.NullInt64
	Position    sql.NullInt64
	Total       sql.NullInt64
	Modified    int64
	ContentHash string
}

type UpsertSettingParams 

type UpsertSettingParams struct {
	Key   string
	Value string
}

type User 

type User struct {
	Username       string
	Pwhash         string
	SessionID      sql.NullString
	SessionCreated sql.NullInt64
	AccountID      string
	LastActivity   sql.NullInt64
	ShareToken     sql.NullString
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.