[Dbix-class] retrieve_from_sql

Matt S Trout dbix-class at trout.me.uk
Mon Oct 17 22:17:42 CEST 2005


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.

-- 
     Matt S Trout       Specialists in perl consulting, web development, and
  Technical Director    UNIX/Linux systems architecture and automation. Mail
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

 + Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +



More information about the Dbix-class mailing list