finding a record by other field values that primary key

[ElKlaaso]

Hi,

I started using reactor 3 weeks ago, basically because it has good
performance, has a quite basic setup, and lets me extend it easily
with SQL if things are just to complicated or slow to implement in
Reactor itself.

I was wondering if there is an easier way to find a single record by
field values other then the primary key.

As far as i know at the moment, i have to use a gateway to find record
by other values, for example, if want to find a user by email and
password, it seems like i would have to do it something like this:

<cfset userQuery=userGateway.getByFields(email=arguments.email,
password=arguments.password)>

<cfif userQuery.recordCount eq 1>
<cfset user.setUserId(userQuery.userId) />
<cfset user.load() />
</cfif>

I find this quite verbose for functionality im likely to use quite
often.

I have a method that can get row one of the query, and populate a user
record with it. This would be quicker then the way described above.

But, it would be handy if reactor has a build in method for this so i
can do this with 1 line of code.. does this exist?

A solution would be to have a getByFields, that woul return 1 record,
and if it find more then 1, would throw an exception like
ToManyRowsException or MoreThenOneRowException.

Forgive me if this already exist or if im missing out on a great
'but'....

Greets,
Klaas-Jan Winkel

[Tom Chiverton]

2008/11/14 ElKlaaso <k.wi...@gmail.com>:

> As far as i know at the moment, i have to use a gateway to find record
> by other values, for example, if want to find a user by email and
> password, it seems like i would have to do it something like this:

gateway.getByFields(a=1,b='ghd')
would also be useful for finding >1 records though.
gateway.getOneByFields(a=1,b='ghd') and gateway.getByFields(a=1,b='ghd') maybe ?

Mark - lets add this one to the list !

--
Tom

[Klaas-Jan Winkel]

Is gateway.getOneByFields a proposed method for a new version of
reactor or does this actually exist?


klaas

--
Because you're so cute, i baked you a pony

[Tom Chiverton]

2008/11/18 Klaas-Jan Winkel <k.wi...@gmail.com>:

> Is gateway.getOneByFields a proposed method for a new version of
> reactor

That, sorry :-)
Feel free to write up your request and this thread on trac.reactorframework.org

--
Tom

[Tom Chiverton]

> Feel free to write up your request and this thread on trac.reactorframework.org

I've done it, don't worry.

--
Tom

[Dutch Rapley]

This functionality already exists with createRecord().load()

Instead of passing the id field, you can pass a list of attributes

<cfset User = Reactor.createRecord('User').load(email=form.email, password = Hash(form.password)) />

If more than one record is returned, it throws an exception.

HTH

-Dutch