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

xsql

package

Go to main page

Versions in this module

v1

v1.4.0-alpha.1

Oct 12, 2023

v1.3.0

Sep 28, 2023

v1.2.0

Mar 6, 2023

v1.1.2

Aug 16, 2022

v1.1.1

May 16, 2022

Changes in this version

+ const Description

+ const Release

+ const Version

+ type Config struct

+ DbType string

+ TablePrefix string

+ type Xsql struct

+ func NewXsql(conn *sql.DB, cfgs ...Config) *Xsql

+ func (x *Xsql) Name(tb string, alias ...string) *Builder

+ func (x *Xsql) SelectFunc(call func(*Builder), tb string, alias ...string) ([]map[string]interface{}, error)

v1.1.0

Jan 11, 2022

Changes in this version

+ type Builder struct

+ func Table(table interface{}, alias ...string) *Builder

+ func (c *Builder) Columns(columns ...string) *Builder

+ func (c *Builder) Delete() *Builder

+ func (c *Builder) GetSQL() (string, []interface{})

+ func (c *Builder) GetTableString() string

+ func (c *Builder) GroupBy(groupBys ...string) *Builder

+ func (c *Builder) InnerJoin(table, cond string) *Builder

+ func (c *Builder) Insert(data map[string]interface{}) *Builder

+ func (c *Builder) Join(table, cond, vtype string) *Builder

+ func (c *Builder) LeftJoin(table, cond string) *Builder

+ func (c *Builder) Limit(offset int, orRowCount ...int) *Builder

+ func (c *Builder) OrderBy(orderBys ...string) *Builder

+ func (c *Builder) Page(page int, orPageSize ...int) *Builder

+ func (c *Builder) ResetBinds() *Builder

+ func (c *Builder) ResetWhere(where string, binds ...interface{}) *Builder

+ func (c *Builder) RightJoin(table, cond string) *Builder

+ func (c *Builder) Select(columns ...string) *Builder

+ func (c *Builder) ToSQL() (string, []interface{})

+ func (c *Builder) Update(data map[string]interface{}) *Builder

+ func (c *Builder) Where(where string, binds ...interface{}) *Builder

+ type Query struct

+ DB *sql.DB

+ RowCount int

+ func NewQuery(db *sql.DB) *Query

+ func (c *Query) RowsDick(rows *sql.Rows) ([]map[string]interface{}, error)

+ func (c *Query) Select(query string, args ...interface{}) ([]map[string]interface{}, error)

v1.1.0-ea3

Dec 15, 2021

v1.1.0-ea1

Jul 13, 2021