TypeORM is not creating the tables Automatically

[DevendarTamma]

Question Title

TypeORM is not creating the tables Automatically

Question

TypeORM is not creating the tables Automatically, I am running the npm run watch: server , but the tables are not creating automatically to the database, I have even tried hardcoding the db connection details in Database.module.ts but still it is not creating, Can you please look into this and let me know where I am missing the db connection settings, I have even tried adding console logging but still it is not printing anything to the console when I run the server , I am placing hardcoded db file in context as it is not allowing me to attach .ts files and the screenshots of my structure as attachments as well

Context

import "reflect-metadata";
import { DataSource } from "typeorm";
import { AccountEntity } from "./entity/Account.entity";
import { CharacterEntity } from "./entity/Character.entity";
import { DatabaseLogger } from "./Logger.module";
import { BanEntity } from "./entity/Ban.entity";
import { InventoryItemsEntity } from "./entity/Inventory.entity";
import { VehicleEntity } from "./entity/Vehicle.entity";
import { BankAccountEntity } from "@entities/Bank.entity";

// Hard-coded configuration
const config = {
connectionLimit: 100,
connectTimeout: 60 * 60 * 1000,
acquireTimeout: 60 * 60 * 1000,
timeout: 60 * 60 * 1000,
host: "localhost", // Replace with your DB host
user: "postgres", // Replace with your DB user
password: "postgres", // Replace with your DB password
database: "mydb", // Replace with your DB name
port: 5432
};

const loggerConfig = {
queryLogFilePath: "./dblogs/query-log.log",
errorLogFilePath: "./dblogs/error.log",
defaultLogFilePath: "./dblogs/default-log.log"
};

// Logging the configuration details
console.log("Database connection configuration:", config);

export const MainDataSource = new DataSource({
type: "postgres",
host: config.host,
port: config.port,
username: config.user,
password: config.password,
database: config.database,
synchronize: true,
connectTimeoutMS: config.connectTimeout,
logging: ["error"],
entities: [AccountEntity, CharacterEntity, BankAccountEntity, BanEntity, InventoryItemsEntity, VehicleEntity],
migrations: [],
subscribers: [],
logger: DatabaseLogger.getInstance(loggerConfig)
});

// Function to test database connection
async function testDatabaseConnection() {
try {
console.log("Attempting to connect to the database...");
await MainDataSource.initialize();
console.log("Database connection established successfully.");
} catch (error) {
console.error("Database connection failed:", error);
}
}

// Test the database connection
testDatabaseConnection();

Troubleshooting Steps

No response

Additional Information

No response

[shr0x]

Is the database connecting?

[DevendarTamma]

I believe no, how to know whethere it is connecting or not , I tried adding a function for testing in Database.module.ts but it is not printing anything in console when I ran the server

[shr0x]

The server should turn off on its own when the database fails to connect, but since you have done changes to it, its not. Do not edit the code as the problem is not there. It's the database, see if you have installed it properly and you have access connecting to it. You might as well try giving RAGEMP server access to your firewall.