/* 獲取個人數(shù)據 */
const personsObj = {}
const getPersonData = (page) => {
    pm.sendRequest(`http://localhost:3000/api/account?_where=(status,eq,2)and(remove_flag,eq,0)&_size=100&_p=${page}`, (err, response) => {
        var data = response.json();
        // 獲取賬戶對應的id
        const psersonAccountMap = data.reduce((total, currentValue) => {
            const _account = currentValue.account.replace('+86-','')
            total[_account] = currentValue
            return total
        }, personsObj)
        if (data.length == 100) {
            getPersonData(++page)
        } else {
            pm.environment.set("psersonAccountMap", psersonAccountMap); // 數(shù)據緩存到環(huán)境變量中
        }
    })
}
getPersonData(0)

const utils = eval(globals.loadUtils); // 全局方法引入
// 獲取默認個人ID；不傳參，取默認值，可傳參：utils.getPerson('賬號') 
let personSignerId = utils.getPerson()

# @set database=database1
# @set database=database2
# @set database=database3
@set database=database4
@set host=xx.xx.xx.xx
@set port=3306
@set user=xxx
@set pwd=xxxxxxx
start cmd /k "xmysql -h %host%  -o %port% -u %user% -p  %pwd% -d %database%"

@echo off  
@set database=''  
@set host=''  
@set port=''  
@set user=''  
@set pwd=''  
Title DataBase  
Color 0A  
:setep1  
echo.  
echo 【第一步：選擇環(huán)境】  
echo 1. 測試環(huán)境  
echo 2. UAT環(huán)境  
echo.  
set /p env=選擇環(huán)境:  
if "%env%"=="1" call :env1  
if "%env%"=="2" call :env2  
:env1  
set host=168.168.168.168
set port=3308  
set user=xxxx  
set pwd=xxxxxxx
goto :setep2  
:env2  
set host=178.178.178.178
set port=8808  
set user=xxxx   
set pwd=xxxxxxx 
goto :setep2  
:setep2  
echo.  
echo 【第二步：選擇數(shù)據庫】  
echo 0. 手動設置數(shù)據庫名  
echo 1. dev-seal  
echo 2. dev-cert  
echo.  
set /p n=選擇數(shù)據庫:  
if "%n%"=="" cls&goto :setep2  
if "%n%"=="0" call :goDB0  
if "%n%"=="1" call :goDB1  
pause   
goto :eof   
:goDB0  
set /p manualDB=輸入數(shù)據庫名:  
set database=%manualDB%  
goto :confirm  
:goDB1  
set database=dev_seal_database1  
goto :confirm  
:confirm  
cls  
echo ═══════════════════════════════════════  
echo 鏈接數(shù)據庫  
echo 目標: %host%:%port%  
echo 數(shù)據庫: %database%  
echo 用戶密碼: %user% %pwd%  
echo ═══════════════════════════════════════  
set /p lastConfirm=是否正確(y/n):  
if "%lastConfirm%"=="y" goto :connect  
if "%lastConfirm%"=="n" cls&goto :setep1  
:connect  
start cmd /k "xmysql -h %host%  -o %port% -u %user% -p  %pwd% -d %database%"  
exit

#!/bin/bash
cd $(dirname $0)
exec ./linkDB.sh

@echo off
set port=3000
# set /p port="請輸入要關閉的端口，默認3000："
echo 開始搜索'netstat -ano^|findstr ":%port%" '
for /f "delims=" %%i in ( 'netstat -ano^|findstr :%port%' ) do set pid_line=%%i 
rem set pid=%pid_line:~-6%
if "%pid_line%" == "" (
  echo 沒有找到！
  goto flag_exit
) else (
  echo 已查找到: %pid_line%
  for %%a in (%pid_line%) do (set pid=%%a)
)
echo 占用端口%port%的進程pid：%pid%；現(xiàn)在開始結束它
TASKKILL /PID %pid% /F
:flag_exit
start C:\Program" "Files\Git\git-bash.exe "linkDB.sh"

#!/bin/bash
# 環(huán)境配置,規(guī)則：自定義環(huán)境名,ip,port,用戶,密碼
evnList=(
    '測試環(huán)境,30.31.16.11,3308,user1,password1'
    'UAT環(huán)境,30.31.16.12,3301,user2,password2'
)
# 可配置常用數(shù)據庫名
database1='dev-seal'
database2='dev_cert'
database3='uat_seal'
devDBList=($database1 $database2 $database3)
# 以下為主程序代碼，無須修改
host=''
port=''
user=''
pwd=''
databaseCn=''
database=''
setep3() {
    clear
    echo ═════════════【連接數(shù)據庫】════════════
    echo 目標: $databaseCn 
    echo 地址: $host:$port
    echo 庫名: $database
    echo 用戶: $user
    echo 密碼: $pwd
    echo ═══════════════════════════════════════
    echo
    read -p "正確(y), 錯誤重來(n):" lastConfirm
    if [[ $lastConfirm == 'y' ]]; 
    then
        clear
        echo '開始連接數(shù)據庫...'
        xmysql -h $host -o $port -u $user -p $pwd -d $database
        # exit
    else
        setep1;
    fi
}
setep2() {
    clear
    echo '【第二步:選擇數(shù)據庫】'
    echo ' ' 0. 手動輸入
    for i in "${!devDBList[@]}"
    do
        index=`expr $i + 1`
    	echo ' ' $index. ${devDBList[i]}
    done
    echo
    read -p "選擇數(shù)據庫編號:" targetDB
    if [[ $targetDB -eq 0 ]]; then
        read -p "輸入數(shù)據庫名:" target
        if [[ $target == '' ]]; then
            setep2
        else
            database=$target
        fi
    else 
        database=${devDBList[$targetDB-1]}
    fi
    echo $database
    setep3;
}
setep1(){
    clear
    echo '【第一步:選擇環(huán)境】'
    for i in "${!evnList[@]}"
    do
        string=${evnList[$i]}
        stringList=(${string//,/ })
        envName=${stringList[0]}
        index=`expr $i + 1`
    	echo ' ' $index. ${envName}
    done
    echo 
    read -p "選擇環(huán)境:" env
    if [[ $env == '' ]]; then
        setep1
    fi
    targetEnv=${evnList[$env-1]}
    params=(${targetEnv//,/ })
    databaseCn=${params[0]} # 目標數(shù)據庫名
    host=${params[1]} # 數(shù)據庫ip
    port=${params[2]} # 數(shù)據庫端口
    user=${params[3]} # 用戶
    pwd=${params[4]} # 密碼
    setep2;
};
setep1;