On 11/7/06, Oleg Broytmann <[EMAIL PROTECTED]> wrote:
> .createTableSQL() returns two SQL queries - to create the table and to
> apply the constraints - but doesn't run the queries itself. The purpose, if
> I understand it right, is to collect all SQL queries and run them in any
> order you want. But one has to run theese queries himself.
OK but wouldn't it be easier if one can simply override
.createTableSQL(), something like :
class MyView(SQLObject):
@classmethod
def createTableSQL(self, createJoinTables=True,
createIndexes=True,
connection=None):
# super call here if needed
query = "CREATE VIEW myview AS SELECT * FROM mytable;"
constraints = []
return (query, constraints)
Then all one has to do is calling
MyView.createTable(ifNotExists=True). This is not possible for the
moment.
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
