29 lines
717 B
JavaScript
29 lines
717 B
JavaScript
const pool = require("./db/pool.js");
|
|
|
|
async function run() {
|
|
const client = await pool.connect();
|
|
try {
|
|
console.log("Querying HWP/HWPX files from database...");
|
|
|
|
const query = `
|
|
SELECT *
|
|
FROM ver4._test_tb_data
|
|
WHERE ext IN ('hwp', 'hwpx')
|
|
ORDER BY data_id DESC
|
|
LIMIT 5;
|
|
`;
|
|
const res = await client.query(query);
|
|
console.log("Results:");
|
|
res.rows.forEach(row => {
|
|
console.log(JSON.stringify(row, null, 2));
|
|
});
|
|
} catch (err) {
|
|
console.error("Error checking HWP files:", err);
|
|
} finally {
|
|
client.release();
|
|
await pool.end();
|
|
}
|
|
}
|
|
|
|
run();
|