jdb

package

v0.0.97 Latest Latest Go to latest Published: Jan 24, 2024 License: MIT Imports: 13 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/cgalvisleon/elvis

Documentation ¶

Index ¶

Constants
func ChangePassword(db int, name, password string) (bool, error)
func Close() error
func CloseListen(host, channel string)
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 CreateUser(db int, name, password string) (bool, error)
func DBClose(idx int) error
func DBQDDL(db int, sql string, args ...any) (e.Items, error)
func DBQuery(db int, sql string, args ...any) (e.Items, error)
func DBQueryAtrib(db int, sql, atrib string, args ...any) (e.Items, error)
func DBQueryAtribOne(db int, sql, atrib string, args ...any) (e.Item, error)
func DBQueryCount(db int, sql string, args ...any) int
func DBQueryData(db int, sql string, args ...any) (e.Items, error)
func DBQueryDataOne(db int, sql string, args ...any) (e.Item, error)
func DBQueryOne(db int, sql string, args ...any) (e.Item, 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 ExistUser(db int, name string) (bool, error)
func HttpQuery(sql string, args []any) (e.Items, error)
func IsCloseListen(host, channel string) bool
func Listen(nodo, url, channel string, listen func(res e.Json))
func ListenClose(listen *pq.Listener) error
func ListenEvent(nodo, url, channel string, listener *pq.Listener, listen func(res e.Json))
func QDDL(sql string, args ...any) (e.Items, error)
func Query(sql string, args ...any) (e.Items, error)
func QueryAtrib(sql, atrib string, args ...any) (e.Items, error)
func QueryAtribOne(sql, atrib string, args ...any) (e.Item, error)
func QueryCount(sql string, args ...any) int
func QueryData(sql string, args ...any) (e.Items, error)
func QueryDataOne(sql string, args ...any) (e.Item, error)
func QueryOne(sql string, args ...any) (e.Item, error)
func SQLDDL(sql string, args ...any) string
func SQLParse(sql string, args ...any) string
func SQLQuote(sql string) string
type Conn
- func Load() (*Conn, error)
type Db
- func DB(idx int) *Db
- func (c *Db) Close() error
- func (c *Db) Describe() e.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 CloseListen ¶ added in v0.0.34

func CloseListen(host, channel string)

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 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) (e.Items, error)

* * DBQDDL *

func DBQuery ¶

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

func DBQueryAtrib ¶

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

* * *

func DBQueryAtribOne ¶

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

func DBQueryCount ¶

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

func DBQueryData ¶

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

func DBQueryDataOne ¶

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

func DBQueryOne ¶

func DBQueryOne(db int, sql string, args ...any) (e.Item, 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 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) (e.Items, error)

* * *

func IsCloseListen ¶ added in v0.0.34

func IsCloseListen(host, channel string) bool

func Listen ¶

func Listen(nodo, url, channel string, listen func(res e.Json))

func ListenClose ¶

func ListenClose(listen *pq.Listener) error

func ListenEvent ¶

func ListenEvent(nodo, url, channel string, listener *pq.Listener, listen func(res e.Json))

func QDDL ¶

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

* * Query *

func Query ¶

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

func QueryAtrib ¶

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

func QueryAtribOne ¶

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

func QueryCount ¶

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

func QueryData ¶

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

func QueryDataOne ¶

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

func QueryOne ¶

func QueryOne(sql string, args ...any) (e.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 *

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
	URL         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() e.Json

Source Files ¶

View all Source files

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