代码之家 › 专栏 › 技术社区 › qbodart

典型的ormconfig。谷歌云SQL的json文件?

typeorm google-cloud-sql

qbodart · 技术社区 · 7 年前

我已经试了几个小时了。ormconfig应该是什么。用于使用TypeORM的Google云SQL的json文件?我设法在本地使用DB的IP(使用mysql workbench和Google cloud proxy并将我的IP列入白名单),但我不知道app engine的连接详细信息应该是什么。

{
  "name": "default",
  "type": "mysql",
  "host": "/cloudsql/[project:region:instance]",
  "port": "3306",
  "username": "root",
  "password": "xxxx",
  "database": "yyy",
  "synchronize": true,
  "logging": false,
  "entities": [
    "modules/**/*.entity.js"
  ]
}

或

{
  "name": "default",
  "type": "mysql",
  "extra": {
    "socketPath": "/cloudsql/[project:region:instance]"
  },
  "username": "root",
  "password": "xxxx",
  "database": "yyy",
  "synchronize": true,
  "logging": false,
  "entities": [
    "modules/**/*.entity.js"
  ]
}

或者其他什么?

谢谢!

2 回复 | 直到 7 年前

qbodart 7 年前

对于感兴趣的人,以下是解决方案:

{
  "name": "default",
  "type": "mysql",
  "extra": {
    "socketPath": "/cloudsql/[project:region:instance]"
  },
  "username": "root",
  "password": "xxxx",
  "database": "yyy",
  "synchronize": true,
  "logging": false,
  "entities": [
    "dist/**/*.entity.js"
  ]
}

注意,我还更改了 entities 路径

Israel 5 年前

直到我添加了“cloud\u sql”路径,也就是“host”,它才对我起作用:

{
     "name": "default",
     "host": "/cloudsql/[project:region:instance]",
     "type": "mysql",
     "extra": {
       "socketPath": "/cloudsql/[project:region:instance]"
     },
     "username": "root",
     "password": "xxxx",
     "database": "yyy",
     "synchronize": true,
     "logging": false,
     "entities": [
         "dist/**/*.entity.js"
     ]
}

推荐文章