godbc

type DB interface {
	Begin() (Tx, error)
	Close() error
	Exec(query string, args ...interface{}) (Result, error)
	Ping() error
	Prepare(query string) (Stmt, error)
	Query(query string, args ...interface{}) (Rows, error)
	QueryRow(query string, args ...interface{}) Row
	SetMaxIdleConns(n int)
	SetMaxOpenConns(n int)
	Stats() DBStats
}

type DBStats interface {
	OpenConnections() int
}

type DbSource interface {
	Open(dataSourceName string) (DB, error)
}

type Result interface {
	sql.Result // Inherit

	Rows() Rows // Possibly nil
}

type Row interface {
	Scan(dest ...interface{}) error
}

type Rows interface {
	Close() error
	Columns() ([]string, error)
	Err() error
	Next() bool
	Scan(dest ...interface{}) error
}

type Stmt interface {
	Close() error
	Exec(args ...interface{}) (Result, error)
	Query(args ...interface{}) (Rows, error)
	QueryRow(args ...interface{}) Row
}

type Tx interface {
	Commit() error
	Exec(query string, args ...interface{}) (Result, error)
	Prepare(query string) (Stmt, error)
	Query(query string, args ...interface{}) (Rows, error)
	QueryRow(query string, args ...interface{}) Row
	Rollback() error
	Stmt(stmt Stmt) Stmt
}