database

Documentation

Index

• type AddFeedFollowParams
• type CreateFeedParams
• type CreatePostParams
• type CreateUserParams
• type DBTX
• type Feed
• type FeedFollow
• type GetPostsByUserParams
• type MarkedFetchedParams
• type Post
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) AddFeedFollow(ctx context.Context, arg AddFeedFollowParams) (FeedFollow, error)
  • func (q *Queries) CreateFeed(ctx context.Context, arg CreateFeedParams) (Feed, error)
  • func (q *Queries) CreatePost(ctx context.Context, arg CreatePostParams) error
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
  • func (q *Queries) DeleteFeed(ctx context.Context, id uuid.UUID) error
  • func (q *Queries) DeleteFeedFollow(ctx context.Context, id uuid.UUID) error
  • func (q *Queries) GetAllFeedFollows(ctx context.Context) ([]FeedFollow, error)
  • func (q *Queries) GetAllFollowed(ctx context.Context, userID uuid.UUID) ([]FeedFollow, error)
  • func (q *Queries) GetAllUsers(ctx context.Context) ([]User, error)
  • func (q *Queries) GetFeed(ctx context.Context, id uuid.UUID) (Feed, error)
  • func (q *Queries) GetFeedFollow(ctx context.Context, id uuid.UUID) (FeedFollow, error)
  • func (q *Queries) GetNextFeedsToFetch(ctx context.Context, limit int32) ([]Feed, error)
  • func (q *Queries) GetPostsByUser(ctx context.Context, arg GetPostsByUserParams) ([]Post, error)
  • func (q *Queries) GetUserByApiKey(ctx context.Context, apiKey string) (User, error)
  • func (q *Queries) MarkedFetched(ctx context.Context, arg MarkedFetchedParams) error
  • func (q *Queries) RetrieveFeeds(ctx context.Context) ([]Feed, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type User

Types

type AddFeedFollowParams

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

type CreateFeedParams

type CreateFeedParams struct {
	ID        uuid.UUID
	CreatedAt time.Time
	UpdatedAt time.Time
	Name      string
	Url       string
	UserID    uuid.UUID
}

type CreatePostParams

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

type CreateUserParams

type CreateUserParams struct {
	ID        uuid.UUID
	CreatedAt time.Time
	UpdatedAt time.Time
	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 Feed

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

type FeedFollow

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

type GetPostsByUserParams

type GetPostsByUserParams struct {
	UserID uuid.UUID
	Limit  int32
}

type MarkedFetchedParams

type MarkedFetchedParams struct {
	ID            uuid.UUID
	UpdatedAt     time.Time
	LastFetchedAt sql.NullTime
}

type Post

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

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) AddFeedFollow

func (q *Queries) AddFeedFollow(ctx context.Context, arg AddFeedFollowParams) (FeedFollow, error)

func (*Queries) CreateFeed

func (q *Queries) CreateFeed(ctx context.Context, arg CreateFeedParams) (Feed, error)

func (*Queries) CreatePost

func (q *Queries) CreatePost(ctx context.Context, arg CreatePostParams) error

func (*Queries) CreateUser

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

func (*Queries) DeleteFeed

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

func (*Queries) DeleteFeedFollow

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

func (*Queries) GetAllFeedFollows

func (q *Queries) GetAllFeedFollows(ctx context.Context) ([]FeedFollow, error)

func (*Queries) GetAllFollowed

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

func (*Queries) GetAllUsers

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

func (*Queries) GetFeed

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

func (*Queries) GetFeedFollow

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

func (*Queries) GetNextFeedsToFetch

func (q *Queries) GetNextFeedsToFetch(ctx context.Context, limit int32) ([]Feed, error)

func (*Queries) GetPostsByUser

func (q *Queries) GetPostsByUser(ctx context.Context, arg GetPostsByUserParams) ([]Post, error)

func (*Queries) GetUserByApiKey

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

func (*Queries) MarkedFetched

func (q *Queries) MarkedFetched(ctx context.Context, arg MarkedFetchedParams) error

func (*Queries) RetrieveFeeds

func (q *Queries) RetrieveFeeds(ctx context.Context) ([]Feed, error)

func (*Queries) WithTx

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

type User

type User struct {
	ID        uuid.UUID
	CreatedAt time.Time
	UpdatedAt time.Time
	Name      string
	ApiKey    string
}