#!/bin/csh
use python 27
source /group/halld/Software/scripts/ccdb_generate/setup.csh
# delete and create blank database
mysql -hhalldweb1 -uccdb_user < $CCDB_HOME/sql/ccdb.mysql.sql
# convert from files to CCDB
python $CCDB_HOME/scripts/halld_convert_from_svn/convert_script.py --execute
# make sqlite version
$CCDB_HOME/scripts/mysql2sqlite/mysql2sqlite.sh -uccdb_user -hhalldweb1 ccdb \
    | sqlite3 /group/halld/Software/calib/ccdb_sqlite/ccdb_`date +%F`.sqlite
