mint/deploy/migaration/20211127214900-sent_sim_index.php

<?php
require_once "../../app/path.php";


$dest_db=_FILE_DB_PALI_SENTENCE_SIM_;#目标数据库
$dest_table=_TABLE_SENT_SIM_INDEX_;#目标表名

echo "migarate sent_sim_index".PHP_EOL;


#打开目标数据库
$PDO_DEST = new PDO($dest_db,_DB_USERNAME_,_DB_PASSWORD_,array(PDO::ATTR_PERSISTENT=>true));
$PDO_DEST->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
echo "open dest".PHP_EOL;

#删除目标表中所有数据
$query = "DELETE FROM ".$dest_table." WHERE true";
$stmt = $PDO_DEST->prepare($query);
if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
    $error = $PDO_DEST->errorInfo();
    echo "error - $error[2] ";
	exit;
}
$stmt->execute();
echo "delete dest".PHP_EOL;

#插入数据
$query = "INSERT INTO ".$dest_table." (sent_id, count ) SELECT sent1,count(*) FROM "._TABLE_SENT_SIM_." where true group by sent1;";
$stmt = $PDO_DEST->prepare($query);
if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
    $error = $PDO_DEST->errorInfo();
    echo "error - $error[2] ";
	exit;
}
$stmt->execute();
echo "insert dest".PHP_EOL;

echo "done".PHP_EOL;