db

type Account struct {
	ID        string
	Name      string
	BudgetID  string
	CreatedAt time.Time
}

type Budget struct {
	ID        string
	Name      string
	CreatedAt time.Time
}

type BudgetsUser struct {
	BudgetID string
	UserID   string
}

type Category struct {
	ID        string
	Name      string
	BudgetID  string
	GroupID   string
	CreatedAt time.Time
}

type CategoryGroup struct {
	ID        string
	Name      string
	IsIncome  bool
	BudgetID  string
	CreatedAt time.Time
}

type CategoryGroupExistsParams struct {
	ID       string
	BudgetID string
}

type CreateAccountParams struct {
	ID       string
	Name     string
	BudgetID string
}

type CreateBudgetParams struct {
	ID   string
	Name string
}

type CreateBudgetUserParams struct {
	BudgetID string
	UserID   string
}

type CreateCategoryGroupParams struct {
	ID       string
	BudgetID string
	Name     string
	IsIncome bool
}

type CreateCategoryParams struct {
	ID       string
	BudgetID string
	GroupID  string
	Name     string
}

type CreateMonthCategoryParams struct {
	ID         string
	MonthID    string
	CategoryID string
	Amount     pgtype.Numeric
}

type CreateMonthParams struct {
	ID        string
	BudgetID  string
	Date      time.Time
	Carryover pgtype.Numeric
}

type CreatePayeeParams struct {
	ID       string
	BudgetID string
	Name     string
}

type CreateTransactionParams struct {
	ID         string
	AccountID  string
	PayeeID    sql.NullString
	CategoryID sql.NullString
	Date       time.Time
	Amount     pgtype.Numeric
	Notes      sql.NullString
}

type CreateUserParams struct {
	ID       string
	Username string
	Password string
}

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type GetAccountsForBudgetRow struct {
	ID        string
	Name      string
	BudgetID  string
	CreatedAt time.Time
	Balance   pgtype.Numeric
}

type GetActivityBeforeDateByCategoryParams struct {
	BudgetID string
	Date     time.Time
}

type GetActivityBeforeDateByCategoryRow struct {
	ID       string
	Activity pgtype.Numeric
}

type GetCategoryForBudgetParams struct {
	ID       string
	BudgetID string
}

type GetIncomeBetweenParams struct {
	BudgetID  string
	EndDate   time.Time
	BeginDate time.Time
}

type GetMonthByDateParams struct {
	BudgetID string
	Date     time.Time
}

type GetMonthCategoriesForMonthParams struct {
	FromDate time.Time
	ToDate   time.Time
	MonthID  string
}

type GetMonthCategoriesForMonthRow struct {
	ID         string
	MonthID    string
	CategoryID string
	Amount     pgtype.Numeric
	CreatedAt  time.Time
	Activity   pgtype.Numeric
}

type GetMonthCategoryByMonthAndCategoryParams struct {
	MonthID    string
	CategoryID string
}

type GetPastMonthCategoriesAvailableParams struct {
	BudgetID   string
	BeforeDate time.Time
}

type GetPastMonthCategoriesAvailableRow struct {
	ID       string
	Assigned pgtype.Numeric
}

type GetTransactionRow struct {
	ID          string
	AccountID   string
	PayeeID     sql.NullString
	CategoryID  sql.NullString
	Date        time.Time
	Amount      pgtype.Numeric
	Notes       sql.NullString
	CreatedAt   time.Time
	AccountName string
	BudgetID    string
}

type GetTransactionsForBudgetRow struct {
	ID           string
	AccountID    string
	PayeeID      sql.NullString
	CategoryID   sql.NullString
	Date         time.Time
	Amount       pgtype.Numeric
	Notes        sql.NullString
	CreatedAt    time.Time
	AccountName  string
	CategoryName sql.NullString
	PayeeName    sql.NullString
}

type Month struct {
	ID        string
	BudgetID  string
	Date      time.Time
	Carryover pgtype.Numeric
	CreatedAt time.Time
}

type MonthCategory struct {
	ID         string
	MonthID    string
	CategoryID string
	Amount     pgtype.Numeric
	CreatedAt  time.Time
}

type Payee struct {
	ID        string
	Name      string
	BudgetID  string
	CreatedAt time.Time
}

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

type Transaction struct {
	ID         string
	AccountID  string
	PayeeID    sql.NullString
	CategoryID sql.NullString
	Date       time.Time
	Amount     pgtype.Numeric
	Notes      sql.NullString
	CreatedAt  time.Time
}

type UpdateMonthCategoryAmountParams struct {
	Amount pgtype.Numeric
	ID     string
}

type UpdateMonthParams struct {
	Carryover pgtype.Numeric
	ID        string
}

type UpdateTransactionParams struct {
	AccountID  string
	CategoryID sql.NullString
	PayeeID    sql.NullString
	Date       time.Time
	Amount     pgtype.Numeric
	Notes      sql.NullString
	ID         string
}

type User struct {
	ID        string
	Username  string
	Password  string
	CreatedAt time.Time
}