Hi,
Just finished replacing the query with Sequel notation. There were other
rather difficult components of the query to translate, but finally it's
done. Sequel.lit rocks and Oracle sucks!
Thx again for all the great work and support.
Regards
Tiago
segunda-feira, 8 de Junho de 2015 às 16:57:22 UTC+2, Jeremy Evans escreveu:
>
> On Monday, June 8, 2015 at 7:43:40 AM UTC-7, Tiago Cardoso wrote:
>>
>> Hi,
>>
>> First of all, let me say that I've become a huge fan of this gem. Sequel
>> is probably top-5 in the ruby world, and one could argue it is the only
>> really "professional" gem of the bunch.
>>
>>
>> I've been tasked with "translating" the queries in use on some obscure
>> projects to plain ruby (or plain sequel). Some of these are quite
>> complicated and I don't necessarily have the knowledge to rewrite them in a
>> more convenient way, for which I just want to blatantly translate them to
>> sequel-speak.
>> One of them is quite complicated, though. I'll show you the complicated
>> part:
>>
>> select cfs."all-ip_cfs_instance_id" as line,
>>
>> ...
>> from
>> ...
>> table(cast(multiset
>>
>> (select table.column1,
>> ....,
>> ) as
>> tableof10strings))(+) warp
>>
>> where ...
>>
>
> This should work:
>
> DB.select(Sequel.qualify(:cfs,
> Sequel.lit('all-ip_cfs_instance_id')).as(:line)).
> from{Sequel.lit("table(cast(multiset ? as tableof10strings))(+) warp",
> DB.select(:table__column1))}
>
> It's possible to go a little further by abusing Sequel.lit, but I think
> the above is better:
>
> DB.select(Sequel.qualify(:cfs,
> Sequel.lit('all-ip_cfs_instance_id')).as(:line)).
> from{table(Sequel.cast(Sequel.lit("multiset ?",
> DB.select(:table__column1)), :tableof10strings)).as(Sequel.lit("(+)
> warp"))}
>
> 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.
