app/debug-db.mjs

#!/usr/bin/env node
import Surreal from 'surrealdb';

const USER_DID = 'did:plc:sypdx6a4u2fblmclv6wbxjl3';

async function main() {
  const db = new Surreal();

  try {
    console.log('Connecting to SurrealDB...');
    await db.connect('ws://localhost:8000/rpc');

    console.log('Signing in...');
    await db.signin({
      username: 'root',
      password: 'root',
    });

    console.log('Using namespace/database...');
    await db.use({
      namespace: 'ponderants',
      database: 'main',
    });

    console.log('\n===== ALL NODES IN DATABASE =====');
    const allNodes = await db.query('SELECT * FROM node LIMIT 20');
    console.log('Total nodes:', allNodes[0]?.length || 0);
    console.log('Nodes:', JSON.stringify(allNodes[0], null, 2));

    console.log(`\n===== NODES FOR USER ${USER_DID} (WITHOUT coords_3d filter) =====`);
    const userNodesNoFilter = await db.query(
      'SELECT id, title, user_did, coords_3d FROM node WHERE user_did = $userDid',
      { userDid: USER_DID }
    );
    console.log('Count:', userNodesNoFilter[0]?.length || 0);
    console.log('Nodes:', JSON.stringify(userNodesNoFilter[0], null, 2));

    console.log(`\n===== NODES FOR USER ${USER_DID} (WITH coords_3d != NONE filter) =====`);
    const userNodesWithFilter = await db.query(
      'SELECT id, title, user_did, coords_3d FROM node WHERE user_did = $userDid AND coords_3d != NONE',
      { userDid: USER_DID }
    );
    console.log('Count:', userNodesWithFilter[0]?.length || 0);
    console.log('Nodes:', JSON.stringify(userNodesWithFilter[0], null, 2));

  } catch (error) {
    console.error('Error:', error);
    console.error('Stack:', error.stack);
  } finally {
    await db.close();
  }
}

main();