6 lines
637 B
TypeScript
6 lines
637 B
TypeScript
|
import { createDatabase, readDatabaseEnvironment } from "./apps/server/src/config/database";
|
||
|
|
import { QueryTypes } from "sequelize";
|
||
|
|
const db=createDatabase(readDatabaseEnvironment(process.env));
|
||
|
|
console.log(await db.query("SELECT TABLE_NAME AS child,COLUMN_NAME AS col,REFERENCED_TABLE_NAME AS parent,REFERENCED_COLUMN_NAME AS parentCol FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA=DATABASE() AND REFERENCED_TABLE_NAME IS NOT NULL",{type:QueryTypes.SELECT}));
|
||
|
|
console.log(await db.query("SELECT TABLE_NAME AS name FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE()",{type:QueryTypes.SELECT}));
|
||
|
|
await db.close();
|