19 lines
478 B
JavaScript
19 lines
478 B
JavaScript
import { pool } from '../db.js';
|
|
|
|
const checkPrizes = async () => {
|
|
try {
|
|
const result = await pool.query('SELECT id, name, type FROM prizes ORDER BY type');
|
|
console.log('\n📦 LOTS DISPONIBLES DANS LA BASE:\n');
|
|
result.rows.forEach(p => {
|
|
console.log(` • Type: ${p.type} | Name: ${p.name}`);
|
|
});
|
|
console.log('');
|
|
await pool.end();
|
|
} catch (error) {
|
|
console.error('Erreur:', error.message);
|
|
await pool.end();
|
|
}
|
|
};
|
|
|
|
checkPrizes();
|