parse sql , compare two .sql file , generate optimization hint for your sql and various other utilities
Project description
Project : Sondesh
Description
Sondesh is the name of my cat . I love him very much so i've decided to name this project after him.
This project is all about a parser and comparator . Question is what is parse ?
- It parse SQL statements , but only DDL statements
- It supports many sql dialects , example oracle , postgresql , sparksql , hive ..
- There is a cli app ( cli_app.py ), it compares two DDL statements and show you the differences in terminal
How to use the cli app ?
python cli_app.py
- Then just follow the instruction in the terminal
- You either paste the raw sql or paste any absolute / relative path of sql file
Dependencies
- Windows 10 , Debian , BSD these are the supported platform
- Python version >= 3.8
Installing
- ddl_compare can be installed using pip
pip install ddl-parse
Usage
from ddlparser import ddl_parser
import pprint
result = ddl_parser.parse_from_file('/home/koushik/sample_ddl.sql')
pprint.pprint(result)
Using the CLI APP .
- Just Open the Terminal
- type sondesh
- VOALAA !!!!!
What Next :
- Integration to remote file system to load .sql from there and parse it
- Integration with data-catalogues like spark catalogue or hive metastore and compare ddl.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
No source distribution files available for this release.See tutorial on generating distribution archives.
Built Distribution
ddlparser-1.0-py3-none-any.whl
(57.3 kB
view hashes)