reverse Sqlite3 error , reverse.go:179 Unknown col "GroupGID" in index "IX_..." #41

New Issue

lunny · 2018-09-10T06:27:00Z

lunny commented

2018-09-10 06:27:00 +00:00

Author: @zwq000

use a exist sqlite database, index sql like

CREATE  INDEX "IX_Users_GroupGID" ON "Users" ("GroupGID")

DbMetas() func throw a error Unknown col "GroupGID", because at dialect_sqlite3.go func GetIndexes()
get column name is "GroupGID" ,it's include quotation.

索引定义中表名和字段名包含引号,这个数据库是其他程序生成的,所以在获取数据库元数据时发生了异常.
无法找到对应的字段名.

目前的解决办法是在 dialect_sqlite3.go 中增加一个 normalizeName 方法,去掉两边的引号和中间的空格

//normalize tabale/index/col name remove quotation
func normalizeName(name string) string {
	if name[0] == '"' {
		name = name[1:]
	}
	l := len(name)
	if name[l-1] == '"' {
		name = name[:l-1]
	}
	spaceIndex := strings.Index(name, " ")
	if spaceIndex > 1 { //name include space,Use firse token
		return name[:spaceIndex]
	}
	return name
}

Author: @zwq000 use a exist sqlite database, index sql like ```sql CREATE INDEX "IX_Users_GroupGID" ON "Users" ("GroupGID") ``` DbMetas() func throw a error Unknown col "GroupGID", because at dialect_sqlite3.go func GetIndexes() get column name is **"GroupGID"** ,it's include quotation. 索引定义中表名和字段名包含引号,这个数据库是其他程序生成的,所以在获取数据库元数据时发生了异常. 无法找到对应的字段名. 目前的解决办法是在 dialect_sqlite3.go 中增加一个 normalizeName 方法,去掉两边的引号和中间的空格 ```go //normalize tabale/index/col name remove quotation func normalizeName(name string) string { if name[0] == '"' { name = name[1:] } l := len(name) if name[l-1] == '"' { name = name[:l-1] } spaceIndex := strings.Index(name, " ") if spaceIndex > 1 { //name include space,Use firse token return name[:spaceIndex] } return name } ```

This repo is archived. You cannot comment on issues.