Add support for ft_STRING_LOWER in the sqlite3 driver

Also fixed some wrong tab/space issues

1 files changed, 17 insertions, 7 deletions

diff --git a/database/sqlite/sqlite.c b/database/sqlite/sqlite.c
index 6021462..13a6f07 100644
--- a/database/sqlite/sqlite.c
+++ b/database/sqlite/sqlite.c
@@ -270,10 +270,10 @@ dbresult *sqlite_query(eurephiaCTX *ctx, const char *fmt, ... ) {
         if( strcasestr(sql, "INSERT INTO") != 0) {
                 dbres->last_insert_id = sqlite3_last_insert_rowid((sqlite3 *) dbc->dbhandle);
         };
-	if( strcasestr(sql, "SELECT ") == 0 ) {
-		// If not a SELECT query, then get the number of affected records
-		dbres->affected_rows = sqlite3_changes((sqlite3 *) dbc->dbhandle);
-	}
+        if( strcasestr(sql, "SELECT ") == 0 ) {
+                // If not a SELECT query, then get the number of affected records
+                dbres->affected_rows = sqlite3_changes((sqlite3 *) dbc->dbhandle);
+        }
 
         dbres->srch_tuples = dbres->tuples;
         dbres->srch_headerrec = dbres->headerrec;
@@ -311,7 +311,7 @@ inline int SQLreservedWord(char **reserved_words, const char *val) {
  *
  * @return Returns a string to be used within an SQL query.
  */
-char *_build_value_string(eDBfieldMap *ptr) {
+static char *_build_value_string(eDBfieldMap *ptr) {
         char *reserved_datetime[] = {"CURRENT_TIMESTAMP", "CURRENT_TIME", "CURRENT_DATE", NULL};
         char *val = NULL;
 
@@ -335,6 +335,10 @@ char *_build_value_string(eDBfieldMap *ptr) {
                 val = sqlite3_mprintf("NULL");
                 break;
 
+        case ft_STRING_LOWER:
+                val = sqlite3_mprintf("lower('%q')", ptr->value);
+                break;
+
         case ft_PASSWD:
         case ft_STRING:
         default:
@@ -355,7 +359,7 @@ char *_build_value_string(eDBfieldMap *ptr) {
  * @return Returns a string with parts of the SQL query containing the dynamic variables on success,
  *         otherwise NULL is returned.
  */
-char *_build_sqlpart(int btyp, eDBfieldMap *map) {
+static char *_build_sqlpart(int btyp, eDBfieldMap *map) {
         eDBfieldMap *ptr = NULL;
         char *ret = NULL;
         char *fsep = NULL;
@@ -393,7 +397,13 @@ char *_build_sqlpart(int btyp, eDBfieldMap *map) {
                                 append_str(buf, ptr->table_alias, 8192);
                                 append_str(buf, ".", 8192);
                         }
-                        append_str(buf, ptr->field_name, 8192);
+                        if( (btyp == btWHERE) && ptr->field_type == ft_STRING_LOWER ) {
+                                append_str(buf, "lower(", 8192);
+                                append_str(buf, ptr->field_name, 8192);
+                                append_str(buf, ")", 8192);
+                        } else {
+                                append_str(buf, ptr->field_name, 8192);
+                        }
 
                         switch( ptr->filter_type ) {
                         case flt_LT: