database

Documentation

Index

• type CreateReviewParams
• type CreateUserParams
• type DBTX
• type GetReviewByIDRow
• type GetReviewsForMovieRow
• type GetReviewsRow
• type GetUserForLoginRow
• type GetUserRow
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateReview(ctx context.Context, arg CreateReviewParams) (Review, error)
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
  • func (q *Queries) DeleteUser(ctx context.Context, id uuid.UUID) error
  • func (q *Queries) GetReviewByID(ctx context.Context, id uuid.UUID) (GetReviewByIDRow, error)
  • func (q *Queries) GetReviews(ctx context.Context) ([]GetReviewsRow, error)
  • func (q *Queries) GetReviewsForMovie(ctx context.Context, movieTmdbID string) ([]GetReviewsForMovieRow, error)
  • func (q *Queries) GetUser(ctx context.Context, userName string) (GetUserRow, error)
  • func (q *Queries) GetUserForLogin(ctx context.Context, userName string) (GetUserForLoginRow, error)
  • func (q *Queries) ListUsers(ctx context.Context) ([]User, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type Review
• type User

Types

type CreateReviewParams

type CreateReviewParams struct {
	ID           uuid.UUID
	CreatedAt    time.Time
	UpdatedAt    time.Time
	UserID       uuid.UUID
	MovieTmdbID  string
	Rating       int32
	Review       string
	PublicReview bool
}

type CreateUserParams

type CreateUserParams struct {
	ID          uuid.UUID
	UserName    string
	DisplayName string
	Password    string
}

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 GetReviewByIDRow

type GetReviewByIDRow struct {
	ID          uuid.UUID
	UserID      uuid.UUID
	UserName    string
	CreatedAt   time.Time
	UpdatedAt   time.Time
	MovieTmdbID string
	Rating      int32
	Review      string
}

type GetReviewsForMovieRow

type GetReviewsForMovieRow struct {
	ID          uuid.UUID
	UserID      uuid.UUID
	UserName    string
	CreatedAt   time.Time
	UpdatedAt   time.Time
	MovieTmdbID string
	Rating      int32
	Review      string
}

type GetReviewsRow

type GetReviewsRow struct {
	ID          uuid.UUID
	UserID      uuid.UUID
	UserName    string
	CreatedAt   time.Time
	UpdatedAt   time.Time
	MovieTmdbID string
	Rating      int32
	Review      string
}

type GetUserForLoginRow

type GetUserForLoginRow struct {
	UserName string
	Password string
}

type GetUserRow

type GetUserRow struct {
	ID          uuid.UUID
	DisplayName string
	UserName    string
	Bio         string
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateReview

func (q *Queries) CreateReview(ctx context.Context, arg CreateReviewParams) (Review, error)

func (*Queries) CreateUser

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

func (*Queries) DeleteUser

func (q *Queries) DeleteUser(ctx context.Context, id uuid.UUID) error

func (*Queries) GetReviewByID

func (q *Queries) GetReviewByID(ctx context.Context, id uuid.UUID) (GetReviewByIDRow, error)

func (*Queries) GetReviews

func (q *Queries) GetReviews(ctx context.Context) ([]GetReviewsRow, error)

func (*Queries) GetReviewsForMovie

func (q *Queries) GetReviewsForMovie(ctx context.Context, movieTmdbID string) ([]GetReviewsForMovieRow, error)

func (*Queries) GetUser

func (q *Queries) GetUser(ctx context.Context, userName string) (GetUserRow, error)

func (*Queries) GetUserForLogin

func (q *Queries) GetUserForLogin(ctx context.Context, userName string) (GetUserForLoginRow, error)

func (*Queries) ListUsers

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

func (*Queries) WithTx

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

type Review

type Review struct {
	ID           uuid.UUID
	CreatedAt    time.Time
	UpdatedAt    time.Time
	UserID       uuid.UUID
	MovieTmdbID  string
	Rating       int32
	Review       string
	PublicReview bool
}

type User

type User struct {
	ID          uuid.UUID
	UserName    string
	DisplayName string
	Password    string
	Bio         string
}