Industrial Ecology Data Commons Tools

Under early development. May later be merged into Industrial Ecology Data Commons project.

A collection of tools to interact with the Industrial Ecology Data Commons project. It pareses data input files, validates and uploades them into the database.

Setup

In order to make this repo work you need access to the Industrial Ecology Freiburg's MySQL database: http://www.database.industrialecology.uni-freiburg.de

Therefore you will need to rename and edit the IEDC_paths_TEMPLATE.py and IEDC_paths_TEMPLATE.py files first.

Content

TODO

Contact

Author: Niko Heeren (niko.heeren@gmail.com)

Credits: Niko Heeren, Stefan Pauliuk

TODO

• Double check the uploaded data

• Routine to apply for entire directory

• Function to (chain-) delete classifications from classification_definitions and classification_items

• Algorithm to parse table formatted template

• Walkthrough documentation (maybe jupyter notebook)

• Routine for data upload

• Function to add user to users table

• Function to add licenses to licenses table

• Routine for creating a custom classification

• Convenience function to pull classification attributes together

• Create repo

• Validation function to check if all aspects exist in the database

• Validation function to check if attributes are present in the DB

• Write basic IO functions

• Make TODO list :)