library db-manager
makes database management a little easier
howlowck/db-manager
makes database management a little easier
- Tuesday, December 17, 2013
- by howlowck
- Repository
- 1 Watchers
- 2 Stars
- 6 Installations
- PHP
- 0 Dependents
- 0 Suggesters
- 2 Forks
- 0 Open issues
- 1 Versions
- 0 % Grown
Notice! This package requires Doctrine/DBAL. As of Laravel 4.1, Laravel is not dependent on Doctrine, but you can still use doctrine, if you include "doctrine/dbal": "2.5.*@dev"
in your composer.json., (*1)
Laravel Package for Database management easier., (*2)
- Lists all the tables in the database
- Lists all the columns of a table
- Get datatype of a column
Install
- Add in your composer.json
"howlowck/db-manager": "dev-master"
- Add in your
app/config/app.php
service provider:
'Howlowck\DbManager\DbManagerServiceProvider'
- (optional) add the facade:
'DbManager' => 'Howlowck\DbManager\Facades\DbManager',
Usage
(If you use the Facade: ), (*3)
-
DbManager::listTables( [optional] $exclude )
-- lists all the tables in your database, $exclude is an array that you want to exclude from the final result (Note: by default, it excludes migrations
table);, (*4)
-
DbManager::listColumns($table, [optional] $exclude)
-- lists all the columns in the given table., (*5)
-
DbManager::getColumnType($table, $columnName)
-- returns the type name of a column, (*6)
(If you choose to only use the service provider), (*7)
App::make('dbmanager')->listTables()
..., (*8)
dev-master
9999999-dev
makes database management a little easier
Sources
Download
The Requires
The Development Requires
database
laravel