sqlcl

package module

v1.0.0 Latest Latest Go to latest Published: Jun 22, 2023 License: Apache-2.0 Imports: 8 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

Repository

github.com/lifezq/sqlcl

Links

Open Source Insights

README ¶

SQLCL

Documentation ¶

Constants ¶

View Source

const (
	QINSERTTABLE  = "0INSERT INTO "
	QINSERTFIELDS = "1FIELDS"
	QINSERTVALUES = "2VALUES"
	QUPDATE       = "0UPDATE "
	QUPDATESET    = "1SET"
	QDELETE       = "0DELETE"
	QSELECT       = "0SELECT"
	QFROM         = "1FROM"
	QINNERJOIN    = "2INNER JOIN"
	QLEFTJOIN     = "2LEFT JOIN"
	QWHERE        = "3WHERE"
	QWHEREFISET   = "3WHERE FIND_IN_SET"
	QAND          = "4AND"
	QANDFISET     = "4AND FIND_IN_SET"
	QOR           = "4OR"
	QORFISET      = "4OR FIND_IN_SET"
	QGROUPBY      = "6GROUP BY"
	QHAVING       = "7HAVING"
	QORDERBY      = "8ORDER BY"
	QLIMIT        = "9LIMIT"
)

Variables ¶

This section is empty.

Functions ¶

This section is empty.

Types ¶

type Config ¶

type Config struct {
	Driver      string // mysql/sqlite3
	Addr        string // mysql:127.0.0.1:3306/sqlite3:/tmp/foo.db or :memory:
	User        string
	Pass        string
	DbName      string
	Protocol    string
	Params      string
	MaxLifetime time.Duration
	MaxIdleConn int
	MaxConn     int
}

type QuerySet ¶

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

func NewQuerySet ¶

func NewQuerySet() *QuerySet

func (*QuerySet) And ¶

func (q *QuerySet) And(name string) *QuerySet

func (*QuerySet) AndFindInSet ¶

func (q *QuerySet) AndFindInSet(value, name string) *QuerySet

func (*QuerySet) AndFindInSetWithLeftBracket ¶

func (q *QuerySet) AndFindInSetWithLeftBracket(value, name string) *QuerySet

func (*QuerySet) Clear ¶

func (q *QuerySet) Clear() *QuerySet

func (*QuerySet) Delete ¶

func (q *QuerySet) Delete() *QuerySet

func (*QuerySet) Eq ¶

func (q *QuerySet) Eq(name string) *QuerySet

func (*QuerySet) EqNative ¶

func (q *QuerySet) EqNative(name string) *QuerySet

func (*QuerySet) From ¶

func (q *QuerySet) From(table string) *QuerySet

func (*QuerySet) FromAs ¶

func (q *QuerySet) FromAs(table, as string) *QuerySet

func (*QuerySet) Ge ¶

func (q *QuerySet) Ge(name string) *QuerySet

func (*QuerySet) GroupBy ¶

func (q *QuerySet) GroupBy(name string) *QuerySet

func (*QuerySet) Gt ¶

func (q *QuerySet) Gt(name string) *QuerySet

func (*QuerySet) Having ¶

func (q *QuerySet) Having(name string) *QuerySet

func (*QuerySet) In ¶

func (q *QuerySet) In(name string) *QuerySet

func (*QuerySet) InnerJoinAsOn ¶

func (q *QuerySet) InnerJoinAsOn(table, as, on string) *QuerySet

func (*QuerySet) InsertFields ¶

func (q *QuerySet) InsertFields(fields string) *QuerySet

func (*QuerySet) InsertTable ¶

func (q *QuerySet) InsertTable(table string) *QuerySet

func (*QuerySet) InsertValues ¶

func (q *QuerySet) InsertValues(values string) *QuerySet

func (*QuerySet) Le ¶

func (q *QuerySet) Le(name string) *QuerySet

func (*QuerySet) LeftJoinAsOn ¶

func (q *QuerySet) LeftJoinAsOn(table, as, on string) *QuerySet

func (*QuerySet) Like ¶

func (q *QuerySet) Like(name string) *QuerySet

func (*QuerySet) Limit ¶

func (q *QuerySet) Limit(offset, num uint64) *QuerySet

func (*QuerySet) LimitString ¶

func (q *QuerySet) LimitString(limit string) *QuerySet

func (*QuerySet) Lt ¶

func (q *QuerySet) Lt(name string) *QuerySet

func (*QuerySet) Neq ¶

func (q *QuerySet) Neq(name string) *QuerySet

func (*QuerySet) NeqNative ¶

func (q *QuerySet) NeqNative(name string) *QuerySet

func (*QuerySet) NotIn ¶

func (q *QuerySet) NotIn(name string) *QuerySet

func (*QuerySet) Or ¶

func (q *QuerySet) Or(name string) *QuerySet

func (*QuerySet) OrFindInSet ¶

func (q *QuerySet) OrFindInSet(value, name string) *QuerySet

func (*QuerySet) OrFindInSetWithRightBracket ¶

