[Modeling-users] No semicolons in SQL
Status: Abandoned
Brought to you by:
sbigaret
From: <luk...@po...> - 2003-11-11 20:52:59
|
Hi First, thanks to you Sebastien for quick and precise response about "fetchSQL". And I've got another problem: Why there are no semicolons after every SQL expression generated by mdl_generate_DB_schema.py? In "quick overview" example they are. I use PostgreSQL and there the semicolons are required. After few recreations o= f my database queries I'm tired with manually inserting this characters. As= I remember Oracle also requires them ( but MySQL doesn't). I generate sql with mdl_generate_DB_schema.py and I don't get semicolons.= Is it caused by my shortage of knowledge how to get the semicolons or it is some author's oversight? If it is my fault please give me some piece of advice. Else maybe in the future releases some additional parameter to th= e mdl_generate_DB_schema.py script could be added? For example: mdl_generate_DB_schema.py -m With -m the sql expressions would be generated with semicolons at the end= , else and default - without them. SB> I'll also be pleased to hear from your own SB> application, at least of the aggregations you're thinking about when SB> asking this (if you can disclose): it always help to learn about the SB> context in which feature requests raises. Of course. Actually I'm learning Modeling Framework and trying to use it = in my application (bussines-portal in Zope(Plone)). As you see I've got many problems with it :-) After the scheme of the database and queries will ha= ve been completed I'll send you some description and 'aggregaton queries fro= m the real life' (I think that I'll do it outside the mailing list) ******************************** * =A3ukasz =A3akomy * Goodwill Internet Factory * * luk...@gi... ******************************** |