Commands

Masonite ORM comes with several terminal commands you can run to speed up your development. Here are a list of commands and their descriptions

Below are examples to use Masonite ORM standalone but if you are using Masonite ORM with Masonite then you can replace the calls to masonite-orm with your applications python craft file.

For example you would replace the call for:

$ masonite-orm model User

with

$ python craft model User

Migrations

Migration commands are used to create migration files, roll them back and refresh your database

Creating

You can create migration files easily. Migration files will create a class with an up method and a down method. You should perform your schema logic in the up method and then reverse what you did in the down method.

$ masonite-orm migration create_users_table
ArgumentDescriptionExample

name_of_migration

The name of the migration file to create

create_users_table

OptionsDescriptionExample

--create {name}

Makes a migration file for creating a new table

--create users

--table {name}

Makes a migration file for altering an existing table

--table users

--directory=databases/migrations

Specifies where the migration directory is

--directory app/databases/migrations

Migrating

Migrating will run each unmigrated migration's up method. Each group of migrations that are ran will create a batch number and store information in the migrations table. The batch number will allow groups of migrations to be rolled back if needed.

$ masonite-orm migrate
OptionsDescriptionExample

--migration {name}

Specify a specific migration to rollback. This will default to rolling back the previous batch of migrations.

--migration create_users_table

--connection {name}

The name of the connection to use to rollback the migrations

--connection staging

--show

If passed this command will output the SQL that will run to modify the schema and will not actually run the SQL.

--show

--force

If the APP_ENV environment variable is set to production then a prompt will ask you if you really want to migrate as a safety check. Using this flag will ignore the prompt and migrate anyway

--force

--directory=databases/migrations

Specifies where the migration directory is

--directory app/databases/migrations

Rollback

You can rollback your migration files as well. This would run your migration files that are already migrated but in reverse order. This will run the down method on each migration file in reverse order to "undo" the migration changes that were previously ran.

When a group of migrations are migrated, that group will create a batch number. The rollback command will only rollback the last batch, or the migrations that were ran in the last group of migrations that you ran.

$ masonite-orm migrate:rollback
OptionsDescriptionExample

--migration {name}

Specify a specific migration to rollback. This will default to rolling back the previous batch of migrations.

--migration create_users_table

--connection {name}

The name of the connection to use to rollback the migrations

--connection staging

--show

If passed this command will output the SQL that will run to modify the schema and will not actually run the SQL.

--show

--directory=databases/migrations

Specifies where the migration directory is

--directory app/databases/migrations

Resetting

While the rollback method will rollback the previous batch of migrations, the reset command will rollback all migrations.

$ masonite-orm migrate:reset
OptionsDescriptionExample

--migration {name}

Specify a specific migration to rollback. This will default to rolling back the previous batch of migrations.

--migration create_users_table

--connection {name}

The name of the connection to use to rollback the migrations

--connection staging

--directory=databases/migrations

Specifies where the migration directory is

--directory app/databases/migrations

Refreshing

Refreshing migrations is a simple way to redo all of your migrations. First it will rollback all migrations and then automatically migrate all the migrations again.

$ masonite-orm migrate:refresh
OptionsDescriptionExample

--migration {name}

Specify a specific migration to refresh. This will default to refreshing everything.

--migration create_users_table

--connection {name}

The name of the connection to use to refresh the migrations

--connection staging

--seed

Whether the seed:run command should be ran after the database schema is refreshed

--seed

--directory=databases/migrations

Specifies where the migration directory is

--directory app/databases/migrations

--seed-directory=databases/seeds

Specifies where the seed directory is

--seed-directory=databases/seeds

Getting Migration Status

Sometimes its good to know the status of the migrations so you can know if you have any migrations that need to be ran:

$ masonite-orm migrate:status
OptionsDescriptionExample

--connection {name}

The name of the connection to use to refresh the migrations

--connection staging

--directory=databases/migrations

Specifies where the migration directory is

--directory app/databases/migrations

Creating Models

You can create a new model class quickly. There are also several options you can pass to this command to quickly create migrations and seeds quickly.

$ masonite-orm model {name}
ArgumentDescriptionExample

{name}

The name of the model to create

User

OptionsDescriptionExample

--migration {name}

Specify a specific migration to refresh. This will default to refreshing everything.

--migration create_users_table

--migration

Whether to create a migration file as well

--migration

--seed

Whether the seed:run command should be ran after the database schema is refreshed

--seed

--create

Whether the created migration should have the create option.

--create

--table

Whether the created migration should have the table option.

--table

--pep

Whether the created file should follow pep8

--pep

--directory=app

Which file the model should be created in

--pep

--migrations-directory=databases/migrations

The directory of the migrations. Use this option if using the migration option.

--migrations-directory=app/migrations

--seeders-directory=databases/seeds

The directory of the seeding classes. Use this option if using the seed option.

--seeders-directory=app/seeds

Model Docstrings

One of the downsides of Masonite ORM compared to other models is you don't know what columns and data types you have on your models / tables.

For example, on other ORMs, columns are class attributes on your models so you can always reference your models to know what your tables look like.

To solve this with Masonite ORM you can use the model:docstring command. This command will output an example docstring of all your tables columns and their data types so you can put it on your model for reference. When you make schema changes you can rerun this command to get the updated schema.

Another downside is not being able to see IDE type hints on your models. This is also solved using the --type-hints option you can find below.

$ masonite-orm model:docstring {table}
ArgumentDescriptionExample

{table}

The name of the table you want to create the docstring for

User

OptionsDescriptionExample

--type-hints

Used to also optionally output type hints you can add to your model class that your IDE can use to assist in column type hinting

--type-hints

--connection {name}

The name of the connection to use to use.

--connection staging

Make Observers

You can easily build observer files:

$ masonite-orm observer {name}
ArgumentDescriptionExample

{name}

The name of the observer to create

UserObserver

OptionsDescriptionExample

--model

Name of the model to build the observer for

--model User

--directory=app/observers

The location of the observers directory.

--directory app/databases

Seeding

Seeding is a great way to get test data into your database.

Making a Seed File

To make a seed file is simple:

$ masonite-orm seed {table}
ArgumentDescriptionExample

{table}

The table of the seed to create

users

OptionsDescriptionExample

--directory=databases/seeds

The location of the seeds directory.

--directory app/seeds

Running Seeds

To run the seeds is simple:

$ masonite-orm seed:run
OptionsDescriptionExample

--connection {name}

The name of the connection to use to refresh the migrations

--connection staging

--dry

If the seed should run in dry mode

--dry

--table

The name of the table to seed

--table users

--directory=databases/seeds

The location of the seeds directory.

--directory app/seeds

Last updated