#!/usr/bin/env node
import pkg from 'pg';
const { Client } = pkg;
const client = new Client({
host: 'localhost',
port: 5433,
database: 'pg-litefarm',
user: 'postgres',
password: 'postgres',
});
await client.connect();
const farmId = '15758606-cb0d-11f0-a430-eed6bc26dc01';
const result = await client.query(`
SELECT
management_plan_id,
name,
deleted,
created_at
FROM management_plan
WHERE deleted = false
ORDER BY created_at DESC
LIMIT 10
`);
console.log('Management Plans found:', result.rows.length);
console.log('');
result.rows.forEach((mp, idx) => {
console.log(`${idx + 1}. ${mp.name || 'Unnamed'}`);
console.log(` Created: ${mp.created_at?.toISOString().split('T')[0] || 'N/A'}`);
console.log(` ID: ${String(mp.management_plan_id).substring(0, 12)}...`);
console.log('');
});
await client.end();
console.log('Now checking if /management_plan/farm endpoint works...');
