数据同步

(♥◠‿◠)ﾉﾞ  数据同步启动成功   ლ(´ڡ`ლ)ﾞ  
______  ___ _____ ___         _______   ___   _ _____ 
|  _  \/ _ \_   _/ _ \       /  ___\ \ / / \ | /  __ \
| | | / /_\ \| |/ /_\ \______\ `--. \ V /|  \| | /  \/
| | | |  _  || ||  _  |______|`--. \ \ / | . ` | |    
| |/ /| | | || || | | |      /\__/ / | | | |\  | \__/\
|___/ \_| |_/\_/\_| |_/      \____/  \_/ \_| \_/\____/

# 进入项目目录
cd sync-ui

# 安装依赖
npm install

# 强烈建议不要用直接使用 cnpm 安装，会有各种诡异的 bug，可以通过重新指定 registry 来解决 npm 安装速度慢的问题。
npm install --registry=https://registry.npm.taobao.org

# 本地开发 启动项目
npm run dev

# 使用命令打包
npm run build:prod

#user  nobody;
worker_processes  auto;

#error_log  logs/error.log;
#error_log  logs/error.log  notice;
#error_log  logs/error.log  info;

#pid        logs/nginx.pid;


events {
    worker_connections  1024;
}


http {
    include       mime.types;
    default_type  application/octet-stream;
    sendfile        on;
    keepalive_timeout  65;

    server {
        listen       7090;
        server_name  localhost;

                location / {
                        root /data/appsvr/sync/dist_prod/;# 根目录，dist_prod是前端打的包
                        try_files $uri $uri/ /index.html;
                        index /data/appsvr/sync/dist_prod/index.html; # 默认首页
        }
                
                location /prod-api/{
                        proxy_set_header Host $http_host;
                        proxy_set_header X-Real-IP $remote_addr;
                        proxy_set_header REMOTE-HOST $remote_addr;
                        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
                        proxy_pass http://localhost:7091/prod-api/;
                }

        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
            root   html;
        }
    }
}

SELECT TP_NUMBER,
       TP_TYPE_DESC,
       TP_TYPE,
       ORGANIZATION_ID,
       ORGANIZATION_NAME,
       ORGANIZATION_CODE,
       CREATED_BY,
       CREATION_DATE,
       LAST_UPDATE_DATE,
       LAST_UPDATED_BY
  FROM apps.cwms_tp_number_detail
 WHERE ORGANIZATION_ID IN (#ORGANIZATIONID#) 
   AND LAST_UPDATE_DATE >= to_date(#SYNC_TIME_BEGIN#, 'yyyy-MM-dd HH24:mi:ss') -- #SYNC_TIME_BEGIN# 固定写法，标识 同步开始时间
   AND LAST_UPDATE_DATE <= to_date(#SYNC_TIME_END#, 'yyyy-MM-dd HH24:mi:ss') -- #SYNC_TIME_END# 固定写法，标识 同步结束时间