Fix primary key no use

Chat2DB-Pro · Chat2DB-Pro · commit edd12b9d5bc5 · 2023-11-03T18:20:10.000+08:00
diff --git a/chat2db-server/chat2db-spi/src/main/java/ai/chat2db/spi/enums/DataTypeEnum.java b/chat2db-server/chat2db-spi/src/main/java/ai/chat2db/spi/enums/DataTypeEnum.java
@@ -108,7 +108,11 @@ public static DataTypeEnum getByCode(String code) {
 
     public String getSqlValue(String value) {
         if (this == DataTypeEnum.BOOLEAN) {
-            return value;
+            if("true".equalsIgnoreCase(value) || "false".equalsIgnoreCase(value)){
+                return value;
+            }else {
+                return "'" + value + "'";
+            }
         }
         if (this == DataTypeEnum.NUMERIC) {
             return value;
@@ -149,9 +153,6 @@ public String getSqlValue(String value) {
         if (this == DataTypeEnum.UNKNOWN) {
             return "'" + value + "'";
         }
-        if (this == DataTypeEnum.CHAT2DB_ROW_NUMBER) {
-            return "'" + value + "'";
-        }
         return "'" + value + "'";
     }
 }

Original file line number	Diff line number	Diff line change
`@@ -108,7 +108,11 @@ public static DataTypeEnum getByCode(String code) {`
`108`	`108`
`109`	`109`	`public String getSqlValue(String value) {`
`110`	`110`	`if (this == DataTypeEnum.BOOLEAN) {`
`111`		`- return value;`
	`111`	`+ if("true".equalsIgnoreCase(value) \|\| "false".equalsIgnoreCase(value)){`
	`112`	`+ return value;`
	`113`	`+ }else {`
	`114`	`+ return "'" + value + "'";`
	`115`	`+ }`
`112`	`116`	`}`
`113`	`117`	`if (this == DataTypeEnum.NUMERIC) {`
`114`	`118`	`return value;`
`@@ -149,9 +153,6 @@ public String getSqlValue(String value) {`
`149`	`153`	`if (this == DataTypeEnum.UNKNOWN) {`
`150`	`154`	`return "'" + value + "'";`
`151`	`155`	`}`
`152`		`- if (this == DataTypeEnum.CHAT2DB_ROW_NUMBER) {`
`153`		`- return "'" + value + "'";`
`154`		`- }`
`155`	`156`	`return "'" + value + "'";`
`156`	`157`	`}`
`157`	`158`	`}`