/* this function is executed in a sub thread */
gboolean *
sub_thread_update_meta_store (GdaConnection *cnc, GError **error)
{
gboolean *result;
result = g_new (gboolean, 1);
*result = gda_connection_update_meta_store (cnc, NULL, error);
return result;
}
/*
* Test 1: gda_connection_open() when there is no error
*/
static guint
test1 (void)
{
g_print ("============= %s started =============\n", __FUNCTION__);
GdaConnection *cnc;
GError *error = NULL;
gchar *cnc_string, *fname;
fname = g_build_filename (ROOT_DIR, "data", NULL);
cnc_string = g_strdup_printf ("DB_DIR=%s;DB_NAME=sales_test", fname);
g_free (fname);
cnc = gda_connection_new_from_string ("SQLite", cnc_string, NULL,
GDA_CONNECTION_OPTIONS_READ_ONLY, NULL);
if (!cnc) {
g_print ("gda_connection_new_from_string([%s]) failed: %s\n", cnc_string,
error && error->message ? error->message : "No detail");
g_free (cnc_string);
return 1;
}
guint counter = 0;
setup_main_context (cnc, &counter);
/* connection open */
if (! gda_connection_open (cnc, &error)) {
g_print ("gda_connection_open([%s]) failed: %s\n", cnc_string,
error && error->message ? error->message : "No detail");
g_free (cnc_string);
return 1;
}
g_free (cnc_string);
if (counter == 0) {
g_print ("gda_connection_open() failed: did not make GMainContext 'run'\n");
return 1;
}
else
g_print ("Counter incremented to %u\n", counter);
g_print ("Connection %p Opened\n", cnc);
/* Update meta store */
counter = 0;
if (! gda_connection_update_meta_store (cnc, NULL, &error)) {
g_print ("gda_connection_update_meta_store () failed: %s\n",
error && error->message ? error->message : "No detail");
return 1;
}
if (counter == 0) {
g_print ("gda_connection_update_meta_store() failed: did not make GMainContext 'run'\n");
g_object_unref (cnc);
return 1;
}
else
g_print ("Counter incremented to %u\n", counter);
/* get meta data */
counter = 0;
GdaDataModel *model;
model = gda_connection_get_meta_store_data (cnc, GDA_CONNECTION_META_TABLES, &error, 0);
if (!model) {
g_print ("gda_connection_get_meta_store_data () failed: %s\n",
error && error->message ? error->message : "No detail");
return 1;
}
if (counter == 0) {
g_print ("gda_connection_get_meta_store_data() failed: did not make GMainContext 'run'\n");
g_object_unref (cnc);
return 1;
}
else
g_print ("Counter incremented to %u\n", counter);
gda_data_model_dump (model, NULL);
g_object_unref (model);
g_object_unref (cnc);
return 0;
}
int
main (G_GNUC_UNUSED int argc, G_GNUC_UNUSED char** argv)
{
xmlDocPtr doc;
xmlNodePtr root, node;
gint failures = 0;
gint ntests = 0;
gchar *fname;
gda_init ();
/* open connection */
gchar *cnc_string;
fname = g_build_filename (ROOT_DIR, "data", NULL);
cnc_string = g_strdup_printf ("DB_DIR=%s;DB_NAME=sales_test", fname);
g_free (fname);
cnc = gda_connection_open_from_string ("SQLite", cnc_string, NULL,
GDA_CONNECTION_OPTIONS_READ_ONLY, NULL);
if (!cnc) {
g_print ("Failed to open connection, cnc_string = %s\n", cnc_string);
exit (1);
}
if (!gda_connection_update_meta_store (cnc, NULL, NULL)) {
g_print ("Failed to update meta store, cnc_string = %s\n", cnc_string);
exit (1);
}
g_free (cnc_string);
/* load file */
fname = g_build_filename (ROOT_DIR, "tests", "parser", "testvalid.xml", NULL);
if (! g_file_test (fname, G_FILE_TEST_EXISTS)) {
g_print ("File '%s' does not exist\n", fname);
exit (1);
}
/* use test data */
doc = xmlParseFile (fname);
g_free (fname);
g_assert (doc);
root = xmlDocGetRootElement (doc);
g_assert (!strcmp ((gchar*) root->name, "testdata"));
for (node = root->children; node; node = node->next) {
if (strcmp ((gchar*) node->name, "test"))
continue;
xmlNodePtr snode;
xmlChar *sql = NULL;
xmlChar *id;
gboolean valid = FALSE;
id = xmlGetProp (node, BAD_CAST "id");
for (snode = node->children; snode; snode = snode->next) {
if (!strcmp ((gchar*) snode->name, "sql")) {
sql = xmlNodeGetContent (snode);
xmlChar *prop;
prop = xmlGetProp (snode, (const xmlChar*) "valid");
if (prop) {
if ((*prop == 't') || (*prop == 'T') || (*prop == '1'))
valid = TRUE;
xmlFree (prop);
}
}
}
if (sql) {
if (!do_test (id, sql, valid))
failures++;
ntests++;
}
/* mem free */
if (sql) xmlFree (sql);
if (id) xmlFree (id);
}
xmlFreeDoc (doc);
g_print ("TESTS COUNT: %d\n", ntests);
g_print ("FAILURES: %d\n", failures);
return failures != 0 ? 1 : 0;
}
int
main (int argc, char *argv[])
{
gda_init ();
GdaConnection *cnc;
GError *error = NULL;
GdaStatement *stmt;
GdaDataModel *model;
gchar *str;
GValue *name;
/* open connection */
cnc = open_connection ();
/* begin transaction */
if (! gda_connection_begin_transaction (cnc, NULL, GDA_TRANSACTION_ISOLATION_UNKNOWN,
&error)) {
g_print ("Could not begin transaction: %s\n",
error && error->message ? error->message : "No detail");
exit (1);
}
/* execute SELECT */
stmt = gda_sql_parser_parse_string (parser, "SELECT id, name FROM customers ORDER BY id", NULL, NULL);
g_assert (stmt);
model = gda_connection_statement_execute_select (cnc, stmt, NULL, &error);
g_object_unref (stmt);
if (!model) {
g_print ("Could not execute SELECT statement: %s\n",
error && error->message ? error->message : "No detail");
exit (1);
}
g_print ("** Data model is:\n");
gda_data_model_dump (model, stdout);
/*
* make sure the mete data is up to date
*/
g_print ("Computing meta data, this may take a while; in real applications, this should be cached to avoid waiting\n");
if (! gda_connection_update_meta_store (cnc, NULL, &error)) {
g_print ("Could not fetch meta data: %s\n",
error && error->message ? error->message : "No detail");
exit (1);
}
/*
* Make the data model compute the modification statements which
* will actually be executed when the data model is modified
*/
if (! gda_data_select_compute_modification_statements (GDA_DATA_SELECT (model), &error)) {
g_print ("Could not compute modification statements: %s\n",
error && error->message ? error->message : "No detail");
exit (1);
}
g_object_get (G_OBJECT (model), "update-stmt", &stmt, NULL);
str = gda_statement_to_sql (stmt, NULL, NULL);
g_print ("Computed UPDATE: %s\n", str);
g_free (str);
g_object_unref (stmt);
g_object_get (G_OBJECT (model), "delete-stmt", &stmt, NULL);
str = gda_statement_to_sql (stmt, NULL, NULL);
g_print ("Computed DELETE: %s\n", str);
g_free (str);
g_object_unref (stmt);
g_object_get (G_OBJECT (model), "insert-stmt", &stmt, NULL);
str = gda_statement_to_sql (stmt, NULL, NULL);
g_print ("Computed INSERT: %s\n", str);
g_free (str);
g_object_unref (stmt);
/*
* remove row 0 (1st row)
*/
g_print ("\n\n** Removing row 0\n");
if (! gda_data_model_remove_row (model, 0, &error)) {
g_print ("Could not remove row 0: %s\n",
error && error->message ? error->message : "No detail");
exit (1);
}
g_print ("** Data model is now:\n");
gda_data_model_dump (model, stdout);
g_print ("** Table's contents is now:\n");
display_customers (cnc);
/*
* add a row: the row's values is a list of GValue pointers
* (or NULL pointers where the default value should be inserted
*/
GList *list;
g_print ("\n\n** Adding a row\n");
list = g_list_append (NULL, NULL);
g_value_set_string ((name = gda_value_new (G_TYPE_STRING)), "Hiro");
list = g_list_append (list, name);
if (gda_data_model_append_values (model, list, &error) == -1) {
g_print ("Could not add a row: %s\n",
error && error->message ? error->message : "No detail");
exit (1);
}
gda_value_free (name);
g_list_free (list);
g_print ("** Data model is now:\n");
gda_data_model_dump (model, stdout);
g_print ("** Table's contents is now:\n");
display_customers (cnc);
/*
* alter row 2
*/
g_print ("\n\n** Modifying row 2\n");
g_value_set_string ((name = gda_value_new (G_TYPE_STRING)), "Tom");
if (! gda_data_model_set_value_at (model, 1, 2, name, &error)) {
g_print ("Could not modify row 2: %s\n",
error && error->message ? error->message : "No detail");
exit (1);
}
gda_value_free (name);
g_print ("** Data model is now:\n");
gda_data_model_dump (model, stdout);
g_print ("** Table's contents is now:\n");
display_customers (cnc);
/* rollback transaction */
gda_connection_rollback_transaction (cnc, NULL, NULL);
gda_connection_close (cnc);
return 0;
}
