db

package
v0.2.1 Latest Latest
Warning

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

Go to latest
Published: Jul 15, 2025 License: MIT Imports: 5 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func Open

func Open(dir string) (*sql.DB, error)

func Schema

func Schema() string

Types

type AddIngredientParams

type AddIngredientParams struct {
	Name   string `json:"name"`
	Amount string `json:"amount"`
}

type AddResourceParams

type AddResourceParams struct {
	Key   string `json:"key"`
	Value string `json:"value"`
}

type Character

type Character struct {
	ID        int64         `json:"id"`
	SessionID sql.NullInt64 `json:"session_id"`
	Result    string        `json:"result"`
}

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 Ingredient

type Ingredient struct {
	ID        int64         `json:"id"`
	SessionID sql.NullInt64 `json:"session_id"`
	Name      string        `json:"name"`
	Amount    string        `json:"amount"`
}

type Joke

type Joke struct {
	ID        int64         `json:"id"`
	SessionID sql.NullInt64 `json:"session_id"`
	Text      string        `json:"text"`
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) AddCharacter

func (q *Queries) AddCharacter(ctx context.Context, result string) (int64, error)

func (*Queries) AddIngredient

func (q *Queries) AddIngredient(ctx context.Context, arg AddIngredientParams) (int64, error)

func (*Queries) AddJoke

func (q *Queries) AddJoke(ctx context.Context, text string) (int64, error)

func (*Queries) AddResource

func (q *Queries) AddResource(ctx context.Context, arg AddResourceParams) (int64, error)

func (*Queries) DeleteAllCharacter

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

func (*Queries) DeleteAllIngredients

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

func (*Queries) DeleteAllJokes

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

func (*Queries) DeleteAllResources

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

func (*Queries) GetCharacter

func (q *Queries) GetCharacter(ctx context.Context) (Character, error)

func (*Queries) GetIngredient

func (q *Queries) GetIngredient(ctx context.Context) (Ingredient, error)

func (*Queries) GetJokes

func (q *Queries) GetJokes(ctx context.Context) ([]Joke, error)

func (*Queries) GetResources

func (q *Queries) GetResources(ctx context.Context) ([]Resource, error)

func (*Queries) RemoveJoke

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

func (*Queries) WithTx

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

type Resource

type Resource struct {
	ID        int64         `json:"id"`
	SessionID sql.NullInt64 `json:"session_id"`
	Key       string        `json:"key"`
	Value     string        `json:"value"`
}

Jump to

Keyboard shortcuts

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