feature: fake migrations for existing tables

[rubiin]

Issue type:

[ ] question
[ ] bug report
[x] feature request
[ ] documentation issue

it would be great to fake migrations something like https://docs.djangoproject.com/en/1.11/ref/django-admin/#cmdoption-migrate-fake .

[rubiin]

heres a workaround i did

import "reflect-metadata";
import {createConnection, MigrationExecutor} from "typeorm";


createConnection().then(async connection => {
    const mig = new MigrationExecutor(connection);
    await mig.showMigrations();
    const migrations = await mig.getAllMigrations();
    for (let migration of migrations)
    {
        await mig.insertMigration(migration);
    }

}).catch(error => console.log(error));

[rubiin]

revised version:

import 'reflect-metadata';
import { createConnection, MigrationExecutor } from 'typeorm';
import config from './config';
import { join } from 'path';

createConnection({
	type: 'postgres',
	host: config.db.host,
	port: config.db.port,
	username: config.db.username,
	password: config.db.password,
	database: config.db.database,
	entities: [join(__dirname, 'entities/*{.ts,.js}')],
	logging: 'all',
	migrationsTableName: 'nest_migration',
	logger: 'advanced-console',
	migrations: [join(__dirname, 'migrations/**/*{.ts,.js}')],
	cli: {
		migrationsDir: join('src', 'migrations'),
	},
})
	.then(async connection => {
		const mig = new MigrationExecutor(connection);
		await connection.manager.query(
			` CREATE TABLE IF NOT EXISTS "nest_migration" ("id" SERIAL NOT NULL, "timestamp" bigint NOT NULL, "name" character varying NOT NULL, CONSTRAINT "PK_d8a054ea06850edd968e06c00e4" PRIMARY KEY ("id"))`,
		);
		const migrations = await mig.getAllMigrations();

		console.log(migrations);

		for (let migration of migrations) {
			//	await mig.insertMigration(migration);

			await connection.manager.query(
				` INSERT INTO "nest_migration"("timestamp", "name") VALUES ($1, $2) `,
				[migration.timestamp, migration.name],
			);
		}
	})
	.catch(error => console.log(error));

[rubiin]

@pleerock can we dosomething like this with the cli. i find it a good addition

[Pipeliner]

@rubiin was something like this feature implemented?

[rubiin]

Sadly no. I have to moveon to MikroOrm due to so many things

[Pipeliner]

Could you please reopen this issue then?

…

On Fri, Apr 8, 2022, 00:45 Rubin Bhandari ***@***.***> wrote: Sadly no. I have to moveon to MikroOrm due to so many things — Reply to this email directly, view it on GitHub <#6195 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAESBUIYNSQ7LOPDOBHHAC3VD43MXANCNFSM4NSRZ7QQ> . You are receiving this because you commented.Message ID: ***@***.***>

[ahmedosama94]

@rubiin willing to contribute if no one has already picked this up, please let me know.

[rubiin]

@ahmedosama94 You can go ahead. This issue has not been picked up. But make sure they are willing to add it first though