Thread: [SQLObject] Re: creating a database
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Brett A. <br...@be...> - 2005-04-14 15:13:26
|
>> Is there a programmatic way to create a new database using SQLObject >> other than _conn_.query("CREATE DATABASE dummy;") > For most databases and almost all real situation it is meaningless, > as databases are created by database administrators using spcial tools; > then DBAs grant neccessary rights to users, and only then users can > connect to the DB. there's always the exception. i'm creating a tool where the end users may not be the most technically inclined and will need the option to create a new "simple" project based on sqlite or an "advanced" project using a server based database. i should be able to give them the option on project creation to set the permission or add user rights. is this outside the scope of sqlobject? |
From: Oleg B. <ph...@ma...> - 2005-04-15 08:29:39
|
On Thu, Apr 14, 2005 at 09:12:57AM -0600, Brett Adams wrote: > i'm creating a tool where the end users may not be the most > technically inclined and will need the option to create a new "simple" > project based on sqlite or an "advanced" project using a server based > database. With SQLite it is simple: open("/path/to/db", 'wb').close() With Postgres or MySQL it is much harder - you have to know in advance login/password of a DBA, connect as the DBA, create a database, disconnect, and connect as the user. > i should be able to give them the option on project creation > to set the permission or add user rights. You are going to give "not the most technically inclined end users" ability to set user rights? How can they do it without reading and understanding a lot of manuals, without good deal of training?.. Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |