I vote: Proposal A
___
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 Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
Hi,
The current stable version of DBIC
(http://www.cpan.org/authors/id/R/RI/RIBASUSHI/DBIx-Class-0.08250.tar.gz)
does not pass its unit tests on a fresh Perl/CPAN install.
ie. Install Perl (via perlbrew, source, whatever) and then install
cpanminus, and then run
cpanm DBIx::Class
The error is:
On 23 July 2013 20:56, Peter Rabbitson rabbit+d...@rabbit.us wrote:
On Tue, Jul 23, 2013 at 06:58:56PM +1000, Toby Corkindale wrote:
Hi,
What is the correct way to rollback when you're using a
txn_scope_guard, and it's intentional, and you'd rather avoid getting
a scary warning message
Hi,
What is the correct way to rollback when you're using a
txn_scope_guard, and it's intentional, and you'd rather avoid getting
a scary warning message printed to the logs?
-Toby
___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
On 5 November 2012 20:19, Peter Rabbitson rabbit+d...@rabbit.us wrote:
On Fri, Nov 02, 2012 at 03:41:48PM +1100, Toby Corkindale wrote:
Hi,
It used to be the case (some versions ago) that if you died with an object
inside a txn_do() then the re-thrown error would still contain that object
Thanks -- have had a public holiday here and was out getting soaked on
a bike a lot, but will look at the branch shortly and get back to you.
On 5 November 2012 20:19, Peter Rabbitson rabbit+d...@rabbit.us wrote:
On Fri, Nov 02, 2012 at 03:41:48PM +1100, Toby Corkindale wrote:
Hi,
It used
Hi,
It used to be the case (some versions ago) that if you died with an object
inside a txn_do() then the re-thrown error would still contain that object.
However now it seems to be stringified on the way out.
To give an example, I'm sure I used to be able to do this:
try {
$schema-txn_do(sub
(Custom::Exception) { $_-custom_method }
default { die $_ }
}
};
On 2 November 2012 15:41, Toby Corkindale t...@dryft.net wrote:
Hi,
It used to be the case (some versions ago) that if you died with an object
inside a txn_do() then the re-thrown error would still contain that object
On 11 July 2012 23:35, Rob Kinyon rob.kin...@gmail.com wrote:
On Wed, Jul 11, 2012 at 6:11 AM, fREW Schmidt fri...@gmail.com wrote:
I wrote a test that confirms it, but it actually has no where clause at all
when I test it, which is even scarier.
Before we go ahead confirming failures and
Hi,
I discovered what smells like a bug in the as_subselect_rs codepath,
but it may just me doing it wrong..
The Perl code looks like this:
$schema-resultset('Step')-search(
{
file_id = $file_id,
'stage.name' = 'Final',
},
{ join = 'stage' }
On 11 July 2012 15:23, Toby Corkindale t...@dryft.net wrote:
This was on version 0.08196 but I can try on a later one in a moment.
Just confirming it still happens on 0.08198.
--
Turning and turning in the widening gyre
The falcon cannot hear the falconer
Things fall apart; the center cannot
maybe I'd expect something like
DELETE FROM step
WHERE id IN (
SELECT id FROM step
JOIN stage ON (step.stage_id = stage.id)
WHERE step.file_id = ?
AND stage.name = 'Final'
);
On 11 July 2012 15:28, Toby Corkindale t...@dryft.net wrote:
On 11 July 2012 15:23, Toby Corkindale t...@dryft.net
an old
to new version of Perl, due to all the roadblocks in the way, and
because in the process you will almost certainly end up upgrading a
bunch of other things at the same time.
Cheers,
Toby
On Jun 17, 2011, at 2:53, Toby Corkindale t...@dryft.net wrote:
On 14 June 2011 22:40, Peter
On 14 June 2011 22:40, Peter Rabbitson rabbit+d...@rabbit.us wrote:
Toby Corkindale wrote:
On 9 June 2011 17:51, Jorge Gonzalez jorge.gonza...@daikon.es wrote:
BTW, thanks for resurrecting a 3 month old thread :-) I had not checked
the EOL status of 5.8 and 5.10. And then again: RHEL 6
On 9 June 2011 17:51, Jorge Gonzalez jorge.gonza...@daikon.es wrote:
BTW, thanks for resurrecting a 3 month old thread :-) I had not checked the
EOL status of 5.8 and 5.10. And then again: RHEL 6 is based on 5.10, which is
also EOL'ed...?
Yes, only the current and prior-to-current versions
On 1 March 2011 01:39, Jorge Gonzalez jorge.gonza...@daikon.es wrote:
I'm developing an app with Catalyst 5.80024, on perl 5.8.8, 32 bits;
DBIx::Class models.
[snip]
Perl 5.8.x has been beyond end-of-life for quite a while, as has
5.10.x more recently. The 5.8 stream is almost ten years old,
Hi,
I don't know how I failed to pick this up during the testing period
for the .19x versions.
I have some code that fails on dbic .192, but works when rolled back to .127.
The failure is due to the Result class defining some accessors with
mk_classdata() which are referred to from within a
Hi,
I'd like to create functional indexes on some columns..
ie. The raw sql would be:
CREATE TABLE foo (bar TEXT);
CREATE INDEX foo_bar_idx ON foo( lower(bar) );
I'm trying to set this up via a DBIC Schema using sqlt_deploy_hook().
Is there a way?
I've tried
$sqlt_table-add_index(
fields =
Hi,
Background knowledge:
SQLite breaks from SQL traditions by not ignoring trailing whitespace
when comparing strings.
ie. SELECT 'FOO ' = 'FOO'; # returns false
However you can specify that it trim the whitespace and DWIW like this:
SELECT 'FOO ' = 'FOO' COLLATE RTRIM; # returns true
So,
try again now.
Cheers! See below for background topic and then my comments.
On 07/05/10 06:31, Matt S Trout wrote:
On Tue, May 04, 2010 at 01:08:52PM +1000, Toby Corkindale wrote:
On 22/04/10 19:00, Peter Rabbitson wrote:
Toby Corkindale wrote:
Hey all,
Wouldn't it be nice if the ResultSet
On 06/06/10 09:13, Marc Chantreux wrote:
hello all,
I'm pretty new in the ORM world and i'm trying to figure out how to
write very simple webapps as quick as possible. DBIx::Class is awesome
and i would like to use it to add persistence to my buziness objects.
For a given Users class, i would
On 04/06/10 19:02, Will Hawes wrote:
Yesterday a colleague new to DBIC ran into a problem with a column
named using a reserved word in MySQL. He worked around it by using a
different column name, but while discussing the issue he asked why
quote_char and name_sep are not set automatically. I
On 07/05/10 06:31, Matt S Trout wrote:
On Tue, May 04, 2010 at 01:08:52PM +1000, Toby Corkindale wrote:
On 22/04/10 19:00, Peter Rabbitson wrote:
Toby Corkindale wrote:
Hey all,
Wouldn't it be nice if the ResultSet iterators were a bit more advanced?
I would love it if the iterator built
On 22/04/10 19:00, Peter Rabbitson wrote:
Toby Corkindale wrote:
Hey all,
Wouldn't it be nice if the ResultSet iterators were a bit more advanced?
I would love it if the iterator built into DBIx::Class supported some
more functional programming style methods.
ie. So that I could do:
$schema
Hey all,
Wouldn't it be nice if the ResultSet iterators were a bit more advanced?
I would love it if the iterator built into DBIx::Class supported some
more functional programming style methods.
ie. So that I could do:
$schema-resultset('Users')-search(
{ first_name = 'Bob' }
)-foreach(
On 22/04/10 18:57, Peter Rabbitson wrote:
Toby Corkindale wrote:
I think this is actually an SQL::Abstract bug, but the SQLA docs say to
try the dbic mailing lists for support, so..
Steps to reproduce under SQL::Abstract:
my $sql = SQL::Abstract-new;
my($stmt, @bind) = $sql-select('foo
I think this is actually an SQL::Abstract bug, but the SQLA docs say to
try the dbic mailing lists for support, so..
Steps to reproduce under SQL::Abstract:
my $sql = SQL::Abstract-new;
my($stmt, @bind) = $sql-select('foo', 'foo', {
address = { '=' = '10.2.3.4' },
}
);
$stmt
I was browsing the CPAN module list, and I noticed that although various
DBIx::Class::* plugins are listed, DBIx::Class itself is not.
I thought that was a bit odd.
http://search.cpan.org/modlist/Database_Interfaces/DBIx
Cheers,
Toby
___
List:
Leandro Hermida wrote:
Hi everyone,
Been a long time since I've posted on this list, but been using
DBIx::Class for a couple years now and love it... great software.
Anywho, I've wrriten this code which do parallel processing (using
Parallel::Forker) within a single DBIx::Class transaction.
Toby Corkindale wrote:
Jacob Bunk Nielsen wrote:
Hi
I have read an interesting blog post about how prepared statements in
PostgreSQL does not work well with LIKE searches. It can be found at:
http://blog.endpoint.com/2009/08/debugging-prepared-statements.html
I'm hit by this in several places
Peter Rabbitson wrote:
Greetings
Pre-release tarball of DBIC 0.08108 is now available at [1]. There
was a ton of improvements under the hood, but from a user perspective
everything should remain the same. The tarball should end up on CPAN
by the end of next week if no problem reports are
Hi,
Catalyst::Model::DBIC::Schema lists Catalyst::Devel as an *optional*
dependency.
However if you do not have Catalyst::Helper installed (via
Catalyst::Devel) then C-M-DBIC-Schema fails its unit tests and won't
install via CPAN.
-Toby
___
Attempting to install DBIC 0.08104, results in:
perl Makefile.PL
...
Checking if your kit is complete...
Warning: the following files are missing in your kit:
t/47bind_attribute.t
t/66relationship.t
t/96multi_create/cd_single.t
Matt S Trout wrote:
On Wed, Jun 03, 2009 at 06:14:13PM +1000, Toby Corkindale wrote:
Hi guys,
I've encountered a regression in DBIC, introduced in revision 5298.
It's more than likely that the way things were being done in the code
here were not correct and *shouldn't* have worked previously
Toby Corkindale wrote:
Hi guys,
I've encountered a regression in DBIC, introduced in revision 5298.
It's more than likely that the way things were being done in the code
here were not correct and *shouldn't* have worked previously, but I
can't seem to work it out myself.
There's a single
Toby Corkindale wrote:
Therefore I'd like to propose that DBIC implements direct accessors for
resultsets, so that I can type:
$schema-MyObject-find(1);
[snip]
Well, no-one spoke up, so here's the patch (against svn trunk).
It allows you to access resultsets via a direct method off $schema
Peter Rabbitson wrote:
Toby Corkindale wrote:
Hi,
Another task I commonly do in DBIC is to access resultsets from the
$schema object, eg:
$schema-resultset('MyObject')-find(1);
Sometimes I make a mistake, and write:
$schema-resultset('MyObjcet')-find(1);
However that compiles just fine
Hi,
Another task I commonly do in DBIC is to access resultsets from the
$schema object, eg:
$schema-resultset('MyObject')-find(1);
Sometimes I make a mistake, and write:
$schema-resultset('MyObjcet')-find(1);
However that compiles just fine, and won't get picked up until that bit
of code is
Jess Robinson wrote:
On Thu, 2 Apr 2009, Toby Corkindale wrote:
Start by assuming I'm smoking crack and do actually want to do this.. :)
If I have a $schema that is already initialised, and I decide I want
to add a new relationship to one of my tables, what is the proper way
to do
so
Hi,
Start by assuming I'm smoking crack and do actually want to do this.. :)
If I have a $schema that is already initialised, and I decide I want to
add a new relationship to one of my tables, what is the proper way to do
so?
Is it this?
my $schema = ExampleApp-connect(..);
my
Toby Corkindale wrote:
Hi,
Start by assuming I'm smoking crack and do actually want to do this.. :)
If I have a $schema that is already initialised, and I decide I want to
add a new relationship to one of my tables, what is the proper way to do
so?
Is it this?
my $schema = ExampleApp
Peter Rabbitson wrote:
Toby Corkindale wrote:
Peter Rabbitson wrote:
Toby Corkindale wrote:
I need to stop replying to myself :(
I'd say the problem lies this block of code:
# Look through the @INC path to find the file
foreach ( @try_first, @INC ) {
my $full = $_/$filename
Peter Rabbitson wrote:
Toby Corkindale wrote:
I need to stop replying to myself :(
I'd say the problem lies this block of code:
# Look through the @INC path to find the file
foreach ( @try_first, @INC ) {
my $full = $_/$filename;
next unless -e $full;
return $UNIX
Toby Corkindale wrote:
Hi,
I seem to have hit an issue in a specific case:
Deployment, to a Postgres DB, when DBIx::Class is running from a PAR file.
The crux is that DBIx::Class::Storage::DBI::Pg has overridden
sqlt_type() to return 'PostgreSQL' rather than the default behaviour
from DBIx
John Siracusa wrote:
On Mon, Jan 12, 2009 at 11:41 PM, Darren Duncan dar...@darrenduncan.net wrote:
Note that I was also thinking about the fact that 1.14 is known in some
circles to have introduced bugs that 1.13 didn't have, so being able to
address this would take more C-fu than simply
Darren Duncan wrote:
Toby Corkindale wrote:
The disconnection code is borked too; if you connect, do some work
with statement handles, and disconnect again, and then repeat many
times in the same process, you'll crash out eventually.
The annoying thing is that there are trivial patches
Darren Duncan wrote:
Good news everyone!
The SQLite DBMS, as of the new version 3.6.8, now has nested transaction
support.
See http://www.sqlite.org/releaselog/3_6_8.html for the release
announcement, and http://www.sqlite.org/lang_savepoint.html for
documentation of the feature.
As far
Adam Witney wrote:
[snip]
The second place i might need this is that i have some data in a
second database and so i would have to interact with this using
dblink (I am using PostgreSQL). This seems easier to just write the
query in a method?
Doesn't Pg just represent the foreign DBI-Linked
Adam Witney wrote:
I am new to DBIx::Class, but have so far been impressed with how easy
it is to use, so thanks to those that have developed and continue to
develop it.
I wanted to know, is there a way of adding a method to a class that
performs a separate database lookup. I have used the
49 matches
Mail list logo