Database creation and import automation

[janpio]

This repository should have automation that can create the required databases, import the schema and data. It would probably also be useful to have scripts to truncate data, and delete databases again.

Requirements:

• MySQL
• Postgres
• Create Database (+ Schema)
• Import Schema
• Import Data
• Truncate Data
• Remove Databases
• Works on Linux/macOS and Windows

Template can probably be some scripts from https://github.com/prisma/introspection-engine-output/

[janpio]

load.ts from introspection-engine-output indeed does a lot of this already, but could certainly be made a bit more user friendly (and cross platform).

[divyenduz]

Can you define this further? I think we almost have the setup to do this. Do you want to use load.ts directly or do you want something running in the CI?

[janpio]

This is user facing, and helps users to automate these many individual steps. The functionality of load.ts, but in a less confusing packaging. It might possibly be worth to move the whole of load.ts here to move this complexity out of Introspection CI if that makes sense.