mysqldb

Documentation

Index

• Constants
• Variables
• func AddUsersViewers(userID *uuid.UUID, userViewers models.ViewersList, tx *sql.Tx) error
• func ConvertToJSONRaw(references interface{}) (*json.RawMessage, error)
• func DeleteViewerIDsByUserID(userID *uuid.UUID, tx *sql.Tx) error
• func IsPasswordCorrect(password string, user *models.User) bool
• func RollbackWithErrorStack(tx *sql.Tx, errorStack error) error
• type ConnectorCommon
• type DBConnectorMock
  • func (*DBConnectorMock) BootstrapSystem() error
  • func (*DBConnectorMock) Commit(tx *sql.Tx) error
  • func (i *DBConnectorMock) ConnectSystem() (*sql.Tx, error)
  • func (DBConnectorMock) Rollback(tx *sql.Tx) error
• type FunctionsCommon
• type MYSQLConnector
  • func (c *MYSQLConnector) BootstrapSystem() error
  • func (*MYSQLConnector) Commit(tx *sql.Tx) error
  • func (c *MYSQLConnector) ConnectSystem() (*sql.Tx, error)
  • func (*MYSQLConnector) Rollback(tx *sql.Tx) error
• type MYSQLFunctions
  • func (*MYSQLFunctions) AddAsset(assetType string, asset *models.Asset, tx *sql.Tx) error
  • func (*MYSQLFunctions) AddProduct(product *models.Product, tx *sql.Tx) error
  • func (*MYSQLFunctions) AddProductUsers(productID *uuid.UUID, productUsers *models.ProductUserIDs, tx *sql.Tx) error
  • func (*MYSQLFunctions) AddProject(project *models.Project, tx *sql.Tx) error
  • func (*MYSQLFunctions) AddProjectUsers(projectID *uuid.UUID, projectUsers *models.ProjectUserIDs, tx *sql.Tx) error
  • func (*MYSQLFunctions) AddProjectViewer(projectViewer *models.ProjectViewer, tx *sql.Tx) error
  • func (*MYSQLFunctions) AddUser(user *models.User, tx *sql.Tx) error
  • func (*MYSQLFunctions) DeleteAsset(assetType string, assetID *uuid.UUID, tx *sql.Tx) error
  • func (*MYSQLFunctions) DeleteProduct(productID *uuid.UUID, tx *sql.Tx) error
  • func (MYSQLFunctions) DeleteProductUser(productID *uuid.UUID, userID *uuid.UUID, tx *sql.Tx) error
  • func (*MYSQLFunctions) DeleteProductUsersByProductID(productID *uuid.UUID, tx *sql.Tx) error
  • func (*MYSQLFunctions) DeleteProject(projectID *uuid.UUID, tx *sql.Tx) error
  • func (*MYSQLFunctions) DeleteProjectUsersByProjectID(projectID *uuid.UUID, tx *sql.Tx) error
  • func (*MYSQLFunctions) DeleteProjectViewerByProjectID(projectID *uuid.UUID, tx *sql.Tx) error
  • func (f *MYSQLFunctions) DeleteProjectViewerByUserID(userID *uuid.UUID, tx *sql.Tx) error
  • func (*MYSQLFunctions) DeleteProjectViewerByViewerID(viewerID *uuid.UUID, tx *sql.Tx) error
  • func (*MYSQLFunctions) DeleteProjectsByProductID(productID *uuid.UUID, tx *sql.Tx) error
  • func (*MYSQLFunctions) DeleteUser(ID *uuid.UUID, tx *sql.Tx) error
  • func (*MYSQLFunctions) DeleteViewerByOwnerID(userID *uuid.UUID, tx *sql.Tx) error
  • func (f *MYSQLFunctions) EmailExists(email string) (bool, error)
  • func (f *MYSQLFunctions) GetAsset(assetType string, assetID *uuid.UUID) (*models.Asset, error)
  • func (*MYSQLFunctions) GetAssets(assetType string, IDs []uuid.UUID, tx *sql.Tx) ([]models.Asset, error)
  • func (f *MYSQLFunctions) GetPrivilege(name string) (*models.Privilege, error)
  • func (f *MYSQLFunctions) GetPrivileges() (models.Privileges, error)
  • func (*MYSQLFunctions) GetProductByID(ID *uuid.UUID, tx *sql.Tx) (*models.Product, error)
  • func (*MYSQLFunctions) GetProductByName(name string, tx *sql.Tx) (*models.Product, error)
  • func (*MYSQLFunctions) GetProductProjects(productID *uuid.UUID, tx *sql.Tx) ([]models.Project, error)
  • func (MYSQLFunctions) GetProductUserIDs(productID *uuid.UUID, tx *sql.Tx) (*models.ProductUserIDs, error)
  • func (*MYSQLFunctions) GetProductsByIDs(IDs []uuid.UUID, tx *sql.Tx) ([]models.Product, error)
  • func (*MYSQLFunctions) GetProjectByID(ID *uuid.UUID, tx *sql.Tx) (*models.Project, error)
  • func (*MYSQLFunctions) GetProjectViewersByUserID(userID *uuid.UUID, tx *sql.Tx) ([]models.ProjectViewer, error)
  • func (*MYSQLFunctions) GetProjectViewersByViewerID(viewerID *uuid.UUID, tx *sql.Tx) ([]models.ProjectViewer, error)
  • func (*MYSQLFunctions) GetProjectsByIDs(IDs []uuid.UUID, tx *sql.Tx) ([]models.Project, error)
  • func (*MYSQLFunctions) GetUser(queryType int, keyValue interface{}, tx *sql.Tx) (*models.User, error)
  • func (f *MYSQLFunctions) GetUserIDsByViewerID(viewerID *uuid.UUID) (*models.ViewUsers, error)
  • func (*MYSQLFunctions) GetUserProductIDs(userID *uuid.UUID, tx *sql.Tx) (*models.UserProductIDs, error)
  • func (*MYSQLFunctions) GetUserProjectIDs(userID *uuid.UUID, tx *sql.Tx) (*models.UserProjectIDs, error)
  • func (MYSQLFunctions) GetUsersByIDs(IDs []uuid.UUID, tx *sql.Tx) ([]models.User, error)
  • func (f *MYSQLFunctions) GetViewerIDsByUserID(userID *uuid.UUID) (models.ViewersList, error)
  • func (f *MYSQLFunctions) UpdateAsset(assetType string, asset *models.Asset) error
  • func (*MYSQLFunctions) UpdateUsersProducts(userID *uuid.UUID, productID *uuid.UUID, privilege int, tx *sql.Tx) error
  • func (*MYSQLFunctions) UpdateUsersProjects(userID *uuid.UUID, projectID *uuid.UUID, privilege int, tx *sql.Tx) error
  • func (f *MYSQLFunctions) UserExists(username string) (bool, error)

