修改查询table sql语句 兼容性

pixel · pixel · commit 7721f7f7aef7 · 2020-07-07T10:02:20.000+08:00
diff --git a/server/config.yaml b/server/config.yaml
@@ -11,8 +11,8 @@ jwt:
 # mysql connect configuration
 mysql:
     username: root
-    password: 'Aa@6447985'
-    path: '127.0.0.1:3306'
+    password: 'wztxz19971029'
+    path: '47.103.196.252:3306'
     db-name: 'qmPlus'
     config: 'charset=utf8&parseTime=True&loc=Local'
     max-idle-conns: 10
diff --git a/server/service/sys_auto_code.go b/server/service/sys_auto_code.go
@@ -119,7 +119,7 @@ func GetAllTplFile(pathName string, fileList []string) ([]string, error) {
 }
 
 func GetTables(dbName string) (err error, TableNames []request.TableReq) {
-	err = global.GVA_DB.Raw("select table_name from information_schema.tables where table_schema= ? and table_type= ? ", dbName, "base table").Scan(&TableNames).Error
+	err = global.GVA_DB.Raw("select table_name as table_name from information_schema.tables where table_schema = ?", dbName).Scan(&TableNames).Error
 	return err, TableNames
 }
 

Original file line number	Diff line number	Diff line change
`@@ -119,7 +119,7 @@ func GetAllTplFile(pathName string, fileList []string) ([]string, error) {`
`119`	`119`	`}`
`120`	`120`
`121`	`121`	`func GetTables(dbName string) (err error, TableNames []request.TableReq) {`
`122`		`- err = global.GVA_DB.Raw("select table_name from information_schema.tables where table_schema= ? and table_type= ? ", dbName, "base table").Scan(&TableNames).Error`
	`122`	`+ err = global.GVA_DB.Raw("select table_name as table_name from information_schema.tables where table_schema = ?", dbName).Scan(&TableNames).Error`
`123`	`123`	`return err, TableNames`
`124`	`124`	`}`
`125`	`125`