Function getColumnTypeAndLen

IceFireDB-SQLite/internal/sqlite/db.go:198–233

(columnType string)

}

func getColumnTypeAndLen(columnType string) (byte, uint32) {
	index := strings.Index(columnType, "(")
	types := columnType
	var length uint32
	if index > -1 {
		types = columnType[:index]
		l := columnType[index+1 : len(columnType)-1]
		le, _ := strconv.Atoi(l)
		length = uint32(le)
	}
	switch types {
	case "INT":
		return mysql.MYSQL_TYPE_INT24, length
	case "TEXT":
		return mysql.MYSQL_TYPE_BLOB, length
	case "CHAR", "VARCHAR":
		return mysql.MYSQL_TYPE_VARCHAR, length
	case "REAL", "DOUBLE":
		return mysql.MYSQL_TYPE_DOUBLE, length
	case "FLOAT":
		return mysql.MYSQL_TYPE_FLOAT, length
	case "DATE":
		return mysql.MYSQL_TYPE_DATE, length
	case "DATETIME":
		return mysql.MYSQL_TYPE_DATETIME, length
	case "TIMESTAMP":
		return mysql.MYSQL_TYPE_TIMESTAMP, length
	case "DECIMAL", "NUMERIC":
		return mysql.MYSQL_TYPE_DECIMAL, length
	case "BOOLEAN":
		return mysql.MYSQL_TYPE_BIT, length
	case "NULL":
		return mysql.MYSQL_TYPE_NULL, length
	}
	return mysql.MYSQL_TYPE_VAR_STRING, length
}

func isDML(sql string) bool {
	prefix := sql