ddlparser 1.1

parse sql , compare two .sql file , generate optimization hint for your sql and various other utilities

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 it is parsing ?

• 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 .

1. Just Open the Terminal
2. type sondesh
3. VOALAA !!!!!

What Next :

1. Integration to remote file system to load .sql from there and parse it
2. Integration with data-catalogues like spark catalogue or hive metastore and compare ddl.