database

package

v0.0.0-...-551aedc Latest Latest Go to latest Published: Dec 26, 2024 License: GPL-3.0 Imports: 6 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/LeRoid-hub/Bookholder-API

Links

Open Source Insights

Documentation ¶

Index ¶

Constants
func DeleteAccount(database *sql.DB, id int) error
func DeleteTransaction(database *sql.DB, id int) error
func DeleteUser(database *sql.DB, id string) error
func New() (*sql.DB, error)
func NewAccount(database *sql.DB, account Account) error
func NewTransaction(database *sql.DB, transaction Transaction) error
func NewUser(database *sql.DB, user User) error
func UpdateAccount(database *sql.DB, account Account) error
func UpdateTransaction(database *sql.DB, transaction Transaction) error
func UpdateUser(database *sql.DB, user User) error
type Account
- func GetAccount(database *sql.DB, id int) (Account, error)
type DB
- func SetEnv(env map[string]string) *DB
type Transaction
- func GetTransaction(database *sql.DB, id int) (Transaction, error)
- func GetTransactions(database *sql.DB, account int, year int, month int) ([]Transaction, error)
type User

Constants ¶

View Source

const (
	SqlFile = "./database/bookholder.sql"
)

Variables ¶

This section is empty.

Functions ¶

func DeleteAccount ¶

func DeleteAccount(database *sql.DB, id int) error

func DeleteTransaction ¶

func DeleteTransaction(database *sql.DB, id int) error

func DeleteUser ¶

func DeleteUser(database *sql.DB, id string) error

func New ¶

func New() (*sql.DB, error)

func NewAccount ¶

func NewAccount(database *sql.DB, account Account) error

func NewTransaction ¶

func NewTransaction(database *sql.DB, transaction Transaction) error

func NewUser ¶

func NewUser(database *sql.DB, user User) error

func UpdateAccount ¶

func UpdateAccount(database *sql.DB, account Account) error

func UpdateTransaction ¶

func UpdateTransaction(database *sql.DB, transaction Transaction) error

func UpdateUser ¶

func UpdateUser(database *sql.DB, user User) error

Types ¶

type Account ¶

type Account struct {
	ID   uint
	Name string
	Kind string
}

func GetAccount ¶

func GetAccount(database *sql.DB, id int) (Account, error)

type DB ¶

type DB struct {
	Host     string
	User     string
	Password string
	Name     string
	Port     string
}

func SetEnv ¶

func SetEnv(env map[string]string) *DB

type Transaction ¶

type Transaction struct {
	ID            uint
	Amount        float32
	Debit         bool
	OffsetAccount uint
	Account       uint
	Date          time.Time
	Description   string
}

func GetTransaction ¶

func GetTransaction(database *sql.DB, id int) (Transaction, error)

func GetTransactions ¶

func GetTransactions(database *sql.DB, account int, year int, month int) ([]Transaction, error)

type User ¶

type User struct {
	ID       string
	Name     string
	Password string
}

func AuthenticateUser ¶

func AuthenticateUser(database *sql.DB, name string, password string) (User, error)

func GetUser ¶

func GetUser(database *sql.DB, id string) (User, error)

func GetUserByName ¶

func GetUserByName(database *sql.DB, name string) (User, error)

Source Files ¶

View all Source files

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