Then, it should be...<br>%typemap = (<br> 'SERIAL' => 'INTEGER PRIMARY KEY AUTOINCREMENT'<br>);<br><br>That's simple! Do you still want me to send Ivan this patch? Or would you?<br><br><div><span class="gmail_quote">
On 3/21/07, <b class="gmail_sendername">Jesse Vincent</b> <<a href="mailto:jesse@bestpractical.com">jesse@bestpractical.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style=""><br><div><span class="q"><div>On Mar 21, 2007, at 1:00 AM, IN SUK JOUNG wrote:</div><br><blockquote type="cite">I guess DBIx::DBSchema is fine. Autoincrement is just need to be specified when creating tables.
<br>So, in Jifty when it creats DBIx::DBSchema::Table object, it should be implemented. Would you indicate where the step is in Jifty? <br><br></blockquote><div><br></div></span><div>The trick is that we're passing the 'SERIAL' type to DBIx::DBSchema. Which it's mapping using this code:
</div><div><br></div><div style="margin: 0px;"><font face="Helvetica" size="3"><span style="font-size: 12px;">%typemap = (</span></font></div><div style="margin: 0px;"><font face="Helvetica" size="3"><span style="font-size: 12px;">
'SERIAL' => 'INTEGER PRIMARY KEY'</span></font></div><div style="margin: 0px;"><font face="Helvetica" size="3"><span style="font-size: 12px;">);</span></font></div><div style="margin: 0px;"><font face="Helvetica" size="3">
<span style="font-size: 12px;"><br></span></font></div><div style="margin: 0px;"><font face="Helvetica" size="3"><span style="font-size: 12px;">That's the code I think wants to be changed to have the AUTOINCREMENT keyword.
</span></font></div><span class="sg"><div style="margin: 0px;"><font face="Helvetica" size="3"><span style="font-size: 12px;"><br></span></font></div><div style="margin: 0px;"><font face="Helvetica" size="3"><span style="font-size: 12px;">
-jesse</span></font></div></span><div><span class="e" id="q_111750ec9f9e93ce_4"><div><br></div><br><blockquote type="cite"><div><span class="gmail_quote">On 3/19/07, <b class="gmail_sendername">Jesse Vincent</b> <<a href="mailto:jesse@bestpractical.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
jesse@bestpractical.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div>Ah hah! I wonder how long that's been true.
<div><br></div><div><font face="Helvetica" size="3"><span style="font-size: 12px;">The problem is here: <a href="http://search.cpan.org/src/IVAN/DBIx-DBSchema-0.31/DBSchema/DBD/SQLite.pm" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://search.cpan.org/src/IVAN/DBIx-DBSchema-0.31/DBSchema/DBD/SQLite.pm</a></span></font></div><div><font face="Helvetica" size="3"><span style="font-size: 12px;"><br></span></font></div><div><font face="Helvetica" size="3">
<span style="font-size: 12px;">Want to send ivan a patch to fix the behaviour?</span></font></div><span><div><font face="Helvetica" size="3"><span style="font-size: 12px;"><br></span></font></div><div><font face="Helvetica" size="3">
<span style="font-size: 12px;">-j</span></font></div></span><div><span><div><font face="Helvetica" size="3"><span style="font-size: 12px;"><br></span></font><div><div>On Mar 19, 2007, at 11:57 PM, IN SUK JOUNG wrote: </div>
<br><blockquote type="cite">Sqlite does support autoincrement...<br><a href="http://www.sqlite.org/autoinc.html" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.sqlite.org/autoinc.html </a>
<br><br><div><span class="gmail_quote">On 3/19/07, <b class="gmail_sendername">Jesse Vincent</b> < <a href="mailto:jesse@bestpractical.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">jesse@bestpractical.com
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>On Mar 19, 2007, at 11:18 PM, IN SUK JOUNG wrote: <br><br>> Window XP, Sqlite3
<br>> Currently, it adds 1 to the maximum value of id. That is, if I<br>> remove the last item and add a new item. The two items have same id.<br>><br>Hm. We're just using SQLite's sequence support. I wouldn't expect
<br>that behaviour.<br><br><br>_______________________________________________<br>jifty-devel mailing list<br><a href="mailto:jifty-devel@lists.jifty.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
jifty-devel@lists.jifty.org</a><br><a href="http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"> http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel
</a><br><br><br></blockquote></div><br><br clear="all"><br>-- <br>Best,<br>In-Suk Joung<div style="margin: 0px;">_______________________________________________</div><div style="margin: 0px;">jifty-devel mailing list</div>
<div style="margin: 0px;"><a href="mailto:jifty-devel@lists.jifty.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">jifty-devel@lists.jifty.org</a></div><div style="margin: 0px;"><a href="http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel</a></div> </blockquote></div><br></div></span></div></div><br>_______________________________________________<br>jifty-devel mailing list<br><a href="mailto:jifty-devel@lists.jifty.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
jifty-devel@lists.jifty.org</a><br><a href="http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel
</a><br><br><br clear="all"></blockquote></div><br><br clear="all"><br>-- <br>Best,<br>In-Suk Joung<div style="margin: 0px;">_______________________________________________</div><div style="margin: 0px;">jifty-devel mailing list
</div><div style="margin: 0px;"><a href="mailto:jifty-devel@lists.jifty.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">jifty-devel@lists.jifty.org</a></div><div style="margin: 0px;"><a href="http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel</a></div> </blockquote></span></div></div><br></div><br>_______________________________________________<br>jifty-devel mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:jifty-devel@lists.jifty.org">
jifty-devel@lists.jifty.org</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel" target="_blank">http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel
</a><br><br><br clear="all"></blockquote></div><br><br clear="all"><br>-- <br>Best,<br>In-Suk Joung