DataExtraction - Data export tool for MySQL & MongoDB
What is DataExtraction
DataExtraction is an unfinished data extraction tool for you to export your specified:
- Data columns (for MySQL), or
- Fields (for MongoDB),
and save them as csv or json.
Besides, DataExtraction support:
-
Data format transform: convert Json object to DataFrame for MySQL. You may not need this since usually we don't store json object or dict in Mysql, and this function is project-oriented since we happened have some json-like or dict data stored in relational database.
-
Query with list type of condition [Not a join operation, the conditon list should be specified in advance]: You can use this package to specified a (list) of condition you may need to filter your query.
What dependencies you need to install
- pandas (0.19.2)
- MySQLdb (1.2.3c1)
- json (2.0.9)
How to install it
pip install DataExtraction
Version
Function description
Demo for basic SQL Query
Demo for basic Mongo Query
License
MIT
You are welcome to pull request to upload your own implement function, improve and modified my current design.