WMS_MAIN/script/fix-order-packages-weight-column.cjs

74 lines
2.4 KiB
JavaScript
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

'use strict';
/**
* 幂等补齐订单分表的 packages_weight 列(所有包裹总重量)。
*
* 背景:该列由订单模型(app/model/order_delivery.js)定义,分表工厂
* (order_delivery_factory.js)在首次访问某张分表时自动同步;history /
* outsourced 等长期不被访问的表可能滞后,可用本脚本提前补齐。
*
* 用法:
* 开发:node script/fix-order-packages-weight-column.cjs
* 生产:PowerShell 中 $env:NODE_ENV='production'; node script/fix-order-packages-weight-column.cjs
*
* 安全:只 ADD 缺失列(INT(11) NOT NULL DEFAULT 0,与模型定义一致),
* 不触碰 id / AUTO_INCREMENT,不修改已有列,可重复执行。
*/
(async () => {
try {
const configs = require('../database/config.js');
const env = process.env.NODE_ENV || 'development';
const cfg = configs[env];
if (!cfg) {
console.error('NO_CONFIG_FOR_ENV');
process.exit(2);
}
const mysql = require('mysql2/promise');
const conn = await mysql.createConnection({
host: cfg.host,
port: cfg.port || 3306,
user: cfg.username,
password: cfg.password,
database: cfg.database,
});
const [ tables ] = await conn.query(
`SELECT TABLE_NAME FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ? AND TABLE_NAME LIKE 'wms_order_delivery\\_%'
ORDER BY TABLE_NAME`,
[ cfg.database ]
);
console.log(`环境: ${env}, 库: ${cfg.host}:${cfg.port}/${cfg.database}`);
console.log(`订单分表数量: ${tables.length}\n`);
const columnSql = "ADD COLUMN packages_weight INT(11) NOT NULL DEFAULT 0 COMMENT '所有包裹总重量(g)'";
let added = 0;
let ok = 0;
for (const row of tables) {
const tableName = row.TABLE_NAME || row.table_name;
const [ columns ] = await conn.query(
`SELECT COLUMN_NAME FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? AND COLUMN_NAME = 'packages_weight'`,
[ cfg.database, tableName ]
);
if (columns.length === 0) {
await conn.query(`ALTER TABLE \`${tableName}\` ${columnSql}`);
console.log(`[ADD] ${tableName} 已补齐列`);
added += 1;
} else {
ok += 1;
}
}
console.log(`\n完成: 已存在 ${ok} 张, 新增 ${added} 张`);
await conn.end();
process.exit(0);
} catch (err) {
console.error('ERROR', err.message);
process.exit(3);
}
})();