Skip to main content
Deno 2 is finally here 🎉️
Learn more
Module

x/typeorm/docs/using-cli.md

Forked from https://github.com/typeorm/typeorm
denolib/typeorm
Very Popular
Go to Latest
File

Using CLI

Initialize a new TypeORM project

You can create a new project with everything already setup:

typeorm init

It creates all files needed for a basic project with TypeORM:

  • .gitignore
  • package.json
  • README.md
  • tsconfig.json
  • ormconfig.json
  • src/entity/User.ts
  • src/index.ts

Then you can run npm install to install all dependencies. Once all dependencies are installed, you need to modify ormconfig.json and insert your own database settings. After that, you can run your application by running npm start.

All files are generated in the current directory. If you want to generate them in a special directory you can use --name: 

typeorm init --name my-project

To specify a specific database you use you can use --database:

typeorm init --database mssql

You can also generate a base project with Express:

typeorm init --name my-project --express

If you are using docker you can generate a docker-compose.yml file using:

typeorm init --docker

typeorm init is the easiest and fastest way to setup a TypeORM project.

Create a new entity

You can create a new entity using CLI:

typeorm entity:create -n User

where User is an entity file and class name. Running the command will create a new empty entity in entitiesDir of the project. To setup the entitiesDir of the project you must add it in connection options:

{
    cli: {
        entitiesDir: "src/entity"
    }
}

Learn more about connection options. If you have a multi-module project structure with multiple entities in different directories you can provide the path to the CLI command where you want to generate an entity:

typeorm entity:create -n User -d src/user/entity

Learn more about entities.

Create a new subscriber

You can create a new subscriber using CLI:

typeorm subscriber:create -n UserSubscriber

where UserSubscriber is a subscriber file and class name. Running the following command will create a new empty subscriber in the subscribersDir of the project. To setup subscribersDir you must add it in connection options:

{
    cli: {
        subscribersDir: "src/subscriber"
    }
}

Learn more about connection options. If you have a multi-module project structure with multiple subscribers in different directories you can provide a path to the CLI command where you want to generate a subscriber:

typeorm subscriber:create -n UserSubscriber -d src/user/subscriber

Learn more about Subscribers.

Create a new migration

You can create a new migration using CLI:

typeorm migration:create -n UserMigration

where UserMigration is a migration file and class name. Running the command will create a new empty migration in the migrationsDir of the project. To setup migrationsDir you must add it in connection options:

{
    cli: {
        migrationsDir: "src/migration"
    }
}

Learn more about connection options. If you have a multi-module project structure with multiple migrations in different directories you can provide a path to the CLI command where you want to generate a migration:

typeorm migration:create -n UserMigration -d src/user/migration

Learn more about Migrations.

Generate a migration from exist table schema

Automatic migration generation creates a new migration file and writes all sql queries that must be executed to update the database.

typeorm migration:generate -n UserMigration

The rule of thumb is to generate a migration after each entity change.

Learn more about Migrations.

Run migrations

To execute all pending migrations use following command:

typeorm migration:run

Learn more about Migrations.

Revert migrations

To revert the most recently executed migration use the following command:

typeorm migration:revert

This command will undo only the last executed migration. You can execute this command multiple times to revert mutliple migrations. Learn more about Migrations.

Sync database schema

To synchronize a database schema use:

typeorm schema:sync

Be careful running this command in production - schema sync may cause data loss if you don’t use it wisely. Check which sql queries it will run before running on production.

Log sync database schema queries without actual running them

To check what sql queries schema:sync is going to run use:

typeorm schema:log

Drop database schema

To completely drop a database schema use:

typeorm schema:drop

Be careful with this command on production since it completely removes data from your database.

Run any sql query

You can execute any sql query you want directly in the database using:

typeorm query "SELECT * FROM USERS"

Clear cache

If you are using QueryBuilder caching, sometimes you may want to clear everything stored in the cache. You can do it using the following command:

typeorm cache:clear

Check version

You can check what typeorm version you have installed (both local and global) by running:

typeorm version