Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

database

package

Go to main page

Versions in this module

v1

v1.1.82

Oct 21, 2024

v1.1.81

Oct 25, 2022

v1.1.8

Oct 21, 2022

Changes in this version

+ const Ora

v1.1.7

Apr 6, 2022

v1.1.6

Mar 16, 2022

v1.1.5

Mar 16, 2022

v1.1.4

Feb 22, 2022

v1.1.3

Dec 16, 2021

v1.1.2

Dec 15, 2021

v1.1.1

Dec 15, 2021

Changes in this version

+ func ValidPrefix(tp string) bool

v1.1.0

Nov 23, 2021

Changes in this version

+ const BLTP

+ const DELETE

+ const DTTP

+ const FLTP

+ const FROM

+ const INSERT

+ const INTP

+ const JSONTP

+ const Mysql

+ const Post

+ const SELECT

+ const SQLLite

+ const STTP

+ const Sqlser

+ const UPDATE

+ var CADCONN = map[string]string

+ var FORMATTOSTRCONECT = "[%s|%s|%s|%d|%s|%s|%s|%s]"

+ var PrefijosDB = map[string]string

+ var Ssmodes = []string

+ var TESTTABLE = map[string]string

+ func CreateDBConect(cnx StCadConect, pass string) ([]byte, error)

+ func CreateDbFile(cnx StCadConect, pass, dir, name string) error

+ func FindTp(v interface{}, tp TpCore) interface

+ type DataTable struct

+ func NewDataTable(table string, rows []StData, index []string) DataTable

+ func (p *DataTable) AddIndex(col string) error

+ func (p *DataTable) AddIndexs(cols ...string) error

+ func (p *DataTable) AddRow(row StData)

+ func (p *DataTable) AddRows(rows ...StData)

+ func (p *DataTable) GenDeletes() ([]StQuery, error)

+ func (p *DataTable) GenInserts() ([]StQuery, error)

+ func (p *DataTable) GenSQL(accion string) ([]StQuery, error)

+ func (p *DataTable) GenUpdates() ([]StQuery, error)

+ func (p *DataTable) GetCols() ([]string, error)

+ func (p *DataTable) GetIndex() []string

+ func (p *DataTable) GetRow(row int) (StData, error)

+ func (p *DataTable) GetRows() []StData

+ func (p *DataTable) GetTable() string

+ func (p *DataTable) LenIndex() int

+ func (p *DataTable) LenRows() int

+ func (p *DataTable) SetTable(table string)

+ func (p *DataTable) ValidRow() bool

+ type StCadConect struct

+ File string

+ Host string

+ Name string

+ Pass string

+ Port int

+ Sslmode string

+ TP string

+ User string

+ func DecripConect(data []byte, pass string) (StCadConect, error)

+ func (p *StCadConect) ToString() string

+ func (p *StCadConect) Trim()

+ func (p *StCadConect) ValidCad() bool

+ type StConect struct

+ Conexion StCadConect

+ DBGO *sqlx.DB

+ DBStmt *sql.Stmt

+ DBTx *sql.Tx

+ Queries map[string]string

+ func (p *StConect) Close() error

+ func (p *StConect) Con() error

+ func (p *StConect) ConfigDBX(path, pass string) error

+ func (p *StConect) ConfigENV() error

+ func (p *StConect) ConfigINI(PathINI string) error

+ func (p *StConect) ConfigJSON(PathJSON string) error

+ func (p *StConect) ConfigURL(url string)

+ func (p *StConect) Exec(Data []StQuery, indConect bool) error

+ func (p *StConect) ExecBackup() error

+ func (p *StConect) ExecDatatable(data DataTable, acc string, indConect bool) error

+ func (p *StConect) ExecNative(sql string, indConect bool, args ...interface{}) (sql.Result, error)

+ func (p *StConect) ExecOne(Data StQuery, indConect bool) error

+ func (p *StConect) ExecValid(Data []StQuery, tipacc string) error

+ func (p *StConect) Insert(Data []StQuery) error

+ func (p *StConect) NamedIn(query StQuery) (string, []interface{}, error)

+ func (p *StConect) Query(query StQuery, cantrow int, indConect bool) ([]StData, error)

+ func (p *StConect) QueryJSON(query StQuery, cantrow int, indConect, indLimit bool) ([]byte, error)

+ func (p *StConect) QueryMap(query StQuery, cantrow int, indConect, indLimit bool) ([]StData, error)

+ func (p *StConect) QueryNative(sql string, indConect bool, args ...interface{}) (*sql.Rows, error)

+ func (p *StConect) QueryOne(query StQuery, indConect bool) (StData, error)

+ func (p *StConect) QueryRows(query StQuery, indConect bool) (*sqlx.Rows, error)

+ func (p *StConect) QueryStruct(datadest interface{}, query StQuery, indConect bool) error

+ func (p *StConect) ResetCnx()

+ func (p *StConect) SendSQL(code string, args map[string]interface{}) StQuery

+ func (p *StConect) SetBackupScript(sql string)

+ func (p *StConect) Test() bool

+ func (p *StConect) UpdateOrDelete(Data []StQuery) (int64, error)

+ func (p *StConect) ValidTable(table string) bool

+ type StData map[string]interface

+ func (p *StData) Filter(keys ...string) StData

+ func (p *StData) KeyColum() []string

+ func (p *StData) ToBool(columna string) bool

+ func (p *StData) ToDate(columna string) (time.Time, error)

+ func (p *StData) ToFloat(columna string) (float32, error)

+ func (p *StData) ToFloat64(columna string) (float64, error)

+ func (p *StData) ToInt(columna string) (int, error)

+ func (p *StData) ToInt32(columna string) int32

+ func (p *StData) ToInt64(columna string) (int64, error)

+ func (p *StData) ToJSON() ([]byte, error)

+ func (p *StData) ToString(columna string) (string, error)

+ func (p *StData) UpperKey() StData

+ func (p *StData) ValidColum(col string) bool

+ func NewStData(mp map[string]interface{}) StData

+ type StExt struct

+ Index []string

+ SQLIn StQuery

+ TableNameOut string

+ type StMerge struct

+ AccMerge func(CnxIn, CnxOut StConect) error

+ CnxIn StConect

+ CnxOut StConect

+ DelsqlIn []StQuery

+ DelsqlOut []StQuery

+ InDelIn bool

+ InDelOut bool

+ ItemsExt []StExt

+ func (p *StMerge) LoadDataIn() ([]DataTable, error)

+ func (p *StMerge) Process() error

+ type StQuery struct

+ Args map[string]interface{}

+ Querie string

+ type StSQLData struct

+ Data []byte

+ func (p *StSQLData) ToJSON() utl.JSON

+ func (p *StSQLData) ToMap() ([]map[string]interface{}, error)

+ func (p *StSQLData) Unmarshal(v interface{}) error

+ type TpCore string