database

Documentation

Index

• type Chirp
• type CreateChirpParams
• type CreateRefreshTokenParams
• type CreateUserParams
• type DBTX
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateChirp(ctx context.Context, arg CreateChirpParams) (Chirp, error)
  • func (q *Queries) CreateRefreshToken(ctx context.Context, arg CreateRefreshTokenParams) (RefreshToken, error)
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
  • func (q *Queries) DeleteChirpByID(ctx context.Context, id uuid.UUID) error
  • func (q *Queries) GetAllChirpsASC(ctx context.Context) ([]Chirp, error)
  • func (q *Queries) GetAllChirpsDESC(ctx context.Context) ([]Chirp, error)
  • func (q *Queries) GetChirpByID(ctx context.Context, id uuid.UUID) (Chirp, error)
  • func (q *Queries) GetChirpsFromUserIDASC(ctx context.Context, userID uuid.UUID) ([]Chirp, error)
  • func (q *Queries) GetChirpsFromUserIDDESC(ctx context.Context, userID uuid.UUID) ([]Chirp, error)
  • func (q *Queries) GetUserByEmail(ctx context.Context, email string) (User, error)
  • func (q *Queries) GetUserFromRefreshToken(ctx context.Context, token string) (uuid.UUID, error)
  • func (q *Queries) ResetUsers(ctx context.Context) error
  • func (q *Queries) RevokeCheck(ctx context.Context, token string) (sql.NullTime, error)
  • func (q *Queries) RevokeToken(ctx context.Context, token string) error
  • func (q *Queries) UpdateUserEmailAndPassword(ctx context.Context, arg UpdateUserEmailAndPasswordParams) (User, error)
  • func (q *Queries) UpgradeToRedByID(ctx context.Context, id uuid.UUID) error
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type RefreshToken
• type UpdateUserEmailAndPasswordParams
• type User

Types

type Chirp

type Chirp struct {
	ID        uuid.UUID
	CreatedAt time.Time
	UpdatedAt time.Time
	Body      string
	UserID    uuid.UUID
}

type CreateChirpParams

type CreateChirpParams struct {
	Body   string
	UserID uuid.UUID
}

type CreateRefreshTokenParams

type CreateRefreshTokenParams struct {
	Token  string
	UserID uuid.UUID
}

type CreateUserParams

type CreateUserParams struct {
	Email          string
	HashedPassword 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 Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateChirp

func (q *Queries) CreateChirp(ctx context.Context, arg CreateChirpParams) (Chirp, error)

func (*Queries) CreateRefreshToken

func (q *Queries) CreateRefreshToken(ctx context.Context, arg CreateRefreshTokenParams) (RefreshToken, error)

func (*Queries) CreateUser

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

func (*Queries) DeleteChirpByID

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

func (*Queries) GetAllChirpsASC

func (q *Queries) GetAllChirpsASC(ctx context.Context) ([]Chirp, error)

func (*Queries) GetAllChirpsDESC

func (q *Queries) GetAllChirpsDESC(ctx context.Context) ([]Chirp, error)

func (*Queries) GetChirpByID

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

func (*Queries) GetChirpsFromUserIDASC

func (q *Queries) GetChirpsFromUserIDASC(ctx context.Context, userID uuid.UUID) ([]Chirp, error)

func (*Queries) GetChirpsFromUserIDDESC

func (q *Queries) GetChirpsFromUserIDDESC(ctx context.Context, userID uuid.UUID) ([]Chirp, error)

func (*Queries) GetUserByEmail

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

func (*Queries) GetUserFromRefreshToken

func (q *Queries) GetUserFromRefreshToken(ctx context.Context, token string) (uuid.UUID, error)

func (*Queries) ResetUsers

func (q *Queries) ResetUsers(ctx context.Context) error

func (*Queries) RevokeCheck

func (q *Queries) RevokeCheck(ctx context.Context, token string) (sql.NullTime, error)

func (*Queries) RevokeToken

func (q *Queries) RevokeToken(ctx context.Context, token string) error

func (*Queries) UpdateUserEmailAndPassword

func (q *Queries) UpdateUserEmailAndPassword(ctx context.Context, arg UpdateUserEmailAndPasswordParams) (User, error)

func (*Queries) UpgradeToRedByID

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

func (*Queries) WithTx

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

type RefreshToken

type RefreshToken struct {
	Token     string
	CreatedAt time.Time
	UpdatedAt time.Time
	UserID    uuid.UUID
	ExpiresAt time.Time
	RevokedAt sql.NullTime
}

type UpdateUserEmailAndPasswordParams

type UpdateUserEmailAndPasswordParams struct {
	Email          string
	HashedPassword string
	ID             uuid.UUID
}

type User

type User struct {
	ID             uuid.UUID
	CreatedAt      time.Time
	UpdatedAt      time.Time
	Email          string
	HashedPassword string
	IsChirpyRed    bool
}