sqlbuilder

package module
v0.0.10 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Oct 21, 2019 License: GPL-3.0 Imports: 5 Imported by: 2

README

sqlbuilder

sqlbuilder is a simple sql query string builder

sqlbuilder its recursive struct call, that you can easy to build sql string

GoDoc

ex: dao.Select().From().Join().Where().Limit()

SqlBuilder functions
  • build select :
    • Select(f ...string)
    • Distinct(b bool)
      • its default in builder is set false
    • Top(i int)
      • only support mssql
    • From(t ...string)
      • t is table name
    • Where(c string)
      • c is condition, ex Where("field1=1 and filed2='b'")
    • WhereAnd(c ...string)
    • WhereOr(c ...string)
    • Limit(i ...int)
      • support 2 parms
      • only support mysql
    • Join(t string, c string)
      • t is table name
      • c is condition
    • InnerJoin(t string, c string)
    • LeftJoin(t string, c string)
    • RightJoin(t string, c string)
    • FullJoin(t string, c string)
    • GroupBy(f ...string)
      • f is a fileds list of strings
    • OrderBy(f ...string)
      • f is a fileds list of strings
    • OrderByAsc(f ...string)
    • OrderByDesc(f ...string)
    • Having(s string)
      • s is having condition string
    • BuildSelectSQL()
      • check and build sql string.
      • you can get sql string via BuildedSQL()
  • build update :
    • Set(s map[string]interface{})
    • FromOne(t string)
      • reset the table for only one
    • BuildUpdateSQL()
      • check and build sql string.
      • you can get sql string via BuildedSQL()
  • build insert :
    • Into(t string)
      • set the insert table
    • Fields(f ...string)
      • f is a fileds list of strings
    • Values(v ...[]interface{})
      • v is a values list of interface{}
    • BuildInsertSQL()
      • check and build sql string.
      • you can get sql string via BuildedSQL()
  • build delete :
    • BuildDeleteSQL()
      • check and build sql string.
      • you can get sql string via BuildedSQL()
  • common :
    • ClearBuilder()
      • reset builder
    • BuildedSQL()
      • return the builded sql string, if build success.
    • SetDbName(s string)
    • SetTbName(s string)
    • SwitchPanicToErrorLog(b bool)
    • PanicOrErrorLog(s string)

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func EscapeStr added in v0.0.4 

func EscapeStr(value string, isMysql ...bool) string

Types

type SQLBuilder 

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

func NewSQLBuilder 

func NewSQLBuilder(d ...string) (b *SQLBuilder)

func (*SQLBuilder) BuildDeleteSQL 

func (sb *SQLBuilder) BuildDeleteSQL() *SQLBuilder

func (*SQLBuilder) BuildInsertOrReplaceSQL added in v0.0.7 

func (sb *SQLBuilder) BuildInsertOrReplaceSQL() *SQLBuilder

func (*SQLBuilder) BuildInsertSQL 

func (sb *SQLBuilder) BuildInsertSQL() *SQLBuilder

func (*SQLBuilder) BuildSelectSQL 

func (sb *SQLBuilder) BuildSelectSQL() *SQLBuilder

func (*SQLBuilder) BuildUpdateSQL 

func (sb *SQLBuilder) BuildUpdateSQL() *SQLBuilder

func (*SQLBuilder) BuildedSQL 

func (sb *SQLBuilder) BuildedSQL() (sql string)

func (*SQLBuilder) CanBuildDelete 

func (sb *SQLBuilder) CanBuildDelete() bool

func (*SQLBuilder) CanBuildInsert 

func (sb *SQLBuilder) CanBuildInsert() bool

func (*SQLBuilder) CanBuildSelect 

func (sb *SQLBuilder) CanBuildSelect() bool

func (*SQLBuilder) CanBuildUpdate 

func (sb *SQLBuilder) CanBuildUpdate() bool

func (*SQLBuilder) ClearBuilder 

func (sb *SQLBuilder) ClearBuilder()

func (*SQLBuilder) Distinct 

func (sb *SQLBuilder) Distinct(b bool) *SQLBuilder

func (*SQLBuilder) Fields 

func (sb *SQLBuilder) Fields(s ...string) *SQLBuilder

func (*SQLBuilder) From 

func (sb *SQLBuilder) From(s ...string) *SQLBuilder

func (*SQLBuilder) FromOne 

func (sb *SQLBuilder) FromOne(s string) *SQLBuilder

func (*SQLBuilder) FullJoin 

func (sb *SQLBuilder) FullJoin(j string) *SQLBuilder

func (*SQLBuilder) FullJoinOn added in v0.0.4 

func (sb *SQLBuilder) FullJoinOn(j string, s string, o string, v interface{}) *SQLBuilder

func (*SQLBuilder) GetDbName 

func (sb *SQLBuilder) GetDbName() string

func (*SQLBuilder) GetFieldsCount 

func (sb *SQLBuilder) GetFieldsCount() int

func (*SQLBuilder) GetTbName 

func (sb *SQLBuilder) GetTbName() string

func (*SQLBuilder) GroupBy 

func (sb *SQLBuilder) GroupBy(s ...string) *SQLBuilder

func (*SQLBuilder) Having 

func (sb *SQLBuilder) Having(s string, o string, v interface{}) *SQLBuilder

func (*SQLBuilder) InnerJoin 

func (sb *SQLBuilder) InnerJoin(j string) *SQLBuilder

func (*SQLBuilder) InnerJoinOn added in v0.0.4 

func (sb *SQLBuilder) InnerJoinOn(j string, s string, o string, v interface{}) *SQLBuilder

func (*SQLBuilder) Into 

