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

sqla

package module

Go to main page

Versions in this module

v0

v0.1.6

Jan 9, 2023

Changes in this version

+ func SetToNullOneByID(db *sql.DB, dbType byte, table string, column string, id int) (rowsaff int)

v0.1.5

Aug 15, 2022

v0.1.4

Aug 15, 2022

retracted

v0.1.3

Apr 8, 2022

v0.1.1

Apr 7, 2022

Changes in this version

+ const DEBUG

+ const MSSQL

+ const MYSQL

+ const ORACLE

+ const POSTGRESQL

+ const SQLITE

+ func BuildDSN(DBType string, DBName string, DBHost string, DBPort string, DBUser string, ...) (DSN string)

+ func BuildSQLIN(DBType byte, sq string, argsCounter int, column string, valueList []int) (counter int, resquery string, args []interface{})

+ func BuildSQLINNOT(DBType byte, sq string, argsCounter int, column string, valueList []int) (counter int, resquery string, args []interface{})

+ func BuildSQLINOR(DBType byte, sq string, argsCounter int, column string, valueList []int, ...) (counter int, resquery string, args []interface{})

+ func ConstructSELECTquery(DBType byte, tableName string, columnsToSelect string, columnsToCount string, ...) (sq string, sqcount string, args []interface{}, argscount []interface{})

+ func CreateDB(DBType byte, DSN string, sqlStmt string)

+ func DeleteObject(db *sql.DB, DBType byte, table string, column string, id int) (rowsaff int)

+ func DeleteObjects(db *sql.DB, DBType byte, table string, column string, ids []int) (rowsaff int)

+ func InsertObject(db *sql.DB, DBType byte, table string, iargs []anyT) (lastid int, rowsaff int)

+ func MakeParam(DBType byte, argsCounter int) string

+ func OpenSQLConnection(DBType byte, DSN string) (db *sql.DB)

+ func ReturnDBType(dbtype string) byte

+ func SetToNull(db *sql.DB, DBType byte, table string, column string, list []int) (rowsaff int)

+ func UnmarshalNonEmptyJSONList(s string) (jsonList []string)

+ func UnmarshalNonEmptyJSONListInt(s string) (jsonList []int)

+ func UpdateMultipleWithOneInt(db *sql.DB, DBType byte, table string, column string, val int, timecol string, ...) (rowsaff int)

+ func UpdateObject(db *sql.DB, DBType byte, table string, iargs []anyT, ID int) (rowsaff int)

+ func UpdateSingleInt(db *sql.DB, DBType byte, table string, column string, valueToSet int, ID int) (rowsaff int)

+ func UpdateSingleJSONListInt(db *sql.DB, DBType byte, table string, column string, valueToSet []int, ID int) (rowsaff int)

+ func UpdateSingleJSONListStr(db *sql.DB, DBType byte, table string, column string, valueToSet []string, ...) (rowsaff int)

+ func UpdateSingleJSONStruct(db *sql.DB, DBType byte, table string, column string, valueToSet interface{}, ...) (rowsaff int)

+ func UpdateSingleStr(db *sql.DB, DBType byte, table string, column string, valueToSet string, ...) (rowsaff int)

+ func VerifyRemovalPermissions(db *sql.DB, DBType byte, table string, Owner int, AdminPrivileges bool, ...) bool

+ type AnyTslice []anyT

+ func (a AnyTslice) AppendInt(column string, i int) AnyTslice

+ func (a AnyTslice) AppendInt64(column string, i int64) AnyTslice

+ func (a AnyTslice) AppendJSONList(column string, sList []string) AnyTslice

+ func (a AnyTslice) AppendJSONListInt(column string, iList []int) AnyTslice

+ func (a AnyTslice) AppendJSONStruct(column string, sStruct interface{}) AnyTslice

+ func (a AnyTslice) AppendNil(column string) AnyTslice

+ func (a AnyTslice) AppendNonEmptyString(column string, s string) AnyTslice

+ func (a AnyTslice) AppendStringOrNil(column string, s string) AnyTslice

+ type ClassFilter struct

+ Column string

+ InJSON bool

+ List []int

+ Name string

+ Selector string

+ type DateFilter struct

+ Column string

+ Dates []int64

+ DatesStr []string

+ Name string

+ Relation string

+ type Filter struct

+ ClassFilter []ClassFilter

+ ClassFilterOR []ClassFilter

+ DateFilter []DateFilter

+ SumFilter []SumFilter

+ TextFilter string

+ TextFilterColumns []string

+ TextFilterName string

+ func (f *Filter) ClearColumnsValues()

+ func (f *Filter) GetFilterFromForm(r *http.Request, dateConvFunc func(string) int64, ...)

+ func (f *Filter) GetFilterFromJSON(JSON []byte, dateConvFunc func(string) int64, ...)

+ type Seek struct

+ UseSeek bool

+ Value int

+ ValueInclude bool

+ type SumFilter struct

+ Column string

+ CurrencyCode int

+ CurrencyColumn string

+ Name string

+ Relation string

+ Sums []int

+ SumsStr []string

v0.1.0

Apr 7, 2022

retracted