Compare SQL schemas
Project description
SQL Compare
Compare SQL schemas.
This package allows to compare two SQL files (or string) to know whether their statements are the same or not. The comparison doesn't care about the order of the columns in a table or the order of the values in an enumerator. It also excludes irrelevant data like comments.
Its main usage is to compare the schemas of two databases (e.g. staging and production).
Installation
$ pip install sql-compare
Usage
Compare two SQL schemas using strings.
import sql_compare
assert sql_compare.compare(first_schema, second_schema)
Compare two SQL schemas using files.
import pathlib
import sql_compare
first_schema = pathlib.Path("/path/to/schema.sql")
second_schema = pathlib.Path("/path/to/other/schema.sql")
assert sql_compare.compare_files(first_schema, second_schema)
Dependencies
SQL Compare relies on sqlparse
to parse SQL statements.
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sql_compare-0.1.3.tar.gz
(8.1 kB
view hashes)
Built Distribution
Close
Hashes for sql_compare-0.1.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 89b1b40f291b7f40fd0ef8c8453b936111bf5eeeb7f18ca00c608ef9468d8d23 |
|
MD5 | 79e3a26090bd666fd9eacd23c0b8a122 |
|
BLAKE2b-256 | a8ab8d032b2ec03187ebd90c07bc7b60591e66d1ae7a1799bf0dc8fe8828f90c |