Help us shape the future of Go! Take the 2026 Go Developer Survey

sqlc

package
v0.2.0 Latest Latest
Warning

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

Go to latest
Published: Jan 7, 2026 License: GPL-3.0 Imports: 6 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Album

type Album struct {
	ID          int32
	SpotifyID   string
	Name        pgtype.Text
	TrackAmount pgtype.Int4
	Popularity  pgtype.Int4
	CoverUrl    pgtype.Text
	CoverID     pgtype.Text
	UpdatedAt   pgtype.Timestamptz
}

type AlbumArtist

type AlbumArtist struct {
	ID       int32
	ArtistID int32
	AlbumID  int32
}

type AlbumArtistCreateParams

type AlbumArtistCreateParams struct {
	AlbumID  int32
	ArtistID int32
}

type AlbumArtistDeleteByArtistAlbumParams

type AlbumArtistDeleteByArtistAlbumParams struct {
	ArtistID int32
	AlbumID  int32
}

type AlbumCreateParams

type AlbumCreateParams struct {
	SpotifyID   string
	Name        pgtype.Text
	TrackAmount pgtype.Int4
	Popularity  pgtype.Int4
	CoverID     pgtype.Text
	CoverUrl    pgtype.Text
}

type AlbumUpdateParams

type AlbumUpdateParams struct {
	ID          int32
	Name        pgtype.Text
	TrackAmount pgtype.Int4
	Popularity  pgtype.Int4
	CoverID     pgtype.Text
	CoverUrl    pgtype.Text
}

type AlbumUser

type AlbumUser struct {
	ID        int32
	UserID    int32
	AlbumID   int32
	DeletedAt pgtype.Timestamptz
}

type AlbumUserCreateParams

type AlbumUserCreateParams struct {
	UserID  int32
	AlbumID int32
}

type AlbumUserDeleteByUserAlbumParams

type AlbumUserDeleteByUserAlbumParams struct {
	UserID  int32
	AlbumID int32
}

type Artist

type Artist struct {
	ID         int32
	SpotifyID  string
	Name       pgtype.Text
	Followers  pgtype.Int4
	Popularity pgtype.Int4
	CoverUrl   pgtype.Text
	CoverID    pgtype.Text
	UpdatedAt  pgtype.Timestamptz
}

type ArtistCreateParams

type ArtistCreateParams struct {
	SpotifyID  string
	Name       pgtype.Text
	Followers  pgtype.Int4
	Popularity pgtype.Int4
	CoverID    pgtype.Text
	CoverUrl   pgtype.Text
}

type ArtistUpdateParams

type ArtistUpdateParams struct {
	ID         int32
	Name       pgtype.Text
	Followers  pgtype.Int4
	Popularity pgtype.Int4
	CoverID    pgtype.Text
	CoverUrl   pgtype.Text
}

type DBTX

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type Directory

type Directory struct {
	ID       int32
	UserID   int32
	Name     string
	ParentID pgtype.Int4
}

type DirectoryCreateParams

type DirectoryCreateParams struct {
	UserID   int32
	Name     string
	ParentID pgtype.Int4
}

type DirectoryPlaylist

type DirectoryPlaylist struct {
	ID          int32
	DirectoryID int32
	PlaylistID  int32
}

type DirectoryPlaylistCreateParams

type DirectoryPlaylistCreateParams struct {
	DirectoryID int32
	PlaylistID  int32
}

type DirectoryUpdateParams

type DirectoryUpdateParams struct {
	ID       int32
	Name     string
	ParentID pgtype.Int4
}

type Generator added in v0.2.0

type Generator struct {
	ID              int32
	UserID          int32
	Name            string
	Description     pgtype.Text
	PlaylistID      pgtype.Int4
	Interval        pgtype.Int8
	SpotifyOutdated bool
	Parameters      []byte
	UpdatedAt       pgtype.Timestamptz
	CreatedAt       pgtype.Timestamptz
}

type GeneratorCreateParams added in v0.2.0

