summaryrefslogtreecommitdiff
path: root/ci-scripts/replaceI18nsql.sh
blob: 56510e3568e63e41cd7df6dcc34a95c6285ada3a (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
#!/bin/bash
set -evx
CUR_PWD=`pwd`

echo 'add sys_i18n begin ... '

# 检查 国际化 数据是否完整
C_RESULT=`mysql -h $NZ_DB_HOST -u$NZ_DB_USER -p$NZ_DB_PASSWORD -D $NZ_DB_NAME \
   -NBe "SELECT t.code FROM ( SELECT count( DISTINCT lang ) counter, code FROM sys_i18n GROUP BY code ) t WHERE t.counter = 1;"`

if [ ! -z "$C_RESULT" ]
then
      echo "Sys_i18n loss of language content, please check code:"
      echo "$C_RESULT"
      exit 1
fi

# 导出表数据
mysqldump --extended-insert=FALSE --add-locks=FALSE  -h $NZ_DB_HOST -u$NZ_DB_USER -p$NZ_DB_PASSWORD $NZ_DB_NAME sys_i18n > ./nz-admin/src/main/resources/db/R__AZ_sys_i18n.sql

echo 'add sys_i18n finished'
exit 0