Perl > dbix-class > October 2012

Hi, I've seen examples of searching in a database using the LIKE operator like: $rs = $rs- search( { name = { -like = "%$name%" }, } ); It doesn't look to be very secure to quote the variable $name ...

I have a Postgres table with a timestamp field that defaults to the current time: CREATE TABLE "notes" ( "id" SERIAL PRIMARY KEY NOT NULL, "note" TEXT, "created" TIMESTAMP NOT NULL DEFAULT ...

I'm running ActivePerl v5.16.1 on Win2008 R2 x64. Anyone see the below error message before? Running same script on x86 machine produces no such error. P:\test perl "test.pl" Can't locate object ...

I am only intending to update a column in a row based on 'item' value. Item value is unique constraint column. DBIx code: $schema- resultset('Itemlist')- update( { item = $item, item_comment = ...

Hi, yesterday I have released the initial version of DBIx::Table::TestDataGenerator, see http://search.cpan.org/~jds/DBIx-Table-TestDataGenerator-0.001/ Its goal is to support testing database ...

Dear DBIx-Class mailing list Hereby we'd like to inform you about a new package related to DBIx::Class. Its objective is to bring efficient and convenient methods for dealing with Lookup Tables. We ...

this straight lift from documentation is not working. what could i be doing wrong? my @all_artists = $schema- resultset('Artist')- search(undef, { columns = [qw/name artistid/], }); my query is: my ...

Hello All, I've just shipped a dev rel that fixes the menagerie of fun issues we got with the previous release and SQLite on various configurations. Assuming we don't get black smoke in the next day ...

Dear All, I have bit of SQL (mysql) which joins three tables to get all the records form the first table and sums from the 2 remaining tables. The SQL looks like: select t1.*, t2_total, t3_total from ...

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 ...

Greetings! We have found out that the number of CachedKids hash elements becomes too big during the life cycle of the DBIx::Class object. How can we limit it to avoid memory usage growth? Thank you! ...

I have a legacy database that has Date type data in the local timezone rather than UTC. As such I have these statements in my class definitions: "creation_date", { data_type = "DATE", timezone = ...

Hello, I guess a very basic question. In the following example: from http://search.cpan.org/~mstrout/DBIx-Class-0.08202/lib/DBIx/Class/ResultSet.pm my @cds = $cd_rs- search({ year = 2001 }); # ".. ...

I've just released Search::Query::Dialect::DBIxClass to CPAN [1]. It uses Search::Query to parse a query string and transforms it into a hashref than can be passed to $rs- search(_rs). The ...

Ok, this release has what 0.08202_01 had in it; so it should fix the SQLite connection regressions on all platforms. -- fREW A non-text attachment was scrubbed... Name: signature.asc Type ...

I fail to implement the following scenario properly with DBIC -) There are Users. -) A User has_many Tests. -) A Test has_many Steps. -) Steps have a 'type' attribute. -) A Step of type 'SubTest' ...

Hi all - I'm trying to install the latest version of DBIx::Class via cpanm. I'm running perl 5.14 under Ubuntu 12.04. The installation fails with: -- Working on DBIx::Class Fetching ...