type GeneratorCreateParams struct {
	UserID          int32
	Name            string
	Description     pgtype.Text
	PlaylistID      pgtype.Int4
	Interval        pgtype.Int8
	SpotifyOutdated bool
	Parameters      []byte
}

type GeneratorGetAllRow added in v0.2.0

type GeneratorGetAllRow struct {
	Generator Generator
	User      User
}

type GeneratorGetByUserPopulatedRow added in v0.2.0

type GeneratorGetByUserPopulatedRow struct {
	Generator Generator
	Tracks    []byte
}

type GeneratorTrack added in v0.2.0

type GeneratorTrack struct {
	ID          int32
	GeneratorID int32
	TrackID     int32
}

type GeneratorTrackCreateBatchParams added in v0.2.0

type GeneratorTrackCreateBatchParams struct {
	Column1 []int32
	Column2 []int32
}

type GeneratorUpdateParams added in v0.2.0

type GeneratorUpdateParams struct {
	ID              int32
	Name            pgtype.Text
	Description     pgtype.Text
	PlaylistID      pgtype.Int4
	Interval        pgtype.Int8
	SpotifyOutdated pgtype.Bool
	Parameters      []byte
}

type History

type History struct {
	ID         int32
	UserID     int32
	TrackID    int32
	PlayedAt   pgtype.Timestamptz
	AlbumID    pgtype.Int4
	ArtistID   pgtype.Int4
	PlaylistID pgtype.Int4
	ShowID     pgtype.Int4
	Skipped    pgtype.Bool
}

type HistoryCreateBatchParams added in v0.2.0

type HistoryCreateBatchParams struct {
	Column1 []int32
	Column2 []int32
	Column3 []pgtype.Timestamptz
	Column4 []bool
}

type HistoryCreateParams

type HistoryCreateParams struct {
	UserID     int32
	TrackID    int32
	PlayedAt   pgtype.Timestamptz
	AlbumID    pgtype.Int4
	ArtistID   pgtype.Int4
	PlaylistID pgtype.Int4
	ShowID     pgtype.Int4
	Skipped    pgtype.Bool
}

type HistoryDeleteUserOlderParams added in v0.2.0

type HistoryDeleteUserOlderParams struct {
	UserID   int32
	PlayedAt pgtype.Timestamptz
}

type HistoryGetPopulatedFilteredPaginatedParams added in v0.2.0

type HistoryGetPopulatedFilteredPaginatedParams struct {
	Column1         int32
	Limit           int32
	Offset          int32
	Column4         pgtype.Timestamptz
	Column5         pgtype.Timestamptz
	Column6         bool
	Column7         bool
	FilterPlayCount interface{}
	FilterStart     interface{}
	FilterEnd       interface{}
	FilterSkipped   interface{}
}

type HistoryGetPopulatedFilteredPaginatedRow added in v0.2.0

type HistoryGetPopulatedFilteredPaginatedRow struct {
	History   History
	Track     Track
	PlayCount int64
}

type HistoryGetPopulatedFilteredParams

type HistoryGetPopulatedFilteredParams struct {
	Column1       int32
	Column2       pgtype.Timestamptz
	Column3       pgtype.Timestamptz
	Column4       bool
	FilterStart   interface{}
	FilterEnd     interface{}
	FilterSkipped interface{}
}

type HistoryGetPopulatedFilteredRow

type HistoryGetPopulatedFilteredRow struct {
	History History
	Track   Track
}

type HistoryGetPreviousPopulatedParams added in v0.2.0

type HistoryGetPreviousPopulatedParams struct {
	PlayedAt pgtype.Timestamptz
	UserID   int32
}

type HistoryGetPreviousPopulatedRow added in v0.2.0

type HistoryGetPreviousPopulatedRow struct {
	History History
	Track   Track
}

type HistoryGetSkippedNullPopulatedRow added in v0.2.0

type HistoryGetSkippedNullPopulatedRow struct {
	History History
	Track   Track
}

type HistoryUpdateParams added in v0.2.0

