github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/dm/tests/_utils/run_sql (about)

     1  #!/bin/bash
     2  # parameter 1: sql command
     3  # parameter 2: port
     4  # parameter 3: password
     5  # parameter 4(optional): charset
     6  
     7  set -eu
     8  
     9  TIDB_PORT=4000
    10  user="root"
    11  OUTFILE="$TEST_DIR/sql_res.$TEST_NAME.txt"
    12  echo "[$(date)] Executing SQL: $1" >$OUTFILE
    13  
    14  if [[ "$2" = $TIDB_PORT ]]; then
    15  	user="test"
    16  fi
    17  
    18  if [[ $# -ge 4 ]]; then
    19  	echo "$1" | iconv -f utf8 -t $4 | mysql -u$user -h127.0.0.1 -P$2 -p$3 --default-character-set $4 -E >>$OUTFILE
    20  else
    21  	mysql -u$user -h127.0.0.1 -P$2 -p$3 --default-character-set utf8 -E -e "$1" >>$OUTFILE
    22  fi