reset_mysql_db.sh

mysql -utree -ptree tree <<EOF
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS app_tree_elementtype_attributes;
DROP TABLE IF EXISTS app_tree_elementtype_required_attr;
DROP TABLE IF EXISTS app_tree_doctype;
DROP TABLE IF EXISTS app_tree_attributetype;
DROP TABLE IF EXISTS app_tree_text;
DROP TABLE IF EXISTS app_tree_attribute;
DROP TABLE IF EXISTS app_tree_elementtype;
DROP TABLE IF EXISTS app_tree_element_texts;
DROP TABLE IF EXISTS app_tree_element_attributes;
DROP TABLE IF EXISTS app_tree_element;
DROP TABLE IF EXISTS app_tree_dataset;
DROP TABLE IF EXISTS app_tree_diff;
DROP TABLE IF EXISTS app_tree_treenode;
SET FOREIGN_KEY_CHECKS = 1;
EOF
./venv/bin/python project/manage.py syncdb
echo 'Loading ipc_scheme 20150101...'
./venv/bin/python project/manage.py load_xml ipc_scheme 20150101 en --xml
echo
echo 'Loading ipc_scheme 20140101...'
./venv/bin/python project/manage.py load_xml ipc_scheme 20140101 en --xml --no_types
echo
echo 'Loading nice_classes 20150101...'
./venv/bin/python project/manage.py load_xml nice_classes 20150101 en 20141215 --xml
echo
echo 'Loading nice_indications 20150101...'
./venv/bin/python project/manage.py load_xml nice_indications 20150101 en 20141219 --xml
echo
echo 'Diffing ipc_scheme 20140101 and 20150101...'
./venv/bin/python project/manage.py diff_trees ipc_scheme 20140101 20150101