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

gosql

package module

Go to main page

Versions in this module

v0

v0.0.10

Jan 12, 2024

Changes in this version

type SQLite

+ func (db *SQLite) Conn() *sql.DB

v0.0.9

Aug 30, 2023

Changes in this version

type Table

+ func (t *Table) AndWhere(field, condition string, value any) *Constraints

+ func (t *Table) OrWhere(field, condition string, value any) *Constraints

v0.0.8

Aug 29, 2023

Changes in this version

type Query

+ func (q Query) IsJoin(tableName string) bool

v0.0.7

Aug 29, 2023

v0.0.6

Aug 29, 2023

Changes in this version

type Query

+ func (q *Query) Distinct() *Query

v0.0.5

Aug 29, 2023

Changes in this version

+ const OrderDirectionAscending

+ const OrderDirectionDescending

type Query

+ func (q *Query) Ignore() *Query

+ func (q *Query) Limit(limit, offset int) *Query

+ func (q *Query) OrderAscending(field string) *Query

+ func (q *Query) OrderDescending(field string) *Query

v0.0.4

Aug 29, 2023

Changes in this version

type Query

+ func Raw(sql string) Query

v0.0.3

Aug 29, 2023

Changes in this version

+ const ActionDelete

+ const ActionInsert

+ const ActionSelect

+ const ActionUpdate

+ const ConditionBetween

+ const ConditionEquals

+ const ConditionGreaterThan

+ const ConditionGreaterThanOrEquals

+ const ConditionIn

+ const ConditionIsNotNull

+ const ConditionIsNull

+ const ConditionLessThan

+ const ConditionLessThanOrEquals

+ const ConditionLike

+ const ConditionNotBetween

+ const ConditionNotEquals

+ const ConditionNotIn

+ const ConditionNotLike

+ const ConjunctionAnd

+ const ConjunctionOr

+ type Constraint struct

+ type Constraints struct

+ func (c *Constraints) And(field, condition string, value any) *Constraints

+ func (c *Constraints) Or(field, condition string, value any) *Constraints

+ type Join struct

+ func (j *Join) On(leftField, rightField string)

+ type Query struct

+ func Delete() Query

+ func Insert() Query

+ func Select() Query

+ func Update() Query

+ func (q *Query) AlsoFrom(name, conjunction string) *Table

+ func (q *Query) Build() (string, []any)

+ func (q *Query) From(name string) *Table

+ func (q *Query) Join(leftTable, rightTable string) *Join

+ func (q *Query) Table(name string) *Table

+ func (q *Query) To(name string) *Table

+ func (q Query) HasConstraints() bool

+ type SQLDB interface

+ Close func() error

+ Exec func(Query) (sql.Result, error)

+ IsOpen func() bool

+ Open func() error

+ Query func(Query) (*sql.Rows, error)

+ type SQLite struct

+ func NewSQLite(path string) SQLite

+ func (db *SQLite) Close() error

+ func (db *SQLite) Open() error

+ func (db SQLite) Exec(query Query) (sql.Result, error)

+ func (db SQLite) IsOpen() bool

+ func (db SQLite) Query(query Query) (*sql.Rows, error)

+ type Table struct

+ func (t *Table) Fields(fields ...string) *Table

+ func (t *Table) Set(field string, value any) *Table

+ func (t *Table) Values(values ...any) *Table

+ func (t *Table) Where(field, condition string, value any) *Constraints

+ func (t Table) HasField(name string) bool