[Dbix-class] retrieve_from_sql

Krzysztof Krzyzaniak eloy at kofeina.net
Mon Oct 17 23:04:28 CEST 2005


Krzysztof Krzyzaniak wrote:
> 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 :-)

BTW. Maybe there is possibility to use "raw" DBI handler? Something like
MyClass->dbh->prepare('SELECT something');

   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