mrwrapper

README

mrwrapper

MariaDB wrapper for Golang.

Install

go get 

How to use

• arguments

args := []any{ "name": "x" }

• Count

count := mrwraper.Count(conn, "SELECT COUNT(id) FROM X", args...)

• Select One

data := mrwraper.SelectOne[Struct](conn, "SELECT * FROM X WHERE id = 1", args...)

• Select List

data := mrwraper.SelectList[Struct](conn, "SELECT * FROM X", args...)

• Create

id := 0
args := []any{
	"x",
}
tx, err := mrwrapper.Create(conn, "INSERT INTO X (name) VALUES (?)", []any{&id}, args...)
_ = tx.Commit()

• Update

set := "name=:name"
params := map[string]interface{}{
	"id": 1, 
	"name": "x",
}
tx, err := mrwrapper.Update(conn, "UPDATE X SET %s WHERE id=:id", set, params)
_ = tx.Commit()

• Delete

id := 1
tx, err := mrwrapper.Delete(conn, "DELETE FROM X WHERE id = ?", id)
_ = tx.Commit()

Documentation

Index

• func Count(conn *sqlx.DB, query string, args ...any) int64
• func Create(conn *sqlx.DB, query string, dest []any, args ...any) (*sql.Tx, error)
• func Delete(conn *sqlx.DB, query string, args ...any) (*sql.Tx, error)
• func SelectList[R any](conn *sqlx.DB, query string, args ...any) []R
• func SelectOne[R any](conn *sqlx.DB, query string, args ...any) R
• func Update(conn *sqlx.DB, query string, set string, params map[string]any) (*sql.Tx, error)

Functions

func Count

func Count(conn *sqlx.DB, query string, args ...any) int64

func Create

func Create(conn *sqlx.DB, query string, dest []any, args ...any) (*sql.Tx, error)

func Delete

func Delete(conn *sqlx.DB, query string, args ...any) (*sql.Tx, error)

func SelectList

func SelectList[R any](conn *sqlx.DB, query string, args ...any) []R

func SelectOne

func SelectOne[R any](conn *sqlx.DB, query string, args ...any) R

func Update

func Update(conn *sqlx.DB, query string, set string, params map[string]any) (*sql.Tx, error)