在microorm中创建迁移时数据库不存在

Question

我尝试了microorm创建迁移，但似乎我不能创建表本身。我不知道我错过了什么，错误提示数据库"crm"不存在

请参阅下面的代码:

mikro-config.ts

import { MikroORM } from "@mikro-orm/core";
import { Post } from "./entities/Post";
import { __prod__ } from "./constants";
import path from "path";
export default {
migrations: {
path: path.join(__dirname, "./migrations"), // path to the folder with migrations
pattern: /^[w-]+d+.[tj]s$/, // regex pattern for the migration files
},
entities: [Post],
dbName: "crm",
type: "postgresql",
user: "postgres",
debug: !__prod__,
} as Parameters<typeof MikroORM.init>[0];

index.ts

import { MikroORM as MK } from "@mikro-orm/core";
import { __prod__ } from "./constants";
import { Post } from "./entities/Post";
import mikroOrmConfig from "./mikro-orm.config";
const main = async () => {
const orm = await MK.init(mikroOrmConfig);
const post = orm.em.create(Post, {
firstName: "Test",
lastName: "Test2",
dateOfBirth: "2012-01-01",
email: "[e-mail]",
phone: "192803994",
address: "34th street local avenue, trade city",
});
await orm.em.persistAndFlush(post);
};
main().catch((err) => console.log(err));
console.log("test");

Post.ts

import { Entity, PrimaryKey, Property } from "@mikro-orm/core";
@Entity()
export class Post {
@PrimaryKey()
_id!: number;
@Property()
createdAt: Date = new Date();
@Property({ onUpdate: () => new Date() })
updatedAt: Date = new Date();
@Property()
firstName!: string;
@Property()
lastName!: string;
@Property()
dateOfBirth!: Date;
@Property()
email!: string;
@Property()
phone!: string;
@Property()
Address!: string;
}

npx micro - form migration:create——initial.

我已经删除了文件夹，再试一次，没有任何结果。

Answer 1

您刚刚创建了迁移，现在您需要通过npx mikro-orm migration:up执行它。

npx mikro-orm migration:create   # Create new migration with current schema diff
npx mikro-orm migration:up       # Migrate up to the latest version
npx mikro-orm migration:down     # Migrate one step down
npx mikro-orm migration:list     # List all executed migrations
npx mikro-orm migration:pending  # List all pending migrations

https://mikro-orm.io/docs/migrations/using-via-cli

或者，您可以直接使用SchemaGenerator来代替迁移:

npx mikro-orm schema:create --run   # creates the schema, including the database if not exists
npx mikro-orm schema:update --run   # updates the schema
npx mikro-orm schema:drop --run     # drops the schema

https://mikro-orm.io/docs/schema-generator/

Answer 2

需要单独创建postgres数据库。micro -orm不会为你创建数据库。

创建postgres数据库，名称为"然后运行并应用迁移，您的表将被创建。