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

directsql

package

Go to main page

Versions in this module

v1

v1.3.0

Jul 1, 2019

Changes in this version

+ func SelectMapIsExist(modelId, sqlId string, mp map[string]interface{}) (bool, error)

type TDefaultType

+ const DT_INT64UUID

+ const DT_SHORTUUID

+ const DT_VALUE

type TSql

+ Eachtran bool

+ type Worker struct

+ func UUIDService() *Worker

+ func (w *Worker) GetInt64Id() int64

+ func (w *Worker) GetShortStrId() string

v1.2.0

Mar 17, 2018

Changes in this version

+ const Email

+ const Float

+ const Int

+ const MSCONFIGFILE

+ func BacthExecMap(modelId, sqlId string, sp []map[string]interface{}) error

+ func BacthMultiExecMap(modelId, sqlId string, mp map[string][]map[string]interface{}) error

+ func CheckRequired(str string) bool

+ func ClearCache()

+ func DealwithParameter(modelId, sqlId string, mp map[string]interface{}, sqlindex int, ...) error

+ func DirectSQL() faygo.HandlerFunc

+ func DirectSQLReloadAll() faygo.HandlerFunc

+ func DirectSQLReloadModel() faygo.HandlerFunc

+ func ExecMap(modelId, sqlId string, mp map[string]interface{}) (sql.Result, error)

+ func ExecStruct(modelId, sqlId string, st interface{}) (sql.Result, error)

+ func GetCache(key string, suffix string) (ok bool, result []byte)

+ func IsEmail(str string) bool

+ func IsFloat(str interface{}) bool

+ func IsInt(str interface{}) bool

+ func IsVaildDate(str string) bool

+ func IsVaildDatetime(str string) bool

+ func IsVaildLength(str string, min, max int) bool

+ func IsVaildValue(value, min, max float64) bool

+ func JSONString(v interface{}, Indent bool) (string, error)

+ func Map2Struct(mp map[string]interface{}, st interface{}) error

+ func MultiSelectMapToMap(modelId, sqlId string, mp map[string]interface{}) (map[string][]map[string]interface{}, error)

+ func MultiSelectMapToRows(modelId, sqlId string, mp map[string]interface{}) (map[string]*core.Rows, error)

+ func RegAny(name string, fn interface{}) (err error)

+ func ReloadAll()

+ func ReloadModel(msqlfile string) error

+ func RemoveCache(key string)

+ func SelectMapToMap(modelId, sqlId string, mp map[string]interface{}) ([]map[string]interface{}, error)

+ func SelectMapToRows(modelId, sqlId string, mp map[string]interface{}) (*core.Rows, error)

+ func SelectMapToStruct(modelId, sqlId string, mp map[string]interface{}, st interface{}) (*[]interface{}, error)

+ func SelectMapToStructPro(modelId, sqlId string, mp map[string]interface{}, dest interface{}) error

+ func SetCache(key string, suffix string, value []byte, timeout int)

+ func SplitRight(s string, c byte) (left, right string)

+ func Struct2Map(st interface{}) map[string]interface

+ type Execresult struct

+ Info string

+ LastInsertId int64

+ RowsAffected int64

+ type MemoPool struct

+ type PagingSelectResult struct

+ Data []map[string]interface{}

+ Total int

+ func PagingSelectMapToMap(modelId, sqlId string, mp map[string]interface{}) (*PagingSelectResult, error)

+ type PagingSelectRows struct

+ Rows *core.Rows

+ Total int

+ func PagingSelectMapToRows(modelId, sqlId string, mp map[string]interface{}) (*PagingSelectRows, error)

+ type TCmd struct

+ Parameters []*TSqlParameter

+ Pin string

+ Rout string

+ Sql string

+ XMLName xml.Name

+ type TDefaultType int

+ const DT_CUSTOM

+ const DT_NOWDATE

+ const DT_NOWDATETIME

+ const DT_NOW_UNIX

+ const DT_PARENTID

+ const DT_UNDEFINED

+ const DT_UUID

+ type TModel struct

+ DB *core.DB

+ Id string

+ Sqls map[string]*TSql

+ type TModels struct

+ func (mss *TModels) StartWatcher() error

+ func (mss *TModels) StopWatcher() error

+ type TParaType int

+ const PT_BLOB

+ const PT_DATE

+ const PT_DATETIME

+ const PT_EMAIL

+ const PT_FLOAT

+ const PT_INT

+ const PT_STRING

+ type TSql struct

+ Cached bool

+ Cachetime int

+ Cmds []*TCmd

+ Id string

+ Idfield string

+ Pidfield string

+ Sqltype TSqltype

+ Sqltypestr string

+ XMLName xml.Name

+ type TSqlParameter struct

+ Default TDefaultType

+ Defaultstr string

+ MaxValue float64

+ Maxlen int

+ MinValue float64

+ Minlen int

+ Name string

+ Paratype TParaType

+ Paratypestr string

+ Parentid bool

+ Required bool

+ Return bool

+ type TSqltype int

+ const ST_BATCHEXEC

+ const ST_BATCHMULTIEXEC

+ const ST_EXEC

+ const ST_EXPORT

+ const ST_GETBLOB

+ const ST_IMPORT

+ const ST_MULTISELECT

+ const ST_NESTEDSELECT

+ const ST_PAGINGSELECT

+ const ST_REPORT

+ const ST_SELECT

+ const ST_SETBLOB

+ func GetSqlType(modelid string, sqlid string) TSqltype