type HistoryUpdateParams struct {
	ID       int32
	PlayedAt pgtype.Timestamptz
	Skipped  pgtype.Bool
}
type Link struct {
	ID                int32
	SourceDirectoryID pgtype.Int4
	SourcePlaylistID  pgtype.Int4
	TargetDirectoryID pgtype.Int4
	TargetPlaylistID  pgtype.Int4
}

type LinkCreateParams

type LinkCreateParams struct {
	SourceDirectoryID pgtype.Int4
	SourcePlaylistID  pgtype.Int4
	TargetDirectoryID pgtype.Int4
	TargetPlaylistID  pgtype.Int4
}

type LinkUpdateParams

type LinkUpdateParams struct {
	ID                int32
	SourceDirectoryID pgtype.Int4
	SourcePlaylistID  pgtype.Int4
	TargetDirectoryID pgtype.Int4
	TargetPlaylistID  pgtype.Int4
}

type NullTaskResult

type NullTaskResult struct {
	TaskResult TaskResult
	Valid      bool // Valid is true if TaskResult is not NULL
}

func (*NullTaskResult) Scan

func (ns *NullTaskResult) Scan(value interface{}) error

Scan implements the Scanner interface.

func (NullTaskResult) Value

func (ns NullTaskResult) Value() (driver.Value, error)

Value implements the driver Valuer interface.

type Playlist

type Playlist struct {
	ID            int32
	SpotifyID     string
	Name          pgtype.Text
	Description   pgtype.Text
	Public        pgtype.Bool
	TrackAmount   pgtype.Int4
	Collaborative pgtype.Bool
	CoverID       pgtype.Text
	CoverUrl      pgtype.Text
	OwnerID       pgtype.Int4
	UpdatedAt     pgtype.Timestamptz
	SnapshotID    pgtype.Text
}

type PlaylistCreateParams

type PlaylistCreateParams struct {
	SpotifyID     string
	OwnerID       pgtype.Int4
	Name          pgtype.Text
	Description   pgtype.Text
	Public        pgtype.Bool
	TrackAmount   pgtype.Int4
	Collaborative pgtype.Bool
	CoverID       pgtype.Text
	CoverUrl      pgtype.Text
	SnapshotID    pgtype.Text
}

type PlaylistGetByUserWithOwnerRow

type PlaylistGetByUserWithOwnerRow struct {
	Playlist Playlist
	User     User
}

type PlaylistGetDuplicateTracksByUserRow

type PlaylistGetDuplicateTracksByUserRow struct {
	Playlist Playlist
	Track    Track
	User     User
}

type PlaylistGetUnplayableTracksByUserRow

type PlaylistGetUnplayableTracksByUserRow struct {
	Playlist Playlist
	Track    Track
	User     User
}

type PlaylistTrack

type PlaylistTrack struct {
	ID         int32
	PlaylistID int32
	TrackID    int32
	DeletedAt  pgtype.Timestamptz
	CreatedAt  pgtype.Timestamptz
}

type PlaylistTrackCreateParams

type PlaylistTrackCreateParams struct {
	PlaylistID int32
	TrackID    int32
}

type PlaylistTrackDeleteByPlaylistTrackParams

type PlaylistTrackDeleteByPlaylistTrackParams struct {
	PlaylistID int32
	TrackID    int32
}

type PlaylistUpdateBySpotifyParams

type PlaylistUpdateBySpotifyParams struct {
	SpotifyID     string
	OwnerID       pgtype.Int4
	Name          pgtype.Text
	Description   pgtype.Text
	Public        pgtype.Bool
	TrackAmount   pgtype.Int4
	Collaborative pgtype.Bool
	CoverID       pgtype.Text
	CoverUrl      pgtype.Text
	SnapshotID    pgtype.Text
}

type PlaylistUser

type PlaylistUser struct {
	ID         int32
	UserID     int32
	PlaylistID int32
	DeletedAt  pgtype.Timestamptz
}

type PlaylistUserCreateParams

type PlaylistUserCreateParams struct {
	UserID     int32
	PlaylistID int32
}

type PlaylistUserDeleteByUserPlaylistParams

