let's say it's not a normal thing to do, and DAL doesn't support it out of
the box. the problem with postgresql is that a create database should be
issued in a non-transaction environment, that is what instead DAL uses by
default.
Instead of fiddling with DAL, just use raw psycopg commands to do it.
with psycopg2.connect(connectionstring) as conn:
conn.set_isolation_level(ISOLATION_LEVEL_AUTOCOMMIT)
with conn.cursor() as curs:
curs.execute('create database testdb')
On Wednesday, October 2, 2013 9:33:33 PM UTC+2, Richard wrote:
>
> Creating an app that create database... There is much more thing to
> consider and there is already thing like webmin for that.
>
> Richard
>
>
> On Wed, Oct 2, 2013 at 3:32 PM, Richard Vézina
> <[email protected]<javascript:>
> > wrote:
>
>> Why would someone do that?!
>>
>> Richard
>>
>>
>> On Wed, Oct 2, 2013 at 1:48 PM, Cliff Kachinske
>> <[email protected]<javascript:>
>> > wrote:
>>
>>> Oops, maybe not.
>>>
>>> Psycopg2 certainly allows table creation, so maybe it's an adapter
>>> question rather than a dal question.
>>>
>>>
>>> On Wednesday, October 2, 2013 1:44:50 PM UTC-4, Cliff Kachinske wrote:
>>>>
>>>> Not for the fainthearted, but this should work.
>>>>
>>>> db = DAL('postgres://user_**authorized_to_create_db:**
>>>> password_for_that_user@**localhost:5432/db_owned_by_**that_user,
>>>> migrate=False)
>>>> stmt = """CREATE DATABASE foo WITH OWNER some_user_in_the_system"""
>>>> db.executesql(stmt ...
>>>>
>>>> On Wednesday, October 2, 2013 9:49:52 AM UTC-4, at wrote:
>>>>>
>>>>>
>>>>> Is is possible to create a postgres database from web2py application?
>>>>>
>>>>> Thanks & Regards
>>>>>
>>>>> --
>>> Resources:
>>> - http://web2py.com
>>> - http://web2py.com/book (Documentation)
>>> - http://github.com/web2py/web2py (Source code)
>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "web2py-users" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to [email protected] <javascript:>.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>
>>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
