[evolution-data-server/openismus-work: 108/122] tests: Verify upgrade to SQLite-only addressbook
- From: Tristan Van Berkom <tvb src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [evolution-data-server/openismus-work: 108/122] tests: Verify upgrade to SQLite-only addressbook
- Date: Mon, 17 Dec 2012 09:12:22 +0000 (UTC)
commit 73e13615f42ab794ba39e0a4a8021abd76ef7f08
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;
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]