Constants

const (
	UserAssets     = "user_assets"
	ProductAssets  = "product_assets"
	ProductDetails = "product_details"
	UserSettings   = "user_settings"
	ProjectDetails = "project_details"
	ProjectAssets  = "project_assets"
)

const (
	ByEmail = iota
	ByID
)

Defines the possible user query key names

Variables

var AddAssetQuery = "INSERT INTO %s (id, data) VALUES (UUID_TO_BIN(?), ?)"

var AddProductQuery = "" /* 129-byte string literal not displayed */

var AddProductUsersQuery = "INSERT INTO users_products (users_id, products_id, privileges_id) VALUES (UUID_TO_BIN(?), UUID_TO_BIN(?), ?)"

var AddProjectQuery = "" /* 149-byte string literal not displayed */

var AddProjectUsersQuery = "INSERT INTO users_projects (users_id, projects_id, privileges_id) VALUES (UUID_TO_BIN(?), UUID_TO_BIN(?), ?)"

var AddProjectViewerQuery = "INSERT INTO users_viewers (users_id, viewer_id, projects_id) VALUES (UUID_TO_BIN(?), UUID_TO_BIN(?), UUID_TO_BIN(?))"

var AddUsersViewersQuery = "" /* 129-byte string literal not displayed */

var AddViewerQuery = "INSERT INTO viewers (id, owner_id) VALUES (UUID_TO_BIN(?), UUID_TO_BIN(?))"

