mysqldb

Documentation

Index

• Variables
• func AddAsset() (*uuid.UUID, error)
• func AddProduct(product *models.Product, productUsers *models.ProductUsers) error
• func AddProject(project models.Project) error
• func AddSettings() (*uuid.UUID, error)
• func AddUser(name string, email string, passwd string) error
• func ConvertToJSONRaw(references interface{}) (*json.RawMessage, error)
• func DeleteAsset(assetID *uuid.UUID) error
• func DeleteProduct(productID *uuid.UUID) error
• func DeleteSettings(settingsID *uuid.UUID) error
• func DeleteUser(email string) error
• func EmailExists(email string) (bool, error)
• func GetAsset(assetID *uuid.UUID) (*models.Asset, error)
• func GetProductByID(ID uuid.UUID) (*models.Product, error)
• func GetProductsByUserID(userID uuid.UUID) (*[]models.Product, error)
• func GetProjectByName(name string) (models.Project, error)
• func GetSettings(settingsID *uuid.UUID) (*models.UserSetting, error)
• func GetUserByEmail(email string) (*models.User, error)
• func GetUserByID(ID uuid.UUID) (*models.User, error)
• func IsPasswordCorrect(password string, user *models.User) bool
• func UpdateAsset(asset *models.Asset) error
• func UpdateAssetID(user *models.User) error
• func UpdateProject(project models.Project) error
• func UserExists(username string) (bool, error)
• type DBInterfaceCommon
• type DBInterfaceMock
  • func (DBInterfaceMock) BootstrapSystem() error
  • func (i DBInterfaceMock) ConnectSystem() (*sql.DB, error)
• type MYSQLInterface
  • func (MYSQLInterface) BootstrapSystem() error
  • func (MYSQLInterface) ConnectSystem() (*sql.DB, error)

Variables

var DBConnection = ""

var MigrationDirectory = ""

Functions

func AddAsset

func AddAsset() (*uuid.UUID, error)

func AddProduct

func AddProduct(product *models.Product, productUsers *models.ProductUsers) error

func AddProject

func AddProject(project models.Project) error

AddProject adds a new project to the database.

func AddSettings

func AddSettings() (*uuid.UUID, error)

func AddUser

func AddUser(name string, email string, passwd string) error

AddUser creates a new user entry in the DB. Whitespaces in the email are automatically deleted Email is a unique attribute, so the function checks for existing email, before adding a new entry

func ConvertToJSONRaw

func ConvertToJSONRaw(references interface{}) (*json.RawMessage, error)

func DeleteAsset

func DeleteAsset(assetID *uuid.UUID) error

func DeleteProduct

func DeleteProduct(productID *uuid.UUID) error

func DeleteSettings

func DeleteSettings(settingsID *uuid.UUID) error

func DeleteUser

func DeleteUser(email string) error

func EmailExists

func EmailExists(email string) (bool, error)

func GetAsset

func GetAsset(assetID *uuid.UUID) (*models.Asset, error)

func GetProductByID

func GetProductByID(ID uuid.UUID) (*models.Product, error)

func GetProductsByUserID

func GetProductsByUserID(userID uuid.UUID) (*[]models.Product, error)

GetProductsByUserID returns all products belonging to the selected user. The function first gets all rows matching with the user DI from users_products table, then gets all products based on the product ids from the first query result.

func GetProjectByName

func GetProjectByName(name string) (models.Project, error)

GetProjectByName returns the project by name.

func GetSettings

func GetSettings(settingsID *uuid.UUID) (*models.UserSetting, error)

func GetUserByEmail

func GetUserByEmail(email string) (*models.User, error)

GetUserByEmail returns the user defined by the email.

func GetUserByID

func GetUserByID(ID uuid.UUID) (*models.User, error)

GetUserByID returns the user defined by it uuid.

func IsPasswordCorrect

func IsPasswordCorrect(password string, user *models.User) bool

CheckPassword compares the password entered by the user with the stored password.

func UpdateAsset

func UpdateAsset(asset *models.Asset) error

func UpdateAssetID

func UpdateAssetID(user *models.User) error

Adds a new assetID if there is non assigned yet. This only can happen if the user was generated before introduction of assets.

func UpdateProject

func UpdateProject(project models.Project) error

UpdateProject updates the selected project.

func UserExists

func UserExists(username string) (bool, error)

Types

type DBInterfaceCommon

type DBInterfaceCommon interface {
	BootstrapSystem() error
	ConnectSystem() (*sql.DB, error)
}

var DBInterface DBInterfaceCommon

type DBInterfaceMock

type DBInterfaceMock struct {
	Mock sqlmock.Sqlmock
	DB   *sql.DB
}

func (DBInterfaceMock) BootstrapSystem

func (DBInterfaceMock) BootstrapSystem() error

func (DBInterfaceMock) ConnectSystem

func (i DBInterfaceMock) ConnectSystem() (*sql.DB, error)

type MYSQLInterface

type MYSQLInterface struct {
}

func (MYSQLInterface) BootstrapSystem

func (MYSQLInterface) BootstrapSystem() error

func (MYSQLInterface) ConnectSystem

func (MYSQLInterface) ConnectSystem() (*sql.DB, error)