#!/usr/bin/env bash

# to call SQL statement at MySQL prompt
mysql -h localhost -P 3306 -u root -plenovo_149569! <<EOF

# clear tables
use lenovo_face_module;

delete from tf_project_daily_attendance;
delete from tf_project_monthly_attendance;
delete from tf_project_face_history;
delete from tf_project_emp_device;
delete from tf_project_password_log;
delete from tf_project_office_device;
delete from tf_project_emp_device;
delete from tf_project_emp;
delete from tf_project_shift where id != "1";
delete from tf_sys_log;
delete from tf_sys_office where office_code != "2000" and office_code != "2000003";
delete from tf_sys_user where user_code != "system" and user_code != "admin";
delete from tf_sys_employee;
delete from tf_sys_user_data_scope where user_code != "system" and user_code != "admin";
delete from tf_sys_user_role;

delete from test_data;
delete from test_data_child;
delete from test_tree;
EOF