jdb

package

v0.0.146 Latest Latest Go to latest Published: Apr 17, 2024 License: MIT Imports: 17 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/cgalvisleon/elvis

Links

Open Source Insights

Documentation ¶

Index ¶

Constants
func ChangePassword(db int, name, password string) (bool, error)
func Close() error
func Connected(driver, host string, port int, dbname, user, password string) (int, error)
func CreateColumn(db int, schema, table, name, kind, defaultValue string) (bool, error)
func CreateDatabase(db int, name string) (bool, error)
func CreateIndex(db int, schema, table, field string) (bool, error)
func CreateSchema(db int, name string) (bool, error)
func CreateSerie(db int, schema, tag string) (bool, error)
func CreateTrigger(db int, schema, table, name, when, event, function string) (bool, error)
func CreateUser(db int, name, password string) (bool, error)
func DBClose(idx int) error
func DBQDDL(db int, sql string, args ...any) (et.Items, error)
func DBQuery(db int, sql string, args ...any) (et.Items, error)
func DBQueryAtrib(db int, sql, atrib string, args ...any) (et.Items, error)
func DBQueryAtribOne(db int, sql, atrib string, args ...any) (et.Item, error)
func DBQueryCount(db int, sql string, args ...any) int
func DBQueryData(db int, sql string, args ...any) (et.Items, error)
func DBQueryDataOne(db int, sql string, args ...any) (et.Item, error)
func DBQueryOne(db int, sql string, args ...any) (et.Item, error)
func DropColumn(db int, schema, table, name string) error
func DropDatabase(db int, name string) error
func DropIndex(db int, schema, table, field string) error
func DropSchema(db int, name string) error
func DropSerie(db int, schema, name string) error
func DropTable(db int, schema, name string) error
func DropTrigger(db int, schema, table, name string) error
func DropUser(db int, name string) error
func ExistColum(db int, schema, table, name string) (bool, error)
func ExistDatabase(db int, name string) (bool, error)
func ExistIndex(db int, schema, table, field string) (bool, error)
func ExistSchema(db int, name string) (bool, error)
func ExistSerie(db int, schema, name string) (bool, error)
func ExistTable(db int, schema, name string) (bool, error)
func ExistTrigger(db int, schema, table, name string) (bool, error)
func ExistUser(db int, name string) (bool, error)
func HttpQuery(sql string, args []any) (et.Items, error)
func Listen(url, channel, tag string, listen func(res et.Json))
func ListenClose(listen *pq.Listener) error
func QDDL(sql string, args ...any) (et.Items, error)
func Query(sql string, args ...any) (et.Items, error)
func QueryAtrib(sql, atrib string, args ...any) (et.Items, error)
func QueryAtribOne(sql, atrib string, args ...any) (et.Item, error)
func QueryCount(sql string, args ...any) int
func QueryData(sql string, args ...any) (et.Items, error)
func QueryDataOne(sql string, args ...any) (et.Item, error)
func QueryOne(sql string, args ...any) (et.Item, error)
func SQLDDL(sql string, args ...any) string
func SQLParse(sql string, args ...any) string
func SQLQuote(sql string) string
func UpdateParamdb(path, atrib, value string) (et.Item, error)
type Conn
- func Load() (*Conn, error)
type Db
- func DB(idx int) *Db
- func (c *Db) Close() error
- func (c *Db) Describe() et.Json

Constants ¶

View Source

const Firebird = "firebird"

View Source

const Mysql = "mysql"

View Source

const Postgres = "postgres"

View Source

const Sqlserver = "sqlserver"

Variables ¶

This section is empty.

Functions ¶

func ChangePassword ¶ added in v0.0.85

func ChangePassword(db int, name, password string) (bool, error)

func Close ¶

func Close() error

func Connected ¶

func Connected(driver, host string, port int, dbname, user, password string) (int, error)

func CreateColumn ¶ added in v0.0.85

func CreateColumn(db int, schema, table, name, kind, defaultValue string) (bool, error)

func CreateDatabase ¶ added in v0.0.85

func CreateDatabase(db int, name string) (bool, error)

* * *

func CreateIndex ¶ added in v0.0.85

func CreateIndex(db int, schema, table, field string) (bool, error)

func CreateSchema ¶ added in v0.0.85

func CreateSchema(db int, name string) (bool, error)

func CreateSerie ¶ added in v0.0.85

func CreateSerie(db int, schema, tag string) (bool, error)

func CreateTrigger ¶ added in v0.0.108

func CreateTrigger(db int, schema, table, name, when, event, function string) (bool, error)