var DeleteAssetQuery = "DELETE FROM %s WHERE id=UUID_TO_BIN(?)"

var DeleteProductQuery = "DELETE FROM products where id = UUID_TO_BIN(?)"

var DeleteProductUserQuery = "DELETE FROM users_products where products_id = UUID_TO_BIN(?) AND users_id = UUID_TO_BIN(?)"

var DeleteProductUsersByProductIDQuery = "DELETE FROM users_products where products_id = UUID_TO_BIN(?)"

var DeleteProjectQuery = "DELETE FROM projects where id = UUID_TO_BIN(?)"

var DeleteProjectUsersByProjectIDQuery = "DELETE FROM users_projects where projects_id = UUID_TO_BIN(?)"

var DeleteProjectViewerByProjectIDQuery = "DELETE FROM users_viewers where projects_id = UUID_TO_BIN(?)"

var DeleteProjectViewerByUserIDQuery = "DELETE FROM users_viewers where users_id = UUID_TO_BIN(?)"

var DeleteProjectViewerByViewerIDQuery = "DELETE FROM users_viewers where viewer_id = UUID_TO_BIN(?)"

var DeleteProjectsByProductIDQuery = "DELETE FROM projects where products_id = UUID_TO_BIN(?)"

var DeleteUserQuery = "DELETE FROM users WHERE id=UUID_TO_BIN(?)"

var DeleteViewerByOwnerQuery = "DELETE FROM viewers where owner_id = UUID_TO_BIN(?)"

var DeleteViewerIDsByUserIDQuery = "DELETE FROM users_viewers where users_id = UUID_TO_BIN(?)"

var ErrAssetMissing = "This %s is missing or old value is the same as new"

var ErrDuplicateProductNameEntry = errors.New("Product with this name already exists")

var ErrDuplicateUserNameEntry = errors.New("User with this name already exists")

var ErrNoProductDeleted = errors.New("No product was deleted")

var ErrNoProductUserAdded = errors.New("No product user relation has been added")

var ErrNoProjectDeleted = errors.New("No project was deleted")

var ErrNoProjectUserAdded = errors.New("No project user relation has been added")

var ErrNoProjectViewerDeleted = errors.New("No project viewer was deleted")

var ErrNoUserDeleted = errors.New("No user was deleted")

var ErrNoUserViewerAdded = errors.New("No data views have been added for this user")

var ErrNoUserWithEmail = errors.New("There is no user associated with this email")

var ErrNoUserWithProduct = errors.New("No user is associated to this product")

var ErrNoUserWithProject = errors.New("No user is associated to this project")

var ErrNoUsersProductUpdate = errors.New("No users product was updated")

var ErrNoUsersProjectUpdate = errors.New("No users project was updated")

var ErrNoViewForThisUser = errors.New("No data views associated with this user")

var ErrNoViewerDeleted = errors.New("No viewer was deleted")

var ErrSQLDuplicateEmailEntryString = "Error 1062: Duplicate entry '%s' for key 'users.email'"

var ErrSQLDuplicateProductNameEntryString = "Duplicate entry '%s' for key 'products.name'"

var ErrSQLDuplicateUserNameEntryString = "Error 1062: Duplicate entry '%s' for key 'users.name'"

var GetAssetQuery = "SELECT BIN_TO_UUID(id), data FROM %s WHERE id = UUID_TO_BIN(?)"

var GetAssetsQuery = "SELECT BIN_TO_UUID(id), data FROM %s WHERE id IN (UUID_TO_BIN(?)"

var GetPrivilegeQuery = "SELECT id, name, description from privileges where name = ?"

var GetPrivilegesQuery = "SELECT id, name, description from privileges"

var GetProductByIDQuery = "" /* 133-byte string literal not displayed */

var GetProductByNameQuery = "SELECT BIN_TO_UUID(id), name, BIN_TO_UUID(product_details_id), BIN_TO_UUID(product_assets_id) FROM products WHERE name = ?"

