Index: src/trackerd/tracker-db-sqlite.c =================================================================== --- src/trackerd/tracker-db-sqlite.c (revision 1330) +++ src/trackerd/tracker-db-sqlite.c (working copy) @@ -3346,6 +3346,9 @@ } id = tracker_db_interface_sqlite_get_last_insert_id (TRACKER_DB_INTERFACE_SQLITE (db_con->db)); + // XESAM TODO + // INSERT INTO Events (ServiceID, ..., EventType) VALUES (sid, ..., 'Create') + if (info->is_hidden) { tracker_db_exec_no_reply (db_con, "Update services set Enabled = 0 where ID = %d", @@ -3549,6 +3552,9 @@ tracker_exec_proc (db_con->common, "DeleteService7", path, name, NULL); tracker_exec_proc (db_con->common, "DeleteService9", path, name, NULL); + // XESAM TODO" + // INSERT INTO Events (ServiceID, ..., EventType) VALUES (str_file_id, ..., 'Delete') + g_free (name); g_free (path); } @@ -3637,8 +3643,16 @@ name = g_path_get_basename (info->uri); path = g_path_get_dirname (info->uri); + // Comment by Philip Van Hoof: + // Please verify that str_service_type_id must be the first argument. + // Reading the file sqlite-stored-procs.sql this doesn't seem to be + // true + tracker_exec_proc (db_con->index, "UpdateFile", str_service_type_id, path, name, info->mime, str_size, str_mtime, str_offset, str_file_id, NULL); - + + // XESAM TODO: + // INSERT INTO Events (ServiceID, ..., EventType) VALUES (str_file_id, ..., 'Update') + g_free (str_service_type_id); g_free (str_size); g_free (str_offset); @@ -4248,6 +4262,9 @@ /* update db so that fileID reflects new uri */ tracker_exec_proc (db_con, "UpdateFileMove", path, name, str_file_id, NULL); + // XESAM TODO: + // INSERT INTO Events (ServiceID, ..., EventType) VALUES (str_file_id, ..., 'Update') + /* update File:Path and File:Filename metadata */ tracker_db_set_single_metadata (db_con, "Files", str_file_id, "File:Path", path, FALSE); tracker_db_set_single_metadata (db_con, "Files", str_file_id, "File:Name", name, FALSE);