Download the PHP package ice6/laravel-schema without Composer
On this page you can find all versions of the php package ice6/laravel-schema. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download ice6/laravel-schema
More information about ice6/laravel-schema
Files in ice6/laravel-schema
Package laravel-schema
Short Description Display the connected database information in console.
License MIT
Homepage https://github.com/thedevsaddam/laravel-schema
Informations about the package laravel-schema
Laravel Schema
This package will help to display database schema information from terminal.
Installation
Via Composer
Install manually (add the line to composer.json file)
Then open your terminal and hit the command
Add the following line to config/app.php file's providers array
For lumen open bootstrap/app.php and add the line below
Available commands / Features
php artisan schema:help
Display the available commands and usages.php artisan schema:simple
Display overall tables with total rows count.php artisan schema:list
Display all the available tables. schema information in list (please see details below).php artisan schema:show
Display all the available tables schema information in tabular form (please see details below).php artisan schema:table --t=yourTableName or --t=Namespace\\Model
Display a table's paginated data (please see details below).php artisan schema:query --r="wirte your raw sql query in double quote"
Perform a sql query.php artisan schema:monitor
Display database server status.
Usage in details
Show Schema information in tabular form
Example output: Schema information in tabular form
If you want to see a specific table then pass table name or Namespace\\Model
Note: Same condition will be applied for tables list view
Show Schema information in List
Example output: Schema information in list
Avaliable Options in show and list:
--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
Example output: Tables name with rows count
Note: You may pass --c=connectionName
or -c connectionName
to display a specific connection schema info
Show table definition
Example output: Table definition with default page and limit
Avaliable Options in table:
--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).
Perform raw sql query
Example output: Query result will be dumped in console
Avaliable Options in query:
--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
Example output: Showing the database status
You can pass --i=integerNumber as refresh time interval and --c=ConnectionName as well
License
The laravel-schema is a open-source software licensed under the MIT License.
Thank you :)