Documentation ¶
Overview ¶
REQUIRE: go 1.19 or later
REQUIRE: go 1.19 or later
Index ¶
- Constants
- func GetArrFromSQLRows(rows *sql.Rows) (arr []map[string]string, err error)
- type DbSqlConnector
- func (conn *DbSqlConnector) CheckConnection() bool
- func (conn *DbSqlConnector) CloseConnection() error
- func (conn *DbSqlConnector) CountData(query string, params ...any) (int64, error)
- func (conn *DbSqlConnector) CountTxData(tx *sql.Tx, query string, params ...any) (int64, error)
- func (conn *DbSqlConnector) GetConnectionInfo() string
- func (conn *DbSqlConnector) OpenConnection() (*sql.DB, error)
- func (conn *DbSqlConnector) ReadData(query string, params ...any) ([]map[string]string, error)
- func (conn *DbSqlConnector) ReadOneData(query string, params ...any) (map[string]string, error)
- func (conn *DbSqlConnector) ReadTxData(tx *sql.Tx, query string, params ...any) ([]map[string]string, error)
- func (conn *DbSqlConnector) ReadTxOneData(tx *sql.Tx, query string, params ...any) (map[string]string, error)
- func (conn *DbSqlConnector) TransactionCommit(tx *sql.Tx) error
- func (conn *DbSqlConnector) TransactionRollback(tx *sql.Tx) error
- func (conn *DbSqlConnector) TransactionStart() (*sql.Tx, error)
- func (conn *DbSqlConnector) WriteData(query string, params ...any) (int64, error)
- func (conn *DbSqlConnector) WriteTxData(tx *sql.Tx, query string, params ...any) (int64, error)
Constants ¶
View Source
const ( DB_SQL_TYPE_SQLITE string = "sqlite3" DB_SQL_TYPE_PGSQL string = "postgres" DB_SQL_TYPE_MYSQL string = "mysql" HARD_LIMIT_ROWS uint64 = 1000000 // get max 1 million rows )
View Source
const ( VERSION string = "v.20240117.2121" NAME string = "SmartGo.DB" ENCODING string = "UTF8" )
View Source
const MYSQL_INIT_META_TABLE string = `` /* 551-byte string literal not displayed */
View Source
const PGSQL_INIT_META_TABLE string = `` /* 806-byte string literal not displayed */
View Source
const SQLITE_INIT_META_TABLE string = `` /* 524-byte string literal not displayed */
Variables ¶
This section is empty.
Functions ¶
Types ¶
type DbSqlConnector ¶
type DbSqlConnector struct {
// contains filtered or unexported fields
}
func (*DbSqlConnector) CheckConnection ¶
func (conn *DbSqlConnector) CheckConnection() bool
func (*DbSqlConnector) CloseConnection ¶
func (conn *DbSqlConnector) CloseConnection() error
func (*DbSqlConnector) CountData ¶
func (conn *DbSqlConnector) CountData(query string, params ...any) (int64, error)
func (*DbSqlConnector) CountTxData ¶
func (*DbSqlConnector) GetConnectionInfo ¶
func (conn *DbSqlConnector) GetConnectionInfo() string
func (*DbSqlConnector) OpenConnection ¶
func (conn *DbSqlConnector) OpenConnection() (*sql.DB, error)
func (*DbSqlConnector) ReadOneData ¶
func (*DbSqlConnector) ReadTxData ¶
func (*DbSqlConnector) ReadTxOneData ¶
func (*DbSqlConnector) TransactionCommit ¶
func (conn *DbSqlConnector) TransactionCommit(tx *sql.Tx) error
func (*DbSqlConnector) TransactionRollback ¶
func (conn *DbSqlConnector) TransactionRollback(tx *sql.Tx) error
func (*DbSqlConnector) TransactionStart ¶
func (conn *DbSqlConnector) TransactionStart() (*sql.Tx, error)
In GoLang opposite to PHP, there is only one connection with possible asynchronous writes. Because of this, should NEVER use direct SQL: BEGIN / TOLLBACK / COMMIT on the connection, they should always be isolated insite a TX transaction !
func (*DbSqlConnector) WriteData ¶
func (conn *DbSqlConnector) WriteData(query string, params ...any) (int64, error)
func (*DbSqlConnector) WriteTxData ¶
Directories ¶
Path | Synopsis |
---|---|
Package pq is a pure Go Postgres driver for the database/sql package.
|
Package pq is a pure Go Postgres driver for the database/sql package. |
oid
Package oid contains OID constants as defined by the Postgres server.
|
Package oid contains OID constants as defined by the Postgres server. |
scram
Package scram implements a SCRAM-{SHA-1,etc} client per RFC5802.
|
Package scram implements a SCRAM-{SHA-1,etc} client per RFC5802. |
Package mysql provides a MySQL driver for Go's database/sql package.
|
Package mysql provides a MySQL driver for Go's database/sql package. |
Package redcon implements a Redis compatible server framework
|
Package redcon implements a Redis compatible server framework |
redigo
|
|
redis
Package redis is a client for the Redis database.
|
Package redis is a client for the Redis database. |
redisx
Package redisx contains experimental features for Redigo.
|
Package redisx contains experimental features for Redigo. |
Click to show internal directories.
Click to hide internal directories.