在nest中使用typeorm-model-generator自动生成实体

1.npm i -g typeorm-model-generator 或者 yarn global add typeorm-model-generator

2.修改项目中的 package.json 文件

"scripts": {
  "db": "rimraf ./src/modules/entities & npx typeorm-model-generator -h 121.36.70.68 -d chat -p 3306 -u root -x 123456 -e mysql -o ./src/modules/entities --noConfig true --ce pascal --cp camel"
}

• rm -rf entities表示先删除文件夹entities（window下使用 rimraf entities ）
• npx typeorm-model-generator如果全局安装了就不需要加npx没有全局安装就加上去

• -h localhost -d 数据库名字 -p 端口 -u 用户名 -x 密码 -e 数据库类型
• -o entities表示输出到指定的文件夹
• --noConfig true表示不生成ormconfig.json和tsconfig.json文件
• --ce pascal表示将类名转换首字母是大写的驼峰命名
• --cp camel表示将数据库中的字段比如create_at转换为createAt
• -a表示会继承一个BaseEntity的类,根据自己需求加

3.运行代码 npm run db 或 yarn run db

 

遇到报错

D:\YYH\nest\project-name\chat-server>yarn run db                               
yarn run v1.22.10
$ rimraf entities & npx typeorm-model-generator -h 121.36.70.68 -d chat -p 3306 -u root -x 123456 -e mysql -o entities --noConfig true --ce pascal --cp camel 
typeorm-model-generator@0.4.3
[10:39:07 ├F10: AM┤] Starting creation of model classes.
Table friend_message has no PK.
Error occurred in typeorm-model-generator.
typeorm-model-generator@0.4.3  node@v12.18.4
If you think this is a bug please open an issue including this log on https://github.com/Kononnable/typeorm-model-generator/issues
Table user_friend has no PK.
Error occurred in typeorm-model-generator.
typeorm-model-generator@0.4.3  node@v12.18.4
If you think this is a bug please open an issue including this log on https://github.com/Kononnable/typeorm-model-generator/issues
Table user_group has no PK.
Error occurred in typeorm-model-generator.
typeorm-model-generator@0.4.3  node@v12.18.4
If you think this is a bug please open an issue including this log on https://github.com/Kononnable/typeorm-model-generator/issues
Table group has no PK.
Error occurred in typeorm-model-generator.
typeorm-model-generator@0.4.3  node@v12.18.4
If you think this is a bug please open an issue including this log on https://github.com/Kononnable/typeorm-model-generator/issues
[10:39:08 ├F10: AM┤] Typeorm model classes created.
Done in 4.54s.

解决办法：数据库表字段没有设置主键