tracker r2774 - in trunk: . src/libtracker-data

[carlosg svn gnome org]

Author: carlosg
Date: Thu Jan  8 15:52:17 2009
New Revision: 2774
URL: http://svn.gnome.org/viewvc/tracker?rev=2774&view=rev

Log:
2009-01-08  Carlos Garnacho  <carlos imendio com>

        * src/libtracker-data/tracker-data-update.c
        (tracker_data_update_create_service)
        (tracker_data_update_set_metadata): Store all dates in the DB as unix
        times.

Modified:
   trunk/ChangeLog
   trunk/src/libtracker-data/tracker-data-update.c

Modified: trunk/src/libtracker-data/tracker-data-update.c
==============================================================================
--- trunk/src/libtracker-data/tracker-data-update.c	(original)
+++ trunk/src/libtracker-data/tracker-data-update.c	Thu Jan  8 15:52:17 2009
@@ -164,7 +164,7 @@
 	TrackerDBInterface *iface;
 	TrackerDBResultSet *result_set;
 	guint32	volume_id = 0;
-	gchar *id_str, *service_type_id_str, *path, *volume_id_str;
+	gchar *id_str, *service_type_id_str, *path, *volume_id_str, *time_str;
 	gboolean is_dir, is_symlink;
 
 	if (!service) {
@@ -194,6 +194,7 @@
 
 	is_dir = g_file_test (path, G_FILE_TEST_IS_DIR);
 	is_symlink = g_file_test (path, G_FILE_TEST_IS_SYMLINK);
+	time_str = tracker_date_to_time_string (g_hash_table_lookup (metadata, "File:Modified"));
 
 	tracker_db_interface_execute_procedure (iface, NULL, "CreateService",
 						id_str,
@@ -205,7 +206,7 @@
 						is_dir ? "1" : "0",
 						is_symlink ? "1" : "0",
 						"0", /* Offset */
-						g_hash_table_lookup (metadata, "File:Modified"),
+						time_str,
 						volume_id_str, /* Aux ID */
 						NULL);
 
@@ -213,6 +214,7 @@
 	g_free (service_type_id_str);
 	g_free (volume_id_str);
 	g_free (path);
+	g_free (time_str);
 
 	return TRUE;
 }
@@ -428,15 +430,20 @@
 	metadata_key = tracker_ontology_service_get_key_metadata (tracker_service_get_name (service),
 								  tracker_field_get_name (field));
 	if (metadata_key > 0) {
-		gchar *escaped_value;
+		gchar *val;
+
+		if (tracker_field_get_data_type (field) == TRACKER_FIELD_TYPE_DATE) {
+			val = tracker_date_to_time_string (value);
+		} else {
+			val = tracker_escape_string (value);
+		}
 
-		escaped_value = tracker_escape_string (value);
 		tracker_db_interface_execute_query (iface, NULL,
 						    "update Services set KeyMetadata%d = '%s' where id = %d",
 						    metadata_key,
-						    escaped_value,
+						    val,
 						    service_id);
-		g_free (escaped_value);
+		g_free (val);
 	}
 
 	g_free (id_str);