Versions in this module Expand all Collapse all v0 v0.2.0 Jan 7, 2026 Changes in this version + type Generator struct + CreatedAt pgtype.Timestamptz + Description pgtype.Text + ID int32 + Interval pgtype.Int8 + Name string + Parameters []byte + PlaylistID pgtype.Int4 + SpotifyOutdated bool + UpdatedAt pgtype.Timestamptz + UserID int32 + type GeneratorCreateParams struct + Description pgtype.Text + Interval pgtype.Int8 + Name string + Parameters []byte + PlaylistID pgtype.Int4 + SpotifyOutdated bool + UserID int32 + type GeneratorGetAllRow struct + Generator Generator + User User + type GeneratorGetByUserPopulatedRow struct + Generator Generator + Tracks []byte + type GeneratorTrack struct + GeneratorID int32 + ID int32 + TrackID int32 + type GeneratorTrackCreateBatchParams struct + Column1 []int32 + Column2 []int32 + type GeneratorUpdateParams struct + Description pgtype.Text + ID int32 + Interval pgtype.Int8 + Name pgtype.Text + Parameters []byte + PlaylistID pgtype.Int4 + SpotifyOutdated pgtype.Bool type History + Skipped pgtype.Bool + type HistoryCreateBatchParams struct + Column1 []int32 + Column2 []int32 + Column3 []pgtype.Timestamptz + Column4 []bool type HistoryCreateParams + Skipped pgtype.Bool + type HistoryDeleteUserOlderParams struct + PlayedAt pgtype.Timestamptz + UserID int32 + type HistoryGetPopulatedFilteredPaginatedParams struct + Column1 int32 + Column4 pgtype.Timestamptz + Column5 pgtype.Timestamptz + Column6 bool + Column7 bool + FilterEnd interface{} + FilterPlayCount interface{} + FilterSkipped interface{} + FilterStart interface{} + Limit int32 + Offset int32 + type HistoryGetPopulatedFilteredPaginatedRow struct + History History + PlayCount int64 + Track Track type HistoryGetPopulatedFilteredParams + Column2 pgtype.Timestamptz + Column3 pgtype.Timestamptz + FilterSkipped interface{} + type HistoryGetPreviousPopulatedParams struct + PlayedAt pgtype.Timestamptz + UserID int32 + type HistoryGetPreviousPopulatedRow struct + History History + Track Track + type HistoryGetSkippedNullPopulatedRow struct + History History + Track Track + type HistoryUpdateParams struct + ID int32 + PlayedAt pgtype.Timestamptz + Skipped pgtype.Bool type Queries + func (q *Queries) GeneratorCreate(ctx context.Context, arg GeneratorCreateParams) (int32, error) + func (q *Queries) GeneratorDelete(ctx context.Context, id int32) error + func (q *Queries) GeneratorGet(ctx context.Context, id int32) (Generator, error) + func (q *Queries) GeneratorGetAll(ctx context.Context) ([]GeneratorGetAllRow, error) + func (q *Queries) GeneratorGetByUserPopulated(ctx context.Context, userID int32) ([]GeneratorGetByUserPopulatedRow, error) + func (q *Queries) GeneratorTrackCreateBatch(ctx context.Context, arg GeneratorTrackCreateBatchParams) error + func (q *Queries) GeneratorTrackDeleteByGenerator(ctx context.Context, generatorID int32) error + func (q *Queries) GeneratorUpdate(ctx context.Context, arg GeneratorUpdateParams) error + func (q *Queries) HistoryCreateBatch(ctx context.Context, arg HistoryCreateBatchParams) error + func (q *Queries) HistoryDeleteUserOlder(ctx context.Context, arg HistoryDeleteUserOlderParams) error + func (q *Queries) HistoryGetPopulatedFilteredPaginated(ctx context.Context, arg HistoryGetPopulatedFilteredPaginatedParams) ([]HistoryGetPopulatedFilteredPaginatedRow, error) + func (q *Queries) HistoryGetPreviousPopulated(ctx context.Context, arg HistoryGetPreviousPopulatedParams) (HistoryGetPreviousPopulatedRow, error) + func (q *Queries) HistoryGetSkippedNullPopulated(ctx context.Context, userID int32) ([]HistoryGetSkippedNullPopulatedRow, error) + func (q *Queries) HistoryUpdate(ctx context.Context, arg HistoryUpdateParams) error + func (q *Queries) PlaylistTrackGetByPlaylistIds(ctx context.Context, dollar_1 []int32) ([]PlaylistTrack, error) + func (q *Queries) TrackGetAllById(ctx context.Context, dollar_1 []int32) ([]Track, error) + func (q *Queries) TrackGetAllBySpotify(ctx context.Context, dollar_1 []string) ([]Track, error) + func (q *Queries) TrackGetByGenerator(ctx context.Context, generatorID int32) ([]Track, error) type Task + Recurring bool type TaskCreateParams + Recurring bool type TaskGetFilteredParams + FilterRecurring interface{} + Recurring bool type TaskUpdateParams + Recurring pgtype.Bool type Track + DurationMs pgtype.Int4 type TrackCreateParams + DurationMs pgtype.Int4 type TrackUpdateParams + DurationMs pgtype.Int4 v0.1.1 Dec 28, 2025 v0.1.0 Dec 27, 2025 Changes in this version + type Album struct + CoverID pgtype.Text + CoverUrl pgtype.Text + ID int32 + Name pgtype.Text + Popularity pgtype.Int4 + SpotifyID string + TrackAmount pgtype.Int4 + UpdatedAt pgtype.Timestamptz + type AlbumArtist struct + AlbumID int32 + ArtistID int32 + ID int32 + type AlbumArtistCreateParams struct + AlbumID int32 + ArtistID int32 + type AlbumArtistDeleteByArtistAlbumParams struct + AlbumID int32 + ArtistID int32 + type AlbumCreateParams struct + CoverID pgtype.Text + CoverUrl pgtype.Text + Name pgtype.Text + Popularity pgtype.Int4 + SpotifyID string + TrackAmount pgtype.Int4 + type AlbumUpdateParams struct + CoverID pgtype.Text + CoverUrl pgtype.Text + ID int32 + Name pgtype.Text + Popularity pgtype.Int4 + TrackAmount pgtype.Int4 + type AlbumUser struct + AlbumID int32 + DeletedAt pgtype.Timestamptz + ID int32 + UserID int32 + type AlbumUserCreateParams struct + AlbumID int32 + UserID int32 + type AlbumUserDeleteByUserAlbumParams struct + AlbumID int32 + UserID int32 + type Artist struct + CoverID pgtype.Text + CoverUrl pgtype.Text + Followers pgtype.Int4 + ID int32 + Name pgtype.Text + Popularity pgtype.Int4 + SpotifyID string + UpdatedAt pgtype.Timestamptz + type ArtistCreateParams struct + CoverID pgtype.Text + CoverUrl pgtype.Text + Followers pgtype.Int4 + Name pgtype.Text + Popularity pgtype.Int4 + SpotifyID string + type ArtistUpdateParams struct + CoverID pgtype.Text + CoverUrl pgtype.Text + Followers pgtype.Int4 + ID int32 + Name pgtype.Text + Popularity pgtype.Int4 + type DBTX interface + Exec func(context.Context, string, ...interface{}) (pgconn.CommandTag, error) + Query func(context.Context, string, ...interface{}) (pgx.Rows, error) + QueryRow func(context.Context, string, ...interface{}) pgx.Row + type Directory struct + ID int32 + Name string + ParentID pgtype.Int4 + UserID int32 + type DirectoryCreateParams struct + Name string + ParentID pgtype.Int4 + UserID int32 + type DirectoryPlaylist struct + DirectoryID int32 + ID int32 + PlaylistID int32 + type DirectoryPlaylistCreateParams struct + DirectoryID int32 + PlaylistID int32 + type DirectoryUpdateParams struct + ID int32 + Name string + ParentID pgtype.Int4 + type History struct + AlbumID pgtype.Int4 + ArtistID pgtype.Int4 + ID int32 + PlayedAt pgtype.Timestamptz + PlaylistID pgtype.Int4 + ShowID pgtype.Int4 + TrackID int32 + UserID int32 + type HistoryCreateParams struct + AlbumID pgtype.Int4 + ArtistID pgtype.Int4 + PlayedAt pgtype.Timestamptz + PlaylistID pgtype.Int4 + ShowID pgtype.Int4 + TrackID int32 + UserID int32 + type HistoryGetPopulatedFilteredParams struct + Column1 int32 + Column4 pgtype.Timestamptz + Column5 pgtype.Timestamptz + FilterEnd interface{} + FilterStart interface{} + Limit int32 + Offset int32 + type HistoryGetPopulatedFilteredRow struct + History History + Track Track + type Link struct + ID int32 + SourceDirectoryID pgtype.Int4 + SourcePlaylistID pgtype.Int4 + TargetDirectoryID pgtype.Int4 + TargetPlaylistID pgtype.Int4 + type LinkCreateParams struct + SourceDirectoryID pgtype.Int4 + SourcePlaylistID pgtype.Int4 + TargetDirectoryID pgtype.Int4 + TargetPlaylistID pgtype.Int4 + type LinkUpdateParams struct + ID int32 + SourceDirectoryID pgtype.Int4 + SourcePlaylistID pgtype.Int4 + TargetDirectoryID pgtype.Int4 + TargetPlaylistID pgtype.Int4 + type NullTaskResult struct + TaskResult TaskResult + Valid bool + func (ns *NullTaskResult) Scan(value interface{}) error + func (ns NullTaskResult) Value() (driver.Value, error) + type Playlist struct + Collaborative pgtype.Bool + CoverID pgtype.Text + CoverUrl pgtype.Text + Description pgtype.Text + ID int32 + Name pgtype.Text + OwnerID pgtype.Int4 + Public pgtype.Bool + SnapshotID pgtype.Text + SpotifyID string + TrackAmount pgtype.Int4 + UpdatedAt pgtype.Timestamptz + type PlaylistCreateParams struct + Collaborative pgtype.Bool + CoverID pgtype.Text + CoverUrl pgtype.Text + Description pgtype.Text + Name pgtype.Text + OwnerID pgtype.Int4 + Public pgtype.Bool + SnapshotID pgtype.Text + SpotifyID string + TrackAmount pgtype.Int4 + type PlaylistGetByUserWithOwnerRow struct + Playlist Playlist + User User + type PlaylistGetDuplicateTracksByUserRow struct + Playlist Playlist + Track Track + User User + type PlaylistGetUnplayableTracksByUserRow struct + Playlist Playlist + Track Track + User User + type PlaylistTrack struct + CreatedAt pgtype.Timestamptz + DeletedAt pgtype.Timestamptz + ID int32 + PlaylistID int32 + TrackID int32 + type PlaylistTrackCreateParams struct + PlaylistID int32 + TrackID int32 + type PlaylistTrackDeleteByPlaylistTrackParams struct + PlaylistID int32 + TrackID int32 + type PlaylistUpdateBySpotifyParams struct + Collaborative pgtype.Bool + CoverID pgtype.Text + CoverUrl pgtype.Text + Description pgtype.Text + Name pgtype.Text + OwnerID pgtype.Int4 + Public pgtype.Bool + SnapshotID pgtype.Text + SpotifyID string + TrackAmount pgtype.Int4 + type PlaylistUser struct + DeletedAt pgtype.Timestamptz + ID int32 + PlaylistID int32 + UserID int32 + type PlaylistUserCreateParams struct + PlaylistID int32 + UserID int32 + type PlaylistUserDeleteByUserPlaylistParams struct + PlaylistID int32 + UserID int32 + type Queries struct + func New(db DBTX) *Queries + func (q *Queries) AlbumArtistCreate(ctx context.Context, arg AlbumArtistCreateParams) (int32, error) + func (q *Queries) AlbumArtistDeleteByArtistAlbum(ctx context.Context, arg AlbumArtistDeleteByArtistAlbumParams) error + func (q *Queries) AlbumCreate(ctx context.Context, arg AlbumCreateParams) (int32, error) + func (q *Queries) AlbumGetAll(ctx context.Context) ([]Album, error) + func (q *Queries) AlbumGetBySpotify(ctx context.Context, spotifyID string) (Album, error) + func (q *Queries) AlbumGetByUser(ctx context.Context, userID int32) ([]Album, error) + func (q *Queries) AlbumUpdate(ctx context.Context, arg AlbumUpdateParams) error + func (q *Queries) AlbumUserCreate(ctx context.Context, arg AlbumUserCreateParams) (int32, error) + func (q *Queries) AlbumUserDeleteByUserAlbum(ctx context.Context, arg AlbumUserDeleteByUserAlbumParams) error + func (q *Queries) ArtistCreate(ctx context.Context, arg ArtistCreateParams) (int32, error) + func (q *Queries) ArtistGetAll(ctx context.Context) ([]Artist, error) + func (q *Queries) ArtistGetByAlbum(ctx context.Context, albumID int32) ([]Artist, error) + func (q *Queries) ArtistGetBySpotify(ctx context.Context, spotifyID string) (Artist, error) + func (q *Queries) ArtistGetByTrack(ctx context.Context, trackID int32) ([]Artist, error) + func (q *Queries) ArtistUpdate(ctx context.Context, arg ArtistUpdateParams) error + func (q *Queries) DirectoryCreate(ctx context.Context, arg DirectoryCreateParams) (int32, error) + func (q *Queries) DirectoryDeleteByUser(ctx context.Context, userID int32) error + func (q *Queries) DirectoryGetByUser(ctx context.Context, userID int32) ([]Directory, error) + func (q *Queries) DirectoryPlaylistCreate(ctx context.Context, arg DirectoryPlaylistCreateParams) (int32, error) + func (q *Queries) DirectoryPlaylistGetByDirectory(ctx context.Context, dollar_1 []int32) ([]DirectoryPlaylist, error) + func (q *Queries) DirectoryUpdate(ctx context.Context, arg DirectoryUpdateParams) error + func (q *Queries) HistoryCreate(ctx context.Context, arg HistoryCreateParams) (int32, error) + func (q *Queries) HistoryGetLatestByUser(ctx context.Context, userID int32) (History, error) + func (q *Queries) HistoryGetPopulatedFiltered(ctx context.Context, arg HistoryGetPopulatedFilteredParams) ([]HistoryGetPopulatedFilteredRow, error) + func (q *Queries) LinkCreate(ctx context.Context, arg LinkCreateParams) (int32, error) + func (q *Queries) LinkDelete(ctx context.Context, id int32) error + func (q *Queries) LinkGetByUser(ctx context.Context, userID int32) ([]Link, error) + func (q *Queries) LinkUpdate(ctx context.Context, arg LinkUpdateParams) error + func (q *Queries) PlaylistCreate(ctx context.Context, arg PlaylistCreateParams) (int32, error) + func (q *Queries) PlaylistGet(ctx context.Context, id int32) (Playlist, error) + func (q *Queries) PlaylistGetBySpotify(ctx context.Context, spotifyID string) (Playlist, error) + func (q *Queries) PlaylistGetByUser(ctx context.Context, userID int32) ([]Playlist, error) + func (q *Queries) PlaylistGetByUserWithOwner(ctx context.Context, userID int32) ([]PlaylistGetByUserWithOwnerRow, error) + func (q *Queries) PlaylistGetDuplicateTracksByUser(ctx context.Context, userID int32) ([]PlaylistGetDuplicateTracksByUserRow, error) + func (q *Queries) PlaylistGetUnplayableTracksByUser(ctx context.Context, userID int32) ([]PlaylistGetUnplayableTracksByUserRow, error) + func (q *Queries) PlaylistTrackCreate(ctx context.Context, arg PlaylistTrackCreateParams) (int32, error) + func (q *Queries) PlaylistTrackDeleteByPlaylistTrack(ctx context.Context, arg PlaylistTrackDeleteByPlaylistTrackParams) error + func (q *Queries) PlaylistUpdateBySpotify(ctx context.Context, arg PlaylistUpdateBySpotifyParams) error + func (q *Queries) PlaylistUserCreate(ctx context.Context, arg PlaylistUserCreateParams) (int32, error) + func (q *Queries) PlaylistUserDeleteByUserPlaylist(ctx context.Context, arg PlaylistUserDeleteByUserPlaylistParams) error + func (q *Queries) ShowCreate(ctx context.Context, arg ShowCreateParams) (int32, error) + func (q *Queries) ShowGetAll(ctx context.Context) ([]Show, error) + func (q *Queries) ShowGetBySpotify(ctx context.Context, spotifyID string) (Show, error) + func (q *Queries) ShowGetByUser(ctx context.Context, userID int32) ([]Show, error) + func (q *Queries) ShowUpdate(ctx context.Context, arg ShowUpdateParams) error + func (q *Queries) ShowUserCreate(ctx context.Context, arg ShowUserCreateParams) (int32, error) + func (q *Queries) ShowUserDeleteByUserShow(ctx context.Context, arg ShowUserDeleteByUserShowParams) error + func (q *Queries) TaskCreate(ctx context.Context, arg TaskCreateParams) error + func (q *Queries) TaskGetByUID(ctx context.Context, uid string) (Task, error) + func (q *Queries) TaskGetFiltered(ctx context.Context, arg TaskGetFilteredParams) ([]TaskGetFilteredRow, error) + func (q *Queries) TaskGetLastAllByUser(ctx context.Context, userID int32) ([]TaskRun, error) + func (q *Queries) TaskRunCreate(ctx context.Context, arg TaskRunCreateParams) (int32, error) + func (q *Queries) TaskRunGet(ctx context.Context, id int32) (TaskRunGetRow, error) + func (q *Queries) TaskSetInactiveAll(ctx context.Context) error + func (q *Queries) TaskUpdate(ctx context.Context, arg TaskUpdateParams) error + func (q *Queries) TrackArtistCreate(ctx context.Context, arg TrackArtistCreateParams) (int32, error) + func (q *Queries) TrackArtistDeleteByArtistTrack(ctx context.Context, arg TrackArtistDeleteByArtistTrackParams) error + func (q *Queries) TrackCreate(ctx context.Context, arg TrackCreateParams) (int32, error) + func (q *Queries) TrackGetAll(ctx context.Context) ([]Track, error) + func (q *Queries) TrackGetByName(ctx context.Context, name pgtype.Text) ([]Track, error) + func (q *Queries) TrackGetByPlaylist(ctx context.Context, playlistID int32) ([]Track, error) + func (q *Queries) TrackGetBySpotify(ctx context.Context, spotifyID string) (Track, error) + func (q *Queries) TrackGetCreatedFilteredPopulated(ctx context.Context, arg TrackGetCreatedFilteredPopulatedParams) ([]TrackGetCreatedFilteredPopulatedRow, error) + func (q *Queries) TrackGetDeletedFilteredPopulated(ctx context.Context, arg TrackGetDeletedFilteredPopulatedParams) ([]TrackGetDeletedFilteredPopulatedRow, error) + func (q *Queries) TrackUpdate(ctx context.Context, arg TrackUpdateParams) error + func (q *Queries) UserAlbumCreate(ctx context.Context, arg UserAlbumCreateParams) (int32, error) + func (q *Queries) UserAlbumDelete(ctx context.Context, id int32) error + func (q *Queries) UserCreate(ctx context.Context, arg UserCreateParams) (int32, error) + func (q *Queries) UserGet(ctx context.Context, id int32) (User, error) + func (q *Queries) UserGetActualAll(ctx context.Context) ([]User, error) + func (q *Queries) UserGetAllByID(ctx context.Context, dollar_1 []int32) ([]User, error) + func (q *Queries) UserGetByUID(ctx context.Context, uid string) (User, error) + func (q *Queries) UserPlaylistCreate(ctx context.Context, arg UserPlaylistCreateParams) (int32, error) + func (q *Queries) UserPlaylistDelete(ctx context.Context, id int32) error + func (q *Queries) UserShowCreate(ctx context.Context, arg UserShowCreateParams) (int32, error) + func (q *Queries) UserShowDelete(ctx context.Context, id int32) error + func (q *Queries) UserUpdate(ctx context.Context, arg UserUpdateParams) error + func (q *Queries) WithTx(tx pgx.Tx) *Queries + type Show struct + CoverID pgtype.Text + CoverUrl pgtype.Text + EpisodeAmount pgtype.Int4 + ID int32 + Name pgtype.Text + SpotifyID string + UpdatedAt pgtype.Timestamptz + type ShowCreateParams struct + CoverID pgtype.Text + CoverUrl pgtype.Text + EpisodeAmount pgtype.Int4 + Name pgtype.Text + SpotifyID string + type ShowUpdateParams struct + CoverID pgtype.Text + CoverUrl pgtype.Text + EpisodeAmount pgtype.Int4 + ID int32 + Name pgtype.Text + type ShowUser struct + DeletedAt pgtype.Timestamptz + ID int32 + ShowID int32 + UserID int32 + type ShowUserCreateParams struct + ShowID int32 + UserID int32 + type ShowUserDeleteByUserShowParams struct + ShowID int32 + UserID int32 + type Task struct + Active bool + Name string + Uid string + type TaskCreateParams struct + Active bool + Name string + Uid string + type TaskGetFilteredParams struct + Column1 int32 + FilterResult interface{} + FilterTaskUid interface{} + Limit int32 + Offset int32 + Result TaskResult + Uid string + type TaskGetFilteredRow struct + Task Task + TaskRun TaskRun + type TaskResult string + const TaskResultFailed + const TaskResultSuccess + func (e *TaskResult) Scan(src interface{}) error + type TaskRun struct + Duration int64 + Error pgtype.Text + ID int32 + Message pgtype.Text + Result TaskResult + RunAt pgtype.Timestamptz + TaskUid string + UserID int32 + type TaskRunCreateParams struct + Duration int64 + Error pgtype.Text + Message pgtype.Text + Result TaskResult + RunAt pgtype.Timestamptz + TaskUid string + UserID int32 + type TaskRunGetRow struct + Task Task + TaskRun TaskRun + type TaskUpdateParams struct + Active bool + Name string + Uid string + type Track struct + ID int32 + Name pgtype.Text + Popularity pgtype.Int4 + SpotifyID string + UpdatedAt pgtype.Timestamptz + type TrackArtist struct + ArtistID int32 + ID int32 + TrackID int32 + type TrackArtistCreateParams struct + ArtistID int32 + TrackID int32 + type TrackArtistDeleteByArtistTrackParams struct + ArtistID int32 + TrackID int32 + type TrackCreateParams struct + Name pgtype.Text + Popularity pgtype.Int4 + SpotifyID string + type TrackGetCreatedFilteredPopulatedParams struct + Column3 int32 + Column4 int32 + FilterPlaylistID interface{} + Limit int32 + Offset int32 + type TrackGetCreatedFilteredPopulatedRow struct + Playlist Playlist + PlaylistTrack PlaylistTrack + Track Track + User User + type TrackGetDeletedFilteredPopulatedParams struct + Column3 int32 + Column4 int32 + FilterPlaylistID interface{} + Limit int32 + Offset int32 + type TrackGetDeletedFilteredPopulatedRow struct + Playlist Playlist + PlaylistTrack PlaylistTrack + Track Track + User User + type TrackUpdateParams struct + ID int32 + Name pgtype.Text + Popularity pgtype.Int4 + type User struct + DisplayName pgtype.Text + Email string + ID int32 + Name string + Uid string + type UserAlbumCreateParams struct + AlbumID int32 + UserID int32 + type UserCreateParams struct + DisplayName pgtype.Text + Email string + Name string + Uid string + type UserPlaylistCreateParams struct + PlaylistID int32 + UserID int32 + type UserShowCreateParams struct + ShowID int32 + UserID int32 + type UserUpdateParams struct + DisplayName pgtype.Text + Email string + ID int32 + Name string