thedevsaddam/laravel-schema

Display the connected database information in console.

Laravel Schema

This package will help to display database schema information from terminal., _(*1)

Installation

Via Composer, _(*2)

``` bash $ composer require thedevsaddam/laravel-schema, <sub>(*3)</sub>

Install manually (add the line to composer.json file)
``` bash
"thedevsaddam/laravel-schema": "^2.0"

Then open your terminal and hit the command, <sub>(*4)</sub>

composer update

Add the following line to config/app.php file's providers array, <sub>(*5)</sub>

Thedevsaddam\LaravelSchema\LaravelSchemaServiceProvider::class,

For lumen open bootstrap/app.php and add the line below, <sub>(*6)</sub>

$app->register(Thedevsaddam\LaravelSchema\LaravelSchemaServiceProvider::class);

Available commands / Features

1. php artisan schema:help Display the available commands and usages.
2. php artisan schema:simple Display overall tables with total rows count.
3. php artisan schema:list Display all the available tables. schema information in list (_please see details below_).
4. php artisan schema:show Display all the available tables schema information in tabular form (_please see details below_).
5. php artisan schema:table --t=yourTableName or --t=Namespace\\Model Display a table's paginated data (_please see details below_).
6. php artisan schema:query --r="wirte your raw sql query in double quote" Perform a sql query.
7. php artisan schema:monitor Display database server status.

Usage in details

Show Schema information in tabular form, <sub>(*7)</sub>

 php artisan schema:show

Example output: Schema information in tabular form, <sub>(*8)</sub>

, <sub>(*9)</sub>

If you want to see a specific table then pass table name or Namespace\\Model, <sub>(*10)</sub>

 php artisan schema:show --t=tableName or --t=Namespace\\Model

, <sub>(*11)</sub>

Note: Same condition will be applied for tables list view, <sub>(*12)</sub>

Show Schema information in List, <sub>(*13)</sub>

 php artisan schema:list

Example output: Schema information in list, <sub>(*14)</sub>

, <sub>(*15)</sub>

Avaliable Options in show and list:, <sub>(*16)</sub>

• --t=tableName or -t tableName to provide table name or Namespace\Model
• --c=connectionName or -c connectionName to provide connection name

Show Table names and total rows, <sub>(*17)</sub>

 php artisan schema:simple

Example output: Tables name with rows count, <sub>(*18)</sub>

, <sub>(*19)</sub>

Note: You may pass --c=connectionName or -c connectionName to display a specific connection schema info, <sub>(*20)</sub>

Show table definition, <sub>(*21)</sub>

 php artisan schema:table --t=tableName or --t=Namespace\\Model

Example output: Table definition with default page and limit, <sub>(*22)</sub>

, <sub>(*23)</sub>

Avaliable Options in table:, <sub>(*24)</sub>

• --t=tableName or -t tableName to provide table name or Namespace\\Model (e.g: --t=App\\User or --t=users).
• --p=pageNumber or -p PageNumber to provide current page which you want to see
• --o=orderBy or -o orderBy to provide orderBy clause against a column (e.g: --o=id:desc or --o=id:asc [default asc]).
• --l=rowsLimitPerPage or -l rowsLimitPerPage to provide number of rows you want to display (e.g: --l=20).
• --c=connectionName or -c connectionName to provide connection name
• --w=widthOfTableCell or -w widthOfTableCell to provide character length of cell to show in tables (numeric [default=10]).
• --s=columnName to provide the column to display, you can provide comma (,) separated names to display (e.g: --s=name or --s=id,name).

php artisan schema:table --t=countries --p=4 --o=id:desc --l=25

Perform raw sql query, <sub>(*25)</sub>

 php artisan schema:query --r="your sql query"

Example output: Query result will be dumped in console, <sub>(*26)</sub>

, <sub>(*27)</sub>

Avaliable Options in query:, <sub>(*28)</sub>

• --r=yourRawQuery or -r yourRawQuery to provide your raw sql query (e.g: --r="select * from someTable limit 20").
• --c=connectionName or -c connectionName to provide connection name (e.g: --c=mysql or -c sqlite)

Monitor database server, <sub>(*29)</sub>

 php artisan schema:monitor

Example output: Showing the database status, <sub>(*30)</sub>

, <sub>(*31)</sub>

You can pass --i=integerNumber as refresh time interval and --c=ConnectionName as well, <sub>(*32)</sub>

 php artisan schema:monitor --i=3 --c=secondaryDatabase

License

The laravel-schema is a open-source software licensed under the MIT License., <sub>(*33)</sub>

Thank you :), <sub>(*34)</sub>