Re: [SQLObject] creating an empty Firebird database

2008-04-09 Thread Petr Jakeš
Oleg, I am still eating, drinking, smoking and inhalling special SQLobject substances from new April release. Because of that I am able to preditct that, thanks to your effort, the SQLObject will be the best db object-relational mapper in the whole Universe in the near future :-) regards Petr B

Re: [SQLObject] creating an empty Firebird database

2008-04-09 Thread Oleg Broytmann
On Wed, Feb 06, 2008 at 08:01:57PM +0100, Petr Jake?? wrote: > > So the code should be (providing that SQLObject's connection knows the > > user as self.user and self.password): > > > > con = kinterbasdb.create_database("create database '%s' user '%s' password > > '%s'" % (self.db, self.user, sel

Re: [SQLObject] creating an empty Firebird database

2008-02-06 Thread Petr Jakeš
> > So the code should be (providing that SQLObject's connection knows the > user as self.user and self.password): > > con = kinterbasdb.create_database("create database '%s' user '%s' password > '%s'" % (self.db, self.user, self.password) > > It looks promising. But I am not a Firebird guru, so

Re: [SQLObject] creating an empty Firebird database

2008-02-06 Thread Oleg Broytmann
On Wed, Feb 06, 2008 at 07:19:52PM +0100, Petr Jake?? wrote: > > import kinterbasdb > > > con = kinterbasdb.create_database("create database '%s' user 'sysdba' > > > password 'masterkey'" % db_filename) > > > While you install Firebird (not the database or table), you have to set the > Firebird use

Re: [SQLObject] creating an empty Firebird database

2008-02-06 Thread Petr Jakeš
> > In what way SQLObject can help? Encapsulate the cheating? ;) > :-D > import kinterbasdb > > con = kinterbasdb.create_database("create database '%s' user 'sysdba' > > password 'masterkey'" % db_filename) > > Users have to create a different connection with user='sysdba' and > password='mast

Re: [SQLObject] creating an empty Firebird database

2008-02-06 Thread Oleg Broytmann
On Wed, Feb 06, 2008 at 06:49:22PM +0100, Petr Jake?? wrote: > Right now I am cheating a little bit ;-) : In what way SQLObject can help? Encapsulate the cheating? ;) > import kinterbasdb > con = kinterbasdb.create_database("create database '%s' user 'sysdba' > password 'masterkey'" % db_filen

Re: [SQLObject] creating an empty Firebird database

2008-02-06 Thread Petr Jakeš
> > Currently SQLObject can only create an empty DB on PostgreSQL, and even > this has its limitations. > Usually one has to have administrative rights to create a new DB, and > then delegates rights to connect to the new DB to another user > (login/password), so it'd be hard to implement in SQ

Re: [SQLObject] creating an empty Firebird database

2008-02-06 Thread Oleg Broytmann
On Wed, Feb 06, 2008 at 05:55:10PM +0100, Petr Jake?? wrote: > is there a way how to creat an empty FB database using SQLobject? Currently SQLObject can only create an empty DB on PostgreSQL, and even this has its limitations. Usually one has to have administrative rights to create a new DB,

[SQLObject] creating an empty Firebird database

2008-02-06 Thread Petr Jakeš
Hi, is there a way how to creat an empty FB database using SQLobject? Petr Jakes - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt