From 7ce618b6866b649dbf9ac8f9b3f6d1b86c3bf8fc Mon Sep 17 00:00:00 2001
From: Andrea Zagli <azagli@libero.it>
Date: Sun, 16 Sep 2012 10:41:19 +0200
Subject: [PATCH] Reading tables of reference and compared databases.

---
 .anjuta_sym_db.db | Bin 34816 -> 34816 bytes
 src/main.c        |  62 ++++++++++++++++++++++++++++++++++++++++++++++
 tests/refdb.db    | Bin 2048 -> 3072 bytes
 3 files changed, 62 insertions(+)

diff --git a/.anjuta_sym_db.db b/.anjuta_sym_db.db
index 583328c4d8a71eefbb76f043a9aa9ea6b1d49f2b..47502246193c39b910552aac7b492894091fdb2f 100644
GIT binary patch
delta 758
zcmZXRO=uHA7=~x&-K4u~Xxf<CR-0%W`eQU0Eu~O}8glTY;7O#~y3MW<Y<Alw5q}Og
zC<LK_guV7qyy&42;-0*<QU!0NrH35s!9dVMQG2lmA<h;8X|gbTnEAfvd*+>`JX^}M
z{297d=!?>|(u21rP8ErW9K`{uC}RsBv5HOPtWF^fGw1Ff03k%?i+_>>-8309<~7J|
z=%vYLiCJS#wzk|OF7a}BVsva`Ec~HQ@Onk&ci;{C#)@#`7QV6s^OrJC_VT9OL8Jhc
zu69w;7mz3w7d1tlNhz~)T5@vahN?sjUDsl%xS^j5K2nvKp`U+Z#8o^@>qol{^|jh{
ziQ__4A~r5$<I?l0lG0`pT1rW#j74qOZf5mnPxEoDW)`pfrc>tXsOlB5Kw#ky_OOB-
zEMNn#OPRa4;BnZh4U;G3ZihXt88<AME8`J5W$ld*U6g@sg1`8VZL3q<#I<&S1R5wO
z8AzxZ(MCbK5=vaRLkD&U4!KK(6Fy_mjX<LYya=^8FzfKK%f+8yonRSXSQYK~$=2}>
z_ez=fY-rFKkbK85^>iB4WV8DG4jm{&{NYQ^kmPF}Q*Ubam#pO%PX(T3ncyGx@dFi}
z!2!>-%<r%PS%657ev(;v)z1rq1iuhO0lSz+6rWHmWjyHZ5x8Z2$}zR+>}m6U_AKow
SM7(~Vz~$;?Eiz^?d;32WQtIOX

delta 422
zcmX|7JxD@P6u$R<Pkov6kSs}qC?W-e$|%X9FqfvFmX?ZshbSwMpdSYx4H78$xT}M-
zwDowst*r*3C4y>js6~((>~GPbp=(&@aL#u)-{G8(lgzSYmSw#(p>;-S!dN<OZa*h7
zG6Y{Jqlh~ckjEu5rc>Gj&nVqJgb;^_U$fiLLE{Ipm7OhFw!qyKU)|YVH}4d`LmnIp
z2SeeJp^Hw*<+3u}f)n<{bSRj{4I5wshU#V#n#rW51{HySTQN>1G&Lj%l(-)Jpgx`-
zUUONIBQWuaXXJ2?D?H%AQ0L)Cfq4G}HBhwVM%nvM@mwfEedcqhuir{hC8(OtsR~+c
z6r?S-ys>Q;qZBoQnjqd_);1jup}b6xMuC;lf>)f?-B52CFCWg)SxxPu0ZsLp>7#u~
zNGuV2qk<QdP!%sMqG&qhE7(yX7I9D{UOMg;gHeKaJYo@1TtlzBp$5PgQy#vM>Y}4s
N#6!JW#Le~8%nwgCZxjFk

diff --git a/src/main.c b/src/main.c
index 547d053..621cd1d 100644
--- a/src/main.c
+++ b/src/main.c
@@ -35,6 +35,58 @@ static GOptionEntry entries[] =
 	{ NULL }
 };
 
+static void
+update_metastore ()
+{
+	GError *error;
+
+	GdaMetaContext mcontext = {"_tables", 0, NULL, NULL};
+
+	g_message ("Updating metastores.");
+
+	error = NULL;
+	if (!gda_connection_update_meta_store (gda_conn_ref_db, &mcontext, &error))
+		{
+			g_warning ("Unable to update reference database metastore: %s",
+			           (error != NULL && error->message != NULL ? error->message : "no details."));
+		}
+
+	error = NULL;
+	if (!gda_connection_update_meta_store (gda_conn_db, &mcontext, &error))
+		{
+			g_warning ("Unable to update database metastore: %s",
+			           (error != NULL && error->message != NULL ? error->message : "no details."));
+		}
+}
+
+static void
+read_tables (GdaConnection *gdacon)
+{
+	GError *error;
+
+	GdaDataModel *dm_tables;
+
+	guint rows;
+	guint row;
+
+	gchar *table_name;
+
+	error = NULL;
+	dm_tables = gda_connection_get_meta_store_data (gdacon,
+	                                                GDA_CONNECTION_META_TABLES,
+	                                                &error,
+	                                                0);
+	if (dm_tables != NULL && error == NULL)
+		{
+			rows = gda_data_model_get_n_rows (dm_tables);
+			for (row = 0; row < rows; row++)
+				{
+					table_name = gda_value_stringify (gda_data_model_get_value_at (dm_tables, 0, row, NULL));
+					g_message ("Table: %s", table_name);
+				}
+		}
+}
+
 int
 main (int argc, char *argv[])
 {
@@ -63,6 +115,8 @@ main (int argc, char *argv[])
 			return 1;
 		}
 
+	g_message ("Connecting to databases.");
+
 	error = NULL;
 	gda_conn_ref_db = gda_connection_open_from_string (NULL, ref_db_cnc, NULL,
 	                                       GDA_CONNECTION_OPTIONS_NONE,
@@ -85,6 +139,14 @@ main (int argc, char *argv[])
 			return;
 		}
 
+	update_metastore ();
+
+	g_message ("Reading tables of reference database.");
+	read_tables (gda_conn_ref_db);
+
+	g_message ("Reading tables of database.");
+	read_tables (gda_conn_db);
+
 	g_object_unref (gda_conn_ref_db);
 	g_object_unref (gda_conn_db);
 
diff --git a/tests/refdb.db b/tests/refdb.db
index 9831ee9ed9ac7c1e57b3a448a1750eb81d7c9e3d..81a6e21fec7986cb58e9e4f99691f8c2ac396241 100644
GIT binary patch
delta 149
zcmZn=Xpop7Ey%*az`zW|Fu*cV#~3K6`$&}+D8$4xi-9?iY1YO<Ehh6u6DD?Xd3nYr
z^OD4*oYdsf;*$K_)S_ZIgV{OA)iK0XA;i(i$5jC)Jh_QEQ68o?z92ibQXwG7)7LR5
XQo-9bQb8j#MN@NgAoF^bMJy};<)<hE

delta 53
zcmZpWXb_knEy&2gz`z8=Fu*ub$C#gyLHCg=FHne)Igo)laI+xGW2Vi4%<EYIw8aQI

-- 
2.49.0