sql

Documentation

Index

• Constants
• func ParserSQL(s string) (cmd interface{}, err error)
• type DeleteCommand
• type SelectCommand
• type UpdateCommand

Constants

const (
	//CmdInsert 插入
	CmdInsert = 1
	//CmdSelect 查询
	CmdSelect = 2
	//CmdUpdate 更新
	CmdUpdate = 3
	//CmdDelete 删除
	CmdDelete = 4
)

Functions

func ParserSQL

func ParserSQL(s string) (cmd interface{}, err error)

ParserSQL 解析SQL

Types

type DeleteCommand

type DeleteCommand struct {
	SQL   string
	Table string
	Where string
}

DeleteCommand 删除

type SelectCommand

type SelectCommand struct {
	SQL    string
	Fields []string
	Table  string
	Where  string
	Limit  []int //100
}

SelectCommand 字符串

type UpdateCommand

type UpdateCommand struct {
	SQL    string
	Fields []string
	Table  string
	Where  string
}

UpdateCommand 更新