test-python-sqlite

A repository to test the Python SQLite module.

Requirements

You can run the application in a Python 3.7 environment.

Install requirements via PIP

virtualenv .venv
pip install -r requirements.txt

Execute the application

python main.py

The application offers:

a main file in order to download the dataset from here and insert records to a local SQLite database
a utils file housing various methods in order to write data to a SQLite database and querying on it
a Jupyter Notebook in order to perform specific queries on the created database
an html file showing the results from the notebook

Name		Name	Last commit message	Last commit date
Latest commit History 22 Commits
example		example
scripts		scripts
.gitignore		.gitignore
README.md		README.md
main.py		main.py
requirements.txt		requirements.txt
test_clean_output.ipynb		test_clean_output.ipynb
utils.py		utils.py