zh_db

Documentation

Index

• func DbInit() dbSingleTon
• func SqliteExist()
• type CreateArticleParams
• type DBTX
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateArticle(ctx context.Context, arg CreateArticleParams) error
  • func (q *Queries) FindArticle(ctx context.Context, link string) (string, error)
  • func (q *Queries) GetAll(ctx context.Context) ([]Zh, error)
  • func (q *Queries) GetById(ctx context.Context, id string) (Zh, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type Zh

Functions

func DbInit

func DbInit() dbSingleTon

func SqliteExist

func SqliteExist()

If dbPath does not exist mkdir and touch sqlite.db

Types

type CreateArticleParams

type CreateArticleParams struct {
	ID          string
	Link        string
	Title       string
	Article     string
	ArticleGen  string
	TimeCreated 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) CreateArticle

func (q *Queries) CreateArticle(ctx context.Context, arg CreateArticleParams) error

func (*Queries) FindArticle

func (q *Queries) FindArticle(ctx context.Context, link string) (string, error)

func (*Queries) GetAll

func (q *Queries) GetAll(ctx context.Context) ([]Zh, error)

func (*Queries) GetById

func (q *Queries) GetById(ctx context.Context, id string) (Zh, error)

func (*Queries) WithTx

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

type Zh

type Zh struct {
	ID          string
	Link        string
	Title       string
	Article     string
	ArticleGen  string
	TimeCreated string
}