Re: [gnome-db] prepare_create_database() and perform_create_database()

["Vivien Malerba" <vmalerba gmail com>]

On 11/18/06, Murray Cumming <murrayc murrayc com> wrote:
> On Wed, 2006-11-15 at 16:15 +0100, Vivien Malerba wrote:
> > > > > Surely, we _always_ need the database name, whatever provider we
> > are
> > > > > using. So that can be a parameter to prepare_create_database()?
> > > > >
> > > > > I'm also surprised that both prepare_create_database() and
> > > > > perform_create_database() take the provider name. Surely that
> > should
> > > > be
> > > > > decided since calling prepare_create_database().
> > > >
> > > > Yes, this can easily be done.
> > >
> > > Will you have a chance to do this?
> >
> > Done it locally, I'll try to take some time to commit that tonight.
>
> Thanks. Although the provider name must not now be provided twice, I
> still hope that prepare_create_database() could take the new database
> name explicitly as a parameter.

The name of the database to create, even if it's mandatory is just a
named parameter among th other required parameters, so even if it was
passed as a function argument, you'd still have to set the other names
parameters "manually".

> Also, it would be nice if the documentation for these methods stated
> whether it is necessary to first open a connection. I don't see how it
> could create a database without knowing the other connection details,
> such as hostname.

As far as I know, no opened connection is ever required to perform a
create db or drop db. When applicable (that is when there is a distant
server) the information to connect to the server are among the
required named parameters in the GdaServerOperation object.

For example here are the named parameter for the create DB on a MySQL
provider (as printed by the gnome-db-demo program):
 * /SERVER_CNX_P (GdaParameterList @0x8287590)
 * /SERVER_CNX_P/HOST (GdaParameter) = NULL
 * /SERVER_CNX_P/PORT (GdaParameter) = NULL
 * /SERVER_CNX_P/UNIX_SOCKET (GdaParameter) = NULL
 * /SERVER_CNX_P/ADM_LOGIN (GdaParameter) = NULL
 * /SERVER_CNX_P/ADM_PASSWORD (GdaParameter) = NULL
 * /SERVER_CNX_P/USE_SSL (GdaParameter) = NULL
 * /DB_DEF_P (GdaParameterList @0x83d8028)
 * /DB_DEF_P/DB_NAME (GdaParameter) = NULL
 * /DB_DEF_P/DB_IFNOTEXISTS (GdaParameter) = NULL
 * /DB_DEF_P/DB_CSET (GdaParameter) = NULL
 * /DB_DEF_P/DB_COLLATION (GdaParameter) = NULL

and for the PostgreSQL one:
 * /SERVER_CNX_P (GdaParameterList @0x83d8028)
 * /SERVER_CNX_P/HOST (GdaParameter) = NULL
 * /SERVER_CNX_P/PORT (GdaParameter) = NULL
 * /SERVER_CNX_P/OPTIONS (GdaParameter) = NULL
 * /SERVER_CNX_P/ADM_LOGIN (GdaParameter) = NULL
 * /SERVER_CNX_P/ADM_PASSWORD (GdaParameter) = NULL
 * /SERVER_CNX_P/USE_SSL (GdaParameter) = NULL
 * /DB_DEF_P (GdaParameterList @0x83d82f0)
 * /DB_DEF_P/DB_NAME (GdaParameter) = NULL
 * /DB_DEF_P/DB_CSET (GdaParameter) = NULL
 * /DB_DEF_P/DB_OWNER (GdaParameter) = NULL
 * /DB_DEF_P/TEMPLATE (GdaParameter) = NULL
 * /DB_DEF_P/DB_TABLESPACE (GdaParameter) = NULL

and for SQLite (which does not have a distant server):
 * /DB_DEF_P (GdaParameterList @0x80d5f90)
 * /DB_DEF_P/DB_NAME (GdaParameter) = NULL
 * /DB_DEF_P/DB_DIR (GdaParameter) = NULL

Note some common named parameters (and maybe they should be included
in the doc).

Cheers,

Vivien