func CreateUser ¶ added in v0.0.85

func CreateUser(db int, name, password string) (bool, error)

func DBClose ¶

func DBClose(idx int) error

func DBQDDL ¶

func DBQDDL(db int, sql string, args ...any) (et.Items, error)

* * DBQDDL *

func DBQuery ¶

func DBQuery(db int, sql string, args ...any) (et.Items, error)

func DBQueryAtrib ¶

func DBQueryAtrib(db int, sql, atrib string, args ...any) (et.Items, error)

* * *

func DBQueryAtribOne ¶

func DBQueryAtribOne(db int, sql, atrib string, args ...any) (et.Item, error)

func DBQueryCount ¶

func DBQueryCount(db int, sql string, args ...any) int

func DBQueryData ¶

func DBQueryData(db int, sql string, args ...any) (et.Items, error)

func DBQueryDataOne ¶

func DBQueryDataOne(db int, sql string, args ...any) (et.Item, error)

func DBQueryOne ¶

func DBQueryOne(db int, sql string, args ...any) (et.Item, error)

func DropColumn ¶ added in v0.0.107

func DropColumn(db int, schema, table, name string) error

func DropDatabase ¶ added in v0.0.107

func DropDatabase(db int, name string) error

* * *

func DropIndex ¶ added in v0.0.107

func DropIndex(db int, schema, table, field string) error

func DropSchema ¶ added in v0.0.107

func DropSchema(db int, name string) error

func DropSerie ¶ added in v0.0.108

func DropSerie(db int, schema, name string) error

func DropTable ¶ added in v0.0.107

func DropTable(db int, schema, name string) error

func DropTrigger ¶ added in v0.0.108

func DropTrigger(db int, schema, table, name string) error

func DropUser ¶ added in v0.0.107

func DropUser(db int, name string) error

func ExistColum ¶ added in v0.0.85

func ExistColum(db int, schema, table, name string) (bool, error)

func ExistDatabase ¶ added in v0.0.85

func ExistDatabase(db int, name string) (bool, error)

* *

func ExistIndex ¶ added in v0.0.85

func ExistIndex(db int, schema, table, field string) (bool, error)

func ExistSchema ¶ added in v0.0.85

func ExistSchema(db int, name string) (bool, error)

func ExistSerie ¶ added in v0.0.85

func ExistSerie(db int, schema, name string) (bool, error)

func ExistTable ¶ added in v0.0.85

func ExistTable(db int, schema, name string) (bool, error)

func ExistTrigger ¶ added in v0.0.108

func ExistTrigger(db int, schema, table, name string) (bool, error)

func ExistUser ¶ added in v0.0.85

func ExistUser(db int, name string) (bool, error)

func HttpQuery ¶ added in v0.0.34

func HttpQuery(sql string, args []any) (et.Items, error)

* * *

func Listen ¶

func Listen(url, channel, tag string, listen func(res et.Json))

func ListenClose ¶

func ListenClose(listen *pq.Listener) error

func QDDL ¶

func QDDL(sql string, args ...any) (et.Items, error)

* * Query *

func Query ¶

func Query(sql string, args ...any) (et.Items, error)

func QueryAtrib ¶

func QueryAtrib(sql, atrib string, args ...any) (et.Items, error)

func QueryAtribOne ¶

func QueryAtribOne(sql, atrib string, args ...any) (et.Item, error)

func QueryCount ¶

func QueryCount(sql string, args ...any) int

func QueryData ¶

func QueryData(sql string, args ...any) (et.Items, error)

func QueryDataOne ¶

func QueryDataOne(sql string, args ...any) (et.Item, error)

func QueryOne ¶

func QueryOne(sql string, args ...any) (et.Item, error)

func SQLDDL ¶

func SQLDDL(sql string, args ...any) string

func SQLParse ¶

func SQLParse(sql string, args ...any) string

func SQLQuote ¶

func SQLQuote(sql string) string

* * Data Definition Language *

func UpdateParamdb ¶ added in v0.0.107

func UpdateParamdb(path, atrib, value string) (et.Item, error)

Types ¶

type Conn ¶

type Conn struct {
	Db []*Db
}

func Load ¶

func Load() (*Conn, error)

type Db ¶

type Db struct {
	Index       int
	Description string
	Driver      string
	Host        string
	Port        int
	Dbname      string
	User        string
	ConnStr     string
	Db          *sql.DB
}

func DB ¶

func DB(idx int) *Db

func (*Db) Close ¶

func (c *Db) Close() error

func (*Db) Describe ¶

func (c *Db) Describe() et.Json

Source Files ¶

View all Source files

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