db

Documentation

Index

• type CreateMovieParams
• type CreateUserParams
• type DBTX
• type EditMovieParams
• type Movie
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateMovie(ctx context.Context, arg CreateMovieParams) (Movie, error)
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
  • func (q *Queries) DeleteMovie(ctx context.Context, id int64) error
  • func (q *Queries) EditMovie(ctx context.Context, arg EditMovieParams) (Movie, error)
  • func (q *Queries) GetMoviesForUser(ctx context.Context, userID int64) ([]Movie, error)
  • func (q *Queries) GetUser(ctx context.Context, email string) (User, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type User

Types

type CreateMovieParams

type CreateMovieParams struct {
	UserID          int64
	Name            string
	WatchedDate     time.Time
	PosterUrl       string
	Diary           string
	Description     string
	LocationWatched string
	ReleaseDate     string
}

type CreateUserParams

type CreateUserParams struct {
	Email string
	Name  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 EditMovieParams

type EditMovieParams struct {
	ID              int64
	LocationWatched string
	Diary           string
	WatchedDate     time.Time
}

type Movie

type Movie struct {
	ID              int64
	UserID          int64
	Name            string
	WatchedDate     time.Time
	PosterUrl       string
	Diary           string
	Description     string
	LocationWatched string
	ReleaseDate     string
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateMovie

func (q *Queries) CreateMovie(ctx context.Context, arg CreateMovieParams) (Movie, error)

func (*Queries) CreateUser

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

func (*Queries) DeleteMovie

func (q *Queries) DeleteMovie(ctx context.Context, id int64) error

func (*Queries) EditMovie

func (q *Queries) EditMovie(ctx context.Context, arg EditMovieParams) (Movie, error)

func (*Queries) GetMoviesForUser

func (q *Queries) GetMoviesForUser(ctx context.Context, userID int64) ([]Movie, error)

func (*Queries) GetUser

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

func (*Queries) WithTx

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

type User

type User struct {
	ID    int64
	Name  string
	Email string
}