var GetProductProjectsQuery = "" /* 162-byte string literal not displayed */

var GetProductUserIDsQuery = "SELECT BIN_TO_UUID(users_id), privileges_id FROM users_products where products_id = UUID_TO_BIN(?)"

var GetProductsByIDsQuery = "" /* 135-byte string literal not displayed */

var GetProjectByIDQuery = "" /* 153-byte string literal not displayed */

var GetProjectViewerByUserIDQuery = "" /* 129-byte string literal not displayed */

var GetProjectViewerByViewerIDQuery = "" /* 130-byte string literal not displayed */

var GetProjectsByIDsQuery = "" /* 155-byte string literal not displayed */

var GetUserByEmailQuery = "" /* 132-byte string literal not displayed */

var GetUserByIDQuery = "" /* 142-byte string literal not displayed */

var GetUserIDsByViewerIDQuery = "SELECT BIN_TO_UUID(users_id), is_owner from users_viewers where viewer_id = UUID_TO_BIN(?)"

var GetUserProductIDsQuery = "SELECT BIN_TO_UUID(products_id), privileges_id FROM users_products where users_id = UUID_TO_BIN(?)"

var GetUserProjectIDsQuery = "SELECT BIN_TO_UUID(projects_id), privileges_id FROM users_projects where users_id = UUID_TO_BIN(?)"

var GetUsersByIDsQuery = "" /* 144-byte string literal not displayed */

var GetViewerIDsByUserIDQuery = "SELECT BIN_TO_UUID(viewer_id), is_owner, BIN_TO_UUID(projects_id) from users_viewers where users_id = UUID_TO_BIN(?)"

var InsertUserQuery = "" /* 144-byte string literal not displayed */

var UpdateAssetQuery = "UPDATE %s set data = ? where id = UUID_TO_BIN(?)"

var UpdateUsersProductsQuery = "UPDATE users_products set privileges_id = ? where users_id = UUID_TO_BIN(?) AND products_id = UUID_TO_BIN(?)"

var UpdateUsersProjectsQuery = "UPDATE users_projects set privileges_id = ? where users_id = UUID_TO_BIN(?) AND projects_id = UUID_TO_BIN(?)"

Functions

func AddUsersViewers

func AddUsersViewers(userID *uuid.UUID, userViewers models.ViewersList, tx *sql.Tx) error

func ConvertToJSONRaw

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

func DeleteViewerIDsByUserID

func DeleteViewerIDsByUserID(userID *uuid.UUID, tx *sql.Tx) error

func IsPasswordCorrect

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

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

func RollbackWithErrorStack

func RollbackWithErrorStack(tx *sql.Tx, errorStack error) error

Types

type ConnectorCommon

type ConnectorCommon interface {
	BootstrapSystem() error
	ConnectSystem() (*sql.Tx, error)
	Commit(tx *sql.Tx) error
	Rollback(tx *sql.Tx) error
}

Common interface for DB connection. Needed in order to allow mock and custom DB interface implementation.

type DBConnectorMock

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

func (*DBConnectorMock) BootstrapSystem

func (*DBConnectorMock) BootstrapSystem() error

func (*DBConnectorMock) Commit

func (*DBConnectorMock) Commit(tx *sql.Tx) error

func (*DBConnectorMock) ConnectSystem

func (i *DBConnectorMock) ConnectSystem() (*sql.Tx, error)

func (DBConnectorMock) Rollback

func (DBConnectorMock) Rollback(tx *sql.Tx) error

type FunctionsCommon

