Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  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

sqlquery

package module

Go to main page

Versions in this module

v1

v1.4.0

Feb 15, 2024

Changes in this version

type FindOptions

+ ForUpdate bool

+ ForUpdateMode string

+ func (f *FindOptions) WithForUpdate(mode string) *FindOptions

v1.3.1

Apr 4, 2023

v1.3.0

Apr 3, 2023

Changes in this version

+ func DeleteWithOptionsQuery(tableName string, options *DeleteOptions) (string, []interface{})

+ func UpdateWithOptionsQuery(tableName string, options *UpdateOptions) (string, []interface{})

+ type DeleteOptions struct

+ Filters map[string]interface{}

+ Flavor Flavor

+ func NewDeleteOptions(flavor Flavor) *DeleteOptions

+ func (d *DeleteOptions) WithFilter(field string, value interface{}) *DeleteOptions

+ type UpdateOptions struct

+ Assignments map[string]interface{}

+ Filters map[string]interface{}

+ Flavor Flavor

+ func NewUpdateOptions(flavor Flavor) *UpdateOptions

+ func (u *UpdateOptions) WithAssignment(field string, value interface{}) *UpdateOptions

+ func (u *UpdateOptions) WithFilter(field string, value interface{}) *UpdateOptions

v1.2.0

Mar 31, 2023

v1.1.0

Nov 10, 2022

Changes in this version

type FindAllOptions

+ ForUpdate bool

+ ForUpdateMode string

+ func (f *FindAllOptions) WithForUpdate(mode string) *FindAllOptions

v1.0.1

Sep 12, 2022

v1.0.0

Sep 12, 2022

Changes in this version

+ func DeleteQuery(flavor Flavor, tableName string, id interface{}) (string, []interface{})

+ func FindAllQuery(tableName string, options *FindAllOptions) (string, []interface{})

+ func FindQuery(tableName string, options *FindOptions) (string, []interface{})

+ func InsertQuery(flavor Flavor, tag, tableName string, structValue interface{}) (string, []interface{})

+ func UpdateQuery(flavor Flavor, tag, tableName string, id interface{}, structValue interface{}) (string, []interface{})

+ type FindAllOptions struct

+ Fields []string

+ Filters map[string]interface{}

+ Flavor Flavor

+ Limit int

+ Offset int

+ OrderBy string

+ func NewFindAllOptions(flavor Flavor) *FindAllOptions

+ func (f *FindAllOptions) WithFields(fields []string) *FindAllOptions

+ func (f *FindAllOptions) WithFilter(field string, value interface{}) *FindAllOptions

+ func (f *FindAllOptions) WithLimit(limit int) *FindAllOptions

+ func (f *FindAllOptions) WithOffset(offset int) *FindAllOptions

+ func (f *FindAllOptions) WithOrderBy(orderBy string) *FindAllOptions

+ type FindOptions struct

+ Fields []string

+ Filters map[string]interface{}

+ Flavor Flavor

+ func NewFindOptions(flavor Flavor) *FindOptions

+ func (f *FindOptions) WithFields(fields []string) *FindOptions

+ func (f *FindOptions) WithFilter(field string, value interface{}) *FindOptions

+ type Flavor int

+ const MySQLFlavor

+ const PostgreSQLFlavor

+ const SQLiteFlavor