jdb

Documentation

Index

• Constants
• func ChangePassword(db *sql.DB, name, password string) error
• func Close() error
• func Connected(driver, host string, port int, dbname, user, password, application_name string) (*sql.DB, string, error)
• func CreateColumn(db *sql.DB, schema, table, name, kind, defaultValue string) error
• func CreateDatabase(db *sql.DB, name string) error
• func CreateIndex(db *sql.DB, schema, table, field string) error
• func CreateSchema(db *sql.DB, name string) error
• func CreateSerie(db *sql.DB, schema, tag string) error
• func CreateTrigger(db *sql.DB, schema, table, name, when, event, function string) error
• func CreateUser(db *sql.DB, name, password string) error
• func DBClose(idx int) error
• func DBQuery(db *sql.DB, sql string, args ...any) (et.Items, error)
• func DBQueryOne(db *sql.DB, sql string, args ...any) (et.Item, error)
• func DropColumn(db *sql.DB, schema, table, name string) error
• func DropDatabase(db *sql.DB, name string) error
• func DropIndex(db *sql.DB, schema, table, field string) error
• func DropSchema(db *sql.DB, name string) error
• func DropSerie(db *sql.DB, schema, name string) error
• func DropTable(db *sql.DB, schema, name string) error
• func DropTrigger(db *sql.DB, schema, table, name string) error
• func DropUser(db *sql.DB, name string) error
• func ExistColum(db *sql.DB, schema, table, name string) (bool, error)
• func ExistDatabase(db *sql.DB, name string) (bool, error)
• func ExistIndex(db *sql.DB, schema, table, field string) (bool, error)
• func ExistSchema(db *sql.DB, name string) (bool, error)
• func ExistSerie(db *sql.DB, schema, name string) (bool, error)
• func ExistTable(db *sql.DB, schema, name string) (bool, error)
• func ExistTrigger(db *sql.DB, schema, table, name string) (bool, error)
• func ExistUser(db *sql.DB, name string) (bool, error)
• func HttpQuery(sql string, args []any) (et.Items, error)
• func IDXQuery(index int, sql string, args ...any) (et.Items, error)
• func IDXQueryAtrib(index int, sql, atrib string, args ...any) (et.Items, error)
• func IDXQueryAtribOne(index int, sql, atrib string, args ...any) (et.Item, error)
• func IDXQueryCount(index int, sql string, args ...any) int
• func IDXQueryData(index int, sql string, args ...any) (et.Items, error)
• func IDXQueryDataOne(index int, sql string, args ...any) (et.Item, error)
• func IDXQueryOne(index int, sql string, args ...any) (et.Item, 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

const Firebird = "firebird"

const Mysql = "mysql"

const Postgres = "postgres"

const Sqlserver = "sqlserver"

Functions

func ChangePassword

func ChangePassword(db *sql.DB, name, password string) error

Changue password

func Close

func Close() error

func Connected

func Connected(driver, host string, port int, dbname, user, password, application_name string) (*sql.DB, string, error)

func CreateColumn

func CreateColumn(db *sql.DB, schema, table, name, kind, defaultValue string) error

Create column

func CreateDatabase

func CreateDatabase(db *sql.DB, name string) error

Crate database

func CreateIndex

func CreateIndex(db *sql.DB, schema, table, field string) error

Create index

func CreateSchema

func CreateSchema(db *sql.DB, name string) error

Create schema

func CreateSerie

func CreateSerie(db *sql.DB, schema, tag string) error

Create serie

func CreateTrigger

func CreateTrigger(db *sql.DB, schema, table, name, when, event, function string) error

Create trigger

func CreateUser

func CreateUser(db *sql.DB, name, password string) error

Create user

func DBClose

func DBClose(idx int) error

func DBQuery

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

DBQUERY database query

func DBQueryOne

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

func DropColumn

func DropColumn(db *sql.DB, schema, table, name string) error

Drop column

func DropDatabase

func DropDatabase(db *sql.DB, name string) error

Drop database

func DropIndex

func DropIndex(db *sql.DB, schema, table, field string) error

Drop index

func DropSchema

func DropSchema(db *sql.DB, name string) error

Drop schema

func DropSerie

func DropSerie(db *sql.DB, schema, name string) error

Drop serie

func DropTable

func DropTable(db *sql.DB, schema, name string) error

Drop table

func DropTrigger

func DropTrigger(db *sql.DB, schema, table, name string) error

Drop trigger

func DropUser

func DropUser(db *sql.DB, name string) error

Drop user

func ExistColum

func ExistColum(db *sql.DB, schema, table, name string) (bool, error)

Exist column

func ExistDatabase

func ExistDatabase(db *sql.DB, name string) (bool, error)

Exist database

func ExistIndex

func ExistIndex(db *sql.DB, schema, table, field string) (bool, error)

Exist index

func ExistSchema

func ExistSchema(db *sql.DB, name string) (bool, error)

Exist schema

func ExistSerie

func ExistSerie(db *sql.DB, schema, name string) (bool, error)

Exist serie

func ExistTable

func ExistTable(db *sql.DB, schema, name string) (bool, error)

Exist table

func ExistTrigger

func ExistTrigger(db *sql.DB, schema, table, name string) (bool, error)

Exist trigger

func ExistUser

func ExistUser(db *sql.DB, name string) (bool, error)

Exist user

func HttpQuery

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

* * *

func IDXQuery

func IDXQuery(index int, sql string, args ...any) (et.Items, error)

func IDXQueryAtrib

func IDXQueryAtrib(index int, sql, atrib string, args ...any) (et.Items, error)

func IDXQueryAtribOne

func IDXQueryAtribOne(index int, sql, atrib string, args ...any) (et.Item, error)

func IDXQueryCount

func IDXQueryCount(index int, sql string, args ...any) int

func IDXQueryData

func IDXQueryData(index int, sql string, args ...any) (et.Items, error)

func IDXQueryDataOne

func IDXQueryDataOne(index int, sql string, args ...any) (et.Item, error)

func IDXQueryOne

func IDXQueryOne(index int, sql string, args ...any) (et.Item, 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

SQLDDL SQL Data Definition Language

func SQLParse

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

SQLParse SQL Parse

func SQLQuote

func SQLQuote(sql string) string

SQLQuote quote SQL

func UpdateParamdb

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
	Connection  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