[Dbix-class] Inflate column depending of other column

2012-10-29 Thread Rolf Schaufelberger
Hi, I would like to inflate a column value from json to perl-Hash , but only if another column has a certain value. Do I have acces to the whole fetched row from within inflate_colum ? Rolf Schaufelberger smime.p7s Description: S/MIME cryptographic signature

Re: [Dbix-class] Next problem with 0.8126 , many-to-many an +colums

2011-01-18 Thread Rolf Schaufelberger
now contained attributes.key or price_key.key, we actually didn't use the value :-) We haven't seen any other issues so far. Am 18.01.2011 um 11:36 schrieb Peter Rabbitson: > Rolf Schaufelberger wrote: >> Hi Peter, thanks for your explanation. Spent the whole la

Re: [Dbix-class] Next problem with 0.8126 , many-to-many an +colums

2011-01-17 Thread Rolf Schaufelberger
Hi Peter, thanks for your explanation. Spent the whole last evening with debugging, without finding out whats going wrong. The [{ mode => 'me.mode'}] works as wanted. Thanks. Am 18.01.2011 um 01:00 schrieb Peter Rabbitson: > Rolf Schaufelberger wrote: >> I've

Re: [Dbix-class] Next problem with 0.8126 , many-to-many an +colums

2011-01-17 Thread Rolf Schaufelberger
Same error Am 17.01.2011 um 14:57 schrieb Peter Rabbitson: > Rolf Schaufelberger wrote: >> I've found another issue where the update breaks old code: > > Can you test the 0.08127 RC (0.08126_01)? There were fixes related to the > way

[Dbix-class] Next problem with 0.8126 , many-to-many an +colums

2011-01-17 Thread Rolf Schaufelberger
I've found another issue where the update breaks old code: Given the following definitions: package PW::Iprinter::DB::Article; ... __PACKAGE__->has_many ( article_children => 'PW::Iprinter::DB::ArticleArticle', 'parent_id'); .. __PACKAGE__->many_to_many ( children => 'article_children', 'chi

[Dbix-class] Update : Problem with Update

2011-01-17 Thread Rolf Schaufelberger
eq'); The error happens when calling sequence. Removing the sequence call and define it via column_info works. Yet I wonder, is it "intended" that the update breaks old code ? Meanwhile I've also seen, that I can remove my sequence definition at all since

[Dbix-class] Probel after Update to 08126

2011-01-17 Thread Rolf Schaufelberger
tion failed in require at /serv/perl/lib/PW/Application.pm line 51. Any ideas ? Rolf Schaufelberger ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-

Re: [Dbix-class] Relationship question/database structure

2011-01-10 Thread Rolf Schaufelberger
s', 'obj_id', { where => { obj_name => 'pay_order'} }); Thats it, just add the table info in the attr part of has_many. I never need a relation the other way , from allstatus to one of the status logging tables, there is no use case for that. Regards Rolf

[Dbix-class] Strange beaviour with bind_params for function call (Update)

2010-10-04 Thread Rolf Schaufelberger
I've found why the function is called 28 time, since I user search({}, {…}) and I have 28 records in my database…. Yet,that means I have no way to call a function just once without specifying a search that returns just one result row. So , switching back to dbh->do… Rolf

[Dbix-class] Strange beaviour with bind_params for function call

2010-10-04 Thread Rolf Schaufelberger
5, delta_m 10, act 0 [for Statement "SELECT TEST_PRICES( ?, ?, ?, ?, ?::integer[] ) FROM price_version me" with ParamValues: 1='MyComment', 2='5', 3='10', 4='0', 5='{"6024"}'] at /home/rs/perl/xx.pl line 37 r...@ubuntu: That l

[Dbix-class] Backrefernce to parent object

2010-10-04 Thread Rolf Schaufelberger
e calling user object ? (aside from the aspect, whether this is a good design I'm curious how to do this ) Rolf Schaufelberger ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-c

Re: [Dbix-class] Detecting a "belongs_to" relationship.

2010-03-24 Thread Rolf Schaufelberger
n/mailman/listinfo/dbix-class > IRC: irc.perl.org#dbix-class > SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ > Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk Mit freundlichen Grüßen Rolf Schaufelberger Geschäftsführer plusW GmbH Vorstadtstr. 61 -

[Dbix-class] get Defaults after create

2008-01-28 Thread Rolf Schaufelberger
a->resultset('XY')->find($obj->id); while my $obj = $schema->resultset('XY')->create({...} , {fetch=>1}); would be nicer. -- Rolf Schaufelberger ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/list

Re: [Dbix-class] bug with find_or_new and update_or_insert, for postgres DB -> work around

2008-01-07 Thread Rolf Schaufelberger
should be there since a primary key is defined. Even when I write my $addr = $s->resultset('Address')->update_or_create($fields, {key=>'primary'}); it finds the old record. So, same conclusion as in your case, not useable with for edit/update forms. :-(

[Dbix-class] Get wrong id after insert in Pg

2007-10-29 Thread Rolf Schaufelberger
Hi, I have a table where a trigger creates another record in the same table on INSERT (Postgres 8.2) I've the same workflow working with Class::DBI and so I've checked it again there, but it works OK with Class:DBI Any ideas ? Rolf Scha

[Dbix-class] load_classes question

2007-10-28 Thread Rolf Schaufelberger
understand load_namesaces, but I don't understand the difference between "result class" and result_set class". -- Regards Rolf Schaufelberger ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.or

Re: [Dbix-class] Pg bytea does not work

2007-10-15 Thread Rolf Schaufelberger
first, it works fine! So , how can I force my app to _populate_dbh earlier without doing a placebo select ? -- Regards Rolf Schaufelberger ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev

Re: [Dbix-class] Pg bytea does not work

2007-10-15 Thread Rolf Schaufelberger
On Montag 15 Oktober 2007, John Napiorkowski wrote: > --- Rolf Schaufelberger <[EMAIL PROTECTED]> wrote: > > On Montag 15 Oktober 2007, John Napiorkowski wrote: > > > --- Rolf Schaufelberger <[EMAIL PROTECTED]> wrote: > > > > Hi, > > &

Re: [Dbix-class] Pg bytea does not work

2007-10-15 Thread Rolf Schaufelberger
On Montag 15 Oktober 2007, John Napiorkowski wrote: > --- Rolf Schaufelberger <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I have a table like this: > > id | integer | not > > null default > > nextval('orders.logos_i

[Dbix-class] Pg bytea does not work

2007-10-14 Thread Rolf Schaufelberger
ng with Class::DBI anf now want to move to DBIC. -- Regards Rolf Schaufelberger ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Arc