Hi Laurence<div><br></div><div>I think you missed my point. I was talking about generating code (sql as DDL for instance)</div><div>not sql statements. I use Enterprise architect to model the application in UML for the data model,</div>
<div>entity model, I generate generate storm schema and DDL for accessing the database from the model.</div><div>And much of the model is originally reverse engineered from the RDBMS by EE.</div><div><br></div><div><br></div>
<div>And usually the RDBMS is pre-existing, not a new thing. So the schema of the RDBMS is fixed.</div><div><br></div><div>So I was looking for zope eco system based non html/xml based templating systems as a response to Martin </div>
<div>saying DTML is dead, as I am currently using DTML for these sorts of tasks.</div><div><br></div><div>T<br><br><div class="gmail_quote">On Sun, Sep 5, 2010 at 6:47 PM, Laurence Rowe <span dir="ltr"><<a href="mailto:l@lrowe.co.uk">l@lrowe.co.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div><div></div><div class="h5">On 5 September 2010 02:49, Tim Hoffman <<a href="mailto:zutesmog@gmail.com">zutesmog@gmail.com</a>> wrote:<br>
>>><br>
>><br>
>> Please note that DTML is a dead (and horrid) technology.<br>
>> Martin<br>
><br>
> But zpt is horrible for doing non html/xml based things ;-), What do you<br>
> think is good alternative in the zope eco system now<br>
> for templating other types of things (sql, python ...) ?<br>
<br>
</div></div>If you don't need conditions or looping, then string.Template from the<br>
standard library is a reasonable choice. For templating SQL I would<br>
use SQLAlchemy, as you want appropriate quoting applied to your input.<br>
(You don't have to use it's ORM).<br>
<font color="#888888"><br>
Laurence<br>
</font></blockquote></div><br></div>