82 lines
3.3 KiB
JavaScript
82 lines
3.3 KiB
JavaScript
import chalk from "chalk";
|
|
import { select } from "@inquirer/prompts";
|
|
import { AppData } from "../../data/app-data";
|
|
import showEntries from "./show-entries";
|
|
import showFields from "./show-fields";
|
|
import dbHandler from "../../lib/db-handler";
|
|
import MariaDBQuoteGen from "../../lib/schema/mariadb-quote-gen";
|
|
export default async function listTables(params) {
|
|
const tables = (await dbHandler({
|
|
query: `SELECT table_name FROM ${MariaDBQuoteGen(AppData["DbSchemaManagerTableName"])}`,
|
|
})).payload;
|
|
if (!tables?.length) {
|
|
console.log(chalk.yellow("\nNo tables found.\n"));
|
|
return;
|
|
}
|
|
while (true) {
|
|
const tableName = await select({
|
|
message: "Select a table:",
|
|
choices: [
|
|
...tables.map((t) => ({
|
|
name: t.table_name,
|
|
value: t.table_name,
|
|
})),
|
|
{ name: chalk.dim("← Go Back"), value: "__back__" },
|
|
{ name: chalk.dim("✕ Exit"), value: "__exit__" },
|
|
],
|
|
});
|
|
if (tableName === "__back__")
|
|
break;
|
|
if (tableName === "__exit__")
|
|
return "__exit__";
|
|
while (true) {
|
|
const action = await select({
|
|
message: `"${tableName}" — choose an action:`,
|
|
choices: [
|
|
{ name: "Entries", value: "entries" },
|
|
{ name: "Fields", value: "fields" },
|
|
{ name: "Schema", value: "schema" },
|
|
{ name: chalk.dim("← Go Back"), value: "__back__" },
|
|
{ name: chalk.dim("✕ Exit"), value: "__exit__" },
|
|
],
|
|
});
|
|
if (action === "__back__")
|
|
break;
|
|
if (action === "__exit__")
|
|
return "__exit__";
|
|
if (action === "entries") {
|
|
const result = await showEntries({ tableName });
|
|
if (result === "__exit__")
|
|
return "__exit__";
|
|
}
|
|
if (action === "fields") {
|
|
const result = await showFields({ tableName });
|
|
if (result === "__exit__")
|
|
return "__exit__";
|
|
}
|
|
if (action === "schema") {
|
|
const columns = (await dbHandler({
|
|
query: `SELECT ORDINAL_POSITION, COLUMN_NAME, COLUMN_TYPE, IS_NULLABLE, COLUMN_DEFAULT, COLUMN_KEY, EXTRA FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = ? ORDER BY ORDINAL_POSITION`,
|
|
values: [tableName],
|
|
})).payload;
|
|
console.log(`\n${chalk.bold(`Schema for "${tableName}":`)} \n`);
|
|
if (columns?.length) {
|
|
console.table(columns.map((c) => ({
|
|
"#": c.ORDINAL_POSITION,
|
|
Name: c.COLUMN_NAME,
|
|
Type: c.COLUMN_TYPE,
|
|
Nullable: c.IS_NULLABLE,
|
|
Default: c.COLUMN_DEFAULT ?? "(none)",
|
|
Key: c.COLUMN_KEY || "",
|
|
Extra: c.EXTRA || "",
|
|
})));
|
|
}
|
|
else {
|
|
console.log(chalk.yellow("No columns found."));
|
|
}
|
|
console.log();
|
|
}
|
|
}
|
|
}
|
|
}
|