database

Documentation

Index

• type DB
  • func CreateDB() *DB
  • func (db *DB) Close() error
  • func (db DB) DeleteExpense(id int) error
  • func (db *DB) GetBudgetWithYearMonth(date string) string
  • func (db *DB) GetDefaultBudget() string
  • func (db *DB) GetExpensesWithYearMonth(yearMonth string) []domain.Expense
  • func (db DB) InsertBudget(amount, date string) error
  • func (db DB) InsertExpense(expense domain.Expense) error
  • func (db DB) UpdateDefaultBudget(amount string) error

Types

type DB

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

func CreateDB

func CreateDB() *DB

CreateDB opens sqlite database connection and returns pointer to DB struct.

func (*DB) Close

func (db *DB) Close() error

Close closes the database connection.

func (DB) DeleteExpense

func (db DB) DeleteExpense(id int) error

DeleteExpense deletes an expense from expenses table by its Id.

func (*DB) GetBudgetWithYearMonth

func (db *DB) GetBudgetWithYearMonth(date string) string

GetBudgetWithYearMonth returns budget amount of a specific month and year (YYYY-MM).

func (*DB) GetDefaultBudget

func (db *DB) GetDefaultBudget() string

GetDefaultBudget returns the default monthly budget amount.

func (*DB) GetExpensesWithYearMonth

func (db *DB) GetExpensesWithYearMonth(yearMonth string) []domain.Expense

GetWithMonthYear returns expenses of a specific month and year (YYYY-MM).

func (DB) InsertBudget

func (db DB) InsertBudget(amount, date string) error

InsertBudget inserts budget amount for a specific month and year (YYYY-MM).

func (DB) InsertExpense

func (db DB) InsertExpense(expense domain.Expense) error

InsertExpense inserts a given expense into expenses table.

func (DB) UpdateDefaultBudget

func (db DB) UpdateDefaultBudget(amount string) error

UpdateDefaultBudget updates the default monthly budget amount.