[evolution-data-server/openismus-work] tests: Verify upgrade to SQLite-only addressbook

[Mathias Hasselmann <hasselmm src gnome org>]

commit f64a057a35fecf074bbc324e438aad47706c93af
Author: Mathias Hasselmann <mathias openismus com>
Date:   Fri Dec 14 00:12:03 2012 +0100

    tests: Verify upgrade to SQLite-only addressbook

 tests/libebook/client/Makefile.am                 |    3 +++
 tests/libebook/data/dumps/0.2/addressbook.db_dump |   20 ++++++++++++++++++++
 tests/libebook/data/dumps/0.2/contacts.sql        |   15 +++++++++++++++
 3 files changed, 38 insertions(+), 0 deletions(-)
---
diff --git a/tests/libebook/client/Makefile.am b/tests/libebook/client/Makefile.am
index b8f6a10..e5f780e 100644
--- a/tests/libebook/client/Makefile.am
+++ b/tests/libebook/client/Makefile.am
@@ -50,6 +50,7 @@ TESTS =								\
 	test-client-remove-contacts				\
 	test-client-photo-is-uri				\
 	test-client-change-country-code				\
+	test-client-upgrade-addressbook				\
 	test-client-write-write					\
 	test-client-stress-factory--serial			\
 	test-client-stress-factory--fifo			\
@@ -120,6 +121,8 @@ test_client_photo_is_uri_LDADD=$(TEST_LIBS)
 test_client_photo_is_uri_CPPFLAGS=$(TEST_CPPFLAGS)
 test_client_change_country_code_LDADD=$(TEST_LIBS)
 test_client_change_country_code_CPPFLAGS=$(TEST_CPPFLAGS)
+test_client_upgrade_addressbook_LDADD=$(TEST_LIBS)
+test_client_upgrade_addressbook_CPPFLAGS=$(TEST_CPPFLAGS)
 test_client_write_write_LDADD=$(TEST_LIBS) $(top_builddir)/addressbook/libedata-book/libedata-book-1.2.la
 test_client_write_write_CPPFLAGS=$(TEST_CPPFLAGS)
 test_client_stress_factory__fifo_LDADD=$(TEST_LIBS)
diff --git a/tests/libebook/data/dumps/0.2/addressbook.db_dump b/tests/libebook/data/dumps/0.2/addressbook.db_dump
new file mode 100644
index 0000000..014fbe9
--- /dev/null
+++ b/tests/libebook/data/dumps/0.2/addressbook.db_dump
@@ -0,0 +1,20 @@
+VERSION=3
+format=print
+type=hash
+db_pagesize=4096
+HEADER=END
+ PAS-DB-VERSION\00
+ 0.2\00
+ pas-id-50C9E02500000057\00
+ BEGIN:VCARD\0d\0aVERSION:3.0\0d\0aUID:pas-id-50C9E02500000057\0d\0aFN:Upgrade Issue #1\0d\0aREV:2012-12-13T14:03:17Z\0d\0aEND:VCARD\00
+ pas-id-50C9E02500000059\00
+ BEGIN:VCARD\0d\0aVERSION:3.0\0d\0aUID:pas-id-50C9E02500000059\0d\0aFN:Upgrade Issue #3\0d\0aREV:2012-12-13T14:03:17Z\0d\0aEND:VCARD\00
+ pas-id-50C9E0250000005A\00
+ BEGIN:VCARD\0d\0aVERSION:3.0\0d\0aUID:pas-id-50C9E0250000005A\0d\0aFN:Upgrade Issue #4\0d\0aREV:2012-12-13T14:03:17Z\0d\0aEND:VCARD\00
+ PAS-DB-REVISION\00
+ 2012-12-13T14:03:17Z(4)\00
+ pas-id-50C9E02500000058\00
+ BEGIN:VCARD\0d\0aVERSION:3.0\0d\0aUID:pas-id-50C9E02500000058\0d\0aFN:Upgrade Issue #2\0d\0aREV:2012-12-13T14:03:17Z\0d\0aEND:VCARD\00
+ pas-id-50C9E0250000005B\00
+ BEGIN:VCARD\0d\0aVERSION:3.0\0d\0aUID:pas-id-50C9E0250000005B\0d\0aFN:Upgrade Issue #5\0d\0aREV:2012-12-13T14:03:17Z\0d\0aEND:VCARD\00
+DATA=END
diff --git a/tests/libebook/data/dumps/0.2/contacts.sql b/tests/libebook/data/dumps/0.2/contacts.sql
new file mode 100644
index 0000000..233b54a
--- /dev/null
+++ b/tests/libebook/data/dumps/0.2/contacts.sql
@@ -0,0 +1,15 @@
+PRAGMA foreign_keys=OFF;
+BEGIN TRANSACTION;
+CREATE TABLE folders( folder_id  TEXT PRIMARY KEY, folder_name TEXT,  sync_data TEXT, is_populated INTEGER,  partial_content INTEGER, version INTEGER);
+INSERT INTO "folders" VALUES('folder_id','folder',NULL,1,0,1);
+CREATE TABLE keys( key TEXT PRIMARY KEY, value TEXT, folder_id TEXT REFERENCES folders);
+CREATE TABLE 'folder_id' ( uid TEXT PRIMARY KEY, rev TEXT, file_as TEXT, nickname TEXT, full_name TEXT, given_name TEXT, family_name TEXT, email_1 TEXT, email_2 TEXT, email_3 TEXT, email_4 TEXT, is_list INTEGER, list_show_addresses INTEGER, wants_html INTEGER, vcard TEXT, bdata TEXT);
+INSERT INTO "folder_id" VALUES('pas-id-50C9E02500000057','2012-12-13T14:03:17Z',NULL,NULL,'Upgrade Issue #1',NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,NULL);
+INSERT INTO "folder_id" VALUES('pas-id-50C9E02500000058','2012-12-13T14:03:17Z',NULL,NULL,'Upgrade Issue #2',NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,NULL);
+INSERT INTO "folder_id" VALUES('pas-id-50C9E02500000059','2012-12-13T14:03:17Z',NULL,NULL,'Upgrade Issue #3',NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,NULL);
+INSERT INTO "folder_id" VALUES('pas-id-50C9E0250000005A','2012-12-13T14:03:17Z',NULL,NULL,'Upgrade Issue #4',NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,NULL);
+INSERT INTO "folder_id" VALUES('pas-id-50C9E0250000005B','2012-12-13T14:03:17Z',NULL,NULL,'Upgrade Issue #5',NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,NULL);
+CREATE INDEX keysindex ON keys(folder_id);
+CREATE INDEX 'FNINDEX-folder_id' ON 'folder_id' (full_name);
+CREATE INDEX 'EMINDEX-folder_id' ON 'folder_id' (email_1);
+COMMIT;