@redcap-konex/neat-orm v1.0.81

Setup orm neat

Basic usage with typeorm 0.2

need to use the following ormconfig.js in the root of project

'use strict';
Object.defineProperty(exports, '__esModule', { value: true });
const config = {

	type: process.env.TYPE,
	host: process.env.NODE_ENV === 'test' ? process.env.DB_HOST_LOCAL : process.env.DB_HOST,
	port: process.env.DB_PORT,
	username: process.env.NODE_ENV === 'test' ? process.env.DB_USER_LOCAL : process.env.DB_USER,
	password: process.env.NODE_ENV === 'test' ? process.env.DB_PASSWORD_LOCAL : process.env.DB_PASSWORD,
	database: process.env.NODE_ENV === 'test' ? process.env.DB_TEST : process.env.DB_NAME,
	entities: ['node_modules/@redcap-konex/neat-orm/dist/entity/**/*{.ts,.js}']
}
module.exports = config

import { Countries, OrmManagement,getRepository } from '@redcap-konex/neat-orm';

const { createConexionOrm } = OrmManagement;
createConexionOrm()
  .then(async () => {
    console.log("SE CONECTO EL ORM");
    const countryRepository = getRepository(Countries);
    const buildCountries = countryRepository.createQueryBuilder("Country");
    const res = await buildCountries
      .leftJoin("Country.banks", "banks")
      .addSelect(["banks.id", "banks.name"])
      .addSelect(["Country.id", "Country.name"])
      .getMany();
    console.log(res);
  })
  .catch((error) => {
    console.log(error);
  });

Basic usage with typeorm 0.3

import { Countries, OrmManagement,getRepository } from '@redcap-konex/neat-orm';

const neatOrm = new OrmManagement({
  type: process.env.TYPE as any,
  host:
    process.env.NODE_ENV === "test"
      ? process.env.DB_HOST_LOCAL
      : process.env.DB_HOST,
  port: Number(process.env.DB_PORT),
  username:
    process.env.NODE_ENV === "test"
      ? process.env.DB_USER_LOCAL
      : process.env.DB_USER,
  password:
    process.env.NODE_ENV === "test"
      ? process.env.DB_PASSWORD_LOCAL
      : process.env.DB_PASSWORD,
  database:
    process.env.NODE_ENV === "test" ? process.env.DB_TEST : process.env.DB_NAME,
});
const { createConexionOrm } = neatOrm;
createConexionOrm()
  .then(async () => {
    console.log("SE CONECTO EL ORM");
    const countryRepository = getRepository(Countries);
    const buildCountries = countryRepository.createQueryBuilder("Country");
    const res = await buildCountries
      .leftJoin("Country.banks", "banks")
      .addSelect(["banks.id", "banks.name"])
      .addSelect(["Country.id", "Country.name"])
      .getMany();
    console.log(res);
  })
  .catch((error) => {
    console.log(error);
  });

Get Conection usage

import { getConnection } from '@redcap-konex/neat-orm';

const conn = getConnection()

close Db Conection usage

import { getConnection } from '@redcap-konex/neat-orm';

const conn = getConnection();
if (conn.isInitialized) {
  conn
    .destroy()
    .then(() => {
      console.log("DB conn closed");
    })
    .catch((err) => {
      console.log("Error clossing conn to DB", err);
    });
} else {
  console.log("DB conn already closed.");
}

help migrations

npm run typeorm -- -help

init migrations

npm run typeorm:migrate init -- -d src/migrations

run migrations pendings

npm run typeorm:run

after this execute run

dont forgot update de package.json version

npm run deploy

When get migrations test db

put cross-env NODE_ENV=test in package.json ahead of typeorm:migrate and typeorm:run

Creating the initial data for superadmin

1. npm run seed:config
2. npm run seed:run

well practice when change or add field to table in database

npm run typeorm:migrate added_column_hola_to_users -- -d src/migrations

run test only one file example in windows

npm test src/tests/cities/cities.service.test.ts