先得在项目根目录下创建一个配置文件
module.exports = {
type: 'mysql',
host: process.env.MYSQL_HOST,
port: parseInt(process.env.MYSQL_POST, 10),
username: process.env.MYSQL_USER,
password: process.env.MYSQL_PASSWORD,
database: process.env.MYSQL_DATABASE,
entities: ['src/**/*.entity.ts'],
};
然后在项目里添加一个命令:
"typeorm": "node --require ts-node/register ./node_modules/typeorm/cli.js"
执行下面命令先查看一下同步的时候要执行的 sql 是什么
→ npm run typeorm schema:log
> xuanwu@0.0.1 typeorm /Users/xiaoxue/Desktop/Playground/xuanwu
> node --require ts-node/register ./node_modules/typeorm/cli.js "schema:log"
----------------------------------------------------------------
-- Schema syncronization will execute following sql queries (1):
----------------------------------------------------------------
ALTER TABLE `error-log` ADD `payload` varchar(255) NOT NULL;
确定同步可以执行 :
npm run typeorm schema:sync