#!/usr/bin/env node
/**
* Check onboarding status for user
*/
import pg from 'pg';
const { Client } = pg;
const client = new Client({
host: 'localhost',
port: 5433,
database: 'pg-litefarm',
user: 'postgres',
password: 'postgres'
});
const USER_ID = '3f930e96-4782-4e53-ac9a-3e855f2e7a54';
async function checkStatus() {
try {
await client.connect();
console.log(' Connected\n');
const result = await client.query(
`SELECT
uf.user_id,
uf.farm_id,
uf.step_one,
uf.step_two,
uf.step_three,
uf.step_four,
uf.step_five,
uf.has_consent,
uf.role_id,
uf.status,
f.farm_name,
f.grid_points IS NOT NULL as has_coordinates
FROM "userFarm" uf
JOIN farm f ON uf.farm_id = f.farm_id
WHERE uf.user_id = $1`,
[USER_ID]
);
console.log('=� Onboarding Status:\n');
result.rows.forEach(row => {
console.log(`Farm: ${row.farm_name} (${row.farm_id})`);
console.log(` step_one: ${row.step_one}`);
console.log(` step_two: ${row.step_two}`);
console.log(` step_three: ${row.step_three}`);
console.log(` step_four: ${row.step_four}`);
console.log(` step_five: ${row.step_five}`);
console.log(` has_consent: ${row.has_consent}`);
console.log(` role_id: ${row.role_id}`);
console.log(` status: ${row.status}`);
console.log(` has_coordinates: ${row.has_coordinates}`);
console.log('');
});
} catch (error) {
console.error('L Error:', error.message);
process.exit(1);
} finally {
await client.end();
}
}
checkStatus();
