assembly.bat
7.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
@echo off
echo -------------------------------------------------------------------------
echo 获取服务 SQL 文件
echo -------------------------------------------------------------------------
echo 请选择数据库类型
echo 【1】MySQL 【2】ORACLE 【3】PostgreSQL 【4】SQLServer2012 【5】dameng
set /p sqlmodel= 请输入你的选择:
echo 请选择服务类型
echo 【1】单服务 【2】多服务
set /p eipmodel= 请输入你的选择:
goto :package
:package
@echo off
if /i "%sqlmodel%"=="1" if "%eipmodel%"=="1" cls&goto mysqlassembly
if /i "%sqlmodel%"=="1" if "%eipmodel%"=="2" cls&goto mysql
if /i "%sqlmodel%"=="2" if "%eipmodel%"=="1" cls&goto oracleassembly
if /i "%sqlmodel%"=="2" if "%eipmodel%"=="2" cls&goto oracle
if /i "%sqlmodel%"=="3" if "%eipmodel%"=="1" cls&goto postgresqlassembly
if /i "%sqlmodel%"=="3" if "%eipmodel%"=="2" cls&goto postgresql
if /i "%sqlmodel%"=="4" if "%eipmodel%"=="1" cls&goto sqlserver2012assembly
if /i "%sqlmodel%"=="4" if "%eipmodel%"=="2" cls&goto sqlserver2012
if /i "%sqlmodel%"=="5" if "%eipmodel%"=="1" cls&goto damengassembly
if /i "%sqlmodel%"=="5" if "%eipmodel%"=="2" cls&goto dameng
:mysql
@echo off
call mkdir publish\MicroService\MySQL
call type TableSQL_MySQL\1.bpm_act_init.sql TableSQL_MySQL\2.bpm_init.sql IndexSQL\bpm_index_init.sql InitDataSQL\bpm_init_data.sql ChangeSQL\MySQL\DoSQL\dosql_bpm.sql >> publish\MicroService\MySQL\EipBpm.sql
call type TableSQL_MySQL\3.portal_qrtz_init.sql TableSQL_MySQL\4.portal_init.sql IndexSQL\portal_index_init.sql InitDataSQL\portal_init_data.sql DemoInitDataSQL\portal.sql ChangeSQL\MySQL\DoSQL\dosql_portal.sql >> publish\MicroService\MySQL\EipPortal.sql
call type TableSQL_MySQL\5.form_init.sql IndexSQL\form_index_init.sql InitDataSQL\form_init_data.sql ChangeSQL\MySQL\DoSQL\dosql_form.sql >> publish\MicroService\MySQL\EipForm.sql
call type TableSQL_MySQL\6.uc_init.sql IndexSQL\uc_index_init.sql InitDataSQL\uc_init_data.sql ChangeSQL\MySQL\DoSQL\dosql_uc.sql >> publish\MicroService\MySQL\EipUc.sql
goto :success
:mysqlassembly
@echo off
call mkdir publish\SingleService
call type TableSQL_MySQL\*.sql IndexSQL\*.sql InitDataSQL\*.sql DemoInitDataSQL\*.sql ChangeSQL\MySQL\DoSQL\*.sql >> publish\SingleService\EipAssembly_MySQL.sql
goto :success
:oracle
@echo off
call mkdir publish\MicroService\ORACLE
call type TableSQL_ORACLE\1.bpm_act_init.sql TableSQL_ORACLE\2.bpm_init.sql IndexSQL\bpm_index_init.sql InitDataSQL\bpm_init_data.sql ChangeSQL\ORACLE\DoSQL\dosql_bpm.sql >> publish\MicroService\ORACLE\EipBpm.sql
call type TableSQL_ORACLE\3.portal_qrtz_init.sql TableSQL_ORACLE\4.portal_init.sql IndexSQL\portal_index_init.sql InitDataSQL\portal_init_data.sql DemoInitDataSQL\portal.sql ChangeSQL\ORACLE\DoSQL\dosql_portal.sql >> publish\MicroService\ORACLE\EipPortal.sql
call type TableSQL_ORACLE\5.form_init.sql IndexSQL\form_index_init.sql InitDataSQL\form_init_data.sql ChangeSQL\ORACLE\DoSQL\dosql_form.sql >> publish\MicroService\ORACLE\EipForm.sql
call type TableSQL_ORACLE\6.uc_init.sql IndexSQL\uc_index_init.sql InitDataSQL\uc_init_data.sql ChangeSQL\ORACLE\DoSQL\dosql_uc.sql >> publish\MicroService\ORACLE\EipUc.sql
goto :success
:oracleassembly
@echo off
call mkdir publish\SingleService
call type TableSQL_ORACLE\*.sql IndexSQL\*.sql InitDataSQL\*.sql DemoInitDataSQL\*.sql ChangeSQL\ORACLE\DoSQL\*.sql >> publish\SingleService\EipAssembly_ORACLE.sql
goto :success
:postgresql
@echo off
call mkdir publish\MicroService\PostgreSQL
call type TableSQL_PostgreSQL\1.bpm_act_init.sql TableSQL_PostgreSQL\2.bpm_init.sql IndexSQL\bpm_index_init.sql InitDataSQL\bpm_init_data.sql ChangeSQL\PostgreSql\DoSQL\dosql_bpm.sql >> publish\MicroService\PostgreSQL\EipBpm.sql
call type TableSQL_PostgreSQL\3.portal_qrtz_init.sql TableSQL_PostgreSQL\4.portal_init.sql IndexSQL\portal_index_init.sql InitDataSQL\portal_init_data.sql DemoInitDataSQL\portal.sql ChangeSQL\PostgreSql\DoSQL\dosql_portal.sql >> publish\MicroService\PostgreSQL\EipPortal.sql
call type TableSQL_PostgreSQL\5.form_init.sql IndexSQL\form_index_init.sql InitDataSQL\form_init_data.sql ChangeSQL\PostgreSql\DoSQL\dosql_form.sql >> publish\MicroService\PostgreSQL\EipForm.sql
call type TableSQL_PostgreSQL\6.uc_init.sql IndexSQL\uc_index_init.sql InitDataSQL\uc_init_data.sql ChangeSQL\PostgreSql\DoSQL\dosql_uc.sql >> publish\MicroService\PostgreSQL\EipUc.sql
goto :success
:postgresqlassembly
@echo off
call mkdir publish\SingleService
call type TableSQL_PostgreSQL\*.sql IndexSQL\*.sql InitDataSQL\*.sql DemoInitDataSQL\*.sql ChangeSQL\PostgreSql\DoSQL\*.sql >> publish\SingleService\EipAssembly_PostgreSQL.sql
goto :success
:sqlserver2012
@echo off
call mkdir publish\MicroService\SQLServer2012
call type TableSQL_SQLServer2012\1.bpm_act_init.sql TableSQL_SQLServer2012\2.bpm_init.sql IndexSQL\bpm_index_init.sql InitDataSQL\bpm_init_data.sql ChangeSQL\SQLServer2012\DoSQL\dosql_bpm.sql >> publish\MicroService\SQLServer2012\EipBpm.sql
call type TableSQL_SQLServer2012\3.portal_qrtz_init.sql TableSQL_SQLServer2012\4.portal_init.sql IndexSQL\portal_index_init.sql InitDataSQL\portal_init_data.sql DemoInitDataSQL\portal.sql ChangeSQL\SQLServer2012\DoSQL\dosql_portal.sql >> publish\MicroService\SQLServer2012\EipPortal.sql
call type TableSQL_SQLServer2012\5.form_init.sql IndexSQL\form_index_init.sql InitDataSQL\form_init_data.sql ChangeSQL\SQLServer2012\DoSQL\dosql_form.sql >> publish\MicroService\SQLServer2012\EipForm.sql
call type TableSQL_SQLServer2012\6.uc_init.sql IndexSQL\uc_index_init.sql InitDataSQL\uc_init_data.sql ChangeSQL\SQLServer2012\DoSQL\dosql_uc.sql >> publish\MicroService\SQLServer2012\EipUc.sql
goto :success
:sqlserver2012assembly
@echo off
call mkdir publish\SingleService
call type TableSQL_SQLServer2012\*.sql IndexSQL\*.sql InitDataSQL\*.sql DemoInitDataSQL\*.sql ChangeSQL\SQLServer2012\DoSQL\*.sql >> publish\SingleService\EipAssembly_SQLServer2012.sql
goto :success
:damengassembly
@echo off
call mkdir publish\SingleService
call type TableSQL_Dameng\*.sql IndexSQL\*.sql InitDataSQL\*.sql DemoInitDataSQL\*.sql ChangeSQL\DM\DoSQL\*.sql >> publish\SingleService\EipAssembly_DM.sql
goto :success
:dameng
@echo off
call mkdir publish\MicroService\DM
call type TableSQL_Dameng\1.bpm_act_init.sql TableSQL_Dameng\2.bpm_init.sql IndexSQL\bpm_index_init.sql InitDataSQL\bpm_init_data.sql ChangeSQL\DM\DoSQL\dosql_bpm.sql >> publish\MicroService\DM\EipBpm.sql
call type TableSQL_Dameng\3.portal_qrtz_init.sql TableSQL_Dameng\4.portal_init.sql IndexSQL\portal_index_init.sql InitDataSQL\portal_init_data.sql DemoInitDataSQL\portal.sql ChangeSQL\DM\DoSQL\dosql_portal.sql >> publish\MicroService\DM\EipPortal.sql
call type TableSQL_Dameng\5.form_init.sql IndexSQL\form_index_init.sql InitDataSQL\form_init_data.sql ChangeSQL\DM\DoSQL\dosql_form.sql >> publish\MicroService\DM\EipForm.sql
call type TableSQL_Dameng\6.uc_init.sql IndexSQL\uc_index_init.sql InitDataSQL\uc_init_data.sql ChangeSQL\DM\DoSQL\dosql_uc.sql >> publish\MicroService\DM\EipUc.sql
goto :success
:success
@echo off
echo -------------------------------------------
echo SUCCESS
if "%eipmodel%"=="1" echo 获取完成 请查看 publish 下 SingleService 文件夹
if "%eipmodel%"=="2" echo 获取完成 请查看 publish 下 MicroService 文件夹
echo -------------------------------------------
pause