sqlutil

Documentation

Index

• func ExecQueryMany(ctx context.Context, exec mysql.Exec, sql string, args []interface{}, ...) error
• func ExecQueryOne(ctx context.Context, exec mysql.Exec, sql string, args []interface{}, ...) error
• func TableWithCount(ctx context.Context, exec mysql.Exec, table string, ...) (int64, error)
• func TableWithDelete(ctx context.Context, exec mysql.Exec, table string, ...) (int64, error)
• func TableWithInsertMany(ctx context.Context, exec mysql.Exec, table string, columns []string, ...) (int64, error)
• func TableWithInsertOne(ctx context.Context, exec mysql.Exec, table string, ...) (int64, error)
• func TableWithSelectMany(ctx context.Context, exec mysql.Exec, table string, column []string, ...) error
• func TableWithSelectOne(ctx context.Context, exec mysql.Exec, table string, column []string, ...) error
• func TableWithSelectRange(ctx context.Context, exec mysql.Exec, table string, column []string, ...) error
• func TableWithUpdate(ctx context.Context, exec mysql.Exec, table string, ...) (int64, error)

Functions

func ExecQueryMany

func ExecQueryMany(ctx context.Context, exec mysql.Exec, sql string, args []interface{}, f func(row *sql.Rows) error) error

func ExecQueryOne

func ExecQueryOne(ctx context.Context, exec mysql.Exec, sql string, args []interface{}, f func(row *sql.Row) error) error

func TableWithCount

func TableWithCount(ctx context.Context, exec mysql.Exec, table string, where map[string]interface{}) (int64, error)

func TableWithDelete

func TableWithDelete(ctx context.Context, exec mysql.Exec, table string, where map[string]interface{}) (int64, error)

func TableWithInsertMany

func TableWithInsertMany(ctx context.Context, exec mysql.Exec, table string, columns []string, values []map[string]interface{}) (int64, error)

func TableWithInsertOne

func TableWithInsertOne(ctx context.Context, exec mysql.Exec, table string, value map[string]interface{}) (int64, error)

func TableWithSelectMany

func TableWithSelectMany(ctx context.Context, exec mysql.Exec, table string, column []string, where map[string]interface{}, order map[string]string, f func(row *sql.Rows) error) error

func TableWithSelectOne

func TableWithSelectOne(ctx context.Context, exec mysql.Exec, table string, column []string, where map[string]interface{}, f func(row *sql.Row) error) error

func TableWithSelectRange

func TableWithSelectRange(ctx context.Context, exec mysql.Exec, table string, column []string, where map[string]interface{}, order map[string]string, offset, limit int64, f func(row *sql.Rows) error) error

func TableWithUpdate

func TableWithUpdate(ctx context.Context, exec mysql.Exec, table string, value, where map[string]interface{}) (int64, error)