Test returned value by sql statement

Rails
1

Hello people,

just wanted to know how to actually test returned value from sql
statement like :

@alreadyused = Promotioncodes.find_by_sql [ “select alreadyused from
promotioncodes where id = ?”, @codeid ]

I would like to check whether @alreadyused has value 1 or 0

It doesn’t seem a simple if @alreadyused would word …

Regards

Joel

2

On 21 May 2008, at 14:40, joel wrote:

find_by_sql returns an array of model objects: so

foo = Promotioncodes.find_by_sql [ “select alreadyused from
promotioncodes where id = ?”, @codeid ]

if foo.first.alreadyused?
…
end

Also there’s no need to break out find_by_sql for that
foo = Promotioncodes.find @codeid
if foo.alreadyused?
…
end

is more than enough (and in keeping with rails conversion that model
would be Promotioncode (or even PromotionCode))

Fred

3

Ok thank you very much,

Also wanted to know while using update_attribute method, how to
actually test that the attribute has effectively been updated ? ( need
to test to trigger appropriate popup message )

Thanks again,

Joel

4

joel wrote:

just wanted to know how to actually test returned value from sql
statement like :

@alreadyused = Promotioncodes.find_by_sql [ “select alreadyused from
promotioncodes where id = ?”, @codeid ]

I would like to check whether @alreadyused has value 1 or 0

count_by_sql

next, what’s wrong with

PromotionCode.find_by_id(@codeid).alreadyused

?

I would guess what’s wrong with it is your model names don’t follow
Rails
conventions, so you have not yet tuned your ActiveRecord calls to match
them.

–
Phlip