Re: GNATColl and support for PostgreSQL stored procedures and non-public schemas

[Emmanuel Briot <briot.emmanuel@gmail.com>]

> Are there any plans for adding support for non-public schemas to the
> gnatcoll_db2ada tool? Right now we have to resort to embedded SQL
> instead of using the excellent GNATCOLL.SQL Ada style SQL interface.

No such plan at this stage. Presumably, adding those should not be too
difficult:
in the text file, the name of the tables would be "schema.name". At
this point, gnatcoll_db2ada
needs to issue a "CREATE SCHEMA schema" command. The second part of it
is to replace "." by
some other substring for the Ada identifiers that are generated to
represent the table.

> And how about stored procedures? We use those A LOT in our application
> but we haven't been able to figure out how to make use of them without
> having to go back to plain old embedded SQL, which of course is sub-
> optimal.

For aggregate functions, you can simply define new constants similar
to
GNATCOLL.SQL.Func_Count. For other types of stored procedures, you
could
copy the implementation of GNATCOLL.SQL.Lower, for instance, and
perhaps
even make it more general so that it takes the name of the procedure
in
parameter.

Emmanuel