sqlitedatabase

package

v0.0.0-...-be14f60 Latest Latest Go to latest Published: Jan 26, 2022 License: MIT Imports: 7 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

This section is empty.

View Source

var DBOnce sync.Once

DBOnce used to execute client creation procedure only once. nolint:gochecknoglobals

This section is empty.

type DB struct {
	Client *sql.DB
}

DB is database type that implement database interface.

func NewDB() (*DB, error)

NewDB create new DB struct.

func (db *DB) AddNewCard(card models.Card) error

AddNewCard get card and add it to database.

func (db *DB) CreateCardTable() error

CreateCardTable check if card table exist or not and if not creates one.

func (db *DB) DeleteCard(id string) error

DeleteCard get card id and remove it from database.

func (db *DB) FindByID(id string) (*models.Card, error)

FindByID get card d and find it in the database and return it.

func (db *DB) GetCards() ([]models.Card, error)

GetCards query all cards from database and return them.

func (db *DB) UpdateCard(card models.Card) error

UpdateCard get card and update it in database.