sql

package

v0.0.0-...-fb8553b Latest Latest Go to latest Published: Nov 7, 2017 License: MIT Imports: 8 Imported by: 3

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/qiwihui/DBShield

Links

Open Source Insights

Documentation ¶

Index ¶

Constants
func Classify(sql string) string
func ExtractTableNames(fromSQL string) (rets []string, err error)
func GetStmtType(sql string) string
func GetTableName(query string) (string, error)
func Pattern(query []byte) []byte
type QueryAction
type QueryContext
- func (c *QueryContext) Marshal() []byte
- func (c *QueryContext) Unmarshal(b []byte) (size uint32)

Constants ¶

View Source

const (
	TypeDDL     = "DDL"
	TypeDML     = "DML"
	TypeDCL     = "DCL"
	TypeTCL     = "TCL"
	TypeUnknown = "Unknown"
)

Query

View Source

const (
	StmtSelect         = "SELECT"
	StmtInsert         = "INSERT"
	StmtReplace        = "REPLACE"
	StmtMerge          = "MERE"
	StmtCall           = "CALL"
	StmtUpdate         = "UPDATE"
	StmtDelete         = "DELETE"
	StmtBegin          = "BEGIN"
	StmtCommit         = "COMMIT"
	StmtRollback       = "ROLLBACK"
	StmtSavePoint      = "SAVEPOINT"
	StmtSet            = "SET"
	StmtShow           = "SHOW"
	StmtUse            = "USE"
	StmtCreate         = "CREATE"
	StmtAlert          = "ALERT"
	StmtDrop           = "DROP"
	StmtTruncate       = "TRUNCATE"
	StmtComment        = "COMMENT"
	StmtRename         = "RENAME"
	StmtGrant          = "GRANT"
	StmtRevoke         = "REVOKE"
	StmtExplainPlan    = "EXPLAINPLAN"
	StmtLockTable      = "LOCKTABLE"
	StmtSetTransaction = "SETTRANSATION"
	StmtOther          = "OTHER"
	StmtUnknown        = "UNKNOWN"
)

Statement

Variables ¶

This section is empty.

Functions ¶

func Classify ¶

func Classify(sql string) string

Classify 分类sql语句

func ExtractTableNames ¶

func ExtractTableNames(fromSQL string) (rets []string, err error)

ExtractTableNames from sql statement

func GetStmtType ¶

func GetStmtType(sql string) string

GetStmtType 获取sql语句类型

func GetTableName ¶

func GetTableName(query string) (string, error)

GetTableName from sql select statement

func Pattern ¶

func Pattern(query []byte) []byte

Pattern returns pattern of given query

Types ¶

type QueryAction ¶

type QueryAction struct {
	QueryContext
	Action    string
	Duration  time.Duration
	Tables    []string
	QueryType string
}

QueryAction action and duration

type QueryContext ¶

type QueryContext struct {
	Query      []byte
	User       []byte
	Client     []byte
	Database   []byte
	Time       time.Time
	SessionID  string
	ServerIP   string
	ServerPort uint
}

QueryContext holds information around query

func (*QueryContext) Marshal ¶

func (c *QueryContext) Marshal() []byte

Marshal load []byte into QueryContext

func (*QueryContext) Unmarshal ¶

func (c *QueryContext) Unmarshal(b []byte) (size uint32)

Unmarshal []byte into QueryContext

Source Files ¶

View all Source files

sql.go

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