41 行
1.3 KiB
JavaScript
41 行
1.3 KiB
JavaScript
const fs = require('fs');
|
|
const path = require('path');
|
|
const mysql = require('mysql2/promise');
|
|
|
|
async function run() {
|
|
const sqlPath = path.join(__dirname, 'seed_cards.sql');
|
|
const sqlContent = fs.readFileSync(sqlPath, 'utf8');
|
|
|
|
const connection = await mysql.createConnection({
|
|
host: '127.0.0.1',
|
|
port: 3306,
|
|
user: 'root',
|
|
password: '123456',
|
|
database: 'crmmpdata',
|
|
multipleStatements: true,
|
|
charset: 'utf8mb4',
|
|
});
|
|
|
|
try {
|
|
console.log('[Seed] 正在导入多媒体名片数据 (UTF-8)...');
|
|
await connection.query(sqlContent);
|
|
console.log('[Seed] 5 张高保真多媒体名片数据导入成功！');
|
|
|
|
// 打印验证统计
|
|
const [cards] = await connection.query('SELECT id, slug, name, company FROM card_info WHERE id >= 1001');
|
|
console.log(`[Seed] 成功验证 ${cards.length} 张名片：`);
|
|
cards.forEach(c => console.log(` - [${c.id}] ${c.name} (${c.company}) -> /${c.slug}`));
|
|
|
|
const [videos] = await connection.query("SELECT id, card_id, title FROM card_bento WHERE type = 'video'");
|
|
console.log(`[Seed] 成功验证 ${videos.length} 个视频 Bento 块：`);
|
|
videos.forEach(v => console.log(` - [Bento #${v.id}] (名片 #${v.card_id}): ${v.title}`));
|
|
} catch (err) {
|
|
console.error('[Seed Error]', err);
|
|
process.exit(1);
|
|
} finally {
|
|
await connection.end();
|
|
}
|
|
}
|
|
|
|
run();
|