Automatic retrieving of database entities

[FStefanni]

Feature Description

Hi,

I have the need to connect to SQLite, "dump" the data, perform some adjustment, and store the result to Postgres.
The issue is that I do not know and I do not want to create by hand the Entities, since I do not know in advance the the names of the tables, nor their details (e.g. column names and types).

So ti would be very useful to have a feature to say "hey typeorm, connect to that DB and autogenerate your required instances, so than i can inspect them".

I have searched for this feature, but it seems missing.

Regards

The Solution

Databases allow to write specific queries to inspect themselves.
So leveraging this, it is possible to implement the proposed feature.

Considered Alternatives

I searched internet for typeorm "plugins" but without luck.
I could write the inspection queries by hand, but it is not the best.
Not yet checked if typeorm alternatives have this feature.

Additional Context

No response

Relevant Database Driver(s)

• aurora-mysql
• aurora-postgres
• better-sqlite3
• cockroachdb
• cordova
• expo
• mongodb
• mysql
• nativescript
• oracle
• postgres
• react-native
• sap
• spanner
• sqlite
• sqlite-abstract
• sqljs
• sqlserver

Are you willing to resolve this issue by submitting a Pull Request?

No, I don’t have the time and I’m okay to wait for the community / maintainers to resolve this issue.

[iJhefe]

see https://www.npmjs.com/package/typeorm-model-generator

[FStefanni]

Hi,

thank you for the reply.
It is a pity that the linked project is in maintenance...

Regards.