Re: gda- import/export/creation

[Rodrigo Moya <rmoya tsai es>]

Stephan Heinze wrote:

> Hi all,
>
> I have to be in the office and so why not hacking gnome-db?
>

Yes, why not? Did you get your CVS account? I am not busy at the moment at
work, so I will hack a little bit as well.

>
> If there's anybody else on the list - There's a point on schema
> implementation I need to discuss with somebody:
>

I am on the list!

>
> if there's a request for tables - should we return all tables available
> in the database or only this tables created by the user himself? the
> same question for procedures, types and views.
>

I was thinking the same yesterday. For this, GDA_Connection_TABLE_SCHEMA,
GDA_Connection_TABLE_CATALOG (or *_SCHEMA and _CATALOG to be used for any
object as said yesterday) should be used. So, if you want all types, you
call GDA_Connection_PROV_TYPES with no more args, if you want types created
by the current user:

GDA_Connection_PROV_TYPES, GDA_Connection_SCHEMA, user_name

This will return objects of the specified type created by the given user.

>
> My first thought was to return only the user's tables, views and types.
> But if you want to create a new table you should choose the type of the
> attribute from a combo-box which IMHO should be filled with the results
> of the schema-types-request. Now we shouldn't return only the self
> created
> types but all available.
> another way could be the mapping of gda-types to RDBMS specific types
> and the server should say, wich gda-types it provides (no selfcreated
> types
> provided -> a better posibility to exchange databases from one RDMBS to
> another via gda ).

This will be done by the Export/Import utility. In export (which is the
only one working right now), the types are GDA_Types, not RDBMS specific.
But, we must provide also a list of supported types for the SQL builder
(not done yet), which will be a kind of 'wizard' for creating SQL
statements, included CREATE TABLE, in which case RDBMS-specific types are
needed.

So, first of all, I am going to change the IDLs, so that instead of
TABLE_SCHEMA, we'll use SCHEMA, CATALOG... As soon as I compile everything
ok, I'll commit it to CVS and tell you.

Cheers