#!/bin/bash

###############################################################################
# shell 脚本中执行 sql 语句
###############################################################################

host='127.0.0.1'
username='dev'
password='Dev@123456'

db1='tnb_account_tdb'
db2='tnb_content_tdb'
db3='reghao_bnt_tdb'
db4='reghao_oss_tdb'

sql1="CREATE DATABASE IF NOT EXISTS ${db1} DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;"
sql2="CREATE DATABASE IF NOT EXISTS ${db2} DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;"
sql3="CREATE DATABASE IF NOT EXISTS ${db3} DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;"
sql4="CREATE DATABASE IF NOT EXISTS ${db4} DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;"

mysql -h${host} -u${username} -p${password} << EOF
${sql1}
${sql2}
${sql3}
${sql4}
EOF

cd schema
db11='tnb_account_tdb'
db21='tnb_content_tdb'
db31='reghao_bnt_tdb'
db41='reghao_oss_tdb'

# 还原数据库结构和数据
mysql -h${host} -u${username} -p${password} ${db11} < ${db1}.sql
mysql -h${host} -u${username} -p${password} ${db21} < ${db2}.sql
mysql -h${host} -u${username} -p${password} ${db31} < ${db3}.sql
mysql -h${host} -u${username} -p${password} ${db41} < ${db4}.sql