database

Documentation

Index

• type CreateUserParams
• type DBTX
• type Feed
• type FeedFollow
• type Post
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
  • func (q *Queries) GetUserByAPIKey(ctx context.Context, apiKey string) (User, error)
  • func (q *Queries) GetUserByEmail(ctx context.Context, email string) (User, error)
  • func (q *Queries) UpdateOAuthID(ctx context.Context, arg UpdateOAuthIDParams) (User, error)
  • func (q *Queries) UpdateUserPassword(ctx context.Context, arg UpdateUserPasswordParams) (User, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type UpdateOAuthIDParams
• type UpdateUserPasswordParams
• type User

Types

type CreateUserParams

type CreateUserParams struct {
	ID            uuid.UUID
	Name          string
	Email         string
	PasswordHash  string
	CreatedAt     time.Time
	UpdatedAt     time.Time
	OauthProvider sql.NullString
	OauthID       sql.NullString
}

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 Feed

type Feed struct {
	ID            uuid.UUID
	Name          string
	CreatedAt     time.Time
	UpdatedAt     time.Time
	Url           string
	UserID        uuid.UUID
	LastFetchedAt sql.NullTime
}

type FeedFollow

type FeedFollow struct {
	ID        uuid.UUID
	CreatedAt time.Time
	UpdatedAt time.Time
	UserID    uuid.UUID
	FeedID    uuid.UUID
}

type Post

type Post struct {
	ID          uuid.UUID
	Title       string
	Description sql.NullString
	PublishedAt time.Time
	Url         string
	FeedID      uuid.UUID
	CreatedAt   time.Time
	UpdatedAt   time.Time
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateUser

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

func (*Queries) GetUserByAPIKey

func (q *Queries) GetUserByAPIKey(ctx context.Context, apiKey string) (User, error)

func (*Queries) GetUserByEmail

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

func (*Queries) UpdateOAuthID

func (q *Queries) UpdateOAuthID(ctx context.Context, arg UpdateOAuthIDParams) (User, error)

func (*Queries) UpdateUserPassword

func (q *Queries) UpdateUserPassword(ctx context.Context, arg UpdateUserPasswordParams) (User, error)

func (*Queries) WithTx

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

type UpdateOAuthIDParams

type UpdateOAuthIDParams struct {
	OauthProvider sql.NullString
	OauthID       sql.NullString
	Email         string
}

type UpdateUserPasswordParams

type UpdateUserPasswordParams struct {
	PasswordHash string
	Email        string
}

type User

type User struct {
	ID            uuid.UUID
	Name          string
	CreatedAt     time.Time
	UpdatedAt     time.Time
	ApiKey        string
	Email         string
	PasswordHash  string
	OauthProvider sql.NullString
	OauthID       sql.NullString
}