type PlaylistUserDeleteByUserPlaylistParams struct {
	UserID     int32
	PlaylistID int32
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) AlbumArtistCreate

func (q *Queries) AlbumArtistCreate(ctx context.Context, arg AlbumArtistCreateParams) (int32, error)

func (*Queries) AlbumArtistDeleteByArtistAlbum

func (q *Queries) AlbumArtistDeleteByArtistAlbum(ctx context.Context, arg AlbumArtistDeleteByArtistAlbumParams) error

func (*Queries) AlbumCreate

func (q *Queries) AlbumCreate(ctx context.Context, arg AlbumCreateParams) (int32, error)

func (*Queries) AlbumGetAll

func (q *Queries) AlbumGetAll(ctx context.Context) ([]Album, error)

func (*Queries) AlbumGetBySpotify

func (q *Queries) AlbumGetBySpotify(ctx context.Context, spotifyID string) (Album, error)

func (*Queries) AlbumGetByUser

func (q *Queries) AlbumGetByUser(ctx context.Context, userID int32) ([]Album, error)

func (*Queries) AlbumUpdate

func (q *Queries) AlbumUpdate(ctx context.Context, arg AlbumUpdateParams) error

func (*Queries) AlbumUserCreate

func (q *Queries) AlbumUserCreate(ctx context.Context, arg AlbumUserCreateParams) (int32, error)

func (*Queries) AlbumUserDeleteByUserAlbum

func (q *Queries) AlbumUserDeleteByUserAlbum(ctx context.Context, arg AlbumUserDeleteByUserAlbumParams) error

func (*Queries) ArtistCreate

func (q *Queries) ArtistCreate(ctx context.Context, arg ArtistCreateParams) (int32, error)

func (*Queries) ArtistGetAll

func (q *Queries) ArtistGetAll(ctx context.Context) ([]Artist, error)

func (*Queries) ArtistGetByAlbum

func (q *Queries) ArtistGetByAlbum(ctx context.Context, albumID int32) ([]Artist, error)

func (*Queries) ArtistGetBySpotify

func (q *Queries) ArtistGetBySpotify(ctx context.Context, spotifyID string) (Artist, error)

func (*Queries) ArtistGetByTrack

func (q *Queries) ArtistGetByTrack(ctx context.Context, trackID int32) ([]Artist, error)

func (*Queries) ArtistUpdate

func (q *Queries) ArtistUpdate(ctx context.Context, arg ArtistUpdateParams) error

func (*Queries) DirectoryCreate

func (q *Queries) DirectoryCreate(ctx context.Context, arg DirectoryCreateParams) (int32, error)

func (*Queries) DirectoryDeleteByUser

func (q *Queries) DirectoryDeleteByUser(ctx context.Context, userID int32) error

func (*Queries) DirectoryGetByUser

func (q *Queries) DirectoryGetByUser(ctx context.Context, userID int32) ([]Directory, error)

func (*Queries) DirectoryPlaylistCreate

func (q *Queries) DirectoryPlaylistCreate(ctx context.Context, arg DirectoryPlaylistCreateParams) (int32, error)

func (*Queries) DirectoryPlaylistGetByDirectory

func (q *Queries) DirectoryPlaylistGetByDirectory(ctx context.Context, dollar_1 []int32) ([]DirectoryPlaylist, error)

func (*Queries) DirectoryUpdate

func (q *Queries) DirectoryUpdate(ctx context.Context, arg DirectoryUpdateParams) error

func (*Queries) GeneratorCreate added in v0.2.0

func (q *Queries) GeneratorCreate(ctx context.Context, arg GeneratorCreateParams) (int32, error)

func (*Queries) GeneratorDelete added in v0.2.0

func (q *Queries) GeneratorDelete(ctx context.Context, id int32) error

func (*Queries) GeneratorGet added in v0.2.0

func (q *Queries) GeneratorGet(ctx context.Context, id int32) (Generator, error)

func (*Queries) GeneratorGetAll added in v0.2.0

func (q *Queries) GeneratorGetAll(ctx context.Context) ([]GeneratorGetAllRow, error)

