mirror of
https://github.com/tobycroft/gorose-pro.git
synced 2025-09-26 12:41:16 +08:00
43 lines
1.2 KiB
Go
43 lines
1.2 KiB
Go
package gorose
|
|
|
|
const (
|
|
// DriverSqlite3 ...
|
|
DriverSqlite3 = "sqlite3"
|
|
)
|
|
|
|
// BuilderSqlite3 ...
|
|
type BuilderSqlite3 struct {
|
|
FieldQuotesDefault
|
|
//IOrm
|
|
driver string
|
|
}
|
|
|
|
// sqlstr := fmt.Sprintf("SELECT %s%s FROM %s%s%s%s%s%s%s%s",
|
|
// distinct, fields, table, join, where, group, having, order, limit, offset)
|
|
// select {distinct} {fields} from {table} {join} {where} {group} {having} {order} {limit} {offset}
|
|
// {execute} {table} {data} {where}
|
|
func init() {
|
|
var builder = &BuilderSqlite3{}
|
|
NewBuilderDriver().Register(DriverSqlite3, builder)
|
|
}
|
|
|
|
// NewBuilderSqlite3 ...
|
|
func NewBuilderSqlite3() *BuilderSqlite3 {
|
|
return new(BuilderSqlite3)
|
|
}
|
|
|
|
// Clone : a new obj
|
|
func (b *BuilderSqlite3) Clone() IBuilder {
|
|
return &BuilderSqlite3{driver: DriverSqlite3}
|
|
}
|
|
|
|
// BuildQuery : build query sql string
|
|
func (b *BuilderSqlite3) BuildQuery(o IOrm) (sqlStr string, args []interface{}, err error) {
|
|
return NewBuilderDefault(o, NewBuilderSqlite3()).SetDriver(b.driver).BuildQuery()
|
|
}
|
|
|
|
// BuildExecut : build execute sql string
|
|
func (b *BuilderSqlite3) BuildExecute(o IOrm, operType string) (sqlStr string, args []interface{}, err error) {
|
|
return NewBuilderDefault(o, NewBuilderSqlite3()).SetDriver(b.driver).BuildExecute(operType)
|
|
}
|