database

package
v0.0.0-...-afeb70e Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Jun 25, 2024 License: Unlicense Imports: 4 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type CreateFeedParams

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

type CreatePostParams

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

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
	Name          string
	Url           string
	CreatedAt     time.Time
	UpdatedAt     time.Time
	UserID        uuid.UUID
	LastFetchedAt sql.NullTime
}

type FeedFollow

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

type FollowExistsParams

type FollowExistsParams struct {
	FeedID uuid.UUID
	UserID uuid.UUID
}

type FollowFeedParams

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

type GetUsersPostsParams

type GetUsersPostsParams struct {
	UserID uuid.UUID
	Limit  int32
}

type Post

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

type Queries

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

func New

func New(db DBTX) *Queries

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) (Post, error)

func (*Queries) CreateUser

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

func (*Queries) FollowExists

func (q *Queries) FollowExists(ctx context.Context, arg FollowExistsParams) (FeedFollow, error)

func (*Queries) FollowFeed

func (q *Queries) FollowFeed(ctx context.Context, arg FollowFeedParams) (FeedFollow, error)

func (*Queries) GetAllFeeds

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

func (*Queries) GetNextFeedsToFetch

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

func (*Queries) GetUser

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

func (*Queries) GetUserFeeds

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

-

func (*Queries) GetUsersPosts

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

func (*Queries) IsUser

func (q *Queries) IsUser(ctx context.Context, apikey string) (bool, error)

func (*Queries) UnfollowFeed

func (q *Queries) UnfollowFeed(ctx context.Context, arg UnfollowFeedParams) error

func (*Queries) UpdateFeedFetchTime

func (q *Queries) UpdateFeedFetchTime(ctx context.Context, url string) error

func (*Queries) WithTx

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

type UnfollowFeedParams

type UnfollowFeedParams struct {
	FeedID uuid.UUID
	UserID uuid.UUID
}

type User

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

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL