Cees de Groot wrote: > > David Brown <[EMAIL PROTECTED]> said: > >But isn't Python a decent query language? Isn't it nice to be able to have > >all of the facilities of Python at your disposal when manipulating data, > >rather than hoping that whatever database you are using doesn't have a > >brain-damaged implementation of SQL? > > > Yup. Our business objects are sitting on top of my homebrew O/R mapping layer, > and I find myself entering the Python shell to do ad-hoc stuff with them more > and more often. Especially because stuff that repeats one or two times is > easily added as a method on the object for later reference... > > One nice idea that should be possible in Pythonland as well: a Smalltalk O/R > mapping layer called GLORP uses Smalltalk as a query language in a very nice > way. Queries are given as Smalltalk blocks (say lambdas), and the mapping > layer interprets the block's parse tree in order to spit out equivalent SQL > code. Say: > > Employees.get(lambda e: e.name[:3] == 'Foo') > > to get all employees that have a name starting with "Foo". > The only problem with this is that lambdas are not safe for TTW scripting 8^(. Although a safe lambda could probably be conceived of course... -- | Casey Duncan | Kaivo, Inc. | [EMAIL PROTECTED] `------------------> _______________________________________________ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
