db

Documentation

Index

• type DBTX
• type Editor
• type GetEditorsParams
• type GetQuestionsParams
• type Hint
• type InsertEditorParams
• type InsertHintParams
• type InsertQuestionParams
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CountQuestionByTitleSlug(ctx context.Context, titleSlug string) (int64, error)
  • func (q *Queries) GetEditors(ctx context.Context, arg GetEditorsParams) ([]Editor, error)
  • func (q *Queries) GetHints(ctx context.Context, questionID string) ([]Hint, error)
  • func (q *Queries) GetQuestions(ctx context.Context, arg GetQuestionsParams) ([]Question, error)
  • func (q *Queries) InsertEditor(ctx context.Context, arg InsertEditorParams) error
  • func (q *Queries) InsertHint(ctx context.Context, arg InsertHintParams) error
  • func (q *Queries) InsertQuestion(ctx context.Context, arg InsertQuestionParams) error
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type Question

Types

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 Editor

type Editor struct {
	ID         int64
	QuestionID string
	Lang       string
	LangSlug   string
	Code       string
}

type GetEditorsParams

type GetEditorsParams struct {
	QuestionID string
	LangSlug   string
}

type GetQuestionsParams

type GetQuestionsParams struct {
	From int64
	To   int64
}

type Hint

type Hint struct {
	ID         int64
	QuestionID string
	Hint       string
}

type InsertEditorParams

type InsertEditorParams struct {
	QuestionID string
	Lang       string
	LangSlug   string
	Code       string
}

type InsertHintParams

type InsertHintParams struct {
	QuestionID string
	Hint       string
}

type InsertQuestionParams

type InsertQuestionParams struct {
	QuestionID string
	Link       string
	Title      string
	TitleSlug  string
	IsPaidOnly bool
	Difficulty string
	Content    string
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CountQuestionByTitleSlug

func (q *Queries) CountQuestionByTitleSlug(ctx context.Context, titleSlug string) (int64, error)

func (*Queries) GetEditors

func (q *Queries) GetEditors(ctx context.Context, arg GetEditorsParams) ([]Editor, error)

func (*Queries) GetHints

func (q *Queries) GetHints(ctx context.Context, questionID string) ([]Hint, error)

func (*Queries) GetQuestions

func (q *Queries) GetQuestions(ctx context.Context, arg GetQuestionsParams) ([]Question, error)

func (*Queries) InsertEditor

func (q *Queries) InsertEditor(ctx context.Context, arg InsertEditorParams) error

func (*Queries) InsertHint

func (q *Queries) InsertHint(ctx context.Context, arg InsertHintParams) error

func (*Queries) InsertQuestion

func (q *Queries) InsertQuestion(ctx context.Context, arg InsertQuestionParams) error

func (*Queries) WithTx

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

type Question

type Question struct {
	ID         int64
	QuestionID string
	Link       string
	Title      string
	TitleSlug  string
	IsPaidOnly bool
	Difficulty string
	Content    string
}