Hi,
Perfect! Thanks. The power of this library never ceases to astound me.
Cheers,
On Thursday, 30 July 2015 00:53:06 UTC+10, Jeremy Evans wrote:
>
> On Tuesday, July 28, 2015 at 7:54:34 PM UTC-7, Steven Ringo wrote:
>>
>> Hi,
>>
>> I have a PostgreSQL table-returning function:
>>
>> e.g. matched_devices(device_id uuid, tolerance integer, num_matches
>> integer);
>>
>> I would like to use the dataset of the results from calling this in a
>> Sequel::Model, e.g.
>>
>> class MatchedDevices < Sequel::Model
>>
>> def is_faulty?
>> self[:faulty]
>> end
>>
>> end
>>
>> I can get a dataset using
>> MatchedDevices.from{matched_devices('f165fd3b-9dfd-422a-9a73-9aea9c981fef',
>> 10, 0)}, and I can use the results of the recordset within the model as
>> hash values (per is_faulty?).
>>
>> Ideally I would like to have each value accessible as a regular
>> property/method, as one would get if this model were backed by a regular
>> table.
>>
>> If anyone can help me, that would be awesome.
>>
>
> You can use def_column_alias to automatically create methods. In this
> case, the method name is the same as the column name, so something like
> this should work:
>
> class MatchedDevices
> [:faulty, ...].each do |m|
> def_column_alias m, m
> end
> end
>
> Then you can do:
>
> m
> = MatchedDevices.from{matched_devices('f165fd3b-9dfd-422a-9a73-9aea9c981fef',
> 10, 0)}.first
> m.faulty
>
> This assumes that matched_devices always returns the same columns. If
> that isn't the case, and it can return arbitrary columns, you'll probably
> need to use method_missing.
>
> Thanks,
> Jeremy
>
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
