FAQ - typeorm

​How do I change a column name in the database?​
​How can I set value of default some function, for example NOW()?​
​How to do validation?​
​What does "owner side" in relations mean or why we need to put @JoinColumn and @JoinTable decorators?​
​How do I add extra columns into many-to-many (junction) table?​
​How to use TypeORM with dependency injection tool?​
​How to handle outDir TypeScript compiler option?​
​How to use TypeORM with ts-node?​
​How to use Webpack for the backend​
How do I update a database schema?
One of the main responsibilities of TypeORM is to keep your database tables in sync with your entities. There are two ways that help you achieve this:
Use synchronize: true in your connection options:
1
import {createConnection} from "typeorm";
2
​
3
createConnection({
4
    synchronize: true
5
});
Copied!
This option automatically syncs your database tables with the given entities each time you run this code. This option is perfect during development, but in production you may not want this option to be enabled.
Use command line tools and run schema sync manually in the command line:
1
typeorm schema:sync
Copied!
This command will execute schema synchronization. Note, to make command line tools work, you must create an ormconfig.json file.
Schema sync is extremely fast. If you are considering the disable synchronize option during development because of performance issues, first check how fast it is.
How do I change a column name in the database?
By default, column names are generated from property names. You can simply change it by specifying a name column option:
1
@Column({ name: "is_active" })
2
isActive: boolean;
Copied!
How can I set the default value to some function, for example NOW()?
default column option supports a function. If you are passing a function which returns a string, it will use that string as a default value without escaping it. For example:
1
@Column({ default: () => "NOW()" })
2
date: Date;
Copied!
How to do validation?
Validation is not part of TypeORM because validation is a separate process not really related to what TypeORM does. If you want to use validation use class-validator - it works perfectly with TypeORM.
What does "owner side" in a relations mean or why we need to use @JoinColumn and @JoinTable?
Let's start with one-to-one relation. Let's say we have two entities: User and Photo:
1
@Entity()
2
export class User {
3
    
4
    @PrimaryGeneratedColumn()
5
    id: number;
6
    
7
    @Column()
8
    name: string;
9
    
10
    @OneToOne()
11
    photo: Photo;
12
    
13
}
Copied!
1
@Entity()
2
export class Photo {
3
    
4
    @PrimaryGeneratedColumn()
5
    id: number;
6
    
7
    @Column()
8
    url: string;
9
    
10
    @OneToOne()
11
    user: User;
12
    
13
}
Copied!
This example does not have a @JoinColumn which is incorrect. Why? Because to make a real relation, we need to create a column in the database. We need to create a column userId in photo or photoId in user. But which column should be created - userId or photoId? TypeORM cannot decide for you. To make a decision, you must use @JoinColumn on one of the sides. If you put @JoinColumn in Photo then a column called userId will be created in the photo table. If you put @JoinColumn in User then a column called photoId will be created in the user table. The side with @JoinColumn will be called the "owner side of the relationship". The other side of the relation, without @JoinColumn, is called the "inverse (non-owner) side of relationship".
It is the same in a @ManyToMany relation. You use @JoinTable to show the owner side of the relation.
In @ManyToOne or @OneToMany relations, @JoinColumn is not necessary because both decorators are different, and the table where you put the @ManyToOne decorator will have the relational column.
@JoinColumn and @JoinTable decorators can also be used to specify additional join column / junction table settings, like join column name or junction table name.
How do I add extra columns into many-to-many (junction) table?
It's not possible to add extra columns into a table created by a many-to-many relation. You'll need to create a separate entity and bind it using two many-to-one relations with the target entities (the effect will be same as creating a many-to-many table), and add extra columns in there. You can read more about this in Many-to-Many relations.
How to use TypeORM with a dependency injection tool?
In TypeORM you can use service containers. Service containers allow you to inject custom services in some places, like in subscribers or custom naming strategies. For example, you can get access to ConnectionManager from any place using a service container.
Here is an example for how you can set up typedi service containers with TypeORM. Note: you can setup any service container with TypeORM.
1
import {useContainer, createConnection} from "typeorm";
2
import {Container} from "typedi";
3
​
4
// its important to setup container before you start to work with TypeORM
5
useContainer(Container);
6
createConnection({/* ... */});
Copied!
How to handle outDir TypeScript compiler option?
When you are using the outDir compiler option, don't forget to copy assets and resources your app is using into the output directory. Otherwise, make sure to setup correct paths to those assets.
One important thing to know is that when you remove or move entities, the old entities are left untouched inside the output directory. For example, you create a Post entity and rename it to Blog, you no longer have Post.ts in your project. However, Post.js is left inside the output directory. Now, when TypeORM reads entities from your output directory, it sees two entities - Post and Blog. This may be a source of bugs. That's why when you remove and move entities with outDir enabled, it's strongly recommended to remove your output directory and recompile the project again.
How to use TypeORM with ts-node?
You can prevent compiling files each time using ts-node. If you are using ts-node, you can specify ts entities inside your connection options:
1
{
2
    entities: ["src/entity/*.ts"],
3
    subscribers: ["src/subscriber/*.ts"]
4
}
Copied!
Also, if you are compiling js files into the same folder where your typescript files are, make sure to use the outDir compiler option to prevent this issue.
Also, if you want to use the ts-node CLI, you can execute TypeORM the following way:
1
ts-node ./node_modules/.bin/typeorm schema:sync
Copied!
How to use Webpack for the backend?
Webpack produces warnings due to what it views as missing require statements -- require statements for all drivers supported by TypeORM. To suppress these warnings for unused drivers, you will need to edit your webpack config file.
1
const FilterWarningsPlugin = require('webpack-filter-warnings-plugin');
2
​
3
module.exports = {
4
    ...
5
    plugins: [
6
        //ignore the drivers you don't want. This is the complete list of all drivers -- remove the suppressions for drivers you want to use.
7
        new FilterWarningsPlugin({
8
            exclude: [/mongodb/, /mssql/, /mysql/, /mysql2/, /oracledb/, /pg/, /pg-native/, /pg-query-stream/, /react-native-sqlite-storage/, /redis/, /sqlite3/, /sql.js/, /typeorm-aurora-data-api-driver/]
9
        })
10
    ]
11
};
Copied!
Bundling Migration Files
By default Webpack tries to bundle everything into one file. This can be problematic when your project has migration files which are meant to be executed after bundled code is deployed to production. To make sure all your migrations can be recognized and executed by TypeORM, you may need to use "Object Syntax" for the entry configuration for the migration files only.
1
const glob = require('glob');
2
const path = require('path');
3
​
4
module.exports = {
5
  // ... your webpack configurations here...
6
  // Dynamically generate a `{ [name]: sourceFileName }` map for the `entry` option
7
  // change `src/db/migrations` to the relative path to your migration folder
8
  entry: glob.sync(path.resolve('src/db/migrations/*.ts')).reduce((entries, filename) => {
9
    const migrationName = path.basename(filename, '.ts');
10
    return Object.assign({}, entries, {
11
      [migrationName]: filename,
12
    });
13
  }, {}),
14
  resolve: {
15
    // assuming all your migration files are written in TypeScript
16
    extensions: ['.ts']
17
   },
18
  output: {
19
    // change `path` to where you want to put transpiled migration files.
20
    path: __dirname + '/dist/db/migrations',
21
    // this is important - we want UMD (Universal Module Definition) for migration files.
22
    libraryTarget: 'umd',
23
    filename: '[name].js',
24
  },
25
};
Copied!
Also, since Webpack 4, when using mode: 'production', files are optimized by default which includes mangling your code in order to minimize file sizes. This breaks the migrations because TypeORM relies on their names to determine which has already been executed. You may disable minimization completely by adding:
1
module.exports = {
2
  // ... other Webpack configurations here
3
  optimization: {
4
    minimize: false,
5
  },
6
};
Copied!
Alternatively, if you are using the UglifyJsPlugin, you can tell it to not change class or function names like so:
1
const UglifyJsPlugin = require('uglifyjs-webpack-plugin');
2
​
3
module.exports = {
4
  // ... other Webpack configurations here
5
  optimization: {
6
    minimizer: [
7
      new UglifyJsPlugin({
8
        uglifyOptions: {
9
          keep_classnames: true,
10
          keep_fnames: true
11
        }
12
      })
13
    ],
14
  },
15
};
Copied!
Lastly, make sure in your ormconfig file, the transpiled migration files are included:
1
// TypeORM Configurations
2
module.exports = {
3
  // ...
4
  migrations: [
5
    // this is the relative path to the transpiled migration files in production
6
    'db/migrations/**/*.js',
7
    // your source migration files, used in development mode
8
    'src/db/migrations/**/*.ts',
9
  ],
10
};
Copied!