<p>Hello, </p>

<p>Here is another attempt to introduce sqlite monotonic autoincrement which tries to be back-compatible.</p>

<p>Without extending <code>SQL::Translator::Schema::Field</code> I decided to use <code>extra</code> field to store type of autoincrement, which later could be re-used from Producer.</p>

<p>I hope this would be OK.</p>

<p>I tried to use it directly in <code>DBIx::Class</code> :</p>

<div class="highlight highlight-perl"><pre>
{ <span class="pl-c1">data_type</span> =&gt; <span class="pl-s1"><span class="pl-pds">"</span>integer<span class="pl-pds">"</span></span>, <span class="pl-c1">is_auto_increment</span> =&gt; 1, <span class="pl-c1">is_nullable</span> =&gt; 0, <span class="pl-c1">extra</span> =&gt; { <span class="pl-c1">autoinc_method</span> =&gt; <span class="pl-s1"><span class="pl-pds">'</span>sequence<span class="pl-pds">'</span></span> } }
</pre></div>

<ul class="task-list">
<li>it works that way. But how to specify extra more correctly in DBIx::Class? i..e outside of auto-generated sources?</li>
</ul>

<p>Thanks for the great project!</p>

<hr>

<h4>You can merge this Pull Request by running</h4>
<pre>  git pull https://github.com/basiliscos/p5-sql-translator master</pre>
<p>Or view, comment on, or merge it at:</p>
<p>&nbsp;&nbsp;<a href='https://github.com/dbsrgits/sql-translator/pull/47'>https://github.com/dbsrgits/sql-translator/pull/47</a></p>

<h4>Commit Summary</h4>
<ul>
  <li>Backward-compatible sqlite autoincrement</li>
</ul>

<h4>File Changes</h4>
<ul>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/47/files#diff-0">AUTHORS</a>
    (1)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/47/files#diff-1">lib/SQL/Translator/Generator/DDL/SQLite.pm</a>
    (14)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/47/files#diff-2">t/56-sqlite-producer.t</a>
    (19)
  </li>
</ul>

<h4>Patch Links:</h4>
<ul>
  <li><a href='https://github.com/dbsrgits/sql-translator/pull/47.patch'>https://github.com/dbsrgits/sql-translator/pull/47.patch</a></li>
  <li><a href='https://github.com/dbsrgits/sql-translator/pull/47.diff'>https://github.com/dbsrgits/sql-translator/pull/47.diff</a></li>
</ul>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">&mdash;<br>Reply to this email directly or <a href="https://github.com/dbsrgits/sql-translator/pull/47">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AASeAnu28QxaXwARR_7kw1NNcWJjRphVks5nVUOEgaJpZM4DFbLf.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
  <div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
    <link itemprop="url" href="https://github.com/dbsrgits/sql-translator/pull/47"></link>
    <meta itemprop="name" content="View Pull Request"></meta>
  </div>
  <meta itemprop="description" content="View this Pull Request on GitHub"></meta>
</div>