README

A command-line toolkit for the Webrium PHP framework. Provides commands for scaffolding files, managing databases, inspecting logs, and installing plugins.

Requirements

PHP 8.1+
Symfony Console 6.4+

Installation

composer require webrium/console

Available Commands

Command	Description
`init`	Create the project directory structure
`make:model`	Generate a model file
`make:controller`	Generate a controller file
`make:route`	Generate a route file
`make:migration`	Generate a database migration file
`make:seeder`	Generate a database seeder file
`migrate`	Run, roll back, or inspect database migrations
`db:seed`	Run database seeders
`call`	Call a method on a controller or model
`db`	Manage databases
`table`	Manage database tables and execute SQL files
`log`	Manage log files
`plugin:install`	Install a plugin
`plugin:update`	Update an installed plugin
`plugin:remove`	Remove an installed plugin
`plugin:list`	List installed plugins
`plugin:info`	Preview a plugin without installing

`init`

Creates all standard Webrium project directories.

php webrium init

`make:model`

Generates a model file in the models directory. Without --table, creates a simple model. With --table, creates a database-connected model.

php webrium make:model <Name> [--table=<table>] [--no-plural] [--force]

Argument / Option	Description
`Name`	Model class name (e.g. `User`)
`--table, -t`	Database table name. If omitted, the name is auto-converted to snake_case and pluralized
`--no-plural`	Prevent automatic pluralization of the table name
`--force, -f`	Overwrite if the file already exists

# DB model with explicit table name
php webrium make:model User --table=users

# DB model — table name auto-generated as "users"
php webrium make:model User -t

# Simple model (no DB)
php webrium make:model UserHelper

# DB model — table stays "status" instead of "statuses"
php webrium make:model Status -t --no-plural

`make:controller`

Generates a controller file in the controllers directory. Automatically appends Controller to the name if not already present.

php webrium make:controller <Name> [--namespace=<Namespace>] [--force]

Argument / Option	Description
`Name`	Controller name (e.g. `User` → `UserController`)
`--namespace`	Custom namespace (default: `App\Controllers`)
`--force, -f`	Overwrite if the file already exists

php webrium make:controller User
php webrium make:controller Admin --namespace="App\Controllers\Admin"

`make:route`

Generates a route file in the routes directory.

php webrium make:route <Name> [--force]

Argument / Option	Description
`Name`	Route file name (e.g. `Api` → `Api.php`)
`--force, -f`	Overwrite if the file already exists

php webrium make:route Api
php webrium make:route Web --force

`make:migration`

Generates a timestamped migration file in database/migrations. Builds on top of webrium/foxdb's migration system (Foxdb\Migrations\Migration, Schema, Blueprint).

php webrium make:migration <name> [--table=<table>] [--force]

Argument / Option	Description
`name`	Migration name, e.g. `create_posts_table` or `add_status_to_posts_table`
`--table, -t`	Explicit table name. If omitted, it's inferred from the migration name
`--force, -f`	Allow generating another migration with the same descriptive name

The generated stub depends on the naming convention used:

create_..._table → uses the create stub, with Schema::create() already wired up and a ready-to-run id() + timestamps() example.
add_..._to_..._table / remove_..._from_..._table → uses the update stub, with an empty Schema::table() block in both up() and down() for you to fill in.
Anything else falls back to the create stub.

In every case the table name is inferred automatically from the migration name, unless --table is given explicitly.

# Create stub — Schema::create('posts', ...) is pre-filled
php webrium make:migration create_posts_table

# Update stub — Schema::table('posts', ...) with an empty body
php webrium make:migration add_status_to_posts_table
php webrium make:migration remove_legacy_id_from_posts_table

# Explicit table name, useful when the migration name doesn't follow either convention
php webrium make:migration setup_indexes --table=posts

# Allow a duplicate descriptive name (creates a second, separately timestamped file)
php webrium make:migration create_posts_table --force

`migrate`

Runs database migrations from database/migrations using webrium/foxdb's Migrator. Tracks applied migrations in a migrations table, batched the same way per run so a whole batch can be rolled back together.

php webrium migrate [<action>] [--step=<n>] [--connection=<name>] [--force]

Action	Description
`run` (default)	Apply all pending migrations
`rollback`	Roll back the last batch (or `--step` migrations)
`reset`	Roll back every migration that has been run
`refresh`	Roll back everything, then run all migrations again
`status`	Show which migrations have run, and in which batch

Option	Description
`--step`	Limit `run`/`rollback` to a specific number of migrations
`--connection, -c`	Run against a named connection instead of the default one
`--seed`	After a successful `run` or `refresh`, also run every seeder in `database/seeders`
`--force, -f`	Skip the confirmation prompt for `reset`/`refresh`

# Apply all pending migrations
php webrium migrate
php webrium migrate run

# Show migration status
php webrium migrate status

# Roll back the most recent batch
php webrium migrate rollback

# Roll back only the last 2 migrations
php webrium migrate rollback --step=2

# Roll back everything, with confirmation
php webrium migrate reset

# Roll back everything, skipping the confirmation prompt
php webrium migrate reset --force

# Roll back and re-run all migrations
php webrium migrate refresh --force

# Run against a non-default connection
php webrium migrate --connection=secondary

# Apply pending migrations, then run all seeders
php webrium migrate --seed

# Reset, re-run, and re-seed in one command
php webrium migrate refresh --seed --force

Each migration runs inside its own database transaction. If a migration fails, migrate stops and reports it — earlier migrations in the same run stay applied, matching the underlying Migrator::run() behavior.

`make:seeder`

Generates a seeder class in database/seeders. Seeders populate the database with default or test data (admin users, lookup tables, categories, etc.) and are built on top of webrium/foxdb's Foxdb\Seeders\Seeder base class.

