jdb

package
v0.0.151 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Jun 12, 2024 License: MIT Imports: 17 Imported by: 0

Documentation

Index

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

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.