db

Documentation

Index

• type CreateListenParams
• type CreateSpotifyAccountParams
• type CreateTwitterAccountParams
• type CreateUserParams
• type DBTX
• type Listen
• type OAuth2Token
  • func (dst *OAuth2Token) Scan(src interface{}) error
  • func (src OAuth2Token) Value() (driver.Value, error)
• type Querier
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateListen(ctx context.Context, arg CreateListenParams) error
  • func (q *Queries) CreateSpotifyAccount(ctx context.Context, arg CreateSpotifyAccountParams) error
  • func (q *Queries) CreateTwitterAccount(ctx context.Context, arg CreateTwitterAccountParams) error
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) error
  • func (q *Queries) GetSpotifyAccountsForScanning(ctx context.Context) ([]SpotifyAccount, error)
  • func (q *Queries) GetTwitterAccount(ctx context.Context, twitterUserID string) (TwitterAccount, error)
  • func (q *Queries) GetUser(ctx context.Context, id string) (User, error)
  • func (q *Queries) ListListensForUser(ctx context.Context, userID string) ([]Listen, error)
  • func (q *Queries) SelectSpotifyAccountForUpdate(ctx context.Context, spotifyUserID string) (SpotifyAccount, error)
  • func (q *Queries) UpdateSpotifyAccountListenedAt(ctx context.Context, arg UpdateSpotifyAccountListenedAtParams) error
  • func (q *Queries) WithTx(tx pgx.Tx) *Queries
• type SpotifyAccount
• type TXQuerier
  • func NewQueries(db dbtxer) TXQuerier
• type TwitterAccount
• type UpdateSpotifyAccountListenedAtParams
• type User

Types

type CreateListenParams

type CreateListenParams struct {
	ID         string
	UserID     string
	CreatedAt  time.Time
	Source     string
	Isrc       string
	ListenedAt time.Time
}

type CreateSpotifyAccountParams

type CreateSpotifyAccountParams struct {
	SpotifyUserID string
	UserID        string
	OauthToken    OAuth2Token
	CreatedAt     time.Time
}

type CreateTwitterAccountParams

type CreateTwitterAccountParams struct {
	TwitterUserID string
	UserID        string
	OauthToken    OAuth2Token
	CreatedAt     time.Time
}

type CreateUserParams

type CreateUserParams struct {
	ID        string
	CreatedAt time.Time
}

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 Listen

type Listen struct {
	ID         string
	UserID     string
	CreatedAt  time.Time
	ListenedAt time.Time
	Isrc       string
	Source     string
}

type OAuth2Token

type OAuth2Token oauth2.Token

func (*OAuth2Token) Scan

func (dst *OAuth2Token) Scan(src interface{}) error

Scan implements the database/sql Scanner interface.

func (OAuth2Token) Value

func (src OAuth2Token) Value() (driver.Value, error)

Value implements the database/sql/driver Valuer interface.

type Querier

type Querier interface {
	CreateListen(ctx context.Context, arg CreateListenParams) error
	CreateSpotifyAccount(ctx context.Context, arg CreateSpotifyAccountParams) error
	CreateTwitterAccount(ctx context.Context, arg CreateTwitterAccountParams) error
	CreateUser(ctx context.Context, arg CreateUserParams) error
	GetSpotifyAccountsForScanning(ctx context.Context) ([]SpotifyAccount, error)
	GetTwitterAccount(ctx context.Context, twitterUserID string) (TwitterAccount, error)
	GetUser(ctx context.Context, id string) (User, error)
	ListListensForUser(ctx context.Context, userID string) ([]Listen, error)
	SelectSpotifyAccountForUpdate(ctx context.Context, spotifyUserID string) (SpotifyAccount, error)
	UpdateSpotifyAccountListenedAt(ctx context.Context, arg UpdateSpotifyAccountListenedAtParams) error
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateListen

func (q *Queries) CreateListen(ctx context.Context, arg CreateListenParams) error

func (*Queries) CreateSpotifyAccount

func (q *Queries) CreateSpotifyAccount(ctx context.Context, arg CreateSpotifyAccountParams) error

func (*Queries) CreateTwitterAccount

func (q *Queries) CreateTwitterAccount(ctx context.Context, arg CreateTwitterAccountParams) error

func (*Queries) CreateUser

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

func (*Queries) GetSpotifyAccountsForScanning

func (q *Queries) GetSpotifyAccountsForScanning(ctx context.Context) ([]SpotifyAccount, error)

func (*Queries) GetTwitterAccount

func (q *Queries) GetTwitterAccount(ctx context.Context, twitterUserID string) (TwitterAccount, error)

func (*Queries) GetUser

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

func (*Queries) ListListensForUser

func (q *Queries) ListListensForUser(ctx context.Context, userID string) ([]Listen, error)

func (*Queries) SelectSpotifyAccountForUpdate

func (q *Queries) SelectSpotifyAccountForUpdate(ctx context.Context, spotifyUserID string) (SpotifyAccount, error)

func (*Queries) UpdateSpotifyAccountListenedAt

func (q *Queries) UpdateSpotifyAccountListenedAt(ctx context.Context, arg UpdateSpotifyAccountListenedAtParams) error

func (*Queries) WithTx

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

type SpotifyAccount

type SpotifyAccount struct {
	SpotifyUserID  string
	UserID         string
	OauthToken     OAuth2Token
	LastListenedAt sql.NullTime
	CreatedAt      time.Time
}

type TXQuerier

type TXQuerier interface {
	Querier
	BeginTx(ctx context.Context) (func(ctx context.Context) error, func(ctx context.Context) error, TXQuerier, error)
}

func NewQueries

func NewQueries(db dbtxer) TXQuerier

type TwitterAccount

type TwitterAccount struct {
	TwitterUserID string
	UserID        string
	OauthToken    OAuth2Token
	CreatedAt     time.Time
}

type UpdateSpotifyAccountListenedAtParams

type UpdateSpotifyAccountListenedAtParams struct {
	LastListenedAt sql.NullTime
	SpotifyUserID  string
}

type User

type User struct {
	ID        string
	CreatedAt time.Time
}