tracker r1793 - branches/indexer-split/tests/libtracker-db

[pvanhoof svn gnome org]

Author: pvanhoof
Date: Fri Jun 27 11:56:44 2008
New Revision: 1793
URL: http://svn.gnome.org/viewvc/tracker?rev=1793&view=rev

Log:
Added comparision test

Modified:
   branches/indexer-split/tests/libtracker-db/union-performance.c

Modified: branches/indexer-split/tests/libtracker-db/union-performance.c
==============================================================================
--- branches/indexer-split/tests/libtracker-db/union-performance.c	(original)
+++ branches/indexer-split/tests/libtracker-db/union-performance.c	Fri Jun 27 11:56:44 2008
@@ -6,9 +6,8 @@
 #include "tracker-db-manager-common.h"
 
 
-
 static void
-test_union_performance_xesam ()
+test_union_performance_xesam_view ()
 {
 	TrackerDBInterface *iface;
 	TrackerDBResultSet *result_set;
@@ -57,6 +56,52 @@
 }
 
 
+static void
+test_union_performance_xesam_union ()
+{
+	TrackerDBInterface *iface;
+	TrackerDBResultSet *result_set;
+	GError             *error = NULL;
+
+	iface = tracker_db_manager_get_db_interfaces (7, TRACKER_DB_COMMON,
+												  TRACKER_DB_XESAM,
+												  TRACKER_DB_FILE_METADATA,
+												  TRACKER_DB_FILE_CONTENTS,
+												  TRACKER_DB_EMAIL_CONTENTS,
+												  TRACKER_DB_EMAIL_METADATA,
+												  TRACKER_DB_CACHE);
+
+	g_assert (iface);
+
+	g_assert (!error);
+
+	/* TODO: Start timer  */
+	result_set = tracker_db_interface_execute_query (iface, &error,
+		"SELECT M0.MetaDataValue "
+		"FROM 'file-meta'.Services S "
+		"INNER JOIN 'file-meta'.ServiceMetaData M0 ON (S.ID = M0.ServiceID and " 
+		"M0.MetaDataID in (82)) WHERE (S.ServiceTypeID in (select TypeId from " 
+		"ServiceTypes where TypeName = 'Files' or Parent = 'Files')) AND "
+		" (  (M0.MetaDataValue like '%%test%%')  ) "
+
+		"UNION "
+
+		"SELECT M0.MetaDataValue "
+		"FROM 'email-meta'.Services S "
+		"INNER JOIN 'email-meta'.ServiceMetaData M0 ON (S.ID = M0.ServiceID and " 
+		"M0.MetaDataID in (82)) WHERE (S.ServiceTypeID in (select TypeId from " 
+		"ServiceTypes where TypeName = 'Files' or Parent = 'Files')) AND "
+		" (  (M0.MetaDataValue like '%%test%%')  ) ");
+
+	/* TODO:  Stop timer  */
+	if (result_set)
+		g_object_unref (result_set);
+
+	g_assert (!error);
+
+	g_object_unref (iface);
+}
+
 
 int
 main (int argc, char **argv) 
@@ -73,7 +118,10 @@
 							 &first_time);
 
 	g_test_add_func ("/libtracker-db/union-performance/xesam",
-					 test_union_performance_xesam);
+					 test_union_performance_xesam_view);
+
+	g_test_add_func ("/libtracker-db/union-performance/xesam",
+					 test_union_performance_xesam_union);
 
 	result = g_test_run ();