sqlplus

package module

v0.0.0-...-ef2e3ff Latest Latest Go to latest Published: Jan 17, 2024 License: MIT Imports: 10 Imported by: 0

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/blusewang/sqlplus

Links

Open Source Insights

README ¶

sqlplus

安装

go get github.com/blusewang/sqlplus

文档

详细文档，请前往 https://godoc.org/github.com/blusewang/sqlplus.

使用

type TestObj struct {
	Id       string `json:"id"`
	UserName string `json:"user_name"`
}

db,err := sqlplus.Open("postgres","dsn...")
if err != nil {
	log.Fatal(err)
}

// 查列表
var list []TestObj
err = db.QuerySlice(&list,"select * from test_table where id < $1",100)
if err != nil {
	log.Fatal(err)
}
log.Pringln(list)
// [{3,""},{4,""}]

// 查单行
var obj TestObj
err = db.QueryStruct(&obj,"select * from test_table where id=$1",3)
if err != nil {
	log.Fatal(err)
}
log.Pringln(obj)
// {3,""}


// 事务
tx,err := db.Begin()
err = tx.QueryStruct(&obj,"select * from test_table where id=$1",3)
if err != nil {
	_ = tx.Rollback()
	log.Fatal(err)
}else{
	_ = tx.Commit()
}
log.Pringln(obj)
// {3,""}

License

Documentation ¶

Index ¶

type DbPlus
- func Open(driverName string, dsns ...string) (dp *DbPlus, err error)
type TxPlus

Constants ¶

This section is empty.

Variables ¶

This section is empty.

Functions ¶

This section is empty.

Types ¶

type DbPlus ¶

type DbPlus struct {
	// contains filtered or unexported fields
}

func Open ¶

func Open(driverName string, dsns ...string) (dp *DbPlus, err error)

func (*DbPlus) Begin ¶

func (db *DbPlus) Begin() (*TxPlus, error)

func (*DbPlus) BeginTx ¶

func (db *DbPlus) BeginTx(ctx context.Context, opts *sql.TxOptions) (*TxPlus, error)

func (*DbPlus) Close ¶

func (db *DbPlus) Close() (err error)

func (*DbPlus) Exec ¶

func (db *DbPlus) Exec(query string, args ...interface{}) (sql.Result, error)

func (*DbPlus) ExecContext ¶

func (db *DbPlus) ExecContext(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

func (*DbPlus) Exists ¶

func (db *DbPlus) Exists(query string, args ...interface{}) (exists bool, err error)

Exists 判断记录是否存在

func (*DbPlus) ExistsContext ¶

func (db *DbPlus) ExistsContext(c context.Context, query string, args ...interface{}) (exists bool, err error)

ExistsContext 判断记录是否存在

func (*DbPlus) Prepare ¶

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

func (*DbPlus) PrepareContext ¶

func (db *DbPlus) PrepareContext(ctx context.Context, query string) (*sql.Stmt, error)

func (*DbPlus) Query ¶

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

func (*DbPlus) QueryContext ¶

func (db *DbPlus) QueryContext(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

func (*DbPlus) QueryRow ¶

func (db *DbPlus) QueryRow(query string, args ...interface{}) *sql.Row

func (*DbPlus) QueryRowContext ¶

func (db *DbPlus) QueryRowContext(ctx context.Context, query string, args ...interface{}) *sql.Row

func (*DbPlus) QuerySlice ¶

func (db *DbPlus) QuerySlice(list interface{}, query string, args ...interface{}) (err error)

func (*DbPlus) QuerySliceContext ¶

func (db *DbPlus) QuerySliceContext(ctx context.Context, list interface{}, query string, args ...interface{}) (err error)

func (*DbPlus) QueryStruct ¶

func (db *DbPlus) QueryStruct(obj interface{}, query string, args ...interface{}) (err error)

func (*DbPlus) QueryStructContext ¶

func (db *DbPlus) QueryStructContext(ctx context.Context, obj interface{}, query string, args ...interface{}) (err error)

func (*DbPlus) SetConnMaxLifetime ¶

func (db *DbPlus) SetConnMaxLifetime(ds ...time.Duration)

func (*DbPlus) SetMaxIdleConns ¶

func (db *DbPlus) SetMaxIdleConns(ns ...int)

func (*DbPlus) SetMaxOpenConns ¶

func (db *DbPlus) SetMaxOpenConns(ns ...int)

func (*DbPlus) Writer ¶

func (db *DbPlus) Writer() *sql.DB

type TxPlus ¶

type TxPlus struct {
	*sql.Tx
}

func (TxPlus) QuerySlice ¶

func (tx TxPlus) QuerySlice(list interface{}, query string, args ...interface{}) (err error)

func (TxPlus) QuerySliceContext ¶

func (tx TxPlus) QuerySliceContext(ctx context.Context, list interface{}, query string, args ...interface{}) (err error)

func (TxPlus) QueryStruct ¶

func (tx TxPlus) QueryStruct(obj interface{}, query string, args ...interface{}) (err error)

func (TxPlus) QueryStructContext ¶

func (tx TxPlus) QueryStructContext(ctx context.Context, obj interface{}, query string, args ...interface{}) (err error)

Source Files ¶

View all Source files

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