Enums and constants

import { ConstraintType, ReferentialAction, IsolationLevel } from 'ts-prorm-orm';

await Order.addConstraint('order_user_fk', {
  type: ConstraintType.ForeignKey,
  fields: ['userId'],
  references: { table: 'users', fields: ['id'] },
  onDelete: ReferentialAction.Cascade,
});

- import { Prorm } from 'ts-prorm-orm';
+ import { Prorm, SqlDialect, ConstraintType, ReferentialAction } from 'ts-prorm-orm';

- const prorm = new Prorm({ dialect: 'postgres', database: 'shop' });
+ const prorm = new Prorm({ dialect: SqlDialect.Postgres, database: 'shop' });

  await Order.addConstraint('order_user_fk', {
-   type: 'FOREIGN KEY',
+   type: ConstraintType.ForeignKey,
    fields: ['userId'],
    references: { table: 'users', fields: ['id'] },
-   onDelete: 'CASCADE',
+   onDelete: ReferentialAction.Cascade,
  });

import { Prorm, SqlDialect } from 'ts-prorm-orm';

const prorm = new Prorm({ dialect: SqlDialect.Postgres, database: 'shop' });

import { Prorm, SQL_DIALECTS, isSqlDialect } from 'ts-prorm-orm';

const dialect = process.env.DB_DIALECT ?? 'sqlite';
if (!isSqlDialect(dialect)) {
  // Fails at boot with the list of valid names, not at the first query.
  throw new Error(`DB_DIALECT must be one of: ${SQL_DIALECTS.join(', ')}`);
}

// `dialect` is narrowed to SqlDialect here, so no cast is needed.
export const prorm = new Prorm({
  dialect,
  storage: dialect === 'sqlite' ? './dev.sqlite' : undefined,
  database: process.env.DB_NAME,
});

import { ModelHook, PrormHook } from 'ts-prorm-orm';

User.hook(ModelHook.BeforeCreate, (user) => {
  user.email = String(user.email).trim().toLowerCase();
});

prorm.addHook(PrormHook.AfterSync, () => {
  console.log('schema is in sync');
});

import { OrderDirection } from 'ts-prorm-orm';

const recentlyShipped = await Order.findAll({
  order: [['shippedAt', OrderDirection.DESC_NULLS_LAST]],
  limit: 20,
});

import {
  ConstraintType, ReferentialAction, Deferrable, IndexMethod, PartitionKind,
  SortDirection, OrderDirection, JoinType, AssociationType, LockLevel,
  SqlCommand, TriggerTiming, TriggerEvent, TriggerForEach,
  ParamMode, Volatility, RoutineLanguage, DiagramType,
  ModelHook, PrormHook, TimeUnit, WindowFrameType, SetOperation, GroupingType,
  IsolationLevel, SqliteTransactionType, MigrationState, SeedState, MigrationStorage,
  TableCheckLevel, SeverityLevel, QueryTypes,
} from 'ts-prorm-orm';