func (*Queries) GeneratorGetByUserPopulated added in v0.2.0

func (q *Queries) GeneratorGetByUserPopulated(ctx context.Context, userID int32) ([]GeneratorGetByUserPopulatedRow, error)

func (*Queries) GeneratorTrackCreateBatch added in v0.2.0

func (q *Queries) GeneratorTrackCreateBatch(ctx context.Context, arg GeneratorTrackCreateBatchParams) error

func (*Queries) GeneratorTrackDeleteByGenerator added in v0.2.0

func (q *Queries) GeneratorTrackDeleteByGenerator(ctx context.Context, generatorID int32) error

func (*Queries) GeneratorUpdate added in v0.2.0

func (q *Queries) GeneratorUpdate(ctx context.Context, arg GeneratorUpdateParams) error

func (*Queries) HistoryCreate

func (q *Queries) HistoryCreate(ctx context.Context, arg HistoryCreateParams) (int32, error)

func (*Queries) HistoryCreateBatch added in v0.2.0

func (q *Queries) HistoryCreateBatch(ctx context.Context, arg HistoryCreateBatchParams) error

func (*Queries) HistoryDeleteUserOlder added in v0.2.0

func (q *Queries) HistoryDeleteUserOlder(ctx context.Context, arg HistoryDeleteUserOlderParams) error

func (*Queries) HistoryGetPopulatedFilteredPaginated added in v0.2.0

func (*Queries) HistoryGetPreviousPopulated added in v0.2.0

func (*Queries) HistoryGetSkippedNullPopulated added in v0.2.0

func (q *Queries) HistoryGetSkippedNullPopulated(ctx context.Context, userID int32) ([]HistoryGetSkippedNullPopulatedRow, error)

func (*Queries) HistoryUpdate added in v0.2.0

func (q *Queries) HistoryUpdate(ctx context.Context, arg HistoryUpdateParams) error

func (*Queries) LinkCreate

func (q *Queries) LinkCreate(ctx context.Context, arg LinkCreateParams) (int32, error)

func (*Queries) LinkDelete

func (q *Queries) LinkDelete(ctx context.Context, id int32) error

func (*Queries) LinkGetByUser

func (q *Queries) LinkGetByUser(ctx context.Context, userID int32) ([]Link, error)

func (*Queries) LinkUpdate

func (q *Queries) LinkUpdate(ctx context.Context, arg LinkUpdateParams) error

func (*Queries) PlaylistCreate

func (q *Queries) PlaylistCreate(ctx context.Context, arg PlaylistCreateParams) (int32, error)

func (*Queries) PlaylistGet

func (q *Queries) PlaylistGet(ctx context.Context, id int32) (Playlist, error)

func (*Queries) PlaylistGetBySpotify

func (q *Queries) PlaylistGetBySpotify(ctx context.Context, spotifyID string) (Playlist, error)

func (*Queries) PlaylistGetByUser

func (q *Queries) PlaylistGetByUser(ctx context.Context, userID int32) ([]Playlist, error)

func (*Queries) PlaylistGetByUserWithOwner

func (q *Queries) PlaylistGetByUserWithOwner(ctx context.Context, userID int32) ([]PlaylistGetByUserWithOwnerRow, error)

func (*Queries) PlaylistGetDuplicateTracksByUser

func (q *Queries) PlaylistGetDuplicateTracksByUser(ctx context.Context, userID int32) ([]PlaylistGetDuplicateTracksByUserRow, error)

func (*Queries) PlaylistGetUnplayableTracksByUser

func (q *Queries) PlaylistGetUnplayableTracksByUser(ctx context.Context, userID int32) ([]PlaylistGetUnplayableTracksByUserRow, error)

func (*Queries) PlaylistTrackCreate

func (q *Queries) PlaylistTrackCreate(ctx context.Context, arg PlaylistTrackCreateParams) (int32, error)

func (*Queries) PlaylistTrackDeleteByPlaylistTrack

