[Dbix-class] use array and composite type to prefetch in Pg

2009-03-14 Thread Sam Wong
Hi there, I am new to ORM and to DBIx::Class- In PostgreSQL fetching of composite types and array is supported, as documented in http://www.postgresql.org/docs/8.3/interactive/rowtypes.html http://www.postgresql.org/docs/8.3/interactive/arrays.html prefetch query can be constructed like this...

Re: [Dbix-class] SQL::Abstract : adding support for two potentially MySQL-specific functions

2009-03-14 Thread Spiros Denaxas
>> On Sun, 8 Mar 2009 13:49:36 -0500 Rob Kinyon wrote: >> >> >> Hi, >> >> patches are welcome, but please base your patch on the '1.50_RC' branch >> (the trunk is currently a dead end AFAIK): > Hello, As promised, find attached the first patch, adding support for the "REPLACE" function. The summa

Re: [Dbix-class] bad column names?

2009-03-14 Thread Jess Robinson
On Tue, 10 Mar 2009, Moritz Onken wrote: SQL::Translator::Producer:: SQLServer doesn't seem to honour quote_char and SQL::Translator::Producer:: friends. No, doesnt look like it does. Patches welcome ;) That's not related to fREW's problem though. Jess

Re: [Dbix-class] Set a resultset_class for a result_class from within a component loaded by the result_class

2009-03-14 Thread Jess Robinson
On Thu, 5 Mar 2009, kevin montuori wrote: "PR" == Peter Rabbitson writes: >> You put ResultSetManager in your load_components and you put your custom >> plugin for resultset into a load_resultset_components call. An example >> from one of my classes. PR> Isn't ResultSetManager deprecated

Re: [Dbix-class] Dump table to disk

2009-03-14 Thread Jess Robinson
On Wed, 4 Mar 2009, Dermot wrote: 2009/3/4 Jonathan Yu : Hi there: You can dump the Schema object into SQL, but I'm not sure if it also dumps the appropriate INSERTs... Look in SQL::Translator, that's where you're most likely to find something like that (SQLT is the backend that does some of

Re: [Dbix-class] Dump table to disk

2009-03-14 Thread Jess Robinson
On Wed, 4 Mar 2009, Jonathan Yu wrote: Hi there: You can dump the Schema object into SQL, but I'm not sure if it also dumps the appropriate INSERTs... Look in SQL::Translator, that's where you're most likely to find something like that (SQLT is the backend that does some of the nitty-gritty on

Re: [Dbix-class] DBIx::Class::Schema->deploy and DB views.

2009-03-14 Thread Jess Robinson
Hi Kevin, On Mon, 23 Feb 2009, kevin montuori wrote: hi all -- i have a couple questions about using DBIC::Schema->deploy and views: first, i'be been defining views in the schema just like i would any other table then adding a $sqlt_schema->drop_table("view name") to the sqlt_deploy_hook().