php webrium make:seeder <Name> [--force]

Argument / Option	Description
`Name`	Seeder class name (e.g. `UsersSeeder`). Auto-converted to PascalCase if given in snake_case
`--force, -f`	Overwrite if the file already exists

php webrium make:seeder UsersSeeder
php webrium make:seeder roles_seeder        # generated as RolesSeeder.php
php webrium make:seeder UsersSeeder --force

The generated stub looks like:

<?php

use Foxdb\DB;
use Foxdb\Seeders\Seeder;

class UsersSeeder extends Seeder
{
    public function run(): void
    {
        // DB::table('users')->insert([
        //     'name'  => 'Admin',
        //     'email' => 'admin@example.com',
        // ]);

        // To call other seeders:
        // $this->call(RolesSeeder::class);
    }
}

Inside a seeder you can chain to other seeders with $this->call(...), which accepts a class name or an array of class names. This is the recommended way to build a master seeder that orchestrates the others.

`db:seed`

Runs database seeders from database/seeders using webrium/foxdb's SeederRunner. Unlike migrations, seeders are not tracked — every invocation runs them fresh, so they should be written to be idempotent if you intend to run them more than once.

php webrium db:seed [<class>] [--connection=<name>] [--no-transaction] [--force]

Argument / Option	Description
`class`	Optional. Class or file name of a single seeder to run. If omitted, every seeder in `database/seeders` is executed in alphabetical order
`--connection, -c`	Run against a named connection instead of the default one
`--no-transaction`	Do not wrap each seeder in a transaction (use when seeders contain DDL or are intentionally non-atomic)
`--force, -f`	Skip the production confirmation prompt (relevant only when `APP_ENV=production`)

# Run every seeder in database/seeders
php webrium db:seed

# Run a single seeder by file name
php webrium db:seed UsersSeeder

# Run a single seeder by fully qualified class name
php webrium db:seed "App\\Seeders\\UsersSeeder"

# Use a non-default connection
php webrium db:seed --connection=secondary

# Disable the per-seeder transaction
php webrium db:seed --no-transaction

# Run in production without an interactive prompt
APP_ENV=production php webrium db:seed --force

Each seeder runs inside its own transaction by default, so a failure mid-seed rolls back any inserts from that seeder. If a seeder fails, db:seed stops and reports it — seeders that already completed remain applied.

When APP_ENV is set to production (or prod), db:seed asks for confirmation before running. Pass --force to bypass the prompt in automated environments.

`call`

Calls a method on a controller or model class directly from the terminal.

php webrium call <Class@Method> [--params=<JSON>] [--model] [--namespace=<Namespace>]

Argument / Option	Description
`Class@Method`	Class and method name (e.g. `UserController@index`)
`--params, -p`	JSON array of arguments passed to the method (default: `[]`)
`--model, -m`	Target a model instead of a controller
`--namespace`	Custom namespace (default: `App\Controllers` or `App\Models`)

php webrium call UserController@index
php webrium call UserController@find --params='[42]'
php webrium call User@active --model
php webrium call Report@generate --params='["2024-01", true]' --namespace="App\Services"

`db`

Manages databases.

php webrium db <action> [<name>] [--use=<database>] [--force]

Action	Description
`list`	List all databases
`tables`	List tables in a database
`create`	Create a new database
`drop`	Delete a database (prompts for confirmation)

Option	Description
`--use, -u`	Specify a database for the `tables` action
`--force, -f`	Skip confirmation prompt when dropping

php webrium db list
php webrium db tables --use=my_database
php webrium db create my_database
php webrium db drop my_database
php webrium db drop my_database --force

`table`

Inspects and manages individual tables, and can also execute SQL files against a database.

php webrium table <action> <table_name> [--use=<database>] [--force]

Action	Description
`info`	Show table information
`columns`	Show column details (name, type, nullable, key, default, extra)
`drop`	Delete the table (prompts for confirmation)
`truncate`	Remove all rows from the table (prompts for confirmation)
`rename`	Rename an existing table
`copy`	Copy table structure to a new table
`exists`	Check whether a table exists
`count`	Count rows in a table
`run`	Execute a SQL file (`<table_name>` is treated as a file path)

Option	Description
`--use, -u`	Specify a database
`--force, -f`	Skip confirmation prompts for destructive actions

php webrium table info users
php webrium table columns orders --use=shop_db
php webrium table drop sessions
php webrium table drop sessions --force
php webrium table rename old_table new_table
php webrium table copy products products_backup
php webrium table exists users
php webrium table count orders
php webrium table run sql/setup_tables.sql --use=shop_db

`log`

Manages Webrium log files stored in the logs directory.

php webrium log <action> [<name>]

Action	Description
`list`	List all log files
`latest`	Display the most recent log file
`file <name>`	Display a specific log file by name
`clear`	Delete all log files

php webrium log list
php webrium log latest
php webrium log file 2024-01-15.log
php webrium log clear

Plugin System

Webrium Console includes a full plugin system for installing and managing distributable components.

php webrium plugin:install <source> [--force] [--dry-run] [--no-backup]
php webrium plugin:update  <source> [--force] [--no-backup]
php webrium plugin:remove  <name>   [--no-backup] [--keep-files]
php webrium plugin:list
php webrium plugin:info    <source>

The source argument accepts a local .zip file path or an https:// URL:

php webrium plugin:install ./my-plugin.zip
php webrium plugin:install https://example.com/releases/my-plugin.zip
php webrium plugin:install https://github.com/user/repo/releases/download/v1.0.0/plugin.zip

For full documentation on creating and distributing plugins, see the Plugin System Wiki.

License

MIT

webrium / console

Maintainers

Package info

Statistics

Security