@amplication/plugin-db-mysql

1.1.7 • Public • Published

@amplication/plugin-db-mysql

NPM Downloads

Use a MySQL database in the service generated by Amplication.

Purpose

This plugin adds the required code to use MySQL database in the service generated by Amplication. It updateds the following parts:

  • Updates the datasource on the schema.prisma file:
    • For versions older than 1.3.3 the datesource name is based on the database type
      • mySQL - the datasource name is mysql
    • From version 1.3.3 the datasource name is db, no matter what is the database type
  • From version 1.3.3 as the datasouce name is db, all the custom attributes that use the @{datasource.name}.{nameOfTheAttribute} are replaced with @db.{nameOfTheAttribute}
  • Adds the requires services and varables to docker-compose.yml
  • Add the db service to the docker-compose.dev.yml
  • Add the requires environment variables to .env

Configuration

The plugin uses the parameters configured on the database tab on the service settings page

image

Usage

This plugin integrates with the all default tasks and scripts used by the generated service:

    "seed": "ts-node scripts/seed.ts",
    "db:migrate-save": "prisma migrate dev",
    "db:migrate-up": "prisma migrate deploy",
    "db:clean": "ts-node scripts/clean.ts",
    "db:init": "run-s \"db:migrate-save -- --name 'initial version'\" db:migrate-up seed",
    "prisma:generate": "prisma generate",
    "docker:db": "docker-compose -f docker-compose.db.yml up -d",
    "docker:build": "docker build .",
    "compose:up": "docker-compose up -d",
    "compose:down": "docker-compose down --volumes"

Readme

Keywords

none

Package Sidebar

Install

npm i @amplication/plugin-db-mysql

Weekly Downloads

91,596

Version

1.1.7

License

Apache-2.0

Unpacked Size

163 kB

Total Files

13

Last publish

Collaborators

  • amitbarletz
  • amplication-bot
  • barshimi
  • levivannoort
  • morhag
  • mulygottlieb
  • overbit
  • yuvalhazaz