type FunctionsCommon interface {
	GetUser(queryType int, keyValue interface{}, tx *sql.Tx) (*models.User, error)
	AddUser(user *models.User, tx *sql.Tx) error
	DeleteUser(userID *uuid.UUID, tx *sql.Tx) error
	GetProductUserIDs(productID *uuid.UUID, tx *sql.Tx) (*models.ProductUserIDs, error)
	GetUsersByIDs(IDs []uuid.UUID, tx *sql.Tx) ([]models.User, error)

	AddAsset(assetType string, asset *models.Asset, tx *sql.Tx) error
	DeleteAsset(assetType string, assetID *uuid.UUID, tx *sql.Tx) error
	GetAssets(assetType string, IDs []uuid.UUID, tx *sql.Tx) ([]models.Asset, error)
	GetAsset(assetType string, assetID *uuid.UUID) (*models.Asset, error)
	UpdateAsset(assetType string, asset *models.Asset) error

	UpdateUsersProducts(userID *uuid.UUID, productID *uuid.UUID, privilege int, tx *sql.Tx) error
	AddProductUsers(productID *uuid.UUID, productUsers *models.ProductUserIDs, tx *sql.Tx) error
	DeleteProductUsersByProductID(productID *uuid.UUID, tx *sql.Tx) error
	DeleteProductUser(productID *uuid.UUID, userID *uuid.UUID, tx *sql.Tx) error
	GetUserProductIDs(userID *uuid.UUID, tx *sql.Tx) (*models.UserProductIDs, error)

	GetProductByID(ID *uuid.UUID, tx *sql.Tx) (*models.Product, error)
	GetProductByName(name string, tx *sql.Tx) (*models.Product, error)
	AddProduct(product *models.Product, tx *sql.Tx) error
	DeleteProduct(productID *uuid.UUID, tx *sql.Tx) error
	GetProductsByIDs(IDs []uuid.UUID, tx *sql.Tx) ([]models.Product, error)

	AddProject(project *models.Project, tx *sql.Tx) error
	AddProjectUsers(projectID *uuid.UUID, projectUsers *models.ProjectUserIDs, tx *sql.Tx) error
	GetProjectByID(ID *uuid.UUID, tx *sql.Tx) (*models.Project, error)
	DeleteProjectUsersByProjectID(projectID *uuid.UUID, tx *sql.Tx) error
	DeleteProject(projectID *uuid.UUID, tx *sql.Tx) error
	DeleteProjectsByProductID(productID *uuid.UUID, tx *sql.Tx) error
	GetProjectsByIDs(IDs []uuid.UUID, tx *sql.Tx) ([]models.Project, error)
	GetProductProjects(productID *uuid.UUID, tx *sql.Tx) ([]models.Project, error)

	GetUserProjectIDs(userID *uuid.UUID, tx *sql.Tx) (*models.UserProjectIDs, error)
	UpdateUsersProjects(userID *uuid.UUID, projectID *uuid.UUID, privilege int, tx *sql.Tx) error
	AddProjectViewer(projectViewer *models.ProjectViewer, tx *sql.Tx) error
	DeleteProjectViewerByUserID(userID *uuid.UUID, tx *sql.Tx) error
	GetProjectViewersByUserID(userID *uuid.UUID, tx *sql.Tx) ([]models.ProjectViewer, error)
	GetProjectViewersByViewerID(viewerID *uuid.UUID, tx *sql.Tx) ([]models.ProjectViewer, error)
	DeleteProjectViewerByViewerID(viewerID *uuid.UUID, tx *sql.Tx) error
	DeleteProjectViewerByProjectID(projectID *uuid.UUID, tx *sql.Tx) error

	DeleteViewerByOwnerID(userID *uuid.UUID, tx *sql.Tx) error

	GetPrivileges() (models.Privileges, error)
	GetPrivilege(name string) (*models.Privilege, error)
}

Data handling common function interface. Needed in order to allow mock and custom functionality implementations.

type MYSQLConnector

type MYSQLConnector struct {
	DBConnection       string
	MigrationDirectory string
}

MYSQL database connector implementation

func (*MYSQLConnector) BootstrapSystem

func (c *MYSQLConnector) BootstrapSystem() error

func (*MYSQLConnector) Commit

func (*MYSQLConnector) Commit(tx *sql.Tx) error

func (*MYSQLConnector) ConnectSystem

func (c *MYSQLConnector) ConnectSystem() (*sql.Tx, error)

func (*MYSQLConnector) Rollback

func (*MYSQLConnector) Rollback(tx *sql.Tx) error

type MYSQLFunctions

type MYSQLFunctions struct {
	DBConnector ConnectorCommon
	UUIDImpl    models.UUIDCommon
}

MYSQLFunctions represents the implementation of MYSQL data manipulation functions.

var DBFunctions *MYSQLFunctions

func (*MYSQLFunctions) AddAsset

func (*MYSQLFunctions) AddAsset(assetType string, asset *models.Asset, tx *sql.Tx) error

func (*MYSQLFunctions) AddProduct

func (*MYSQLFunctions) AddProduct(product *models.Product, tx *sql.Tx) error

func (*MYSQLFunctions) AddProductUsers

func (*MYSQLFunctions) AddProductUsers(productID *uuid.UUID, productUsers *models.ProductUserIDs, tx *sql.Tx) error

func (*MYSQLFunctions) AddProject

func (*MYSQLFunctions) AddProject(project *models.Project, tx *sql.Tx) error

func (*MYSQLFunctions) AddProjectUsers

func (*MYSQLFunctions) AddProjectUsers(projectID *uuid.UUID, projectUsers *models.ProjectUserIDs, tx *sql.Tx) error

func (*MYSQLFunctions) AddProjectViewer

func (*MYSQLFunctions) AddProjectViewer(projectViewer *models.ProjectViewer, tx *sql.Tx) error

func (*MYSQLFunctions) AddUser

func (*MYSQLFunctions) AddUser(user *models.User, tx *sql.Tx) error

AddUser creates a new user entry in the DB. Whitespaces in the email are automatically deleted Email/Name are unique in DB. Duplicates will return error.

func (*MYSQLFunctions) DeleteAsset

func (*MYSQLFunctions) DeleteAsset(assetType string, assetID *uuid.UUID, tx *sql.Tx) error

func (*MYSQLFunctions) DeleteProduct

func (*MYSQLFunctions) DeleteProduct(productID *uuid.UUID, tx *sql.Tx) error

func (MYSQLFunctions) DeleteProductUser

func (MYSQLFunctions) DeleteProductUser(productID *uuid.UUID, userID *uuid.UUID, tx *sql.Tx) error

func (*MYSQLFunctions) DeleteProductUsersByProductID

func (*MYSQLFunctions) DeleteProductUsersByProductID(productID *uuid.UUID, tx *sql.Tx) error

func (*MYSQLFunctions) DeleteProject

func (*MYSQLFunctions) DeleteProject(projectID *uuid.UUID, tx *sql.Tx) error

func (*MYSQLFunctions) DeleteProjectUsersByProjectID

func (*MYSQLFunctions) DeleteProjectUsersByProjectID(projectID *uuid.UUID, tx *sql.Tx) error

func (*MYSQLFunctions) DeleteProjectViewerByProjectID

func (*MYSQLFunctions) DeleteProjectViewerByProjectID(projectID *uuid.UUID, tx *sql.Tx) error

func (*MYSQLFunctions) DeleteProjectViewerByUserID

func (f *MYSQLFunctions) DeleteProjectViewerByUserID(userID *uuid.UUID, tx *sql.Tx) error

func (*MYSQLFunctions) DeleteProjectViewerByViewerID

func (*MYSQLFunctions) DeleteProjectViewerByViewerID(viewerID *uuid.UUID, tx *sql.Tx) error

func (*MYSQLFunctions) DeleteProjectsByProductID

func (*MYSQLFunctions) DeleteProjectsByProductID(productID *uuid.UUID, tx *sql.Tx) error

func (*MYSQLFunctions) DeleteUser

func (*MYSQLFunctions) DeleteUser(ID *uuid.UUID, tx *sql.Tx) error

func (*MYSQLFunctions) DeleteViewerByOwnerID

func (*MYSQLFunctions) DeleteViewerByOwnerID(userID *uuid.UUID, tx *sql.Tx) error

func (*MYSQLFunctions) EmailExists

func (f *MYSQLFunctions) EmailExists(email string) (bool, error)

func (*MYSQLFunctions) GetAsset

func (f *MYSQLFunctions) GetAsset(assetType string, assetID *uuid.UUID) (*models.Asset, error)

func (*MYSQLFunctions) GetAssets

