sqlite3

package
v0.2.0 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Dec 23, 2020 License: MIT Imports: 9 Imported by: 0

Documentation

Index

Constants

View Source
const DATABASEDRIVER = "sqlite3"

DATABASEDRIVER is set to sqlite3 database

Variables

This section is empty.

Functions

This section is empty.

Types

type Repository

type Repository struct {
	DB *sql.DB
}

Repository struct to handle database connections

func NewRepository

func NewRepository(migrationPath, databaseFile string) *Repository

NewRepository creates new repository instance

func NewTestRepository

func NewTestRepository(migrationPath string) *Repository

NewTestRepository is only used fot testing purpose

func (*Repository) CreateDevice

func (m *Repository) CreateDevice(device *models.Device) (uint32, error)

CreateDevice returns given device

func (*Repository) CreateInventoryItem

func (m *Repository) CreateInventoryItem(state *models.State) error

CreateInventoryItem creates new user-device-relationship

func (*Repository) CreateUser

func (m *Repository) CreateUser(user *models.User) error

CreateUser creates new user db entry

func (*Repository) DeleteDevice

func (m *Repository) DeleteDevice(id uint64) error

DeleteDevice deletes given device

func (*Repository) DeleteInventoryItem

func (m *Repository) DeleteInventoryItem(inventoryID uint32) error

DeleteInventoryItem creates new user-device-relationship

func (*Repository) DeleteUser

func (m *Repository) DeleteUser(id uint64) error

DeleteUser deletes given user

func (*Repository) GetDevice

func (m *Repository) GetDevice(id uint64) (*models.Device, error)

GetDevice returns given device

func (*Repository) GetDevices

func (m *Repository) GetDevices() ([]*models.Device, error)

GetDevices returns all devices

func (*Repository) GetInventory

func (m *Repository) GetInventory() ([]*commonModel.Inventory, error)

GetInventory returns all users

func (*Repository) GetInventoryItem

func (m *Repository) GetInventoryItem(id uint32) (*commonModel.Inventory, error)

GetInventoryItem get state id db entry

func (*Repository) GetUser

func (m *Repository) GetUser(id uint64) (*models.User, error)

GetUser creates user db entry

func (*Repository) GetUsers

func (m *Repository) GetUsers() ([]*models.User, error)

GetUsers returns all users

func (*Repository) UpdateDevice

func (m *Repository) UpdateDevice(id uint64, device *models.Device) error

UpdateDevice updates given device

func (*Repository) UpdateInventoryItem

func (m *Repository) UpdateInventoryItem(inventoryID, userID, updateTime uint32) error

UpdateInventoryItem set user to inventory item

func (*Repository) UpdateUser

func (m *Repository) UpdateUser(id uint64, user *models.User) error

UpdateUser updates given user

Jump to

Keyboard shortcuts

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