jdb

package

v1.1.196 Latest Latest Go to latest Published: Feb 13, 2026 License: MIT Imports: 15 Imported by: 0

Details

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

Repository

github.com/celsiainternet/elvis

Links

Open Source Insights

Documentation ¶

Index ¶

Constants
func ChangePassword(db *DB, name, password string) error
func CreateColumn(db *DB, schema, table, name, kind, defaultValue string) error
func CreateDatabase(db *DB, name string) error
func CreateIndex(db *DB, schema, table, field string) error
func CreateSchema(db *DB, name string) error
func CreateSequence(db *DB, schema, tag string) error
func CreateTrigger(db *DB, schema, table, name, when, event, function string) error
func CreateUser(db *DB, name, password string) error
func DropColumn(db *DB, schema, table, name string) error
func DropDatabase(db *DB, name string) error
func DropIndex(db *DB, schema, table, field string) error
func DropSchema(db *DB, name string) error
func DropSerie(db *DB, schema, name string) error
func DropTable(db *DB, schema, name string) error
func DropTrigger(db *DB, schema, table, name string) error
func DropUser(db *DB, name string) error
func ExistColum(db *DB, schema, table, name string) (bool, error)
func ExistDatabase(db *DB, name string) (bool, error)
func ExistIndex(db *DB, schema, table, field string) (bool, error)
func ExistSchema(db *DB, name string) (bool, error)
func ExistSerie(db *DB, schema, name string) (bool, error)
func ExistTable(db *DB, schema, name string) (bool, error)
func ExistTrigger(db *DB, schema, table, name string) (bool, error)
func ExistUser(db *DB, name string) (bool, error)
func InitCore(db *DB) error
func LastSerie(db *DB, tag string) int
func NextCode(db *DB, tag, prefix string) string
func NextSerie(db *DB, tag string) int64
func SQLDDL(sql string, args ...any) string
func SQLParse(sql string, args ...any) string
func SQLQuote(sql string) string
func SetSerie(db *DB, tag string, val int) (int, error)
func TipoSQL(query string) string
type DB
- func ConnectTo(params et.Json) (*DB, error)
- func Load() (*DB, error)
- func LoadTo(dbname string) (*DB, error)
- func (d *DB) Bulck(sql string, args ...any) error
- func (c *DB) Close() error
- func (d *DB) Command(sql string, args ...any) (et.Items, error)
- func (d *DB) CommandSource(sourceField string, sql string, args ...any) (et.Items, error)
- func (d *DB) Ddl(sql string, args ...any) error
- func (c *DB) Describe() et.Json
- func (c *DB) HealthCheck() bool
- func (d *DB) Query(sql string, args ...any) (et.Items, error)
- func (d *DB) QueryOne(sql string, args ...any) (et.Item, error)
- func (db *DB) SetListen(channels map[string]HandlerListend)
- func (d *DB) Source(sourceField string, sql string, args ...any) (et.Items, error)
type HandlerListend

Constants ¶

View Source

const (
	Postgres = "postgres"
	Oracle   = "oracle"
	Mysql    = "mysql"
)

View Source

const (
	EVENT_SQL_ERROR   = "sql:error"
	EVENT_SQL_QUERY   = "sql:query"
	EVENT_SQL_DDL     = "sql:definition"
	EVENT_SQL_COMMAND = "sql:command"
)

View Source

const (
	KEY = "_id"
)

Variables ¶

This section is empty.

Functions ¶

func ChangePassword ¶

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

Changue password

func CreateColumn ¶

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

Create column

func CreateDatabase ¶

func CreateDatabase(db *DB, name string) error

* * Created database component *

func CreateIndex ¶

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

Create index

func CreateSchema ¶

func CreateSchema(db *DB, name string) error

Create schema

func CreateSequence ¶

func CreateSequence(db *DB, schema, tag string) error

Create serie

func CreateTrigger ¶

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

Create trigger

func CreateUser ¶

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

Create user

func DropColumn ¶

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

Drop column

func DropDatabase ¶

func DropDatabase(db *DB, name string) error

Drop database