func (q *Queries) PlaylistTrackDeleteByPlaylistTrack(ctx context.Context, arg PlaylistTrackDeleteByPlaylistTrackParams) error

func (*Queries) PlaylistTrackGetByPlaylistIds added in v0.2.0

func (q *Queries) PlaylistTrackGetByPlaylistIds(ctx context.Context, dollar_1 []int32) ([]PlaylistTrack, error)

func (*Queries) PlaylistUpdateBySpotify

func (q *Queries) PlaylistUpdateBySpotify(ctx context.Context, arg PlaylistUpdateBySpotifyParams) error

func (*Queries) PlaylistUserCreate

func (q *Queries) PlaylistUserCreate(ctx context.Context, arg PlaylistUserCreateParams) (int32, error)

func (*Queries) PlaylistUserDeleteByUserPlaylist

func (q *Queries) PlaylistUserDeleteByUserPlaylist(ctx context.Context, arg PlaylistUserDeleteByUserPlaylistParams) error

func (*Queries) ShowCreate

func (q *Queries) ShowCreate(ctx context.Context, arg ShowCreateParams) (int32, error)

func (*Queries) ShowGetAll

func (q *Queries) ShowGetAll(ctx context.Context) ([]Show, error)

func (*Queries) ShowGetBySpotify

func (q *Queries) ShowGetBySpotify(ctx context.Context, spotifyID string) (Show, error)

func (*Queries) ShowGetByUser

func (q *Queries) ShowGetByUser(ctx context.Context, userID int32) ([]Show, error)

func (*Queries) ShowUpdate

func (q *Queries) ShowUpdate(ctx context.Context, arg ShowUpdateParams) error

func (*Queries) ShowUserCreate

func (q *Queries) ShowUserCreate(ctx context.Context, arg ShowUserCreateParams) (int32, error)

func (*Queries) ShowUserDeleteByUserShow

func (q *Queries) ShowUserDeleteByUserShow(ctx context.Context, arg ShowUserDeleteByUserShowParams) error

func (*Queries) TaskCreate

func (q *Queries) TaskCreate(ctx context.Context, arg TaskCreateParams) error

func (*Queries) TaskGetByUID

func (q *Queries) TaskGetByUID(ctx context.Context, uid string) (Task, error)

func (*Queries) TaskGetFiltered

func (q *Queries) TaskGetFiltered(ctx context.Context, arg TaskGetFilteredParams) ([]TaskGetFilteredRow, error)

func (*Queries) TaskGetLastAllByUser

func (q *Queries) TaskGetLastAllByUser(ctx context.Context, userID int32) ([]TaskRun, error)

func (*Queries) TaskRunCreate

func (q *Queries) TaskRunCreate(ctx context.Context, arg TaskRunCreateParams) (int32, error)

func (*Queries) TaskRunGet

func (q *Queries) TaskRunGet(ctx context.Context, id int32) (TaskRunGetRow, error)

func (*Queries) TaskSetInactiveAll

func (q *Queries) TaskSetInactiveAll(ctx context.Context) error

func (*Queries) TaskUpdate

func (q *Queries) TaskUpdate(ctx context.Context, arg TaskUpdateParams) error

func (*Queries) TrackArtistCreate

func (q *Queries) TrackArtistCreate(ctx context.Context, arg TrackArtistCreateParams) (int32, error)

func (*Queries) TrackArtistDeleteByArtistTrack

func (q *Queries) TrackArtistDeleteByArtistTrack(ctx context.Context, arg TrackArtistDeleteByArtistTrackParams) error

func (*Queries) TrackCreate

func (q *Queries) TrackCreate(ctx context.Context, arg TrackCreateParams) (int32, error)

func (*Queries) TrackGetAll

func (q *Queries) TrackGetAll(ctx context.Context) ([]Track, error)

func (*Queries) TrackGetAllById added in v0.2.0

func (q *Queries) TrackGetAllById(ctx context.Context, dollar_1 []int32) ([]Track, error)

func (*Queries) TrackGetAllBySpotify added in v0.2.0

