static void
tested_operation_changed_cb (G_GNUC_UNUSED GdauiCombo *combo, DemoData *data)
{
GdaServerProvider *prov = NULL;
GdaServerOperationType type;
GError *error = NULL;
GdaDataModelIter *iter;
const GValue *cvalue = NULL;
if (data->op) {
g_object_unref (data->op);
data->op = NULL;
}
if (data->op_form)
gtk_widget_destroy (data->op_form);
gtk_widget_set_sensitive (data->show_button, FALSE);
gtk_widget_set_sensitive (data->sql_button, FALSE);
iter = gdaui_data_selector_get_data_set (GDAUI_DATA_SELECTOR (data->op_combo));
if (iter)
cvalue = gda_data_model_iter_get_value_at (iter, 0);
if (!cvalue || !gda_value_isa ((GValue *) cvalue, G_TYPE_INT)) {
GtkWidget *label;
label = gtk_label_new ("Select an operation to perform");
gtk_container_add (GTK_CONTAINER (data->op_container), label);
data->op_form = label;
gtk_widget_show (data->op_form);
return;
}
type = g_value_get_int ((GValue *) cvalue);
prov = get_provider_obj (data);
if (prov)
data->op = gda_server_provider_create_operation (prov, NULL, type, NULL, &error);
if (!data->op) {
GtkWidget *label;
gchar *str;
str = g_strdup_printf ("Can't create GdaServerOperation widget: %s",
error && error->message ? error->message : "No detail");
label = gtk_label_new (str);
g_free (str);
gtk_container_add (GTK_CONTAINER (data->op_container), label);
data->op_form = label;
}
else {
GtkWidget *wid;
wid = gdaui_server_operation_new (data->op);
gtk_container_add (GTK_CONTAINER (data->op_container), wid);
data->op_form = wid;
gtk_widget_set_sensitive (data->show_button, TRUE);
gtk_widget_set_sensitive (data->sql_button, TRUE);
}
gtk_widget_show (data->op_form);
}
/*
* Create a "products" table using a GdaServerOperation object
*/
void
create_table (GdaConnection *cnc)
{
GError *error = NULL;
GdaServerProvider *provider;
GdaServerOperation *op;
gchar *sql;
gint i;
/* create a new GdaServerOperation object */
provider = gda_connection_get_provider (cnc);
op = gda_server_provider_create_operation (provider, cnc, GDA_SERVER_OPERATION_CREATE_TABLE, NULL, &error);
if (!op) {
g_print ("CREATE TABLE operation is not supported by the provider: %s\n",
error && error->message ? error->message : "No detail");
exit (1);
}
/* Set parameter's values */
/* table name */
if (!gda_server_operation_set_value_at (op, "products", &error, "/TABLE_DEF_P/TABLE_NAME")) goto on_set_error;
/* "id' field */
i = 0;
if (!gda_server_operation_set_value_at (op, "id", &error, "/FIELDS_A/@COLUMN_NAME/%d", i)) goto on_set_error;
if (!gda_server_operation_set_value_at (op, "integer", &error, "/FIELDS_A/@COLUMN_TYPE/%d", i)) goto on_set_error;
if (!gda_server_operation_set_value_at (op, "TRUE", &error, "/FIELDS_A/@COLUMN_AUTOINC/%d", i)) goto on_set_error;
if (!gda_server_operation_set_value_at (op, "TRUE", &error, "/FIELDS_A/@COLUMN_PKEY/%d", i)) goto on_set_error;
/* 'product_name' field */
i++;
if (!gda_server_operation_set_value_at (op, "product_name", &error, "/FIELDS_A/@COLUMN_NAME/%d", i)) goto on_set_error;
if (!gda_server_operation_set_value_at (op, "varchar", &error, "/FIELDS_A/@COLUMN_TYPE/%d", i)) goto on_set_error;
if (!gda_server_operation_set_value_at (op, "50", &error, "/FIELDS_A/@COLUMN_SIZE/%d", i)) goto on_set_error;
if (!gda_server_operation_set_value_at (op, "TRUE", &error, "/FIELDS_A/@COLUMN_NNUL/%d", i)) goto on_set_error;
/* Show the SQL to execute
* This does not always work since some operations may not be accessible through SQL
*/
sql = gda_server_provider_render_operation (provider, cnc, op, &error);
if (!sql) {
g_print ("Error rendering SQL: %s\n",
error && error->message ? error->message : "No detail");
exit (1);
}
g_print ("SQL to execute: %s\n", sql);
g_free (sql);
/* Actually execute the operation */
if (! gda_server_provider_perform_operation (provider, cnc, op, &error)) {
g_print ("Error executing the operation: %s\n",
error && error->message ? error->message : "No detail");
exit (1);
}
g_object_unref (op);
return;
on_set_error:
g_print ("Error setting value in GdaSererOperation: %s\n",
error && error->message ? error->message : "No detail");
exit (1);
}
