Re: Creating database tables from queries based on ORM API?

Oleg Broytman <[email protected]> Sat, 13 Apr 2019 19:05:28 +0200

Newsgroups	gmane.comp.python.sqlobject
Message-ID	<[email protected]>

On Sat, Apr 13, 2019 at 06:38:32PM +0200, Markus Elfring <[email protected]> wrote:
> >> This software situation can look different if there are additional
> >> abstractions involved because of object-relational mapping.
> >> Can a query object be passed as a parameter for a corresponding method call?
> >
> >    Certainly. Both SelectResults[1] and SQLBuilder[2]'s objects
> > can be passed, they're just Python objects, no magic.
> >
> > 1. http://sqlobject.org/SelectResults.html
> > 2. http://sqlobject.org/SQLBuilder.html
> 
> Do any of these classes trigger a table creation (CTAS command)
> which is automatically mapped to another Python object?

   No, not even ``CREATE TABLE``. And ``CREATE TABLE AS SELECT`` is not
implemented in SQLObject at all. Do you want to implement it?

> Regards,
> Markus

Oleg.
-- 
    Oleg Broytman            https://phdru.name/            [email protected]
           Programmers don't die, they just GOSUB without RETURN.