func DropIndex ¶

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

Drop index

func DropSchema ¶

func DropSchema(db *DB, name string) error

Drop schema

func DropSerie ¶

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

Drop serie

func DropTable ¶

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

Drop table

func DropTrigger ¶

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

Drop trigger

func DropUser ¶

func DropUser(db *DB, name string) error

Drop user

func ExistColum ¶

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

Exist column

func ExistDatabase ¶

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

Exist database

func ExistIndex ¶

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

Exist index

func ExistSchema ¶

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

Exist schema

func ExistSerie ¶

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

Exist serie

func ExistTable ¶

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

Exist table

func ExistTrigger ¶

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

Exist trigger

func ExistUser ¶

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

Exist user

func InitCore ¶

func InitCore(db *DB) error

func LastSerie ¶

func LastSerie(db *DB, tag string) int

* * LastSerie * @param db *DB, tag string * @return int *

func NextCode ¶

func NextCode(db *DB, tag, prefix string) string

* * NextCode * @param db *DB, tag string, prefix string * @return string *

func NextSerie ¶

func NextSerie(db *DB, tag string) int64

* * NextSerie * @param db *DB, tag string * @return int64 *

func SQLDDL ¶

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

* * SQLDDL * @param sql string, args ...any * @return string *

func SQLParse ¶

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

* * SQLParse * @param sql string, args ...any * @return string *

func SQLQuote ¶

func SQLQuote(sql string) string

* * SQLQuote * @param sql string * @return string *

func SetSerie ¶

func SetSerie(db *DB, tag string, val int) (int, error)

* * SetSerie * @param db *DB, tag string, val int * @return int, error *

func TipoSQL ¶ added in v1.1.132

func TipoSQL(query string) string

Types ¶

type DB ¶

type DB struct {
	Description string
	Driver      string
	Host        string
	Port        int
	Dbname      string
	Connection  string
	UseCore     bool
	// contains filtered or unexported fields
}

func ConnectTo ¶

func ConnectTo(params et.Json) (*DB, error)

* * ConnectTo * @param params et.Json * @return *DB, error *

func Load ¶

func Load() (*DB, error)

* * Load * @return *Conn, error *

func LoadTo ¶ added in v1.1.118

func LoadTo(dbname string) (*DB, error)

* * LoadTo * @param dbname string * @return *DB, error *

func (*DB) Bulck ¶ added in v1.1.26

func (d *DB) Bulck(sql string, args ...any) error

* * Bulck * @param sql string, args ...any * @return error *

func (*DB) Close ¶

func (c *DB) Close() error

* * Close * @return error *

func (*DB) Command ¶

func (d *DB) Command(sql string, args ...any) (et.Items, error)

* * Command * @param sql string, args ...any * @return et.Items, error *

func (*DB) CommandSource ¶ added in v1.1.125

func (d *DB) CommandSource(sourceField string, sql string, args ...any) (et.Items, error)

* * CommandSource * @param sourceField string, sql string, args ...any * @return et.Items, error *

func (*DB) Ddl ¶ added in v1.1.125

func (d *DB) Ddl(sql string, args ...any) error

* * Ddl * @param sql string, args ...any * @return error *

func (*DB) Describe ¶

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

* * Describe * @return et.Json *

func (*DB) HealthCheck ¶ added in v1.1.124

func (c *DB) HealthCheck() bool

* * HealthCheck * @return bool *

func (*DB) Query ¶

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

* * Query * @param sql string, args ...any * @return et.Items, error *

func (*DB) QueryOne ¶

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

* * QueryOne * @param sql string, args ...any * @return et.Item, error *

func (*DB) SetListen ¶

func (db *DB) SetListen(channels map[string]HandlerListend)

* * SetListen * @param channels map[string]HandlerListend *

func (*DB) Source ¶

func (d *DB) Source(sourceField string, sql string, args ...any) (et.Items, error)

* * Source * @param sourceField string, sql string, args ...any * @return et.Items, error *

type HandlerListend ¶

type HandlerListend func(res et.Json)

Source Files ¶

View all Source files

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