[Dbix-class] Does DBIC support -create() with more clob fields?

2012-01-29 Thread Octavian Rasnita
Hi all, I have an Oracle table with 2 clob columns and I am trying to add a new record in it, using: my $row = $schema-resultset( 'TblName' )-create( { question = 'This is the first question', answer = 'Answer 1', date_time_q = '2012-01-01 00:00:00', date_time_a = '2012-01-01

Re: [Dbix-class] Does DBIC support -create() with more clob fields?

2012-01-29 Thread Peter Rabbitson
Octavian Rasnita wrote: Hi all, I have an Oracle table with 2 clob columns and I am trying to add a new record in it, using: my $row = $schema-resultset( 'TblName' )-create( { question = 'This is the first question', answer = 'Answer 1', date_time_q = '2012-01-01 00:00:00',

[Dbix-class] Extended JOIN syntax

2012-01-29 Thread Bernhard Graf
I have just learned, that the JOIN syntax was improved recently, so it is possible to specify more than just the equality of column values, as shown in the example from DBIx::Class::Relationship::Base: My::Schema::Artist-has_many( cds_80s = 'My::Schema::CD', sub { my $args = shift;

Re: [Dbix-class] Extended JOIN syntax

2012-01-29 Thread Bernhard Graf
Am 29.01.2012 20:42, schrieb Bernhard Graf: The example above still requires the bind values to be defined statically in the schema. I couldn't find any examples, about how to specify bind values at execution time - e.g. likes this: My::Schema::Artist-has_many( cds_era = 'My::Schema::CD', sub

Re: [Dbix-class] Does DBIC support -create() with more clob fields?

2012-01-29 Thread Octavian Rasnita
From: Peter Rabbitson rabbit+d...@rabbit.us Octavian Rasnita wrote: Hi all, I have an Oracle table with 2 clob columns and I am trying to add a new record in it, using: my $row = $schema-resultset( 'TblName' )-create( { question = 'This is the first question', answer = 'Answer

Re: [Dbix-class] Extended JOIN syntax

2012-01-29 Thread Peter Rabbitson
Bernhard Graf wrote: I have just learned, that the JOIN syntax was improved recently, so it is possible to specify more than just the equality of column values, as shown in the example from DBIx::Class::Relationship::Base: My::Schema::Artist-has_many( cds_80s = 'My::Schema::CD', sub {

Re: [Dbix-class] Extended JOIN syntax

2012-01-29 Thread Peter Rabbitson
Bernhard Graf wrote: Am 29.01.2012 20:42, schrieb Bernhard Graf: The example above still requires the bind values to be defined statically in the schema. I couldn't find any examples, about how to specify bind values at execution time - e.g. likes this: My::Schema::Artist-has_many( cds_era =

Re: [Dbix-class] Extended JOIN syntax

2012-01-29 Thread Bernhard Graf
Am 29.01.2012 21:52, schrieb Peter Rabbitson: It is possible, but is not yet particularly pretty. The trick is that the coderef in question is called every time the relationship needs to be resolved. By referencing some external package-global you can control what the coderef will return.

Re: [Dbix-class] Extended JOIN syntax

2012-01-29 Thread Bernhard Graf
Correction: $artist_rs-result_class-era_begin(1979); $artist_rs-result_class-era_end(1990); $artist_rs-search_related('cds_era')-next; Bernhard ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN:

Re: [Dbix-class] Does DBIC support -create() with more clob fields?

2012-01-29 Thread Daniel J. Luke
On Jan 29, 2012, at 11:42 AM, Peter Rabbitson wrote: Crap! I would hazard a guess this is some subtle behavior change in DBD::Oracle. In any case DBIC needs to move away from using the buggy blob support in DBD::Oracle, and use the blob OCI calls directly. I'll try to get on IRC tomorrow to