mardi 12 janvier 2016

How to compare two .sql files in python?

I would like to compare the *.sql files in python and capture the difference in a new file (.sql file)

Are there any packages in python which helps in performing the below tasks.

For example:

file_1.sql

CREATE TABLE Persons ( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) );

file_2.sql

CREATE TABLE Persons ( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255), Salary int, JobDetail int );

Expected Output file ->

diff.sql

CREATE TABLE Persons ( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255), Salary int, JobDetail int );

Aucun commentaire:

Enregistrer un commentaire