I liked it because it fit his coding model. I didn't see it as
something to apply universally, but it was an interesting new way to
think about writing queries so that they fit an approach you're
already using for other code.
I like your objectmapper too.
On 2/3/06, Chesty Puller <[EMAIL PROTECTED]> wrote:
> Not that I doubt that it is indeed spiffy, how in fact is it so? I don't
> understand why this complex-looking piece of sql abstraction is an
> improvement over either standard SQL or the object-relational database
> mapping scheme
>
> This is Issac's - I think it's more difficult to understand than classic
> SQL. Not bad, but not really an improvement - all of the fields in the
> table are returned, right?
>
> ds = request.tapi.getObject("datasource")
> statement = ds.getStatement("select").init("mytable")
> qry = statement.filter("X",x,"=").filter("Y",y,"=").execute()
>
>
> I think I'd rather do something like:
>
> object = objectmapper.get(objectid)
>
> which replaces
>
> select
> objectid, objectproperty1, objectproperty2, objectproperty3
> from
> table
> where
> objectid = #objectid#
>
> Even better, the programmer can further abstract the use of the query by
> adding parameters to the get method of the objectmapper class. This way you
> end up with a complete class in and out of the database. You don't write a
> lot of queries over and over, you don't find new ways to join the data in
> the db (unless you're doing reporting, which is a different subject
> altogether), and you use classic OOP for code readability, maintenence and
> reuse.
>
> Anyway, my question is, exactly why is Issac's code spiffy?
>
> - Matt
>
> ----- Original Message -----
> From: "William Bowen" <[EMAIL PROTECTED]>
> To: "CF-Community" <cf-community@houseoffusion.com>
> Sent: Friday, February 03, 2006 10:06 AM
> Subject: Re: B-E-A-UTIFUL!
>
>
> >> Everyone else just ignored you. :-p
> >
> > Bah! Not ignoring! Just trying to figure out how I can use this!
> >
> > it is indeed "damn spiffy code."
> >
> > will
> > --
> >
> > "If my life weren't funny, it would just be true;
> > and that would just be unacceptable."
> > - Carrie Fisher
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:195675
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
