On Jan 24, 5:15 pm, Chris Nelson <[email protected]> wrote:
> On 01/24/2012 05:07 PM, osimons wrote:
> > So that means you want to combine the concepts:
> > >>> cursor.execute("SELECT * FROM %s WHERE id=%%s" % 'ticket', [42])
>
> Perfect. Thank you so much!
>
> > It is all here in the docs:
>
> >http://trac.edgewall.org/wiki/TracDev/DatabaseApi#RulesforDBAPIUsage
I've made progress but even with the docs, I don't quite know what to
do with
cursor.execute("SELECT ondate, username, availability FROM %s
" % \
self.table_name +
"WHERE ondate >= '%s' " % fromDate.isoformat()
+
" AND ondate <= '%s' " % toDate.isoformat() +
" AND username IN ('%s')" % "',
'".join(users))
The first two I'm OK with but is there DB API help fur building a set/
list for "WHERE ... IN ..."?
http://trac.edgewall.org/wiki/TracDev/DatabaseApi#GuidelinesforSQLStatements
notes
For anything not portable (and you really fall quickly in there),
you need to use some methods from the connection when building your
SQL query (e.g. db.cast(column, type), db.concat(*params), db.like(),
db.like_escape(), db.quote(param), db.get_last_id(cursor, table,
col)).
but gives an example of LIKE but not IN. Is there some support for
IN? There best I can come up with is something like:
cursor.execute("SELECT * from table WHERE username in (%s)" +
MyDbList(users)
where MyDbList is something like:
def MyDbList(db, pyList):
myList = [db.quote(e) for e in pyList]
return ','.join(myList)
Is there a cleaner way?
--
You received this message because you are subscribed to the Google Groups "Trac
Development" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/trac-dev?hl=en.
