<p>rename_field is ignored by Producer::SQLite and the existing tests have:</p>

<p>SELECT ... physical_description FROM person"</p>

<p>which should be:</p>

<p>SELECT ... description FROM person"</p>

<p>Patches address this and try to make some of the code (mostly inside batch_alter_table) more readable.</p>

<hr>

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

<h4>Commit Summary</h4>
<ul>
  <li>make Producer::SQLite::batch_alter_table more readable</li>
  <li>add sub _quote to Producer::SQLite</li>
  <li>start on fixing field rename in sqlite producer</li>
  <li>finish Producer::SQLite::batch_alter_table rename_field fix + update t</li>
  <li>go back to using new table for temp table ddl in Producer::SQLite</li>
  <li>remove some cruft from Producer::SQLite</li>
</ul>

<h4>File Changes</h4>
<ul>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/39/files#diff-0">lib/SQL/Translator/Producer/SQLite.pm</a>
    (125)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/39/files#diff-1">t/30sqlt-new-diff-sqlite.t</a>
    (4)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/39/files#diff-2">t/72-sqlite-add-drop-fields.t</a>
    (2)
  </li>
</ul>

<h4>Patch Links:</h4>
<ul>
  <li><a href='https://github.com/dbsrgits/sql-translator/pull/39.patch'>https://github.com/dbsrgits/sql-translator/pull/39.patch</a></li>
  <li><a href='https://github.com/dbsrgits/sql-translator/pull/39.diff'>https://github.com/dbsrgits/sql-translator/pull/39.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/39">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/302594__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcxODcxOTM1MSwiZGF0YSI6eyJpZCI6MzQ5NTcwMjB9fQ==--e8c173591e2db3bb3e4699ec2b666b238d64d298.gif" width="1" /></p>