repo

Documentation

Index

• Constants
• type ApiOpsInterface
• type DBHolder
  • func NewDriver(dsn string) (*DBHolder, error)
  • func (d *DBHolder) AddCar(car *models.Cars) error
  • func (d *DBHolder) AddUser(user *models.Users) error
  • func (d *DBHolder) CreateStatement(ctx context.Context, name string, query string) error
  • func (d *DBHolder) CreateTables() error
  • func (d *DBHolder) DeleteUser(userID int) error
  • func (d *DBHolder) Dispose() error
  • func (d *DBHolder) GetAllUsers(limit, offset int) ([]*models.Users, error)
  • func (d *DBHolder) GetUserByID(userID int) (*models.Users, error)
  • func (d *DBHolder) PingingDB() error
  • func (d *DBHolder) UpdateCar(car *models.Cars) error
  • func (d *DBHolder) UpdateUser(user *models.Users) error

Constants

const (
	CarsTable = `` /* 370-byte string literal not displayed */

	UsersTable = `` /* 213-byte string literal not displayed */

	GetUserCarsById = `SELECT r.id, r.number_plate, r.color, r.vin FROM users s INNER JOIN cars r ON r.owner_id = s.id WHERE s.id=?`
)

Types

type ApiOpsInterface

type ApiOpsInterface interface {
	CreateTables() error
	AddUser(user *models.Users) error
	AddCar(car *models.Cars) error
	UpdateUser(user *models.Users) error
	UpdateCar(car *models.Cars) error
	DeleteUser(userID int) error
	GetUserByID(userID int) (*models.Users, error)
	GetAllUsers(limit, offset int) ([]*models.Users, error)
}

type DBHolder

type DBHolder struct {
	DB         *sql.DB
	Statements map[string]*sql.Stmt
}

func NewDriver

func NewDriver(dsn string) (*DBHolder, error)

func (*DBHolder) AddCar

func (d *DBHolder) AddCar(car *models.Cars) error

AddCar use for adding car into the db

func (*DBHolder) AddUser

func (d *DBHolder) AddUser(user *models.Users) error

AddUser use for adding user into db

func (*DBHolder) CreateStatement

func (d *DBHolder) CreateStatement(ctx context.Context, name string, query string) error

func (*DBHolder) CreateTables

func (d *DBHolder) CreateTables() error

CreateTables use for creating our tables at the beginning of the program

func (*DBHolder) DeleteUser

func (d *DBHolder) DeleteUser(userID int) error

DeleteUser use for deleting a user with its own ID

func (*DBHolder) Dispose

func (d *DBHolder) Dispose() error

func (*DBHolder) GetAllUsers

func (d *DBHolder) GetAllUsers(limit, offset int) ([]*models.Users, error)

GetAllUsers use for getting all users and associated cars

func (*DBHolder) GetUserByID

func (d *DBHolder) GetUserByID(userID int) (*models.Users, error)

GetUserByID use for getting models.Users information with models.Cars

func (*DBHolder) PingingDB

func (d *DBHolder) PingingDB() error

func (*DBHolder) UpdateCar

func (d *DBHolder) UpdateCar(car *models.Cars) error

UpdateCar use for update a car by its id

func (*DBHolder) UpdateUser

func (d *DBHolder) UpdateUser(user *models.Users) error

UpdateUser use for update a user