func (q *Queries) TrackGetAllBySpotify(ctx context.Context, dollar_1 []string) ([]Track, error)

func (*Queries) TrackGetByGenerator added in v0.2.0

func (q *Queries) TrackGetByGenerator(ctx context.Context, generatorID int32) ([]Track, error)

func (*Queries) TrackGetByName

func (q *Queries) TrackGetByName(ctx context.Context, name pgtype.Text) ([]Track, error)

func (*Queries) TrackGetByPlaylist

func (q *Queries) TrackGetByPlaylist(ctx context.Context, playlistID int32) ([]Track, error)

func (*Queries) TrackGetBySpotify

func (q *Queries) TrackGetBySpotify(ctx context.Context, spotifyID string) (Track, error)

func (*Queries) TrackUpdate

func (q *Queries) TrackUpdate(ctx context.Context, arg TrackUpdateParams) error

func (*Queries) UserAlbumCreate

func (q *Queries) UserAlbumCreate(ctx context.Context, arg UserAlbumCreateParams) (int32, error)

func (*Queries) UserAlbumDelete

func (q *Queries) UserAlbumDelete(ctx context.Context, id int32) error

func (*Queries) UserCreate

func (q *Queries) UserCreate(ctx context.Context, arg UserCreateParams) (int32, error)

func (*Queries) UserGet

func (q *Queries) UserGet(ctx context.Context, id int32) (User, error)

func (*Queries) UserGetActualAll

func (q *Queries) UserGetActualAll(ctx context.Context) ([]User, error)

func (*Queries) UserGetAllByID

func (q *Queries) UserGetAllByID(ctx context.Context, dollar_1 []int32) ([]User, error)

func (*Queries) UserGetByUID

func (q *Queries) UserGetByUID(ctx context.Context, uid string) (User, error)

func (*Queries) UserPlaylistCreate

func (q *Queries) UserPlaylistCreate(ctx context.Context, arg UserPlaylistCreateParams) (int32, error)

func (*Queries) UserPlaylistDelete

func (q *Queries) UserPlaylistDelete(ctx context.Context, id int32) error

func (*Queries) UserShowCreate

func (q *Queries) UserShowCreate(ctx context.Context, arg UserShowCreateParams) (int32, error)

func (*Queries) UserShowDelete

func (q *Queries) UserShowDelete(ctx context.Context, id int32) error

func (*Queries) UserUpdate

func (q *Queries) UserUpdate(ctx context.Context, arg UserUpdateParams) error

func (*Queries) WithTx

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

type Show

type Show struct {
	ID            int32
	SpotifyID     string
	EpisodeAmount pgtype.Int4
	Name          pgtype.Text
	CoverUrl      pgtype.Text
	CoverID       pgtype.Text
	UpdatedAt     pgtype.Timestamptz
}

type ShowCreateParams

type ShowCreateParams struct {
	SpotifyID     string
	EpisodeAmount pgtype.Int4
	Name          pgtype.Text
	CoverID       pgtype.Text
	CoverUrl      pgtype.Text
}

type ShowUpdateParams

type ShowUpdateParams struct {
	ID            int32
	Name          pgtype.Text
	EpisodeAmount pgtype.Int4
	CoverID       pgtype.Text
	CoverUrl      pgtype.Text
}

type ShowUser

type ShowUser struct {
	ID        int32
	UserID    int32
	ShowID    int32
	DeletedAt pgtype.Timestamptz
}

type ShowUserCreateParams

type ShowUserCreateParams struct {
	UserID int32
	ShowID int32
}

type ShowUserDeleteByUserShowParams

type ShowUserDeleteByUserShowParams struct {
	UserID int32
	ShowID int32
}

type Task

type Task struct {
	Uid       string
	Name      string
	Active    bool
	Recurring bool
}

type TaskCreateParams

type TaskCreateParams struct {
	Uid       string
	Name      string
	Active    bool
	Recurring bool
}

type TaskGetFilteredParams

type TaskGetFilteredParams struct {
	Column1         int32
	Uid             string
	Result          TaskResult
	Recurring       bool
	Limit           int32
	Offset          int32
	FilterTaskUid   interface{}
	FilterResult    interface{}
	FilterRecurring interface{}
}

