sqlc

Documentation

Index

• type CreateEpisodeParams
• type CreateSeriesParams
• type DBTX
• type Episode
• type Podcast
• type Querier
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateEpisode(ctx context.Context, arg *CreateEpisodeParams) (*Episode, error)
  • func (q *Queries) CreatePodcast(ctx context.Context, name string) (*Podcast, error)
  • func (q *Queries) CreateSeries(ctx context.Context, arg *CreateSeriesParams) (*Series, error)
  • func (q *Queries) DeleteEpisode(ctx context.Context, id int32) error
  • func (q *Queries) DeletePodcast(ctx context.Context, id int32) error
  • func (q *Queries) DeleteSeries(ctx context.Context, id int32) error
  • func (q *Queries) GetEpisode(ctx context.Context, id int32) (*Episode, error)
  • func (q *Queries) GetPodcast(ctx context.Context, id int32) (*Podcast, error)
  • func (q *Queries) GetSeries(ctx context.Context, id int32) (*Series, error)
  • func (q *Queries) ListEpisodes(ctx context.Context) ([]*Episode, error)
  • func (q *Queries) ListPodcasts(ctx context.Context) ([]*Podcast, error)
  • func (q *Queries) ListSeries(ctx context.Context) ([]*Series, error)
  • func (q *Queries) SearchEpisodes(ctx context.Context, websearchToTsquery string) ([]*SearchEpisodesRow, error)
  • func (q *Queries) UpdateEpisode(ctx context.Context, arg *UpdateEpisodeParams) (*Episode, error)
  • func (q *Queries) UpdatePodcast(ctx context.Context, arg *UpdatePodcastParams) (*Podcast, error)
  • func (q *Queries) UpdateSeries(ctx context.Context, arg *UpdateSeriesParams) (*Series, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type SQLStore
• type SearchEpisodesRow
• type Series
• type Store
  • func NewStore(db *sql.DB) Store
• type UpdateEpisodeParams
• type UpdatePodcastParams
• type UpdateSeriesParams

Types

type CreateEpisodeParams

type CreateEpisodeParams struct {
	Name          string    `json:"name"`
	NumberSeries  int32     `json:"number_series"`
	NumberOverall int32     `json:"number_overall"`
	ReleaseDate   time.Time `json:"release_date"`
	Description   string    `json:"description"`
	Body          string    `json:"body"`
	TranscriptUrl string    `json:"transcript_url"`
	PodcastID     int32     `json:"podcast_id"`
	SeriesID      int32     `json:"series_id"`
}

type CreateSeriesParams

type CreateSeriesParams struct {
	Name      string `json:"name"`
	PodcastID int32  `json:"podcast_id"`
}

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 Episode

type Episode struct {
	ID            int32       `json:"id"`
	Name          string      `json:"name"`
	NumberSeries  int32       `json:"number_series"`
	NumberOverall int32       `json:"number_overall"`
	ReleaseDate   time.Time   `json:"release_date"`
	Description   string      `json:"description"`
	Body          string      `json:"body"`
	TranscriptUrl string      `json:"transcript_url"`
	PodcastID     int32       `json:"podcast_id"`
	SeriesID      int32       `json:"series_id"`
	LastUpdated   time.Time   `json:"last_updated"`
	FtsDocEn      interface{} `json:"fts_doc_en"`
}

type Podcast

type Podcast struct {
	ID          int32     `json:"id"`
	Name        string    `json:"name"`
	LastUpdated time.Time `json:"last_updated"`
}

type Querier

type Querier interface {
	CreateEpisode(ctx context.Context, arg *CreateEpisodeParams) (*Episode, error)
	CreatePodcast(ctx context.Context, name string) (*Podcast, error)
	CreateSeries(ctx context.Context, arg *CreateSeriesParams) (*Series, error)
	DeleteEpisode(ctx context.Context, id int32) error
	DeletePodcast(ctx context.Context, id int32) error
	DeleteSeries(ctx context.Context, id int32) error
	GetEpisode(ctx context.Context, id int32) (*Episode, error)
	GetPodcast(ctx context.Context, id int32) (*Podcast, error)
	GetSeries(ctx context.Context, id int32) (*Series, error)
	ListEpisodes(ctx context.Context) ([]*Episode, error)
	ListPodcasts(ctx context.Context) ([]*Podcast, error)
	ListSeries(ctx context.Context) ([]*Series, error)
	SearchEpisodes(ctx context.Context, websearchToTsquery string) ([]*SearchEpisodesRow, error)
	UpdateEpisode(ctx context.Context, arg *UpdateEpisodeParams) (*Episode, error)
	UpdatePodcast(ctx context.Context, arg *UpdatePodcastParams) (*Podcast, error)
	UpdateSeries(ctx context.Context, arg *UpdateSeriesParams) (*Series, error)
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateEpisode

func (q *Queries) CreateEpisode(ctx context.Context, arg *CreateEpisodeParams) (*Episode, error)

func (*Queries) CreatePodcast

func (q *Queries) CreatePodcast(ctx context.Context, name string) (*Podcast, error)

func (*Queries) CreateSeries

func (q *Queries) CreateSeries(ctx context.Context, arg *CreateSeriesParams) (*Series, error)

func (*Queries) DeleteEpisode

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

func (*Queries) DeletePodcast

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

func (*Queries) DeleteSeries

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

func (*Queries) GetEpisode

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

func (*Queries) GetPodcast

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

func (*Queries) GetSeries

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

func (*Queries) ListEpisodes

func (q *Queries) ListEpisodes(ctx context.Context) ([]*Episode, error)

func (*Queries) ListPodcasts

func (q *Queries) ListPodcasts(ctx context.Context) ([]*Podcast, error)

func (*Queries) ListSeries

func (q *Queries) ListSeries(ctx context.Context) ([]*Series, error)

func (*Queries) SearchEpisodes

func (q *Queries) SearchEpisodes(ctx context.Context, websearchToTsquery string) ([]*SearchEpisodesRow, error)

func (*Queries) UpdateEpisode

func (q *Queries) UpdateEpisode(ctx context.Context, arg *UpdateEpisodeParams) (*Episode, error)

func (*Queries) UpdatePodcast

func (q *Queries) UpdatePodcast(ctx context.Context, arg *UpdatePodcastParams) (*Podcast, error)

func (*Queries) UpdateSeries

func (q *Queries) UpdateSeries(ctx context.Context, arg *UpdateSeriesParams) (*Series, error)

func (*Queries) WithTx

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

type SQLStore

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

SQLStore provides all functions to execute SQL queries and transactions

type SearchEpisodesRow

type SearchEpisodesRow struct {
	ID            int32       `json:"id"`
	Name          string      `json:"name"`
	NumberSeries  int32       `json:"number_series"`
	NumberOverall int32       `json:"number_overall"`
	ReleaseDate   time.Time   `json:"release_date"`
	Description   string      `json:"description"`
	Body          string      `json:"body"`
	TranscriptUrl string      `json:"transcript_url"`
	PodcastID     int32       `json:"podcast_id"`
	SeriesID      int32       `json:"series_id"`
	LastUpdated   time.Time   `json:"last_updated"`
	FtsDocEn      interface{} `json:"fts_doc_en"`
	Headline      string      `json:"headline"`
}

type Series

type Series struct {
	ID          int32     `json:"id"`
	Name        string    `json:"name"`
	PodcastID   int32     `json:"podcast_id"`
	LastUpdated time.Time `json:"last_updated"`
}

type Store

type Store interface {
	Querier
}

Store defines all functions to execute db queries and transactions

func NewStore

func NewStore(db *sql.DB) Store

NewStore creates a new store

type UpdateEpisodeParams

type UpdateEpisodeParams struct {
	Name          sql.NullString `json:"name"`
	NumberSeries  sql.NullInt32  `json:"number_series"`
	NumberOverall sql.NullInt32  `json:"number_overall"`
	ReleaseDate   sql.NullTime   `json:"release_date"`
	Description   sql.NullString `json:"description"`
	Body          sql.NullString `json:"body"`
	TranscriptUrl sql.NullString `json:"transcript_url"`
	PodcastID     sql.NullInt32  `json:"podcast_id"`
	SeriesID      sql.NullInt32  `json:"series_id"`
	ID            int32          `json:"id"`
}

type UpdatePodcastParams

type UpdatePodcastParams struct {
	Name sql.NullString `json:"name"`
	ID   int32          `json:"id"`
}

type UpdateSeriesParams

type UpdateSeriesParams struct {
	Name      sql.NullString `json:"name"`
	PodcastID sql.NullInt32  `json:"podcast_id"`
	ID        int32          `json:"id"`
}