Re: [gnome-db] gda_connection_create_table() equivalent.

[Rodrigo Moya <rodrigo gnome-db org>]

On Sun, 2006-08-27 at 11:00 +0200, Vivien Malerba wrote:
> On 8/27/06, Bas Driessen <bas driessen xobas com> wrote:
> >
> >  Hello,
> >
> >  I noticed that functions like gda_connection_create_table() have been
> > removed recently. This now should go through a new GdaServerOperation. Is it
> > possible to give an example of how I would create a table now? I used
> > function calls like this:
> >
> >  gda_connection_create_table(connection, table_name,
> > columns, NULL)
>  >
> >  What would the equivalent be with this new GdaServerOperation? Any
> > clues/examples?
> 
> Example to create a table. The idea is to ask a provider for a
> GdaServerOperation for a given operation to perform, then set the data
> in the GdaServerOperation (here from an XML string), and the ask the
> provider to execute the operation. The parameters to be set for each
> kind of operation is provider-dependant, but there is a common set
> mentionned in the libgda doc (such as table name and columns to create
> a table).
> 
> For more examples, have a look at src/util.c and src/ws-tables.c in
> mergeant. You can use libgnomedb's GnomeDbServerOperation widget to
> have a GUI to enter the necessary parameters for a given
> GdaServerOperation.
> 
> GdaServerOperation *op;
> GError *error = NULL;
> 
> op = gda_server_provider_create_operation (prov, cnc,
> GDA_SERVER_OPERATION_CREATE_TABLE, NULL, &error);
> if (!op) {
>     /* error */
> }
> else {
>     /* we have to set the table parameters */
>    const gchar *params = "
> <serv_op_data>
>   <op_data path="/TABLE_DEF_P/TABLE_NAME">testtable</op_data>
>   <op_data path="/FIELDS_A">
>     <gda_array_data>
>       <gda_array_row>
>         <gda_array_value colid="COLUMN_NAME">id</gda_array_value>
>         <gda_array_value colid="COLUMN_TYPE">int</gda_array_value>
>       </gda_array_row>
>     </gda_array_data>
>   </op_data>
> </serv_op_data>"
> 
>     doc = xmlParseMemory (params, -1);
>     if (!gda_server_operation_load_data_from_xml (op,
> xmlDocGetRootElement (doc), &error)) {
>         /* error */
>     }
>     else {
>         gda_server_provider_perform_operation (prov, cnc, op, &error) {
>             /* error */
>         }
>         else {
>             /* ok, table created */
>         }
>     }
>    xmlFreeDoc (doc);
>    g_object_unref (op);
> }
> 
> Hope this helps,
> 
it would be nice to have in the API convenience functions that do all
this work for common operations, like creating a table. How do you see
it?
-- 
Rodrigo Moya <rodrigo gnome-db org>