[Dbix-class] Providing unified interface through DBIx::Class

2008-07-15 Thread Andreas Pronakis
This question might sound a bit silly as I'm sure that DBIx::Class has the DBI part at the front for a reason, however I thought I'd ask anyway. While evaluating DBIx::Class a question was raised by a colleague: "Can we use DBIx::Class to connect to data servers other than a Database e.g. to a s

Re: [Dbix-class] Re: Creating custom resultset error and MySQL

2008-07-04 Thread Andreas Pronakis
tice the missing [...] around the call. Is this something that was changed resentrly but not updated in the Cookbook docs or something else? --- On Fri, 7/4/08, Andreas Pronakis <[EMAIL PROTECTED]> wrote: > From: Andreas Pronakis <[EMAIL PROTECTED]> > Subject: [Dbix-cl

[Dbix-class] Re: Creating custom resultset error and MySQL

2008-07-04 Thread Andreas Pronakis
; at the very end of the \<result_source_instance(); my $new_source = $source->new($source); $new_source->source_name('FindStory'); $new_source->name(\<register_source('FindStory' => $new_source); 1; Then called from a perl script like so: $story_obj = [ $schema-&

Re: [Dbix-class] DBIx::Class and caching

2008-07-02 Thread Andreas Pronakis
I was wondering if anyone has tried using the module DBIx::Class::Cursor::Cached but replacing the cache engine Cache::FileCache with Memcache? I will try it out and let you know the results, but if someone else has already tried it would be nice to know what their findings were Andreas ---

[Dbix-class] Creating custom resultset error and MySQL

2008-07-01 Thread Andreas Pronakis
I've tried creating a custom resultset, following the instructions on DBIx::Class::Cookbook docs, but when calling the search() method on it it always returns empty, so I enabled DBIC_TRACE and the following sql was being executed: SELECT me.story_id, me.journalist_user_id, me.revision, me.sto

[Dbix-class] DBIx::Class subclass and multiple tables

2008-06-25 Thread Andreas Pronakis
This topic might have been previously covered but i don't seem to be able to find the solution, so apologies in advance if it's a repeated post. Is it possible with DBIx::Class to have a class (sub-class) which properties are associated with two or more DB tables. A generic example would be:

[Dbix-class] DBIx::Class and caching

2008-06-24 Thread Andreas Pronakis
points 1/1.1 and also set a default cache_for periodf for a whole class, rather than individual search requests? Thanks in advance for your patience and help Andreas Pronakis DBIx::Class newbie but believer ___ List: http://lists.scsys.co.