From 2febff178831c3ad5121b82d330467b2b2ac409c Mon Sep 17 00:00:00 2001
From: Andrea Zagli <azagli@libero.it>
Date: Sun, 25 Nov 2012 10:42:37 +0100
Subject: [PATCH] Used GdaServerOperation to drop tables/views.

---
 .anjuta_sym_db.db | Bin 36864 -> 36864 bytes
 src/main.c        |  78 ++++++++++++++++++++++++++++++++++++----------
 tests/db.db       | Bin 3072 -> 3072 bytes
 3 files changed, 62 insertions(+), 16 deletions(-)

diff --git a/.anjuta_sym_db.db b/.anjuta_sym_db.db
index ae8119988f733c8bc0f0a4e628a02a4f71866ffe..63a109627e1ec22d05f954f6d9479ef14d9e05c9 100644
GIT binary patch
delta 56
zcmZozz|^pSX@WGP+e8^>Mz@U#v!z)~46O_||Cc@^#l$2$`K(zH<HgMm=DFdF7bmal
LTM7~j?OzQ58x|BA

delta 56
zcmZozz|^pSX@WGP(L@<%Mx%`hv!z*#jIB&I|Cc@^#l-k$@>#PY#>JZ*%yYvT7f)W-
Lw-h86+P@kADjyYT

diff --git a/src/main.c b/src/main.c
index 9a03c04..ea90fb3 100644
--- a/src/main.c
+++ b/src/main.c
@@ -424,15 +424,38 @@ read_tables ()
 
 					if (drop_tables)
 						{
-							gchar *sql;
-
-							sql = g_strdup_printf ("DROP TABLE %s",
-							                       table->name);
-							gda_connection_execute_non_select_command (gda_conn_db,
-							                                           sql,
-							                                           NULL);
+							error = NULL;
+							op = gda_connection_create_operation (gda_conn_db, GDA_SERVER_OPERATION_DROP_TABLE, NULL, &error);
+							if (op == NULL
+							    || error != NULL)
+								{
+									g_warning ("Error on creating GdaServerOperation: %s.",
+									           error != NULL && error->message != NULL ? error->message : "no details");
+								}
+							else
+								{
+									error = NULL;
+									if (!gda_server_operation_set_value_at (op, table->name, &error, 
+									                                        "/TABLE_DESC_P/TABLE_NAME"))
+										{
+											g_warning ("Error on setting GdaServerOperation's value: %s.",
+											           error != NULL && error->message != NULL ? error->message : "no details");
+										}
+									else
+										{
+											error = NULL;
+											if (!gda_connection_perform_operation (gda_conn_db, op, &error))
+												{
+													g_warning ("Error on performing GdaServerOperation: %s.",
+													           error != NULL && error->message != NULL ? error->message : "no details");
+											}
+										}
+								}
 
-							g_free (sql);
+							if (op != NULL)
+								{
+									g_object_unref (op);
+								}
 						}
 
 					/* sql builder for insert into */
@@ -550,15 +573,38 @@ read_views ()
 
 					if (drop_tables)
 						{
-							gchar *sql;
-
-							sql = g_strdup_printf ("DROP VIEW %s",
-							                       view_name);
-							gda_connection_execute_non_select_command (gda_conn_db,
-							                                           sql,
-							                                           NULL);
+							error = NULL;
+							op = gda_connection_create_operation (gda_conn_db, GDA_SERVER_OPERATION_DROP_VIEW, NULL, &error);
+							if (op == NULL
+							    || error != NULL)
+								{
+									g_warning ("Error on creating GdaServerOperation: %s.",
+									           error != NULL && error->message != NULL ? error->message : "no details");
+								}
+							else
+								{
+									error = NULL;
+									if (!gda_server_operation_set_value_at (op, view_name, &error, 
+									                                        "/VIEW_DESC_P/VIEW_NAME"))
+										{
+											g_warning ("Error on setting GdaServerOperation's value: %s.",
+											           error != NULL && error->message != NULL ? error->message : "no details");
+										}
+									else
+										{
+											error = NULL;
+											if (!gda_connection_perform_operation (gda_conn_db, op, &error))
+												{
+													g_warning ("Error on performing GdaServerOperation: %s.",
+													           error != NULL && error->message != NULL ? error->message : "no details");
+											}
+										}
+								}
 
-							g_free (sql);
+							if (op != NULL)
+								{
+									g_object_unref (op);
+								}
 						}
 
 					error = NULL;
diff --git a/tests/db.db b/tests/db.db
index 86481fb785ce84b99270de96b8a2cfd0b4e5c059..d6c7e7119b23df6253eb0ca93b99e8077c213c6e 100644
GIT binary patch
delta 85
zcmZpWXpop7Ex4Y6fq@x_nIM=kX`+s?@OlQ_M{2x45e62Z%nl%o-W<sMhLJILVq^5=
eT}+cEPEcc<II(dGD<e=1Gf-|D%jN`TJ7xgx5)=;r

delta 80
zcmZpWXpop7EjX8ffq@x{nHU%t!zSt&3(sZHeWb<<6lGum%6c;GVA`=+kmWTa6XVi}
ajnR{LF->CJ4iwnM!paC#!vti0VFmzW`4K(<

-- 
2.49.0