Re: gda- import/export/creation

[Rodrigo Moya <rmoya tsai es>]

Stephan Heinze wrote:

> Hola Rodrigo ( yes I'm going to learn espanol :)
>

Perfect!

>
> On Wed, 29 Dec 1999 09:54:14 Rodrigo Moya wrote:
> > Yes, why not? Did you get your CVS account?
>
> not yet - I'm in contact wiht Miguel.
> can you mail me the IP of the cvs - server (or is it the same like
> anonymous cvs?) for the firewall people?
>

the IP is 199.183.24.238. To set it up, the only thing you need to change from
the anonymous CVS setup, is the server (cvs.gnome.org) and your user, so:

CVSROOT=:pserver:stephan@cvs.gnome.org:/cvs/gnome

>
> > I am not busy at the moment at
> > work, so I will hack a little bit as well.
>
> I think you're at holidays?
>

Not until Friday, tomorrow Thursday is my last day at work for this year.

>
> > 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.
>
> what's the different between _SCHEMA and _CATALOG ?
>

schema is the user name, catalog is the database name.

>
> > > 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.
>
> sure? why don't we hide this things in the gda-provider? if you create a
> database schema for an application (using gda) this should be rdbms
> independent (or not?). for example I would like to test the gnome-mailer
> which
> uses mysql as datastore - but I don't want to install mysql on my box.
> If they
> would use gda ... be free ...
>
> I know that's much more work on the provider-side ( 4 providers against
> 1 application - now ) but later the relationship should be invers. some
> providers an lots of applications.
>

>
> > 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
>
> so long,
>

About compilation: as I don't have oracle installed on my linux box at work (I
always forget the CD at home) I am not able to test it for compilation problems
now. So, please do it. The only things I've changed in the other servers are:

* convert GDA_Connection_TABLE_SCHEMA to GDA_Connection_SCHEMA
* convert GDA_Connection_TABLE_CATALOG to GDA_Connection_CATALOG

These changes are on CVS now