type TaskGetFilteredRow

type TaskGetFilteredRow struct {
	Task    Task
	TaskRun TaskRun
}

type TaskResult

type TaskResult string
const (
	TaskResultSuccess TaskResult = "success"
	TaskResultFailed  TaskResult = "failed"
)

func (*TaskResult) Scan

func (e *TaskResult) Scan(src interface{}) error

type TaskRun

type TaskRun struct {
	ID       int32
	TaskUid  string
	UserID   int32
	RunAt    pgtype.Timestamptz
	Result   TaskResult
	Error    pgtype.Text
	Duration int64
	Message  pgtype.Text
}

type TaskRunCreateParams

type TaskRunCreateParams struct {
	TaskUid  string
	UserID   int32
	RunAt    pgtype.Timestamptz
	Result   TaskResult
	Message  pgtype.Text
	Error    pgtype.Text
	Duration int64
}

type TaskRunGetRow

type TaskRunGetRow struct {
	Task    Task
	TaskRun TaskRun
}

type TaskUpdateParams

type TaskUpdateParams struct {
	Uid       string
	Name      pgtype.Text
	Active    pgtype.Bool
	Recurring pgtype.Bool
}

type Track

type Track struct {
	ID         int32
	SpotifyID  string
	Name       pgtype.Text
	Popularity pgtype.Int4
	UpdatedAt  pgtype.Timestamptz
	DurationMs pgtype.Int4
}

type TrackArtist

type TrackArtist struct {
	ID       int32
	ArtistID int32
	TrackID  int32
}

type TrackArtistCreateParams

type TrackArtistCreateParams struct {
	TrackID  int32
	ArtistID int32
}

type TrackArtistDeleteByArtistTrackParams

type TrackArtistDeleteByArtistTrackParams struct {
	ArtistID int32
	TrackID  int32
}

type TrackCreateParams

type TrackCreateParams struct {
	SpotifyID  string
	Name       pgtype.Text
	Popularity pgtype.Int4
	DurationMs pgtype.Int4
}

type TrackGetCreatedFilteredPopulatedParams

type TrackGetCreatedFilteredPopulatedParams struct {
	Limit            int32
	Offset           int32
	Column3          int32
	Column4          int32
	FilterPlaylistID interface{}
}

type TrackGetCreatedFilteredPopulatedRow

type TrackGetCreatedFilteredPopulatedRow struct {
	Track         Track
	PlaylistTrack PlaylistTrack
	Playlist      Playlist
	User          User
}

type TrackGetDeletedFilteredPopulatedParams

type TrackGetDeletedFilteredPopulatedParams struct {
	Limit            int32
	Offset           int32
	Column3          int32
	Column4          int32
	FilterPlaylistID interface{}
}

type TrackGetDeletedFilteredPopulatedRow

type TrackGetDeletedFilteredPopulatedRow struct {
	Track         Track
	PlaylistTrack PlaylistTrack
	Playlist      Playlist
	User          User
}

type TrackUpdateParams

type TrackUpdateParams struct {
	ID         int32
	Name       pgtype.Text
	Popularity pgtype.Int4
	DurationMs pgtype.Int4
}

type User

type User struct {
	ID          int32
	Uid         string
	Name        string
	DisplayName pgtype.Text
	Email       string
}

type UserAlbumCreateParams

type UserAlbumCreateParams struct {
	UserID  int32
	AlbumID int32
}

type UserCreateParams

type UserCreateParams struct {
	Uid         string
	Name        string
	DisplayName pgtype.Text
	Email       string
}

type UserPlaylistCreateParams

type UserPlaylistCreateParams struct {
	UserID     int32
	PlaylistID int32
}

type UserShowCreateParams

type UserShowCreateParams struct {
	UserID int32
	ShowID int32
}

type UserUpdateParams

type UserUpdateParams struct {
	ID          int32
	Name        string
	DisplayName pgtype.Text
	Email       string
}

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL