mysqldb

package

v0.0.0 Latest Latest Go to latest Published: Mar 29, 2021 License: MIT Imports: 11 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 AddResourceQuery = "INSERT INTO resources (id, category, content) VALUES (UUID_TO_BIN(?), ?, ?)"

View Source

var DeleteResourceQuery = "DELETE FROM resources WHERE id=UUID_TO_BIN(?)"

View Source

var ErrResourcesMissing = errors.New("This resources is missing or old value is the same as new")

View Source

var GetCategorsQuery = "SELECT id, name, description FROM categories"

View Source

var GetCategoryByIDQuery = "SELECT id, name, description FROM categories WHERE id = ?"

View Source

var GetCategoryByNameQuery = "SELECT id, name, description FROM categories WHERE name = ?"

View Source

var GetResourceByCategoryQuery = "SELECT BIN_TO_UUID(id), category, content FROM resources WHERE category = ? ORDER BY created_at DESC"

View Source

var GetResourceByIDQuery = "SELECT BIN_TO_UUID(id), category, content FROM resources WHERE id = UUID_TO_BIN(?)"

View Source

var GetResourcesByIDsQuery = "SELECT BIN_TO_UUID(id), category, content FROM resources WHERE id IN (UUID_TO_BIN(?)"

View Source

var UpdateResourceQuery = "UPDATE resources set content = ?, category = ? where id = UUID_TO_BIN(?)"

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

type MYSQLConnector struct {
	DBConnection       string
	MigrationDirectory string
}

MYSQL database connector implementation

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 struct {
	DBConnector *MYSQLConnector
}

MYSQLFunctions represents the implementation of MYSQL data manipulation functions.

func (*MYSQLFunctions) AddResource(resource *models.Resource, tx *sql.Tx) error

func (*MYSQLFunctions) DeleteResource(resourceID string, tx *sql.Tx) error

func (f *MYSQLFunctions) GetCategories() ([]models.Category, error)

func (f *MYSQLFunctions) GetCategoryByID(id int) (*models.Category, error)

func (f *MYSQLFunctions) GetCategoryByName(name string) (*models.Category, error)

func (f *MYSQLFunctions) GetResourceByID(resourceID *uuid.UUID) (*models.Resource, error)

func (*MYSQLFunctions) GetResourcesByCategory(category int, tx *sql.Tx) ([]models.Resource, error)

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

func (f *MYSQLFunctions) UpdateResource(resource *models.Resource, tx *sql.Tx) error