<p>Update Producer::SQLite and Producer::MySQL to only wrap the trigger<br>
action in "BEGIN...END" when the user has not already done so, bringing<br>
them in line with other producers and the add_trigger documentation.</p>

<p>Fixes <a href="https://github.com/dbsrgits/sql-translator/issues/46" class="issue-link" title="add_trigger inconsistencies">#46</a>.</p>

<p>Signed-off-by: Andrew Gregory <a href="mailto:andrew.gregory.8@gmail.com">andrew.gregory.8@gmail.com</a></p>

<hr>

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

<h4>Commit Summary</h4>
<ul>
  <li>improve add_trigger consistency between producers</li>
</ul>

<h4>File Changes</h4>
<ul>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/48/files#diff-0">lib/SQL/Translator/Producer/MySQL.pm</a>
    (7)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/48/files#diff-1">lib/SQL/Translator/Producer/SQLite.pm</a>
    (4)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/48/files#diff-2">t/38-mysql-producer.t</a>
    (45)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/48/files#diff-3">t/56-sqlite-producer.t</a>
    (32)
  </li>
</ul>

<h4>Patch Links:</h4>
<ul>
  <li><a href='https://github.com/dbsrgits/sql-translator/pull/48.patch'>https://github.com/dbsrgits/sql-translator/pull/48.patch</a></li>
  <li><a href='https://github.com/dbsrgits/sql-translator/pull/48.diff'>https://github.com/dbsrgits/sql-translator/pull/48.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/48">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AASeAs2hNUHE2xWz8ywE3ZHcVjOZx8iZks5nXhB4gaJpZM4DIOO2.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/48"></link>
    <meta itemprop="name" content="View Pull Request"></meta>
  </div>
  <meta itemprop="description" content="View this Pull Request on GitHub"></meta>
</div>