Skip Menu |

This queue is for tickets about the DBIx-Class-Schema-Loader CPAN distribution.

Report information
The Basics
Id: 31473
Status: resolved
Priority: 0/
Queue: DBIx-Class-Schema-Loader

People
Owner: ilmari+cpan [...] ilmari.org
Requestors: frankg [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in: 0.04003
Fixed in: (no value)



Subject: Missing "is_auto_increment" => 1 when creating files
Config =================== perl 5.8.8 mysql 5.0.45 OS: Fedora 7 uname: Linux fgutierr-f7 2.6.23.1-21.fc7 #1 SMP Thu Nov 1 21:09:24 EDT 2007 i686 i686 i386 GNU/Linux DBIx-Class-Schema-Loader: 0.04003 Problem =================== When loader created a Schema file from the database -- the resulting schema file did not have "is_auto_increment" => 1 P.S. I was asked by castaway to send you this bug report Generated Schema File ==================== package Schema::Data; use strict; use warnings; use base 'DBIx::Class'; __PACKAGE__->load_components("Core"); __PACKAGE__->table("data"); __PACKAGE__->add_columns( "id", { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, "date", { data_type => "DATE", default_value => "", is_nullable => 0, size => 10 }, "type", { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 80 }, "spot", { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 80 }, "amount", { data_type => "DOUBLE", default_value => "", is_nullable => 0, size => 64 }, "category", { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 80 }, ); __PACKAGE__->set_primary_key("id"); # Created by DBIx::Class::Schema::Loader v0.04003 @ 2007-12-13 01:58:33 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:N51lB7tjwMMQr2238Z8C7Q # You can replace this text with custom content, and it will be preserved on regeneration 1;
Show quoted text
> Problem > =================== > When loader created a Schema file from the database -- the resulting > schema file did not have "is_auto_increment" => 1
This feature has now been added to the "current" branch, since it changes the generated schema. It only supports MySQL, SQLite and PostgreSQL so far, since I don't have access to DB2 or Oracle.
From: colin.fine [...] pace.co.uk
On Fri Dec 14 00:04:20 2007, ilmari wrote: Show quoted text
> > Problem > > =================== > > When loader created a Schema file from the database -- the resulting > > schema file did not have "is_auto_increment" => 1
> > This feature has now been added to the "current" branch, since it > changes the generated schema. > > It only supports MySQL, SQLite and PostgreSQL so far, since I don't have > access to DB2 or Oracle.
Please would you explain the implications of this reply, and of setting the status to 'stalled'? From my point of view, I have encountered a bug, tracked it down and found that it has already been reported. What happens next?
Subject: Re: [rt.cpan.org #31473] Missing "is_auto_increment" => 1 when creating files
Date: Mon, 11 Feb 2008 17:07:55 -0800
To: bug-DBIx-Class-Schema-Loader [...] rt.cpan.org
From: "Frank Gutierrez" <dearfrankg [...] gmail.com>
Colin, I was asked to file this by "castaway" on #catalyst - irc.perl,org that person can tell you more. -frank On Feb 11, 2008 2:48 AM, Colin Fine via RT < bug-DBIx-Class-Schema-Loader@rt.cpan.org> wrote: Show quoted text
> > <URL: http://rt.cpan.org/Ticket/Display.html?id=31473 > > > On Fri Dec 14 00:04:20 2007, ilmari wrote:
> > > Problem > > > =================== > > > When loader created a Schema file from the database -- the resulting > > > schema file did not have "is_auto_increment" => 1
> > > > This feature has now been added to the "current" branch, since it > > changes the generated schema. > > > > It only supports MySQL, SQLite and PostgreSQL so far, since I don't have > > access to DB2 or Oracle.
> > Please would you explain the implications of this reply, and of setting > the status to 'stalled'? From my point of view, I have encountered a > bug, tracked it down and found that it has already been reported. What > happens next? >
On Mon Feb 11 05:48:25 2008, COLINFINE wrote: Show quoted text
> On Fri Dec 14 00:04:20 2007, ilmari wrote:
> > > Problem > > > =================== > > > When loader created a Schema file from the database -- the resulting > > > schema file did not have "is_auto_increment" => 1
> > > > This feature has now been added to the "current" branch, since it > > changes the generated schema. > > > > It only supports MySQL, SQLite and PostgreSQL so far, since I don't have > > access to DB2 or Oracle.
> > Please would you explain the implications of this reply, and of setting > the status to 'stalled'? From my point of view, I have encountered a > bug, tracked it down and found that it has already been reported. What > happens next?
The bug has been fixed in the branch that will be released as 0.05 soon (it is available as a development release at http://search.cpan.org/~ilmari/DBIx-Class-Schema-Loader-0.04999_02/). I marked the bug as "stalled" since I was waiting for help from others to add support for Oracle and DB2. Oracle support has since been added, so I'm just waiting for someone who knows DB2 before this bug can be closed and 0.05 released. Hope that clarifies the situation.
This is now complete. Dev release as 0.04999_04.