TypeORM：在使用SQLITE运行迁移时不创建数据库表

Question

我目前面临着将迁移与TypeORM和sqlite3数据库一起使用的问题。我希望在本地/测试/登台/生产环境之间尽可能多地使用奇偶校验，只在运行时使用将在docker compose文件中传递给docker的环境变量。我希望避免使用ormconfig。json文件和同步方法。

现在，在本地，我尝试使用一个dev配置文件来运行迁移，该文件似乎正在运行，但是迁移表不知何故是空的，并且从未创建过URL实体表。即使数据库或dev.db文件根本不存在或是全新的，该问题仍然存在，请使用：

$ sqlite3 src/db/storage/dev.db

文件结构：

backend
 ┣ env
 ┃ ┣ dev.env
 ┃ ┣ prod.env
 ┃ ┗ test.env
 ┣ scripts
 ┣ src
 ┃ ┣ db
 ┃ ┃ ┣ entity
 ┃ ┃ ┣ migration
 ┃ ┃ ┗ storage
 ┃ ┣ tests
 ┃ ┃ ┗ api.test.ts
 ┃ ┣ utils
 ┃ ┃ ┗ url.ts
 ┃ ┣ index.ts
 ┃ ┗ server.ts
 ┣ .babelrc
 ┣ .dockerignore
 ┣ .gitignore
 ┣ .prettierrc.json
 ┣ Dockerfile
 ┣ README.md
 ┣ jest.config.ts
 ┣ package.json
 ┣ tsconfig.json
 ┣ tsconfig.prod.json
 ┗ yarn.lock

我的环境文件（dev.env）：

TYPEORM_CONNECTION = better-sqlite3
TYPEORM_DATABASE = src/db/storage/dev.db
TYPEORM_ENTITIES = src/db/entity/*.ts 
TYPEORM_MIGRATIONS_DIR = src/db/migration/*.ts

TYPEORM_LOGGING = all

包裹json（脚本）：

{
...
"scripts": {
   "typeorm": "ts-node --transpile-only ./node_modules/typeorm/cli.js",
   "typeorm:generate-migration": "yarn typeorm migration:generate",
   "typeorm:create-migration": "yarn typeorm migration:create",
   "typeorm:run-migration": "yarn typeorm migration:run",
   "typeorm:revert-migration": "yarn typeorm migration:revert",
   },
"dependencies": {
  ...
  "better-sqlite3": "^7.4.3",
  "reflect-metadata": "^0.1.13",
  "typeorm": "0.2.34"
  ...
}
...
}

我的实体：

import {EntitySchema} from "typeorm"

export interface Url {
  id: number
  url: string
}

export const UrlEntity = new EntitySchema<Url>({
  name: "Url",
  columns: {
    id: {
      type: Number,
      primary: true,
      generated: true
    },
    url: {
      type: String
    }
  }
})

我所尝试的：

• 生成迁移文件

$ yarn typeorm:generate-migration -n CreateDatabase --config env/dev.env

迁移文件内容：

import {MigrationInterface, QueryRunner} from "typeorm";

export class CreateDatabase1627595908837 implements MigrationInterface {
    name = 'CreateDatabase1627595908837'

    public async up(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`CREATE TABLE "url" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "url" varchar NOT NULL)`);
    }

    public async down(queryRunner: QueryRunner): Promise<void> {
        await queryRunner.query(`DROP TABLE "url"`);
    }

}

• 运行迁移，生成迁移表（不知何故为空），但不创建url表

$ yarn typeorm:run-migration --config ./env/dev.env 

命令的输出：

$ query: SELECT * FROM "sqlite_master" WHERE "type" = 'table' AND "name" = 'migrations'
$ query: CREATE TABLE "migrations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "timestamp" bigint NOT NULL, "name" varchar NOT NULL)
query: SELECT * FROM "migrations" "migrations" ORDER BY "id" DESC
$ No migrations are pending
~``

Answer 1

我想出了这个问题的解决办法。

当使用ormconfig时。json和使用typeorm CLI，我们需要明确订阅者、实体和迁移的目录，使用环境变量时也是如此。如果未提供这些文件，或者在我的示例中仅提供其中一个，则最终将创建名为“/path/*.ts”的迁移文件夹，这是不正确的行为，即使这意味着它仍然创建文件，但不知道使用cli工具在何处查找。

之前：

TYPEORM_CONNECTION = better-sqlite3
TYPEORM_DATABASE = src/db/storage/dev.db
TYPEORM_ENTITIES = src/db/entity/*.ts 
TYPEORM_MIGRATIONS_DIR = src/db/migration/*.ts
TYPEORM_LOGGING = all

之后：

TYPEORM_CONNECTION = "better-sqlite3"
TYPEORM_DATABASE = src/db/storage/dev.db
TYPEORM_ENTITIES = src/db/entity/*.ts
TYPEORM_MIGRATIONS = src/db/migrations/*.ts
TYPEORM_ENTITIES_DIR = src/db/entity
TYPEORM_MIGRATIONS_DIR = src/db/migrations
TYPEORM_LOGGING = all

运行迁移后，输出如下：

$ yarn typeorm migration:run --config ./env/dev.env

$ ts-node --transpile-only ./node_modules/typeorm/cli.js migration:run --config ./env/dev.env

query: SELECT * FROM "sqlite_master" WHERE "type" = 'table' AND "name" = 'migrations'

query: CREATE TABLE "migrations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "timestamp" bigint NOT NULL, "name" varchar NOT NULL)

query: SELECT * FROM "migrations" "migrations" ORDER BY "id" DESC

0 migrations are already loaded in the database.
1 migrations were found in the source code.
1 migrations are new migrations that needs to be executed.

query: BEGIN TRANSACTION

query: CREATE TABLE "url" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "url" varchar NOT NULL)

query: INSERT INTO "migrations"("timestamp", "name") VALUES (?, ?) -- PARAMETERS: [1627601766574,"CreateDatabase1627601766574"]

Migration CreateDatabase1627601766574 has been executed successfully.
query: COMMIT

我希望这能帮助其他和我有同样问题的人。