As long as we're on the topic of dynamic creation of where clauses ... maybe
this is helpful?
I have been working on a script that involves the creation of a table based
on a dynamic set of requirements and got it to work using eval(). This
probably isn't best-practice, but hey ... it makes me my tables from a set
of requirements gathered based on a list of fields with some details about
the fields (the max string length, whether it is unique or null):
rollingfields = "Table('%s', meta" % (filename)
for row in self.fields:
rollingfields = rollingfields + ",
Column('"+row['fieldname']+"', String("+str(row['fieldlength'])+")"
if row['unique'] == True:
rollingfields = rollingfields + ", unique=True"
if row['notnull'] == True:
rollingfields = rollingfields + ", nullable=False"
rollingfields = rollingfields + ")"
rollingfields = rollingfields + ")"
eval(rollingfields)
meta.create_all(execengine)
-----
Luke Peterson
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
