Function printTable

packages/core/src/scripts/db/query.ts:123–164

(
  rows: Record<string, unknown>[],
  finalSql: string,
  format?: string,
)

}

function printTable(
  rows: Record<string, unknown>[],
  finalSql: string,
  format?: string,
) {
  if (format === "json") {
    console.log(
      JSON.stringify({ query: finalSql, rows, count: rows.length }, null, 2),
    );
    return;
  }

  console.log(`Query: ${finalSql}`);
  console.log(`Rows: ${rows.length}\n`);

  if (rows.length === 0) {
    console.log("(no results)");
    return;
  }

  const keys = Object.keys(rows[0]);
  const widths = keys.map((k) => {
    const maxVal = Math.max(...rows.map((r) => String(r[k] ?? "NULL").length));
    return Math.max(k.length, Math.min(maxVal, 60));
  });

  const header = keys.map((k, i) => k.padEnd(widths[i])).join(" | ");
  console.log(header);
  console.log(widths.map((w) => "-".repeat(w)).join("-+-"));

  for (const row of rows) {
    const line = keys
      .map((k, i) => {
        const val = String(row[k] ?? "NULL");
        return val.length > 60
          ? val.slice(0, 57) + "..."
          : val.padEnd(widths[i]);
      })
      .join(" | ");
    console.log(line);
  }
}

export default async function dbQuery(args: string[]): Promise<void> {
  const parsed = parseArgs(args);