ications.
I haven't looked into DBD::Pg, I was just curious if I was overlooking
existing functionality.
Thanks!
Adam
--
"it will turn into pointer equality or something Adam Sjøgren
ghastly like that" a...
omething obvious, before hacking together a parser for
Postgres' format.
Best regards,
Adam
Adding Cc to the DBD::Pg mailing list, as it now looks to me to perhaps
not just be me not configuring DBIx::Class properly.
--
Adam Sjøg
old a DBD::Pg version (2.19.0-1), what version are you using?
Best regards,
Adam
--
Adam Sjøgren
a...@novozymes.com
___
List: h
Will writes:
> { data_type => "integer[]", ... }
> works for me?
Ahh, cool, I will try that. My arrays are sometimes of custom types, but
I will experiment.
Thanks for the tip!
Best regards,
Adam
--
ing-with-PostgreSQL-array-types
but not how to read them.)
Any pointers?
Thanks,
Adam
--
Adam Sjøgren
a...@novozymes.com
___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/d
)
Try something like:
my $foos=$schema->resultset('Foo');
while (my $row=$foos->next) {
...
}
Best regards,
Adam
--
"In the past we would do little things for love, but Adam Sjøgren
but things, big things required money.
.pm
> line 1908
> The interesting information is inside that ARRAY ref, unfortunately.
How about adding a line to ASE.pm or DBI.pm that outputs the information
you are after?
Just a crazy idea,
Adam
--
"You know, if the sun was an oboe, what would y
This?
Best regards,
Adam
--
"Angels can fly because they take themselves lightly." Adam Sjøgren
a...@koldfront.dk
___
List: http://lists.scsys.co.uk/cg
the event table and
person objects are then generated for you from that single query.
Running your script with DBIC_TRACE=1 set in the environment is an easy
way to check that prefetching indeed saves you roundtrips to the
database.
Best regards,
Adam
--
"You have to photosynthe
',
> USER', 'PASSWD', { AutoCommit=>1, pg_enable_utf8=>1 });
--
"Good car to drive after a war" Adam Sjøgren
a...@koldfront.dk
__
you asked for something that doesn't use Catalyst and
is small (I left out the helper-sub and the error-checking) :-)
Maybe if you show what you have tried and describe what you wanted, it
is easier to get help.
Best regards,
Adam
--
"Good car to drive after a war"
bms/
Best regards,
Adam
--
"I got into the driver’s seat Adam Sjøgren
And I drove down 42nd Street a...@koldfront.dk
In my Cadillac
Good car to drive after a war"
___
Lis
merge - thanks!
Best regards,
Adam
--
Adam Sjøgren
a...@novozymes.com
___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-cl
them.
Thanks!
Best regards,
Adam
--
Adam Sjøgren
a...@novozymes.com
___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.
drivers.car_id FROM car me LEFT JOIN
driver drivers ON drivers.car_id = me.id WHERE ( me.fleet_id = ? ): '1'
Christensen
Use of uninitialized value in concatenation (.) or string at ./test.pl line
24.
Elgaard
Magnussen
Issuing rollback() for database handle be
om C in that a C relationship
+returns undef or exactly one row, while has_many returns a resultset
+(which can match no, one, or more rows.)
+
=over
=item accessor_name
--
1.6.3.3
--
Adam Sjøgren
at!
Best regards,
Adam
--
Adam Sjøgren
a...@novozymes.com
___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst
ts is discarded with a loud warning.
Thanks for this very clear explanation. It should be shoveled into the
documentation right away!
Best regards,
Adam
--
Adam Sjøgren
;
};
$schema->txn_do($transaction);
Remembering to put the die in there is of course important :-)
Best regards,
Adam
--
Adam Sjøgren
a...@novozymes.com
__
>> and/or
+C<< cascade_delete => 0 >> to the C<$attr> hashref.
The cascaded operations are performed after the requested delete or
update, so if your database has a constraint on the relationship, it
--
"I wan
On Wed, 11 Jun 2008 12:53:34 +0100, Ash wrote:
> On 11 Jun 2008, at 12:35, Adam Sjøgren wrote:
>> and mike provided a test-patch in:
>> <http://article.gmane.org/gmane.comp.lang.perl.modules.dbix-class/5443> .
>> The test-patch broke some other patches, so I post
;fleet_id');
1;
CarDB/Fleet.pm:
---
package CarDB::Fleet;
use strict;
use warnings;
use base qw(DBIx::Class);
__PACKAGE__->load_components('PK::Auto', 'Core');
__PACKAGE__->table('fleet');
__PACKAGE__->add_columns(qw(id company));
__PACKAGE__->set_primary_key('id')
k secs ( 0.74 usr 0.25 sys + 75.95 cusr
5.10 csys = 82.04 CPU)
Result: FAIL
The patch is against the latest 0.08/trunk (I hope that is the right
thing to do).
Best regards,
Adam
--
e usual
> mix that overrides disallowed methods like search_literal, etc.
That sounds cool - I guess it also is way more configurable than what
people are used to today (the few using AutoCommit=0 getting "you forgot
to think about transactions"-feedback early, and the majority
DBI directly instead of going
through DBIx::Class, but I shouldn't and most probably won't).
Best regards,
Adam
--
"Although, in a sense, recognizing them as ancient Adam Sjøgren
might not necessarily be wrong, it's indeed useless." [EMAIL PROTECTED]
__
nice way to ensure that I remember to consider
transactions for all the parts of the code that modifies/adds stuff.
Since txn_do arrived, I know I ought to use that for transactions, every
time I need them, but with AutoCommit=1 I lose the automatic kick in the
head if (when)
On Thu, 18 Oct 2007 18:55:43 +0100, Matt wrote:
> On Thu, Oct 18, 2007 at 04:39:54PM +0200, Adam Sjøgren wrote:
>> $schema->storage->sql_maker->quote_char('"');
>> $schema->storage->sql_maker->name_sep('.');
>> This works fine un
TABLE
INSERT 0 1
$ psql userdb --command 'SELECT * FROM "user" ORDER BY "name" DESC'
id | name
+--
1 | Axel
(1 row)
$ ./test.pl
DBIx::Class::ResultSet::search(): DBI Exception: DBD::Pg::st execute failed:
ERROR: column "name DESC" does
28 matches
Mail list logo
