[Dbix-class] retrieve_from_sql

Krzysztof Krzyzaniak eloy at kofeina.net
Mon Oct 17 22:48:13 CEST 2005


Matt S Trout wrote:
> On Mon, Oct 17, 2005 at 08:59:56PM +0200, Krzysztof Krzyzaniak wrote:
> 
>>Krzysztof Krzyzaniak wrote:
>>
>>[..]
>>
>>>O, this is nice. Second example: what with selects without tables at 
>>>all? For example:
>>>
>>>select my_table_insert(field1, field2); (which means actually "insert 
>>>into my_table values (field1, field2); select currval("my_table_seq");")
>>
>>Let me repeat part from old email. Is this possible with current version 
>>of DBIx::Class?
> 
> 
> Hmm. We don't have support for selecting from functions at all, yet, and
> I'm not 100% sure whether SQL::Abstract will handle it as-is (anyone?).
> 
> And of course there's the lack of "no table" support.
> 
> I think my main target for 0.04 will be to make the core truly
> resultset-oriented - so a table class becomes effectively a special case
> against a resultset of "SELECT * FROM table". Features like this, selecting
> on aggregates, etc. etc. should fall out quite easily from there, I hope.

Thanks, I will wait :-)

   eloy
-- 
-------e-l-o-y-----------e-l-o-y- at -t-r-a-n-s-i-l-v-a-n-i-a-.-e-u-.-o-r-g------

        jak to dobrze, że są oceany - bez nich byłoby jeszcze smutniej



More information about the Dbix-class mailing list