title: How to compare two .sql files in python?
body: <p>I would like to compare the *.sql files in python and capture the difference in a new file (.sql file)</p>
  
  <p>Are there any packages in python which helps in performing the below tasks.</p>
  
  <p>For example:</p>
  
  <h3>file_1.sql</h3>
  
  <pre><code> CREATE TABLE Persons
   (
   PersonID int,
   LastName varchar(255),
   FirstName varchar(255),
   Address varchar(255),
   City varchar(255)
   );  
  </code></pre>
  
  <h3>file_2.sql</h3>
  
  <pre><code>CREATE TABLE Persons
  (
  PersonID int,
  LastName varchar(255),
  FirstName varchar(255),
  Address varchar(255),
  City varchar(255),
  Salary int,
  JobDetail int
  );
  </code></pre>
  
  <p>Expected Output file -></p>
  
  <h3>diff.sql</h3>
  
  <pre><code>CREATE TABLE Persons
  (
  PersonID int,
  LastName varchar(255),
  FirstName varchar(255),
  Address varchar(255),
  City varchar(255),
  **Salary int,
  JobDetail int**
  );
  </code></pre>