database

package
v0.0.0-...-4f2aa15 Latest Latest
Warning

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

 Go to latest Published: Nov 21, 2024 License: MIT Imports: 3 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type AddFeedToViewParams 

type AddFeedToViewParams struct {
	ViewID int64 `json:"view_id"`
	FeedID int64 `json:"feed_id"`
}

type CreateFeedItemParams 

type CreateFeedItemParams struct {
	RssFeedID   int64     `json:"rss_feed_id"`
	Title       string    `json:"title"`
	Url         string    `json:"url"`
	PublishedAt time.Time `json:"published_at"`
}

type CreateFeedParams 

type CreateFeedParams struct {
	Title string `json:"title"`
	Url   string `json:"url"`
}

type CreateSessionParams 

type CreateSessionParams struct {
	UserID    int64     `json:"user_id"`
	Token     string    `json:"token"`
	ExpiresAt time.Time `json:"expires_at"`
}

type CreateUserParams 

type CreateUserParams struct {
	Email    string `json:"email"`
	Password string `json:"password"`
}

type CreateUserViewParams 

type CreateUserViewParams struct {
	UserID int64 `json:"user_id"`
	ViewID int64 `json:"view_id"`
}

type CreateViewParams 

type CreateViewParams struct {
	Name   string `json:"name"`
	Public bool   `json:"public"`
	Slug   string `json:"slug"`
}

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 GetViewFeedsItemsParams 

type GetViewFeedsItemsParams struct {
	ViewID int64 `json:"view_id"`
	Limit  int32 `json:"limit"`
}

type Queries 

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

func New 

func New(db DBTX) *Queries

func (*Queries) AddFeedToView 

func (q *Queries) AddFeedToView(ctx context.Context, arg AddFeedToViewParams) error

func (*Queries) CreateFeed 

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

func (*Queries) CreateFeedItem 

func (q *Queries) CreateFeedItem(ctx context.Context, arg CreateFeedItemParams) error

func (*Queries) CreateSession 

func (q *Queries) CreateSession(ctx context.Context, arg CreateSessionParams) (sql.Result, error)

func (*Queries) CreateUser 

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

func (*Queries) CreateUserView 

func (q *Queries) CreateUserView(ctx context.Context, arg CreateUserViewParams) error

func (*Queries) CreateView 

func (q *Queries) CreateView(ctx context.Context, arg CreateViewParams) (sql.Result, error)

func (*Queries) DecrementFeedRefCount 

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

func (*Queries) DeleteFeed 

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

func (*Queries) DeleteSession 

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

func (*Queries) DeleteView 

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

func (*Queries) GCSessions 

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

func (*Queries) GetAllViews 

func (q *Queries) GetAllViews(ctx context.Context) ([]View, error)

func (*Queries) GetFeedByURL 

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

func (*Queries) GetFeedRefCount 

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

func (*Queries) GetFeeds 

func (q *Queries) GetFeeds(ctx context.Context) ([]RssFeed, error)

func (*Queries) GetFeedsUpdatable 

func (q *Queries) GetFeedsUpdatable(ctx context.Context) ([]RssFeed, error)

func (*Queries) GetLatestFeedItems 

func (q *Queries) GetLatestFeedItems(ctx context.Context, rssFeedID int64) ([]RssFeedItem, error)

func (*Queries) GetSessionByToken 

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

func (*Queries) GetUserByEmail 

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

func (*Queries) GetUserViews 

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

func (*Queries) GetViewBySlug 

func (q *Queries) GetViewBySlug(ctx context.Context, slug string) (View, error)

func (*Queries) GetViewFeeds 

func (q *Queries) GetViewFeeds(ctx context.Context, viewID int64) ([]RssFeed, error)

func (*Queries) GetViewFeedsItems 

func (q *Queries) GetViewFeedsItems(ctx context.Context, arg GetViewFeedsItemsParams) ([]RssFeedItem, error)

func (*Queries) MarkUpdated 

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

func (*Queries) RemoveFeedFromView 

func (q *Queries) RemoveFeedFromView(ctx context.Context, arg RemoveFeedFromViewParams) error

func (*Queries) WithTx 

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

type RemoveFeedFromViewParams 

type RemoveFeedFromViewParams struct {
	ViewID int64 `json:"view_id"`
	FeedID int64 `json:"feed_id"`
}

type RssFeed 

type RssFeed struct {
	ID             int64     `json:"id"`
	Title          string    `json:"title"`
	Url            string    `json:"url"`
	ReferenceCount int64     `json:"reference_count"`
	CreatedAt      time.Time `json:"created_at"`
	UpdatedAt      time.Time `json:"updated_at"`
}

type RssFeedItem 

type RssFeedItem struct {
	ID          int64     `json:"id"`
	RssFeedID   int64     `json:"rss_feed_id"`
	Title       string    `json:"title"`
	Url         string    `json:"url"`
	PublishedAt time.Time `json:"published_at"`
	AddedAt     time.Time `json:"added_at"`
}

type Session 

type Session struct {
	ID        int64     `json:"id"`
	UserID    int64     `json:"user_id"`
	Token     string    `json:"token"`
	ExpiresAt time.Time `json:"expires_at"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type User 

type User struct {
	ID        int64     `json:"id"`
	Email     string    `json:"email"`
	Password  string    `json:"password"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type UserView 

type UserView struct {
	UserID    int64     `json:"user_id"`
	ViewID    int64     `json:"view_id"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type View 

type View struct {
	ID        int64     `json:"id"`
	Name      string    `json:"name"`
	Public    bool      `json:"public"`
	Slug      string    `json:"slug"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type ViewItem 

type ViewItem struct {
	ID        int64     `json:"id"`
	ViewID    int64     `json:"view_id"`
	FeedID    int64     `json:"feed_id"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

Source Files

View all Source files

Directories

Path Synopsis

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.