[tracker/wip/carlosg/serialize-api: 37/53] libtracker-data: Use SQL value type as a last resort to determine column type

[Carlos Garnacho <carlosg src gnome org>]

commit 3e17a49a4747fbfe74ab73a75b31b310092811f9
Author: Carlos Garnacho <carlosg gnome org>
Date:   Sun Nov 21 11:34:53 2021 +0100

    libtracker-data: Use SQL value type as a last resort to determine column type
    
    Since all values in SQLite are neatly transformable to strings, we resorted
    to those if we could not know the underlying type. Look up the SQLite value
    type for that column as a last resort, so we have better chances of getting
    it right.

 src/libtracker-data/tracker-db-interface-sqlite.c | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)
---
diff --git a/src/libtracker-data/tracker-db-interface-sqlite.c 
b/src/libtracker-data/tracker-db-interface-sqlite.c
index b73d10b3a..4978b9b55 100644
--- a/src/libtracker-data/tracker-db-interface-sqlite.c
+++ b/src/libtracker-data/tracker-db-interface-sqlite.c
@@ -3607,7 +3607,14 @@ tracker_db_cursor_get_value_type (TrackerDBCursor *cursor,
                }
        }
 
-        return TRACKER_SPARQL_VALUE_TYPE_STRING;
+       switch (column_type) {
+       case SQLITE_INTEGER:
+               return TRACKER_SPARQL_VALUE_TYPE_INTEGER;
+       case SQLITE_FLOAT:
+               return TRACKER_SPARQL_VALUE_TYPE_DOUBLE;
+       default:
+               return TRACKER_SPARQL_VALUE_TYPE_STRING;
+       }
 }
 
 const gchar*