mysql

Documentation

Index

• Constants
• func Connect(url string) (*sql.DB, error)
• func NewRepository(db *sql.DB) domain.Repository

Constants

const (
	QUERY_GET_USERS            = "SELECT * FROM auth"
	QUERY_GET_USER             = "SELECT * FROM auth WHERE id = ? "
	QUERY_GET_USER_EMAIL       = "SELECT id,username,email,password,role FROM auth WHERE email  like  ? limit 1 "
	QUERY_CREATE_USER          = "INSERT INTO auth (username, email,password,role, created, modified) VALUES (?, ?, ?, ?,?,?)"
	QUERY_UPDATE_USER          = "UPDATE auth SET username = ?,role = ? , modified = ? WHERE id = ?"
	QUERY_UPDATE_USER_PASSWORD = "UPDATE auth SET password = ? , modified = ? WHERE id = ?"
	QUERY_DELETE_USER          = "DELETE FROM auth WHERE id = ?"
)

Functions

func Connect

func Connect(url string) (*sql.DB, error)

func NewRepository

func NewRepository(db *sql.DB) domain.Repository