gosql

README

GoSQL

This isn't anything serious, just a little bit of code I'd like to re-use for generating basic SQL statements.

Depends on: github.com/mattn/go-sqlite3

Documentation

Index

• Constants
• type Constraint
• type Constraints
  • func (c *Constraints) And(field, condition string, value any) *Constraints
  • func (c *Constraints) Or(field, condition string, value any) *Constraints
• type Join
  • func (j *Join) On(leftField, rightField string)
• type Query
  • func Delete() *Query
  • func Insert() *Query
  • func Raw(sql string) *Query
  • func Select() *Query
  • func Update() *Query
  • func (q *Query) AlsoFrom(name, conjunction string) *Table
  • func (q *Query) Build() (string, []any)
  • func (q *Query) Distinct() *Query
  • func (q *Query) From(name string) *Table
  • func (q Query) HasConstraints() bool
  • func (q *Query) Ignore() *Query
  • func (q Query) IsJoin(tableName string) bool
  • func (q *Query) Join(leftTable, rightTable string) *Join
  • func (q *Query) Limit(limit, offset int) *Query
  • func (q *Query) OrderAscending(field string) *Query
  • func (q *Query) OrderDescending(field string) *Query
  • func (q *Query) Table(name string) *Table
  • func (q *Query) To(name string) *Table
• type SQLDB
• type SQLite
  • func NewSQLite(path string) SQLite
  • func (db *SQLite) Close() error
  • func (db *SQLite) Conn() *sql.DB
  • func (db SQLite) Exec(query *Query) (sql.Result, error)
  • func (db SQLite) IsOpen() bool
  • func (db *SQLite) Open() error
  • func (db SQLite) Query(query *Query) (*sql.Rows, error)
• type Table
  • func (t *Table) AndWhere(field, condition string, value any) *Constraints
  • func (t *Table) Fields(fields ...string) *Table
  • func (t Table) HasField(name string) bool
  • func (t *Table) OrWhere(field, condition string, value any) *Constraints
  • 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

Constants

const (
	ConditionEquals              = "="
	ConditionNotEquals           = "<>"
	ConditionLessThan            = "<"
	ConditionGreaterThan         = ">"
	ConditionLessThanOrEquals    = "<="
	ConditionGreaterThanOrEquals = ">="
	ConditionLike                = "LIKE"
	ConditionNotLike             = "NOT LIKE"
	ConditionIn                  = "IN"
	ConditionNotIn               = "NOT IN"
	ConditionBetween             = "BETWEEN"
	ConditionNotBetween          = "NOT BETWEEN"
	ConditionIsNull              = "IS NULL"
	ConditionIsNotNull           = "IS NOT NULL"

	ConjunctionAnd = "AND"
	ConjunctionOr  = "OR"
)

const (
	ActionSelect = "SELECT"
	ActionInsert = "INSERT"
	ActionUpdate = "UPDATE"
	ActionDelete = "DELETE"

	OrderDirectionAscending  = "ASC"
	OrderDirectionDescending = "DESC"
)

Types

type Constraint

type Constraint struct {
	// contains filtered or unexported fields
}

type Constraints

type Constraints struct {
	// contains filtered or unexported fields
}

func (*Constraints) And

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

func (*Constraints) Or

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

type Join

type Join struct {
	// contains filtered or unexported fields
}

func (*Join) On

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

type Query

type Query struct {
	// contains filtered or unexported fields
}

func Delete

func Delete() *Query

func Insert

func Insert() *Query

func Raw

func Raw(sql string) *Query

func Select

func Select() *Query

func Update

func Update() *Query

func (*Query) AlsoFrom

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

func (*Query) Build

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

func (*Query) Distinct

func (q *Query) Distinct() *Query

func (*Query) From

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

func (Query) HasConstraints

func (q Query) HasConstraints() bool

func (*Query) Ignore

func (q *Query) Ignore() *Query

func (Query) IsJoin

func (q Query) IsJoin(tableName string) bool

func (*Query) Join

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

func (*Query) Limit

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

func (*Query) OrderAscending

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

func (*Query) OrderDescending

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

func (*Query) Table

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

func (*Query) To

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

type SQLDB

type SQLDB interface {
	IsOpen() bool
	Open() error
	Close() error
	Query(Query) (*sql.Rows, error)
	Exec(Query) (sql.Result, error)
}

type SQLite

type SQLite struct {
	// contains filtered or unexported fields
}

func NewSQLite

func NewSQLite(path string) SQLite

func (*SQLite) Close

func (db *SQLite) Close() error

func (*SQLite) Conn

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

func (SQLite) Exec

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

func (SQLite) IsOpen

func (db SQLite) IsOpen() bool

func (*SQLite) Open

func (db *SQLite) Open() error

func (SQLite) Query

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

type Table

type Table struct {
	// contains filtered or unexported fields
}

func (*Table) AndWhere

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

func (*Table) Fields

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

func (Table) HasField

func (t Table) HasField(name string) bool

func (*Table) OrWhere

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

func (*Table) Set

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

func (*Table) Values

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

func (*Table) Where

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