[jifty-devel] autoincrement id

IN SUK JOUNG i.joung at gmail.com
Wed Mar 21 12:15:33 EDT 2007


Then, it should be...
%typemap = (
    'SERIAL' => 'INTEGER PRIMARY KEY AUTOINCREMENT'
);

That's simple! Do you still want me to send Ivan this patch? Or would you?

On 3/21/07, Jesse Vincent <jesse at bestpractical.com> wrote:
>
>
> On Mar 21, 2007, at 1:00 AM, IN SUK JOUNG wrote:
>
> I guess DBIx::DBSchema is fine. Autoincrement is just need to be specified
> when creating tables.
> So, in Jifty when it creats DBIx::DBSchema::Table object, it should be
> implemented. Would you indicate where the step is in Jifty?
>
>
> The trick is that we're passing the 'SERIAL' type to DBIx::DBSchema. Which
> it's mapping using this code:
>
> %typemap = (
> 'SERIAL' => 'INTEGER PRIMARY KEY'
> );
>
> That's the code I think wants to be changed to have the AUTOINCREMENT
> keyword.
>
> -jesse
>
>
> On 3/19/07, Jesse Vincent <jesse at bestpractical.com> wrote:
> >
> > Ah hah! I wonder how long that's been true.
> > The problem is here:
> > http://search.cpan.org/src/IVAN/DBIx-DBSchema-0.31/DBSchema/DBD/SQLite.pm
> >
> > Want to send ivan a patch to fix the behaviour?
> >
> > -j
> >
> > On Mar 19, 2007, at 11:57 PM, IN SUK JOUNG wrote:
> >
> > Sqlite does support autoincrement...
> > http://www.sqlite.org/autoinc.html
> >
> > On 3/19/07, Jesse Vincent < jesse at bestpractical.com > wrote:
> > >
> > >
> > > On Mar 19, 2007, at 11:18 PM, IN SUK JOUNG wrote:
> > >
> > > > Window XP, Sqlite3
> > > > Currently, it adds 1 to the maximum value of id. That is, if I
> > > > remove the last item and add a new item. The two items have same id.
> > > >
> > > Hm. We're just using SQLite's sequence support.  I wouldn't expect
> > > that behaviour.
> > >
> > >
> > > _______________________________________________
> > > jifty-devel mailing list
> > > jifty-devel at lists.jifty.org
> > > http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel
> > >
> > >
> > >
> >
> >
> > --
> > Best,
> > In-Suk Joung_______________________________________________
> > jifty-devel mailing list
> > jifty-devel at lists.jifty.org
> > http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel
> >
> >
> >
> > _______________________________________________
> > jifty-devel mailing list
> > jifty-devel at lists.jifty.org
> > http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel
> >
> >
> >
>
>
> --
> Best,
> In-Suk Joung_______________________________________________
> jifty-devel mailing list
> jifty-devel at lists.jifty.org
> http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel
>
>
>
> _______________________________________________
> jifty-devel mailing list
> jifty-devel at lists.jifty.org
> http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel
>
>
>


-- 
Best,
In-Suk Joung
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.bestpractical.com/pipermail/jifty-devel/attachments/20070321/d36baf8d/attachment.htm


More information about the jifty-devel mailing list