db

Documentation

Index

• type Account
• type Category
• type CreateAccountParams
• type CreateCategoryParams
• type CreateUserParams
• type DBTX
• type GetAccountsGraphParams
• type GetAccountsParams
• type GetAccountsReportsParams
• type GetAccountsRow
• type GetCategoriesParams
• type Querier
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateAccount(ctx context.Context, arg CreateAccountParams) (Account, error)
  • func (q *Queries) CreateCategory(ctx context.Context, arg CreateCategoryParams) (Category, error)
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
  • func (q *Queries) DeleteAccount(ctx context.Context, id int32) error
  • func (q *Queries) DeleteCategories(ctx context.Context, id int32) error
  • func (q *Queries) GetAccount(ctx context.Context, id int32) (Account, error)
  • func (q *Queries) GetAccounts(ctx context.Context, arg GetAccountsParams) ([]GetAccountsRow, error)
  • func (q *Queries) GetAccountsGraph(ctx context.Context, arg GetAccountsGraphParams) (int64, error)
  • func (q *Queries) GetAccountsReports(ctx context.Context, arg GetAccountsReportsParams) (int64, error)
  • func (q *Queries) GetCategories(ctx context.Context, arg GetCategoriesParams) ([]Category, error)
  • func (q *Queries) GetCategory(ctx context.Context, id int32) (Category, error)
  • func (q *Queries) GetUser(ctx context.Context, username string) (User, error)
  • func (q *Queries) GetUserById(ctx context.Context, id int32) (User, error)
  • func (q *Queries) UpdateAccount(ctx context.Context, arg UpdateAccountParams) (Account, error)
  • func (q *Queries) UpdateCategories(ctx context.Context, arg UpdateCategoriesParams) (Category, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type SQLStore
  • func NewStore(db *sql.DB) *SQLStore
• type Store
• type UpdateAccountParams
• type UpdateCategoriesParams
• type User

Types

type Account

type Account struct {
	ID          int32     `json:"id"`
	UserID      int32     `json:"user_id"`
	CategoryID  int32     `json:"category_id"`
	Title       string    `json:"title"`
	Type        string    `json:"type"`
	Description string    `json:"description"`
	Value       int32     `json:"value"`
	Date        time.Time `json:"date"`
	CreatedAt   time.Time `json:"created_at"`
}

type Category

type Category struct {
	ID          int32     `json:"id"`
	UserID      int32     `json:"user_id"`
	Title       string    `json:"title"`
	Type        string    `json:"type"`
	Description string    `json:"description"`
	CreatedAt   time.Time `json:"created_at"`
}

type CreateAccountParams

type CreateAccountParams struct {
	UserID      int32     `json:"user_id"`
	CategoryID  int32     `json:"category_id"`
	Title       string    `json:"title"`
	Type        string    `json:"type"`
	Description string    `json:"description"`
	Value       int32     `json:"value"`
	Date        time.Time `json:"date"`
}

type CreateCategoryParams

type CreateCategoryParams struct {
	UserID      int32  `json:"user_id"`
	Title       string `json:"title"`
	Type        string `json:"type"`
	Description string `json:"description"`
}

type CreateUserParams

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

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 GetAccountsGraphParams

type GetAccountsGraphParams struct {
	UserID int32  `json:"user_id"`
	Type   string `json:"type"`
}

type GetAccountsParams

type GetAccountsParams struct {
	UserID      int32         `json:"user_id"`
	Type        string        `json:"type"`
	Title       string        `json:"title"`
	Description string        `json:"description"`
	CategoryID  sql.NullInt32 `json:"category_id"`
	Date        sql.NullTime  `json:"date"`
}

type GetAccountsReportsParams

type GetAccountsReportsParams struct {
	UserID int32  `json:"user_id"`
	Type   string `json:"type"`
}

type GetAccountsRow

type GetAccountsRow struct {
	ID            int32          `json:"id"`
	UserID        int32          `json:"user_id"`
	Title         string         `json:"title"`
	Type          string         `json:"type"`
	Description   string         `json:"description"`
	Value         int32          `json:"value"`
	Date          time.Time      `json:"date"`
	CreatedAt     time.Time      `json:"created_at"`
	CategoryTitle sql.NullString `json:"category_title"`
}

type GetCategoriesParams

type GetCategoriesParams struct {
	UserID      int32  `json:"user_id"`
	Type        string `json:"type"`
	Title       string `json:"title"`
	Description string `json:"description"`
}

type Querier

type Querier interface {
	CreateAccount(ctx context.Context, arg CreateAccountParams) (Account, error)
	CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
	DeleteAccount(ctx context.Context, id int32) error
	DeleteCategories(ctx context.Context, id int32) error
	GetAccount(ctx context.Context, id int32) (Account, error)
	GetAccounts(ctx context.Context, arg GetAccountsParams) ([]GetAccountsRow, error)
	GetAccountsGraph(ctx context.Context, arg GetAccountsGraphParams) (int64, error)
	GetAccountsReports(ctx context.Context, arg GetAccountsReportsParams) (int64, error)
	GetCategories(ctx context.Context, arg GetCategoriesParams) ([]Category, error)
	GetCategory(ctx context.Context, id int32) (Category, error)
	GetUser(ctx context.Context, username string) (User, error)
	GetUserById(ctx context.Context, id int32) (User, error)
	UpdateAccount(ctx context.Context, arg UpdateAccountParams) (Account, error)
	UpdateCategories(ctx context.Context, arg UpdateCategoriesParams) (Category, error)
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateAccount

func (q *Queries) CreateAccount(ctx context.Context, arg CreateAccountParams) (Account, error)

func (*Queries) CreateCategory

func (q *Queries) CreateCategory(ctx context.Context, arg CreateCategoryParams) (Category, error)

func (*Queries) CreateUser

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

func (*Queries) DeleteAccount

func (q *Queries) DeleteAccount(ctx context.Context, id int32) error

func (*Queries) DeleteCategories

func (q *Queries) DeleteCategories(ctx context.Context, id int32) error

func (*Queries) GetAccount

func (q *Queries) GetAccount(ctx context.Context, id int32) (Account, error)

func (*Queries) GetAccounts

func (q *Queries) GetAccounts(ctx context.Context, arg GetAccountsParams) ([]GetAccountsRow, error)

func (*Queries) GetAccountsGraph

func (q *Queries) GetAccountsGraph(ctx context.Context, arg GetAccountsGraphParams) (int64, error)

func (*Queries) GetAccountsReports

func (q *Queries) GetAccountsReports(ctx context.Context, arg GetAccountsReportsParams) (int64, error)

func (*Queries) GetCategories

func (q *Queries) GetCategories(ctx context.Context, arg GetCategoriesParams) ([]Category, error)

func (*Queries) GetCategory

func (q *Queries) GetCategory(ctx context.Context, id int32) (Category, error)

func (*Queries) GetUser

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

func (*Queries) GetUserById

func (q *Queries) GetUserById(ctx context.Context, id int32) (User, error)

func (*Queries) UpdateAccount

func (q *Queries) UpdateAccount(ctx context.Context, arg UpdateAccountParams) (Account, error)

func (*Queries) UpdateCategories

func (q *Queries) UpdateCategories(ctx context.Context, arg UpdateCategoriesParams) (Category, error)

func (*Queries) WithTx

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

type SQLStore

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

func NewStore

func NewStore(db *sql.DB) *SQLStore

type Store

type Store interface {
	Querier
}

type UpdateAccountParams

type UpdateAccountParams struct {
	ID          int32  `json:"id"`
	Title       string `json:"title"`
	Description string `json:"description"`
	Value       int32  `json:"value"`
}

type UpdateCategoriesParams

type UpdateCategoriesParams struct {
	ID          int32  `json:"id"`
	Title       string `json:"title"`
	Description string `json:"description"`
}

type User

type User struct {
	ID        int32     `json:"id"`
	Username  string    `json:"username"`
	Password  string    `json:"password"`
	Email     string    `json:"email"`
	CreatedAt time.Time `json:"created_at"`
}