-
Notifications
You must be signed in to change notification settings - Fork 0
/
edw-svn.txt
41 lines (34 loc) · 1.08 KB
/
edw-svn.txt
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
[tpodps@DEV-EDWETL bin]$ more ~/.edw/dl_sql.sh
#!/bin/bash
# rpt_act_intfreinshare_md.sql
read -p "Enter SqlFile name: " sqlfile
echo Input File Name is: $sqlfile
# if [ -z $sqlfile ]
# then
# echo file: $sqlfile hasn't exists!
# else
# echo file: $sqlfile
# fi
do_svn() {
cd /alidata/edwproject/taskfile/sql
svn cat svn:https://10.19.0.22/edw/08src/alidata/edwproject/taskfile/sql/$sqlfile > $sqlfile
ls -l $sqlfile
}
read -p "Are you sure to continue? [y/n] " input
case $input in
[yY]*)
echo "sqlfile is $sqlfile"
do_svn;
;;
[nN]*)
exit
;;
*)
echo "Just enter y or n, please."
exit
;;
esac
## [cognos@DEV-COGNOSSRV edw]$ cd /alidata/workspace/edw
## [cognos@DEV-COGNOSSRV edw]$ svn add 07pm/30-·¢²¼/2019-12-11\ Çåµ¥°ü/
## [cognos@DEV-COGNOSSRV edw]$ svn add 07pm/30-·¢²¼/2019-12-12\ Çåµ¥°ü/
## [cognos@DEV-COGNOSSRV edw]$ svn commit -m"cdm_ply_policy_dd, tps_web_bas_comm_code.c_cnm web_ply_tgt_obj.c_tgt_obj_txt_fld_4: varchar2(600)"