From 6959d044528ac4883ee39280b15cb1766c0f6061 Mon Sep 17 00:00:00 2001 From: Andrea Zagli Date: Sun, 25 Nov 2012 09:34:19 +0100 Subject: [PATCH] Added command line parameter output-file. --- .anjuta/session/anjuta.session | 10 ++--- .anjuta/session/dock-layout.xml | 4 +- .anjuta_sym_db.db | Bin 34816 -> 36864 bytes src/main.c | 66 ++++++++++++++++++++++++++++++++ tests/db.db | Bin 3072 -> 3072 bytes 5 files changed, 72 insertions(+), 8 deletions(-) diff --git a/.anjuta/session/anjuta.session b/.anjuta/session/anjuta.session index f6b6037..7e38a96 100644 --- a/.anjuta/session/anjuta.session +++ b/.anjuta/session/anjuta.session @@ -2,16 +2,16 @@ Maximized=1 Geometry=1024x687+0+24 +[Project Manager] +Shortcut=gdadbcopy//src//gdadbcopy +Expand=gdadbcopy + [File Loader] -Files=../../src/main.c#10 +Files=../../src/main.c#527 [Document Manager] bookmarks=\n\n -[Project Manager] -Shortcut=gdadbcopy//src//gdadbcopy -Expand=gdadbcopy - [Execution] Run in terminal=2 Working directories=../../../gdadbcopy diff --git a/.anjuta/session/dock-layout.xml b/.anjuta/session/dock-layout.xml index aea89b1..3b61c4d 100644 --- a/.anjuta/session/dock-layout.xml +++ b/.anjuta/session/dock-layout.xml @@ -1,4 +1,2 @@ - - - + diff --git a/.anjuta_sym_db.db b/.anjuta_sym_db.db index c8b7601ae068d8c59443796cbba6a82f658872bf..76de4102e41d84f1db60630974d7507fa49200dc 100644 GIT binary patch delta 985 zcmYjQOK1~e5Z?JGn`B$tw9T%u#MnogD!#~OP1ROV#OFaR#0M%8x7n>mlWyH?>kBbK zQA7{bUqLK_c+q+gV$e&^(t{`>n7iIQNJ|e=thoN^CX&nW&&)UTfAh*uko+?;5#$#* zj_bMKxg8dYr;qqRD!udVa5cm`qg(r9O1~U`BmVL@s-pBqW6xKL%{&VMTx62#!NpSR z;4H?ua9ab@B{J#3Cz!%8`Ghn00?YUVcVd9NBy)I(Orwl%@g7>_8#a>3Vj)dp%lLo* zaLF_bD=f9~VWt>k*65g(98PESmHsxqOCVtCs+Js2>lbtIlYZ>$+7xQ>Gi=o{oYpg1 zjw?6eEY5Q{-N;LooSKp97M=Hqn$>06y?NdByS}m73cOf%0md6-lf;Kx;SM=KR>Ks2N0GcIk6;cANE8cQa5U%+2%(_U+;P=RS9o5^W)2#f zF15QQA=JLqq&n9wBPDjY!$K%fKZP3LOzNy^`b$%nPr6aU$JCRLxbZnY#mB|MF#25R z1*sy$ity7HH%_5MqSSLU;wHz*ZW1jP{=zoV#W>Yc*68?Mj7*)eLZr>bXw+=gzcaTU z!h`5Jwgu;-8ieTQs0?LFbNB^cVZPMrGV%Hvsf7~)Ag~MZhS<2l>uk1NE2CPkZTE@{DOHh`o$@a2 dYdw(lz_!=>87^GKRZhiQe;)tgOYO12{s+le7PSBX delta 588 zcmYjNO=uHQ5Z-x{ZA{WO>6#i#LfW)c#nzH-O4`PQp@KgLt5C(FNZe#!CAvx4-EF0m zVuE7xBN%;p(TjKqxd<`pC5N7*f>gZNd%bzG^x#2+_-YV3%nW?r{4n2SUy*E?l)Yk3 z5QP3GeWxH-yLrV4QvHK7YO#;?$>GT8L?k%z*8R)62PY%kL-K2%`)U3*d}4Ruo4ug;}$M^)AZ_vdaA% SC=rcW9}L!VQBv0)K7+rOgREu% diff --git a/src/main.c b/src/main.c index 9ec049e..f8bf60f 100644 --- a/src/main.c +++ b/src/main.c @@ -25,16 +25,21 @@ static gchar *ref_db_cnc = NULL; static gchar *db_cnc = NULL; static gboolean drop_tables = FALSE; +static gchar *output_file = NULL; static gboolean verbose = FALSE; static GdaConnection *gda_conn_ref_db; static GdaConnection *gda_conn_db; +static xmlDoc *xdoc; +static xmlNode *xroot; + static GOptionEntry entries[] = { { "ref-db-cnc", 0, 0, G_OPTION_ARG_STRING, &ref_db_cnc, "Reference database connection string", "CNC_STRING" }, { "db-cnc", 0, 0, G_OPTION_ARG_STRING, &db_cnc, "Database connection string", "CNC_STRING" }, { "drop-tables", 0, 0, G_OPTION_ARG_NONE, &drop_tables, "Drop tables before creating new ones", NULL }, + { "output-file", 0, 0, G_OPTION_ARG_FILENAME, &output_file, "Ouput the whole operation in an xmlfile", "FILENAME" }, { "verbose", 0, 0, G_OPTION_ARG_NONE, &verbose, "Verbose", NULL }, { NULL } }; @@ -172,6 +177,24 @@ copy_data () (error != NULL && error->message != NULL ? error->message : "no details.")); continue; } + + if (output_file != NULL) + { + xmlNode *xnode; + + xnode = xmlNewNode (NULL, "insert_into"); + error = NULL; + sql = gda_statement_to_sql_extended (stmt, + gda_conn_db, + params, + GDA_STATEMENT_SQL_PARAMS_AS_VALUES, + NULL, + &error); + + xmlNodeSetContent (xnode, sql); + xmlAddChild (xroot, xnode); + g_free (sql); + } } g_printf ("\n"); @@ -423,6 +446,20 @@ read_tables () read_fields (table, op); + if (output_file != NULL) + { + error = NULL; + xmlAddChild (xroot, + gda_server_operation_save_data_to_xml (op, + &error)); + if (error != NULL) + { + g_warning ("Error on saving GdaServerOperation to xml: %s.", + error->message != NULL ? error->message : "no details"); + continue; + } + } + error = NULL; if (!gda_connection_perform_operation (gda_conn_db, op, &error)) { @@ -584,6 +621,20 @@ read_views () continue; } + if (output_file != NULL) + { + error = NULL; + xmlAddChild (xroot, + gda_server_operation_save_data_to_xml (op, + &error)); + if (error != NULL) + { + g_warning ("Error on saving GdaServerOperation to xml: %s.", + error->message != NULL ? error->message : "no details"); + continue; + } + } + g_free (view_def); g_free (view_name); @@ -648,6 +699,12 @@ main (int argc, char *argv[]) return; } + if (output_file != NULL) + { + /* initialize output file */ + xroot = xmlNewNode (NULL, "gdadbcopy"); + } + update_metastore (); g_printf ("* Reading tables of reference database (%s).\n", @@ -661,6 +718,15 @@ main (int argc, char *argv[]) g_printf ("* Reading views.\n"); read_views (); + if (output_file != NULL) + { + /* initialize output file */ + xdoc = xmlNewDoc ("1.0"); + xmlDocSetRootElement (xdoc, xroot); + xmlSaveFormatFile (output_file, xdoc, 2); + xmlFreeDoc (xdoc); + } + g_object_unref (gda_conn_ref_db); g_object_unref (gda_conn_db); diff --git a/tests/db.db b/tests/db.db index 2dd433b277d62bed76ba1fcd5b9e5aecfa55e722..3acae74c67fb1993f874253949d4aa9a3f8b9ce9 100644 GIT binary patch delta 52 zcmZpWXpop7EjXEhfq@x_p@7kMqK+}+QOB4udSk*LMn;9nu}ray@{@NnZDW+%T*TbR0RZ-g B3p@Y- -- 2.49.0