Re: [gnome-db] create/drop table for PostgreSQL.

["Robert Bertram" <rbirdman swiftdsl com au>]

Bas Driessen said:
> On Sat, 2005-01-29 at 19:57 +1100, Robert Bertram wrote:
>> >
>> > The first round of changes are in regarding new functions
>> > "gda_connection_create_table" and "gda_connection_drop_table" for the
>> > PostgreSQL provider. This enables you to create/drop a table in a
>> > PostgreSQL database using the GDA API. Additional features like multi
>> > column indexes etc will follow, once we decide on the correct
>> > implementation. I ask the PostgreSQL users/programmers to test this
>> new
>> > functionality and also to review the new function
>> > postgres_name_from_gda_type() in providers/postgres/gda-postgres-
>> > provider.c This function takes care of the mapping between GDA
>> datatypes
>> > and PostgreSQL data types. Very important to get this right, so please
>> > review and let me know the issues (if any).
>> >
>> > I will implement similar for MySQL in the next couple of days as well
>> as
>> > to find a (n API) solution for multi column indexes.
>
>> Is there a patch for this. I could could do some user testing maybe
>> though
>> I have little programming skills. It would be good bit of functionality
>> to
>> have added.
>>
>
> The changes are applied to the HEAD of the cvs libgda source tree.
> Please read page http://www.gnome-db.org/download.php (near the bottom
> of the page) of how to download/install the latest (developer) libgda.
> If you have any problems, let me know how I can help.
>
> What you have to do in your logic is to create a for loop for all your
> columns that you want to include in your table, create a
> GdaDataModelColumnAttributes object for that and add that to a GList.
>
>
> So:
>
> GList *columns = NULL;
> GdaDataModelColumnAttributes *dmca;
>
>
> for (........) {
>
>    /* Create new column structure */
>    dmca = gda_data_model_column_attributes_new();
>
>   /* Set all your the parameters */
>
>   /* Table Name */
>   gda_data_model_column_attributes_set_table(dmca, (const gchar
> *)your_table_name);
>
>   /* Column Name */
>   gda_data_model_column_attributes_set_name(dmca, (const gchar
> *)your_column_name);
>
>   etc etc etc
>
>   /* Add column structure to the list */
>   columns = g_list_append(columns, dmca);
> }
>
> /* Call create table call */
> status = gda_connection_create_table(connection, your_table_name,
> columns);
>
> /* Clean up */
> g_list_foreach(columns, FreeColumn, NULL);
> g_list_free(columns);
>
>
> The clean up function "FreeColumn" can be something like:
>
> void FreeColumn(gpointer data, gpointer user_data)
> {
>     GdaDataModelColumnAttributes *dmca = (GdaDataModelColumnAttributes
> *)data;
>     gda_data_model_column_attributes_free(dmca);
> }
>
> Hope this helps,
>
> Bas.
>
>

Well I know enough C now to understand the code you posted but
unfortunately I don't know how to compile the stuff in CVS. There is no
configure script or Makefile from memory.

Sorry. I'll have another look but I think it will take me awhile to get to
that point. I'll certainly try the next lot of releases though.

Rob.