Last active
May 1, 2020 02:46
-
-
Save ziadoz/7326872 to your computer and use it in GitHub Desktop.
Laravel Eloquent/Capsule Silex Service Provicer
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| $app = new Silex\Application; | |
| $app->register(new CapsuleServiceProvider, array( | |
| // DB Connection: Multiple. | |
| 'capsule.connections' => array( | |
| 'default' => array( | |
| 'driver' => 'mysql', | |
| 'host' => 'localhost', | |
| 'database' => 'dname1', | |
| 'username' => 'root', | |
| 'password' => '', | |
| 'charset' => 'utf8', | |
| 'collation' => 'utf8_unicode_ci', | |
| 'prefix' => '', | |
| 'logging' => false, // Toggle query logging on this connection. | |
| ), | |
| 'other' => array( | |
| 'driver' => 'mysql', | |
| 'host' => 'localhost', | |
| 'database' => 'dbname2', | |
| 'username' => 'root', | |
| 'password' => '', | |
| 'charset' => 'utf8', | |
| 'collation' => 'utf8_unicode_ci', | |
| 'prefix' => '', | |
| 'logging' => true, // Toggle query logging on this connection. | |
| ), | |
| ), | |
| /* | |
| // DB Connection: Single. | |
| 'capsule.connection' => array( | |
| 'driver' => 'mysql', | |
| 'host' => 'localhost', | |
| 'database' => 'dbname', | |
| 'username' => 'root', | |
| 'password' => '', | |
| 'charset' => 'utf8', | |
| 'collation' => 'utf8_unicode_ci', | |
| 'prefix' => '', | |
| 'logging' => true, // Toggle query logging on this connection. | |
| ), | |
| */ | |
| // Cache. | |
| 'capsule.cache' => array( | |
| 'driver' => 'apc', | |
| 'prefix' => 'laravel', | |
| ), | |
| /* | |
| // Cache: Available Options. | |
| 'capsule.cache' => array( | |
| 'driver' => 'file', | |
| 'path' => '/path/to/cache', | |
| 'connection' => null, | |
| 'table' => 'cache', | |
| 'memcached' => array( | |
| array( | |
| 'host' => '127.0.0.1', | |
| 'port' => 11211, | |
| 'weight' => 100 | |
| ), | |
| ), | |
| 'prefix' => 'laravel', | |
| ), | |
| */ | |
| /* | |
| Other Options: | |
| 'capsule.global' => true, // Enable global access to Capsule query builder. | |
| 'capsule.eloquent' => true, // Automatically boot Eloquent ORM. | |
| */ | |
| )); | |
| $app['capsule']; // Establish database connection manually (otherwise this occurs upon $app->run()). | |
| // Create an Eloquent Model. | |
| class Book extends Illuminate\Database\Eloquent\Model | |
| { | |
| protected $table = 'books'; | |
| } | |
| // Work with the Eloquent Model. | |
| $book = new Book; | |
| $book->title = '61 Hours'; | |
| $book->author = 'Lee Child'; | |
| $book->save(); | |
| $book = Book::find(1); | |
| print_r($book); | |
| // Use the Capsule query builder globally. | |
| use Illuminate\Database\Capsule\Manager as Capsule; | |
| $book = Capsule::table('books')->where('id', 1)->get(); | |
| print_r($book); | |
| $app->run(); // Database connection established automatically upon Silex run. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| use Silex\Application; | |
| use Silex\ServiceProviderInterface; | |
| use Illuminate\Database\Capsule\Manager as Capsule; | |
| use Illuminate\Events\Dispatcher; | |
| use Illuminate\Container\Container; | |
| use Illuminate\Cache\CacheManager; | |
| class CapsuleServiceProvider implements ServiceProviderInterface | |
| { | |
| /** | |
| * Register the Capsule service. | |
| * See: http://stackoverflow.com/questions/17105829/using-eloquent-orm-from-laravel-4-outside-of-laravel | |
| * | |
| * @param Silex\Application $app | |
| **/ | |
| public function register(Application $app) | |
| { | |
| $app['capsule.connection_defaults'] = array( | |
| 'driver' => 'mysql', | |
| 'host' => 'localhost', | |
| 'database' => null, | |
| 'username' => 'root', | |
| 'password' => null, | |
| 'charset' => 'utf8', | |
| 'collation' => 'utf8_unicode_ci', | |
| 'prefix' => null, | |
| 'logging' => false, | |
| ); | |
| $app['capsule.global'] = true; | |
| $app['capsule.eloquent'] = true; | |
| $app['capsule.container'] = $app->share(function() { | |
| return new Container; | |
| }); | |
| $app['capsule.dispatcher'] = $app->share(function() use($app) { | |
| return new Dispatcher($app['capsule.container']); | |
| }); | |
| if (class_exists('Illuminate\Cache\CacheManager')) { | |
| $app['capsule.cache_manager'] = $app->share(function() use($app) { | |
| return new CacheManager($app['capsule.container']); | |
| }); | |
| } | |
| $app['capsule'] = $app->share(function($app) { | |
| $capsule = new Capsule($app['capsule.container']); | |
| $capsule->setEventDispatcher($app['capsule.dispatcher']); | |
| if (isset($app['capsule.cache_manager']) && isset($app['capsule.cache'])) { | |
| $capsule->setCacheManager($app['capsule.cache_manager']); | |
| foreach ($app['capsule.cache'] as $key => $value) { | |
| $app['capsule.container']->offsetGet('config')->offsetSet('cache.' . $key, $value); | |
| } | |
| } | |
| if ($app['capsule.global']) { | |
| $capsule->setAsGlobal(); | |
| } | |
| if ($app['capsule.eloquent']) { | |
| $capsule->bootEloquent(); | |
| } | |
| if (! isset($app['capsule.connections'])) { | |
| $app['capsule.connections'] = array( | |
| 'default' => (isset($app['capsule.connection']) ? $app['capsule.connection'] : array()), | |
| ); | |
| } | |
| foreach ($app['capsule.connections'] as $connection => $options) { | |
| $options = array_replace($app['capsule.connection_defaults'], $options); | |
| $logging = $options['logging']; | |
| unset($options['logging']); | |
| $capsule->addConnection($options, $connection); | |
| if ($logging) { | |
| $capsule->connection($connection)->enableQueryLog(); | |
| } else { | |
| $capsule->connection($connection)->disableQueryLog(); | |
| } | |
| } | |
| return $capsule; | |
| }); | |
| } | |
| /** | |
| * Boot the Capsule service. | |
| * | |
| * @param Silex\Application $app; | |
| **/ | |
| public function boot(Application $app) | |
| { | |
| if ($app['capsule.eloquent']) { | |
| $app->before(function() use($app) { | |
| $app['capsule']; | |
| }, Application::EARLY_EVENT); | |
| } | |
| } | |
| } |
Author
Thank you very much, this is very insightful!
Author
I've added back $app->share() so that things work correctly, as the latest version of Silex isn't using Pimple 3.0 yet.
Author
This project now has a permanent home on Github: https://github.com/ziadoz/silex-capsule
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I've updated the service provider so it now works correctly with the latest version of Pimple by removing all references to
$app->share(). I've also added a new parameter calledloggingthat allows per-connection control of query logging. Finally, I've updated theapp.phpscript with some better examples.