mysql

package

v0.0.0-...-4b4c4d1 Latest Latest Go to latest Published: Feb 21, 2021 License: MIT Imports: 5 Imported by: 1

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

Repository

github.com/arthasyou/db-go

Links

Open Source Insights

Documentation ¶

Index ¶

func Close()
func Connect(addr string, port uint16, user string, password string, dbname string)
func Deltet(table string) string
func Insert(table string, kvs []*KeyVal) string
func Limit(page uint, column uint) string
func Order(key string) string
func OrderDesc(key string) string
func Prepare(query string) (*sql.Stmt, error)
func Query(query string, args ...interface{}) (*sql.Rows, error)
func Replace(table string, kvs []*KeyVal) string
func Select(table string, args ...[]string) string
func SubAnd(kovs []*KeyOpVal) string
func SubOr(kovs []*KeyOpVal) string
func Update(table string, kvs []*KeyVal) string
func Where(kovs []*KeyOpVal) string
func WhereOr(kovs []*KeyOpVal) string
type KeyOpVal
type KeyVal

Constants ¶

This section is empty.

Variables ¶

This section is empty.

Functions ¶

func Close ¶

func Close()

Close mysql connection

func Connect ¶

func Connect(addr string, port uint16, user string, password string, dbname string)

Connect to mysql

func Deltet ¶

func Deltet(table string) string

Deltet from database

func Insert ¶

func Insert(table string, kvs []*KeyVal) string

Insert into database

func Limit ¶

func Limit(page uint, column uint) string

Limit statement

func Order ¶

func Order(key string) string

Order statement

func OrderDesc ¶

func OrderDesc(key string) string

OrderDesc statement

func Prepare ¶

func Prepare(query string) (*sql.Stmt, error)

Prepare database

func Query ¶

func Query(query string, args ...interface{}) (*sql.Rows, error)

Query database

func Replace ¶

func Replace(table string, kvs []*KeyVal) string

Replace into database

func Select ¶

func Select(table string, args ...[]string) string

Select query

func SubAnd ¶

func SubAnd(kovs []*KeyOpVal) string

SubAnd join to where statement

func SubOr ¶

func SubOr(kovs []*KeyOpVal) string

SubOr join to where statement

func Update ¶

func Update(table string, kvs []*KeyVal) string

Update into database

func Where ¶

func Where(kovs []*KeyOpVal) string

Where statement

func WhereOr ¶

func WhereOr(kovs []*KeyOpVal) string

WhereOr statement

Types ¶

type KeyOpVal ¶

type KeyOpVal struct {
	Key   string
	Op    string
	Value string
}

KeyOpVal for where statement used

type KeyVal ¶

type KeyVal struct {
	Key   string
	Value string
}

KeyVal for insert replace statement used

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL