mysql

package

v0.9.0 Latest Latest Go to latest Published: May 8, 2022 License: GPL-3.0 Imports: 11 Imported by: 0

Details

Package mysql holds MySQL database and repository methods.

This section is empty.

This section is empty.

This section is empty.

type Database struct {
	// contains filtered or unexported fields
}

Database - MySQL database struct

func New(address string) (*Database, error)

New creates a new MySQL database struct

func (db *Database) CreateUser(ctx context.Context, user model.User) (string, error)

CreateUser - Creates a user and returns its ID or an error, if anything fails

func (db *Database) DeleteUser(ctx context.Context, id string) error

DeleteUser - Deletes a User for a given ID and could return an error if anything fails

func (db *Database) FindAllUsers(ctx context.Context, offset int64, limit int64) ([]model.User, error)

FindAllUsers - Returns all users for a given limit and offset

func (db *Database) FindUser(ctx context.Context, id string) (model.User, error)

FindUser - Returns a user for a given ID or an error if anything fails

func (db *Database) Migrate(databaseName string, migrationsPath string) error

Migrate - Runs a database migration for a given database and migrations path with the SQL files It returns an error in case of failure

func (db *Database) UpdateUser(ctx context.Context, user model.User) error

UpdateUser - Updates a user and returns an error if anything fails