evolution-data-server r8710 - branches/camel-db-summary/camel/db-scrap-tools

[psankar svn gnome org]

Author: psankar
Date: Wed Apr 30 06:11:55 2008
New Revision: 8710
URL: http://svn.gnome.org/viewvc/evolution-data-server?rev=8710&view=rev

Log:
Revert "Added scrap files to test db basic operations"

This reverts commit 14916378faea759628ce03bc66089930a4092a59.

Conflicts:


Modified:
   branches/camel-db-summary/camel/db-scrap-tools/db.c
   branches/camel-db-summary/camel/db-scrap-tools/test.db

Modified: branches/camel-db-summary/camel/db-scrap-tools/db.c
==============================================================================
--- branches/camel-db-summary/camel/db-scrap-tools/db.c	(original)
+++ branches/camel-db-summary/camel/db-scrap-tools/db.c	Wed Apr 30 06:11:55 2008
@@ -91,8 +91,10 @@
 
 	sqlite3_create_collation(db, "uidcmp", SQLITE_UTF8,  NULL, sort_cmp);
 	sqlite3_create_collation(db, "uidsort", SQLITE_UTF8,  NULL, sort_uid);
+
+	char *subject_san = "San?%*()-234 #$!@#$ #$%32424kar's Subject";
 	create_table ("table1");
-	sql_stmt ("INSERT INTO table1 (uid, gflags, isize, jsubject, mlist) VALUES ('5120', 100, 123, 'nice subject', 'mlistbinary')");
+	sql_stmt (sqlite3_mprintf("INSERT INTO table1 (uid, gflags, isize, jsubject, mlist) VALUES ('5120', 100, 123, '%q', 'mlistbinary')", subject_san));
 	sql_stmt ("INSERT INTO table1 (uid, gflags, isize, jsubject, mlist) VALUES ('6103', 100, 123, 'nice subject', 'mlistbinary')");
 	sql_stmt ("INSERT INTO table1 (uid, gflags, isize, jsubject, mlist) VALUES ('3194', 100, 123, 'nice subject', 'mlistbinary')");
 	sql_stmt ("INSERT INTO table1 (uid, gflags, isize, jsubject, mlist) VALUES ('8130', 100, 123, 'nice subject', 'mlistbinary')");
@@ -104,6 +106,7 @@
 	
 //	select_stmt ("select * from table1 where uid collate uidsort order by uid collate uidsort");
 	select_stmt ("select * from table1 where uid == 5120 collate uidcmp");
+	printf ("\n\aFrom teh C File: [%s] \n\a", subject_san);
 
 	printf("------\n");
 	select_stmt ("select count(isize) from table1");

Modified: branches/camel-db-summary/camel/db-scrap-tools/test.db
==============================================================================
Binary files branches/camel-db-summary/camel/db-scrap-tools/test.db	(original) and branches/camel-db-summary/camel/db-scrap-tools/test.db	Wed Apr 30 06:11:55 2008 differ