func (sb *SQLBuilder) Into(s string) *SQLBuilder

func (*SQLBuilder) IsDistinct 

func (sb *SQLBuilder) IsDistinct() bool

func (*SQLBuilder) IsHadBuildedSQL 

func (sb *SQLBuilder) IsHadBuildedSQL() bool

func (*SQLBuilder) IsHasDbName 

func (sb *SQLBuilder) IsHasDbName() bool

func (*SQLBuilder) IsHasFields 

func (sb *SQLBuilder) IsHasFields() bool

func (*SQLBuilder) IsHasFroms 

func (sb *SQLBuilder) IsHasFroms() bool

func (*SQLBuilder) IsHasGroups 

func (sb *SQLBuilder) IsHasGroups() bool

func (*SQLBuilder) IsHasHavings 

func (sb *SQLBuilder) IsHasHavings() bool

func (*SQLBuilder) IsHasInto 

func (sb *SQLBuilder) IsHasInto() bool

func (*SQLBuilder) IsHasJoins 

func (sb *SQLBuilder) IsHasJoins() bool

func (*SQLBuilder) IsHasLimit 

func (sb *SQLBuilder) IsHasLimit() bool

func (*SQLBuilder) IsHasOneFroms 

func (sb *SQLBuilder) IsHasOneFroms() bool

func (*SQLBuilder) IsHasOrders 

func (sb *SQLBuilder) IsHasOrders() bool

func (*SQLBuilder) IsHasSelects 

func (sb *SQLBuilder) IsHasSelects() bool

func (*SQLBuilder) IsHasSets 

func (sb *SQLBuilder) IsHasSets() bool

func (*SQLBuilder) IsHasTbName 

func (sb *SQLBuilder) IsHasTbName() bool

func (*SQLBuilder) IsHasTop 

func (sb *SQLBuilder) IsHasTop() bool

func (*SQLBuilder) IsHasValues 

func (sb *SQLBuilder) IsHasValues() bool

func (*SQLBuilder) IsHasWheres 

func (sb *SQLBuilder) IsHasWheres() bool

func (*SQLBuilder) IsMssql 

func (sb *SQLBuilder) IsMssql() bool

func (*SQLBuilder) IsMysql 

func (sb *SQLBuilder) IsMysql() bool

func (*SQLBuilder) IsOracle 

func (sb *SQLBuilder) IsOracle() bool

func (*SQLBuilder) IsPostgresql 

func (sb *SQLBuilder) IsPostgresql() bool

func (*SQLBuilder) IsSQLite added in v0.0.7 

func (sb *SQLBuilder) IsSQLite() bool

func (*SQLBuilder) Join 

func (sb *SQLBuilder) Join(j string) *SQLBuilder

func (*SQLBuilder) JoinOn added in v0.0.4 

func (sb *SQLBuilder) JoinOn(j string, s string, o string, v interface{}) *SQLBuilder

func (*SQLBuilder) LeftJoin 

func (sb *SQLBuilder) LeftJoin(j string) *SQLBuilder

func (*SQLBuilder) LeftJoinOn added in v0.0.4 

func (sb *SQLBuilder) LeftJoinOn(j string, s string, o string, v interface{}) *SQLBuilder

func (*SQLBuilder) Limit 

func (sb *SQLBuilder) Limit(i ...int) *SQLBuilder

func (*SQLBuilder) OrderBy 

func (sb *SQLBuilder) OrderBy(s ...string) *SQLBuilder

func (*SQLBuilder) OrderByAsc 

func (sb *SQLBuilder) OrderByAsc(s ...string) *SQLBuilder

func (*SQLBuilder) OrderByDesc 

func (sb *SQLBuilder) OrderByDesc(s ...string) *SQLBuilder

func (*SQLBuilder) PanicOrErrorLog 

func (sb *SQLBuilder) PanicOrErrorLog(s string)

func (*SQLBuilder) Release added in v0.0.8 

func (sb *SQLBuilder) Release()

func (*SQLBuilder) RightJoin 

func (sb *SQLBuilder) RightJoin(j string) *SQLBuilder

func (*SQLBuilder) RightJoinOn added in v0.0.4 

func (sb *SQLBuilder) RightJoinOn(j string, s string, o string, v interface{}) *SQLBuilder

func (*SQLBuilder) Select 

func (sb *SQLBuilder) Select(s ...string) *SQLBuilder

func (*SQLBuilder) Set 

func (sb *SQLBuilder) Set(s []Set) *SQLBuilder

func (*SQLBuilder) SetDbName 

func (sb *SQLBuilder) SetDbName(s string)

func (*SQLBuilder) SetDriverType 

func (sb *SQLBuilder) SetDriverType(t string)

func (*SQLBuilder) SetTbName 

func (sb *SQLBuilder) SetTbName(s string)

func (*SQLBuilder) SwitchPanicToErrorLog 

func (sb *SQLBuilder) SwitchPanicToErrorLog(b bool)

func (*SQLBuilder) Top 

func (sb *SQLBuilder) Top(i int) *SQLBuilder

func (*SQLBuilder) Values 

func (sb *SQLBuilder) Values(s ...interface{}) *SQLBuilder

func (*SQLBuilder) Where 

func (sb *SQLBuilder) Where(s string, o string, v interface{}) *SQLBuilder

Where : just equal WhereAnd

func (*SQLBuilder) WhereAnd 

func (sb *SQLBuilder) WhereAnd(s string, o string, v interface{}) *SQLBuilder

func (*SQLBuilder) WhereOr 

func (sb *SQLBuilder) WhereOr(s string, o string, v interface{}) *SQLBuilder

type Set added in v0.0.5 

type Set struct {
	K string
	V interface{}
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.