func (q *QuerySet) OrFindInSetWithRightBracket(value, name string) *QuerySet

func (*QuerySet) OrderBy ¶

func (q *QuerySet) OrderBy(name string) *QuerySet

func (*QuerySet) Select ¶

func (q *QuerySet) Select(fields string) *QuerySet

func (*QuerySet) Sql ¶

func (q *QuerySet) Sql()

func (*QuerySet) UpdateSet ¶

func (q *QuerySet) UpdateSet(values string) *QuerySet

func (*QuerySet) UpdateTable ¶

func (q *QuerySet) UpdateTable(table string) *QuerySet

func (*QuerySet) Where ¶

func (q *QuerySet) Where(name string) *QuerySet

func (*QuerySet) WhereFindInSet ¶

func (q *QuerySet) WhereFindInSet(value, name string) *QuerySet

type Result ¶

type Result struct {
	Data []*RowColumn
}

type RowColumn ¶

type RowColumn map[string]string

func (*RowColumn) Float32 ¶

func (r *RowColumn) Float32(k string) float32

func (*RowColumn) Float64 ¶

func (r *RowColumn) Float64(k string) float64

func (*RowColumn) Get ¶

func (r *RowColumn) Get(k string) string

func (*RowColumn) Int ¶

func (r *RowColumn) Int(k string) int

func (*RowColumn) Int16 ¶

func (r *RowColumn) Int16(k string) int16

func (*RowColumn) Int32 ¶

func (r *RowColumn) Int32(k string) int32

func (*RowColumn) Int64 ¶

func (r *RowColumn) Int64(k string) int64

func (*RowColumn) Int8 ¶

func (r *RowColumn) Int8(k string) int8

func (*RowColumn) Uint16 ¶

func (r *RowColumn) Uint16(k string) uint16

func (*RowColumn) Uint32 ¶

func (r *RowColumn) Uint32(k string) uint32

func (*RowColumn) Uint64 ¶

func (r *RowColumn) Uint64(k string) uint64

func (*RowColumn) Uint8 ¶

func (r *RowColumn) Uint8(k string) uint8

type Server ¶

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

func New ¶

func New(c Config) (*Server, error)

func (*Server) Close ¶

func (s *Server) Close() error

func (*Server) Exec ¶

func (s *Server) Exec(q *QuerySet) (sql.Result, error)

func (*Server) ExecString ¶

func (s *Server) ExecString(sql string) (sql.Result, error)

func (*Server) Ping ¶

func (s *Server) Ping() error

func (*Server) Prepare ¶

func (s *Server) Prepare(q *QuerySet) error

func (*Server) PrepareClose ¶

func (s *Server) PrepareClose(q *QuerySet)

func (*Server) PrepareExec ¶

func (s *Server) PrepareExec(q *QuerySet, args ...interface{}) (sql.Result, error)

func (*Server) PrepareQuery ¶

func (s *Server) PrepareQuery(q *QuerySet, args ...interface{}) (*Result, error)

func (*Server) PrepareQueryRow ¶

func (s *Server) PrepareQueryRow(q *QuerySet, args ...interface{}) (*RowColumn, error)

func (*Server) Query ¶

func (s *Server) Query(q *QuerySet, args ...interface{}) (*Result, error)

func (*Server) QueryRow ¶

func (s *Server) QueryRow(q *QuerySet, args ...interface{}) (*RowColumn, error)

func (*Server) QueryString ¶

func (s *Server) QueryString(sql string) (*Result, error)

func (*Server) TxBegin ¶

func (s *Server) TxBegin(q *QuerySet) error

func (*Server) TxCommit ¶

func (s *Server) TxCommit(q *QuerySet) error

func (*Server) TxExec ¶

func (s *Server) TxExec(q *QuerySet, args ...interface{}) (sql.Result, error)

func (*Server) TxPrepare ¶

func (s *Server) TxPrepare(q *QuerySet) error

func (*Server) TxPrepareClose ¶

func (s *Server) TxPrepareClose(q *QuerySet) error

func (*Server) TxPrepareExec ¶

func (s *Server) TxPrepareExec(q *QuerySet, args ...interface{}) (sql.Result, error)

func (*Server) TxQuery ¶

func (s *Server) TxQuery(q *QuerySet, args ...interface{}) (*Result, error)

func (*Server) TxQueryRow ¶

func (s *Server) TxQueryRow(q *QuerySet, args ...interface{}) (*RowColumn, error)

func (*Server) TxRollBack ¶

func (s *Server) TxRollBack(q *QuerySet) error

func (*Server) TxStmtExec ¶

func (s *Server) TxStmtExec(q *QuerySet, args ...interface{}) (sql.Result, error)

func (*Server) TxStmtQuery ¶

func (s *Server) TxStmtQuery(q *QuerySet, args ...interface{}) (*Result, error)

func (*Server) TxStmtQueryRow ¶

func (s *Server) TxStmtQueryRow(q *QuerySet, args ...interface{}) (*RowColumn, error)

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL