[Dbix-class] txn_do on a custom ResultSource gets unbound placeholder exception

2008-02-01 Thread Cedric Boudin
Dear members of the list. I have a custom resultsource calling a db function with 4 input parameters returning a set of rowtypes. This resultsource is build as described in DBIx::Class::Manual::Cookbook Arbitrary SQL through a custom ResultSource case a) When I use this resultsource to get a re

Re: [Dbix-class] update with result of a function

2007-12-07 Thread Cedric Boudin
my $rs=$schema->resultset('...')->search({}); my $what='not column'; $rs->update({column=>\$what}); Automagical thx cedric Cedric Boudin wrote: > Dear Members of the list, > > I want to do this on a table: > > update table set colum

[Dbix-class] update with result of a function

2007-12-07 Thread Cedric Boudin
Dear Members of the list, I want to do this on a table: update table set column=function(column) where fk=some_value; I'm generalising here, in fact in this first case function is "not" and column type is boolean. I tried : a) something inspired of "Using database functions or stored procedures

[Dbix-class] with PK::Auto not loaded: insert complains about missing sequence/table name

2007-11-25 Thread Cedric Boudin
Dear list Members, I don't want to use sequences or automatic pk generation. I create my own specific pk's with a trigger. Thus I thaught that just not loading the comp PK::Core in the class definition would do the trick. Unfortunatedly, this seems not to work. I do get: DBD::Pg::db last_insert_id