From: Ian B. <ia...@co...> - 2001-10-07 06:25:40
|
tom smith <to...@ot...> wrote: > objectized, it worked but it sucked, and the first thing I did was to > circumvent it to be able to add text ala "clauses". Because making a simply > query used to take a fortnight. > > Using objects is great, but sql is great (ish) too. I think using 3 lines, > like the example, above to write the one liner (below), which incidentally, > reads well... > > "state = 'NJ' and 'extension' = 1111 and duration > 60" > > ...is overkill. The tables are "like" objects, so we should treat them so, > queries are like more like prose. Of course, no one actually writes that clause. They write something like "state = '%s' and %s = %s and duration > 60" % ("NJ", "extension", 1111, 60), or something of that sort. So it kinda sucks any way you do it. Prose is what the programming is itself. Unfortunately, a SQL query means writing a program that runs on the DBMS, not in your native language. That's awkward too, just like the builder is awkward. Ian |