<p dir="auto">Adds functionality to Producer/Oracle.pm to drop constraints and drop fields. Related tests have been added as well.</p>
<p dir="auto">Changes were modeled after the structure of Producer/MySQL.pm.</p>
<p dir="auto">This branch also includes changes from pull request <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1334917264" data-permission-text="Title is private" data-url="https://github.com/dbsrgits/sql-translator/issues/142" data-hovercard-type="pull_request" data-hovercard-url="/dbsrgits/sql-translator/pull/142/hovercard" href="https://github.com/dbsrgits/sql-translator/pull/142">#142</a></p>

<hr>

<h4>You can view, comment on, or merge this pull request online at:</h4>
<p>&nbsp;&nbsp;<a href='https://github.com/dbsrgits/sql-translator/pull/143'>https://github.com/dbsrgits/sql-translator/pull/143</a></p>

<h4>Commit Summary</h4>
<ul>
  <li><a href="https://github.com/dbsrgits/sql-translator/pull/143/commits/ca601dbbeb7150ac99a0eb9a9ca20d13e26a08da" class="commit-link">ca601db</a>  Added support for CURRENT_TIMESTAMP as a default value when parsing Oracle SQL.</li>
  <li><a href="https://github.com/dbsrgits/sql-translator/pull/143/commits/0d8ce8f2703e11cb0201a6cbf0e1485950c305c1" class="commit-link">0d8ce8f</a>  Added tests to verify changes to oracle parser.</li>
  <li><a href="https://github.com/dbsrgits/sql-translator/pull/143/commits/dbd1da135552f60464019a2bef10ee0d52e1d51a" class="commit-link">dbd1da1</a>  Split the creation of contraints out from the creation of the table and added alter_create_constraint and alter_drop_constraint functions.</li>
  <li><a href="https://github.com/dbsrgits/sql-translator/pull/143/commits/929ae338b01d4a6857c17428c03a671cdd4d6d6c" class="commit-link">929ae33</a>  Missing a few small things</li>
  <li><a href="https://github.com/dbsrgits/sql-translator/pull/143/commits/ed59a4dd418e95b504f476819b75b73166e78d45" class="commit-link">ed59a4d</a>  Added drop_field to Oracle.pm and added alter constraint testing.</li>
</ul>

<h4 style="display: inline-block">File Changes </h4> <p style="display: inline-block">(<a href="https://github.com/dbsrgits/sql-translator/pull/143/files">8&nbsp;files</a>)</p>
<ul>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/143/files#diff-fee87e81d291d1a4b392d6723d0db13ade044fbc41f7895cab6fc472d3febb50">lib/SQL/Translator/Parser/Oracle.pm</a>
    (17)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/143/files#diff-46fe9adb335e20788e4267133b929fb39616ad439adb14bd5b49eab7576c457b">lib/SQL/Translator/Producer/Oracle.pm</a>
    (160)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/143/files#diff-666e9885108f5d96971caa1c47629eaa9c0d78582c117a0d7221833b43981164">t/15oracle-parser.t</a>
    (15)
  </li>
  <li>
    <strong>A</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/143/files#diff-2961ab55b2fe793b7c51d5d7625d5ff1eba4582ef3fa9954629800dc35762ad0">t/54-oracle-alter-constraint.t</a>
    (55)
  </li>
  <li>
    <strong>R</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/143/files#diff-a8f60fdb7540136980d184d727da64e7253c996cd0694865d79c78724fa0da01">t/55-oracle-add-drop-field.t</a>
    (7)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/143/files#diff-196652cb5400dbc616bd485824c5f5a49b73d1e6ba2549a02ec6e22c281138e6">t/data/oracle/schema_diff_b.yaml</a>
    (11)
  </li>
  <li>
    <strong>A</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/143/files#diff-3d4d7fdd35c2f6a8a666b1a75aac7a0b191fa3092fc770be091f8506704b32a3">t/data/oracle/schema_diff_d.yaml</a>
    (73)
  </li>
  <li>
    <strong>A</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/143/files#diff-3082650df7b4293963c068cc27d240083157228006a0aa6eb3723ec34c520737">t/data/oracle/schema_diff_e.yaml</a>
    (70)
  </li>
</ul>

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

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">&mdash;<br />Reply to this email directly, <a href="https://github.com/dbsrgits/sql-translator/pull/143">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AACJ4AQQTRQBF6LBORCNAKLVZ6ZMNANCNFSM57BJTHFA">unsubscribe</a>.<br />You are receiving this because you are subscribed to this thread.<img src="https://github.com/notifications/beacon/AACJ4AURG3V5X3MBCDG7TJDVZ6ZMNA5CNFSM57BJTHFKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4UBF5D2A.gif" height="1" width="1" alt="" /><span style="color: transparent; font-size: 0; display: none; visibility: hidden; overflow: hidden; opacity: 0; width: 0; height: 0; max-width: 0; max-height: 0; mso-hide: all">Message ID: <span>&lt;dbsrgits/sql-translator/pull/143</span><span>@</span><span>github</span><span>.</span><span>com&gt;</span></span></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/dbsrgits/sql-translator/pull/143",
"url": "https://github.com/dbsrgits/sql-translator/pull/143",
"name": "View Pull Request"
},
"description": "View this Pull Request on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>