flore 0.0.2

A great option for creating SQL tables in yaml format.

It's a script to transform yaml file to SQL-code.

We worked as a migration to the database. You can create your migration through of migration.yaml file inside migrations folder and run the script for migrate.

Install

You can install the script through of pip command:

pip intall flore

Usage

Run the command flore init to create migration folder with the follow files:

• migration.yaml
• seed.yaml
• config.yaml

Configuration

For configuration the migration, open config.yaml file and set information:

dialect: 'pg'
host: 'localhost'
port: 5432
username: 'postgres'
password: 'docker'
database: 'flore'

dialect is a name of the database service, for example: mysql, pg => postgres. Currently support postgres only. Now, you can set username, password, database, port and host for you database.

Migration

For create migration you set in migration.yaml the following information:

tables:
  users:
    name:
      - varchar:120
      - required
    email:
      - varchar:84
      - required
      - unique
    password:
      - varchar:255
    is_admin:
      - boolean
      - default false
  products:
    price:
      - float

Run with the follow command

flore run

To migrate tables your postgres database.

Screenshot