r22449 - gnucash/trunk/src/backend/dbi/test - Add unittests for mysql and postgresql backends

[Geert Janssens]

Author: gjanssens
Date: 2012-10-26 04:49:41 -0400 (Fri, 26 Oct 2012)
New Revision: 22449
Trac: http://svn.gnucash.org/trac/changeset/22449

Modified:
   gnucash/trunk/src/backend/dbi/test/utest-backend-dbi-basic.c
Log:
Add unittests for mysql and postgresql backends

Modified: gnucash/trunk/src/backend/dbi/test/utest-backend-dbi-basic.c
===================================================================
--- gnucash/trunk/src/backend/dbi/test/utest-backend-dbi-basic.c	2012-10-18 08:15:21 UTC (rev 22448)
+++ gnucash/trunk/src/backend/dbi/test/utest-backend-dbi-basic.c	2012-10-26 08:49:41 UTC (rev 22449)
@@ -17,6 +17,8 @@
 void test_suite_gnc_backend_dbi_basic(void);
 
 void do_test_sqlite(void);
+void do_test_mysql(void);
+void do_test_pgsql(void);
 
 #define DBI_TEST_XML_FILENAME "test-dbi.xml"
 #define FILE_NAME "sqlite3:///tmp/test-sqlite3-file"
@@ -46,7 +48,45 @@
 }
 
 void
+do_test_mysql(void)
+{
+    gchar* filename;
+    QofSession* session_1;
+
+    g_test_log_set_fatal_handler(handler, 0);
+
+    // Create a session with data
+    session_1 = qof_session_new();
+    qof_session_begin( session_1, DBI_TEST_XML_FILENAME, FALSE, FALSE, FALSE );
+    qof_session_load( session_1, NULL );
+
+    g_test_message ( "Using database: %s\n", TEST_MYSQL_URL );
+    test_dbi_store_and_reload( "mysql", session_1, TEST_MYSQL_URL );
+}
+
+void
+do_test_pgsql(void)
+{
+    gchar* filename;
+    QofSession* session_1;
+
+    g_test_log_set_fatal_handler(handler, 0);
+
+    // Create a session with data
+    session_1 = qof_session_new();
+    qof_session_begin( session_1, DBI_TEST_XML_FILENAME, FALSE, FALSE, FALSE );
+    qof_session_load( session_1, NULL );
+
+    g_test_message ( "Using database: %s\n", TEST_PGSQL_URL );
+    test_dbi_store_and_reload( "postgres", session_1, TEST_PGSQL_URL );
+}
+
+void
 test_suite_gnc_backend_dbi_basic(void)
 {
     GNC_TEST_ADD_FUNC(suitename, "gnc dbi test sqlite", do_test_sqlite);
+    if ( strlen( TEST_MYSQL_URL ) > 0 )
+        GNC_TEST_ADD_FUNC(suitename, "gnc dbi test mysql", do_test_mysql);
+    if ( strlen( TEST_PGSQL_URL ) > 0 )
+        GNC_TEST_ADD_FUNC(suitename, "gnc dbi test pgsql", do_test_pgsql);
 }