goalMySql

README

goalMySql

Go MySql library.

Documentation

Index

• func Initialize(allowNativePassword bool) (*sql.DB, error)
• func Insert(databaseHandler *sql.DB, table string, columns []string, ...) (int, error)
• func PingDatabase(databaseHandler *sql.DB) (bool, error)
• func Replace(databaseHandler *sql.DB, table string, columns []string, ...) (int, error)
• func Select(databaseHandler *sql.DB, columns []string, table string, condition string, ...) ([]map[string]interface{}, error)
• func Update(databaseHandler *sql.DB, table string, columns []string, condition string, ...) (int, error)

Functions

func Initialize

func Initialize(allowNativePassword bool) (*sql.DB, error)

MySql database connection initializer

func Insert

func Insert(databaseHandler *sql.DB, table string, columns []string, inputParameters ...any) (int, error)

Insert into MySql table. On success update this method will return how many rows affected. Please put your parameter placeholders values in inputParameters to prevent SQL Injection.

func PingDatabase

func PingDatabase(databaseHandler *sql.DB) (bool, error)

Ping to mysql database

func Replace

func Replace(databaseHandler *sql.DB, table string, columns []string, inputParameters ...any) (int, error)

Replace into MySql table. On success update this method will return how many rows affected. Please put your parameter placeholders values in inputParameters to prevent SQL Injection.

func Select

func Select(databaseHandler *sql.DB, columns []string, table string,
	condition string, inputParameters ...any) ([]map[string]interface{}, error)

MySql select query for multiple rows of data. Please put your parameter placeholders in inputParameters to prevent SQL Injection.

func Update

func Update(databaseHandler *sql.DB, table string, columns []string,
	condition string, inputParameters ...any) (int, error)

Update MySql table. On success update this method will return how many rows updated. Please put your parameter placeholders values in inputParameters to prevent SQL Injection.