edu-textbook/server/db/func/import-data.js

const pgp = require('pg-promise')();
const fs = require('fs');

// 连接到数据库
const db = pgp({
    user: 'postgres',
    password: 'postgres',
    host: 'localhost',
    port: 25432,
    database: 'postgres'
});

let initDataSQL
try{initDataSQL = fs.readFileSync("../data/init-data.sql").toString()}catch(err){}
try{initDataSQL = fs.readFileSync("./db/data/init-data.sql").toString()}catch(err){}
// 执行SELECT语句并返回结果的函数
async function main() {
    console.log("加载初始化数据")
    try {
        // 查询：数据库版本信息
        const data = await db.any(initDataSQL);
        console.log(data)
        return data;
    } catch (error) {
        console.error('Error executing query:', error);
        return null;
    }
}

// 调用函数并处理结果
main()