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

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

  •  4
  • 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 年前
        1
  •  13
  •   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 路径

        2
  •  1
  •   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"
         ]
    }