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) HistoryGetPopulatedFiltered 

func (q *Queries) HistoryGetPopulatedFiltered(ctx context.Context, arg HistoryGetPopulatedFilteredParams) ([]HistoryGetPopulatedFilteredRow, error)

func (*Queries) HistoryGetPopulatedFilteredPaginated added in v0.2.0 

func (q *Queries) HistoryGetPopulatedFilteredPaginated(ctx context.Context, arg HistoryGetPopulatedFilteredPaginatedParams) ([]HistoryGetPopulatedFilteredPaginatedRow, error)

func (*Queries) HistoryGetPreviousPopulated added in v0.2.0 

func (q *Queries) HistoryGetPreviousPopulated(ctx context.Context, arg HistoryGetPreviousPopulatedParams) (HistoryGetPreviousPopulatedRow, error)

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) TrackGetCreatedFilteredPopulated 

func (q *Queries) TrackGetCreatedFilteredPopulated(ctx context.Context, arg TrackGetCreatedFilteredPopulatedParams) ([]TrackGetCreatedFilteredPopulatedRow, error)

func (*Queries) TrackGetDeletedFilteredPopulated 

func (q *Queries) TrackGetDeletedFilteredPopulated(ctx context.Context, arg TrackGetDeletedFilteredPopulatedParams) ([]TrackGetDeletedFilteredPopulatedRow, 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
}

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.