Laravel Eloquent/Capsule Silex Service Provicer

app.php

<?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.

CapsuleServiceProvider.php

<?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);
        }
    }
}

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 called logging that allows per-connection control of query logging. Finally, I've updated the app.php script with some better examples.

Thank you very much, this is very insightful!

I've added back $app->share() so that things work correctly, as the latest version of Silex isn't using Pimple 3.0 yet.

This project now has a permanent home on Github: https://github.com/ziadoz/silex-capsule