Metadata-Version: 2.1
Name: pysqlutil
Version: 1.0.1
Summary: parse sql , compare two .sql file , generate optimization hint for your sql and various other utilities
Home-page: https://github.com/koustreak/dot.parser
Author: Koushik Dutta <a.k.a DotPY>
Author-email: dot.py@yahoo.com
License: MIT
Platform: UNKNOWN
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.10
Classifier: Programming Language :: Python :: Implementation :: CPython
Classifier: Programming Language :: Python :: Implementation :: PyPy
Requires-Python: >=3.9.0
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: pip (==22.3.1)
Requires-Dist: setuptools (==65.5.0)
Requires-Dist: sqlparse (==0.4.3)
Requires-Dist: wheel (==0.37.1)


## dot.parser

[![Generic badge](https://img.shields.io/badge/python-3.10-success.svg)](https://shields.io/)
[![Generic badge](https://img.shields.io/badge/GUI-WIP-success.svg)](https://shields.io/)
[![Generic badge](https://img.shields.io/badge/CLI-no-red.svg)](https://shields.io/)
[![Generic badge](https://img.shields.io/badge/projectStatus-developing-yellow.svg)](https://shields.io/)
![Maintainer](https://img.shields.io/badge/maintainer-koushikdutta-blue)
[![Linux](https://svgshare.com/i/Zhy.svg)](https://svgshare.com/i/Zhy.svg)
[![Tests](https://github.com/macbre/sql-metadata/actions/workflows/python-ci.yml/badge.svg)](https://github.com/macbre/sql-metadata/actions/workflows/python-ci.yml)
[![Coverage Status](https://coveralls.io/repos/github/macbre/sql-metadata/badge.svg?branch=master&1)](https://coveralls.io/github/macbre/sql-metadata?branch=master)
<a href="https://github.com/psf/black"><img alt="Code style: black" src="https://img.shields.io/badge/code%20style-black-000000.svg"></a>
[![Maintenance](https://img.shields.io/badge/maintained%3F-yes-green.svg)](https://github.com/macbre/sql-metadata/graphs/commit-activity)

### Project Phase One:

- SQL ( Parsing SQL ) Till now I could only managed to create SQL Parser
- Phase Status - initial Development
- Due to beta version release you might face some difficulties

### SQL Dialects Supported 

- MySQL
- PostreSQL ( Redshift in progress )
- Sqlite 

[![forthebadge made-with-python](http://ForTheBadge.com/images/badges/made-with-python.svg)](https://www.python.org/)

[![PyPI license](https://img.shields.io/pypi/l/ansicolortags.svg)](https://pypi.python.org/pypi/ansicolortags/)

---

### How to use this python module

```
pip install pysqlutil
```

### Extracting raw sql-metadata tokens

```python
from pysqlutil import parser

# extract raw sql-metadata tokens
parser("SELECT * FROM test_table").tokens
parser("SELECT test, id FROM test_table1,test_table2").columns
# you will get column names

parser_object = parser("<your custom SQL>")
parser_object.columns
# you will get column names as a list

# but you can still extract aliases names
parser_object.columns_aliases
# column alias list 
```

### Soon , new featurers will be included like SQL File compare , DDL Compare , Analyze and optimize SQL
### Future Release list
- Jan-2023 : SQL Compare , Compare two versions of DDL 
- Feb-2023 : GUI Support .

