Database creation and import automation

prisma / database-schema-examples

Database Schema Examples we strive to support in Prisma

215 stars 50 forks source link

Database creation and import automation #106

Open janpio opened 4 years ago

janpio commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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.