func (*MYSQLFunctions) GetAssets(assetType string, IDs []uuid.UUID, tx *sql.Tx) ([]models.Asset, error)

func (*MYSQLFunctions) GetPrivilege

func (f *MYSQLFunctions) GetPrivilege(name string) (*models.Privilege, error)

func (*MYSQLFunctions) GetPrivileges

func (f *MYSQLFunctions) GetPrivileges() (models.Privileges, error)

func (*MYSQLFunctions) GetProductByID

func (*MYSQLFunctions) GetProductByID(ID *uuid.UUID, tx *sql.Tx) (*models.Product, error)

func (*MYSQLFunctions) GetProductByName

func (*MYSQLFunctions) GetProductByName(name string, tx *sql.Tx) (*models.Product, error)

func (*MYSQLFunctions) GetProductProjects

func (*MYSQLFunctions) GetProductProjects(productID *uuid.UUID, tx *sql.Tx) ([]models.Project, error)

func (MYSQLFunctions) GetProductUserIDs

func (MYSQLFunctions) GetProductUserIDs(productID *uuid.UUID, tx *sql.Tx) (*models.ProductUserIDs, error)

func (*MYSQLFunctions) GetProductsByIDs

func (*MYSQLFunctions) GetProductsByIDs(IDs []uuid.UUID, tx *sql.Tx) ([]models.Product, error)

func (*MYSQLFunctions) GetProjectByID

func (*MYSQLFunctions) GetProjectByID(ID *uuid.UUID, tx *sql.Tx) (*models.Project, error)

func (*MYSQLFunctions) GetProjectViewersByUserID

func (*MYSQLFunctions) GetProjectViewersByUserID(userID *uuid.UUID, tx *sql.Tx) ([]models.ProjectViewer, error)

func (*MYSQLFunctions) GetProjectViewersByViewerID

func (*MYSQLFunctions) GetProjectViewersByViewerID(viewerID *uuid.UUID, tx *sql.Tx) ([]models.ProjectViewer, error)

func (*MYSQLFunctions) GetProjectsByIDs

func (*MYSQLFunctions) GetProjectsByIDs(IDs []uuid.UUID, tx *sql.Tx) ([]models.Project, error)

func (*MYSQLFunctions) GetUser

func (*MYSQLFunctions) GetUser(queryType int, keyValue interface{}, tx *sql.Tx) (*models.User, error)

GetUser returns the user defined by the key name and key value. Key name can be either id or email.

func (*MYSQLFunctions) GetUserIDsByViewerID

func (f *MYSQLFunctions) GetUserIDsByViewerID(viewerID *uuid.UUID) (*models.ViewUsers, error)

func (*MYSQLFunctions) GetUserProductIDs

func (*MYSQLFunctions) GetUserProductIDs(userID *uuid.UUID, tx *sql.Tx) (*models.UserProductIDs, error)

func (*MYSQLFunctions) GetUserProjectIDs

func (*MYSQLFunctions) GetUserProjectIDs(userID *uuid.UUID, tx *sql.Tx) (*models.UserProjectIDs, error)

func (MYSQLFunctions) GetUsersByIDs

func (MYSQLFunctions) GetUsersByIDs(IDs []uuid.UUID, tx *sql.Tx) ([]models.User, error)

func (*MYSQLFunctions) GetViewerIDsByUserID

func (f *MYSQLFunctions) GetViewerIDsByUserID(userID *uuid.UUID) (models.ViewersList, error)

func (*MYSQLFunctions) UpdateAsset

func (f *MYSQLFunctions) UpdateAsset(assetType string, asset *models.Asset) error

func (*MYSQLFunctions) UpdateUsersProducts

func (*MYSQLFunctions) UpdateUsersProducts(userID *uuid.UUID, productID *uuid.UUID, privilege int, tx *sql.Tx) error

func (*MYSQLFunctions) UpdateUsersProjects

func (*MYSQLFunctions) UpdateUsersProjects(userID *uuid.UUID, projectID *uuid.UUID, privilege int, tx *sql.Tx) error

func (*MYSQLFunctions) UserExists

func (f *MYSQLFunctions) UserExists(username string) (bool, error)