Re: [gnome-db] Auto-updated GdaMetaStore?

["Vivien Malerba" <vmalerba gmail com>]

2009/1/9 Johannes Schmid <jhs jsschmid de>

Hi!

OK, I think I got kind of a clue now. Seems I had some postgres
permission problems but I fixed them now.

Anyway, it seems that update_meta_store() with no further arguments is
working fine after an ALTER TABLE statement. But what would actually be
much more useful, would be to update the meta store for a single table
like you can specify with get_meta_store_data():

g_value_init (&value, G_TYPE_STRING);
       g_value_set_static_string (&value, "customer");
       model = gda_connection_get_meta_store_data (cnc,
GDA_CONNECTION_META_FIELDS, &error, 1, "name", &value);

I would just like to update the meta_store for the table "customer". I
am kind of lost in the database schema the documentation provides for
GdaMetaStore.

I know the doc is not up to the expectations... anyway, you can use a specific GdaMetaContext for this purpose. See the attached test case.

Here is a sample output from my test DB:
> ./upd_single_table customers
Updating the meta store for the 'customers' table
Number of tables: 1
Columns: 5
table_catalog | table_schema | table_name | column_name     
--------------+--------------+------------+------------------
sales         | public       | customers  | id              
sales         | public       | customers  | name            
sales         | public       | customers  | default_served_by
sales         | public       | customers  | country         
sales         | public       | customers  | city            
(5 rows)
 

./upd_single_table pg_database
Updating the meta store for the 'pg_database' table
Number of tables: 1
Columns: 11
table_catalog | table_schema | table_name  | column_name 
--------------+--------------+-------------+--------------
sales         | pg_catalog   | pg_database | datname     
sales         | pg_catalog   | pg_database | datdba      
sales         | pg_catalog   | pg_database | encoding    
sales         | pg_catalog   | pg_database | datistemplate
sales         | pg_catalog   | pg_database | datallowconn
sales         | pg_catalog   | pg_database | datconnlimit
sales         | pg_catalog   | pg_database | datlastsysoid
sales         | pg_catalog   | pg_database | datfrozenxid
sales         | pg_catalog   | pg_database | dattablespace
sales         | pg_catalog   | pg_database | datconfig   
sales         | pg_catalog   | pg_database | datacl      
(11 rows)

Regards,

Vivien

Attachment: testcase.tbz
Description: application/bzip-compressed-tar