public function setUp() { $capsule = new Illuminate\Database\Capsule\Manager(); $capsule->addConnection(['driver' => 'sqlite', 'database' => ':memory:', 'prefix' => '']); $capsule->setAsGlobal(); $capsule->bootEloquent(); }
/** * IlluminateのDB接続設定とブートアップ * @param array $settings 接続設定 */ public static function registerIlluminate(array $settings) { $capsule = new \Illuminate\Database\Capsule\Manager(); $capsule->addConnection($settings); $capsule->setEventDispatcher(new \Illuminate\Events\Dispatcher(new \Illuminate\Container\Container())); $capsule->setAsGlobal(); $capsule->bootEloquent(); }
public function setUp() { $capsule = new Illuminate\Database\Capsule\Manager(); $capsule->addConnection(['driver' => 'sqlite', 'database' => __DIR__ . '/database.sqlite']); $capsule->bootEloquent(); $this->property = \Microsistec\DbParser\Models\Property::first(); }
private function boot() { // Connect to MySQL database $capsule = new \Illuminate\Database\Capsule\Manager(); $capsule->addConnection(array('driver' => 'mysql', 'host' => MYSQL_HOST, 'database' => MYSQL_DATABASE, 'username' => MYSQL_USERNAME, 'password' => MYSQL_PASSWORD, 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '')); $capsule->bootEloquent(); }
private static function loadOrm() { // Eloquent ORM $capsule = new \Illuminate\Database\Capsule\Manager(); $capsule->addConnection(require '../config/database.php'); $capsule->bootEloquent(); }
/** * Run Method. * * Write your database seeder using this method. * * More information on writing seeders is available here: * http://docs.phinx.org/en/latest/seeding.html */ public function run() { $capsule = new \Illuminate\Database\Capsule\Manager(); $capsule->addConnection(['driver' => 'sqlite', 'database' => __DIR__ . '/../../data/database.db']); $capsule->bootEloquent(); \Cartalyst\Sentinel\Native\Facades\Sentinel::registerAndActivate(['email' => '*****@*****.**', 'password' => 'password']); }
/** * Init Core * * @uses Stativo\Helpers\Language * @uses Stativo\Helpers\File * @return \Core Returns instance of Stativo\Core\Core */ public function init() { // Load env files $dotenv = new \Dotenv\Dotenv(DOCROOT, '.env'); $dotenv->overload(); // Load config (after \Dotenv) $config = self::config('app'); // Init DB if is set true if ($config->get('database')['enabled']) { $capsule = new \Illuminate\Database\Capsule\Manager(); foreach ($config->get('database')['connections'] as $name => $conn) { $capsule->addConnection($conn, $name); } $capsule->setAsGlobal(); $capsule->bootEloquent(); } // Init translation if set true if ($config->get('language')['enabled']) { \Stativo\Helpers\Language::instance(); } if (class_exists(\Stativo\Helpers\File::class)) { \Stativo\Helpers\File::instance(); } return $this; }
public function _initEloquentORM() { Loader::import("vendor/autoload.php"); $capsule = new \Illuminate\Database\Capsule\Manager(); $capsule->addConnection($this->_config->orm->eloquent->toArray()); $capsule->bootEloquent(); $capsule->setAsGlobal(); }
function setupDB() { $config = (include __DIR__ . '/../src/config.php'); $capsule = new Illuminate\Database\Capsule\Manager(); $connection = ['driver' => 'sqlite', 'database' => realpath(__DIR__ . '/' . $config['path'] . '/' . $config['db'])]; $capsule->addConnection($connection, 'calibre'); $capsule->setAsGlobal(); $capsule->bootEloquent(); }
public function setup() { $db = DbConfig::get_params(); $capsule = new Illuminate\Database\Capsule\Manager(); $capsule->addConnection(['driver' => 'mysql', 'host' => $db['host'], 'database' => $db['dbname'], 'username' => $db['username'], 'password' => $db['password'], 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '']); $capsule->setEventDispatcher(new Illuminate\Events\Dispatcher(new Illuminate\Container\Container())); $capsule->setAsGlobal(); $capsule->bootEloquent(); }
function db() { $capsule = new Illuminate\Database\Capsule\Manager(); $capsule->addConnection(['driver' => 'mysql', 'host' => 'localhost', 'database' => 'Library', 'username' => 'root', 'password' => 'hornline', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '']); // Make this Capsule instance available globally via static methods $capsule->setAsGlobal(); // Setup the Eloquent ORM $capsule->bootEloquent(); }
public function getSlimInstance() { $capsule = new Illuminate\Database\Capsule\Manager(); $capsule->addConnection(['driver' => 'sqlite', 'database' => ':memory:', 'prefix' => '']); $capsule->setEventDispatcher(new Illuminate\Events\Dispatcher()); $capsule->setAsGlobal(); $capsule->bootEloquent(); require __DIR__ . '/../app/schema.php'; $app = new \Slim\Slim(['debug' => false, 'mode' => 'testing', 'templates.path' => __DIR__ . '/../views']); $app->setName('default'); require __DIR__ . '/../app/app.php'; return $app; }
public function register(\Exedra\Application $app) { $app->wizard->add(\Laraquent\Support\Exedra\Wizard::class); if (!$app->config->has('db')) { throw new \Exception('db. configuration is required.'); } $config = $app->config; $capsule = new \Illuminate\Database\Capsule\Manager(); $capsule->addConnection(array('driver' => $config->get('db.driver', 'mysql'), 'host' => $config->get('db.host', 'localhost'), 'database' => $config->get('db.name'), 'username' => $config->get('db.user'), 'password' => $config->get('db.pass'), 'charset' => $config->get('db.charset', 'utf8'), 'collation' => $config->get('db.collation', 'utf8_unicode_ci'))); $capsule->setAsGlobal(); $capsule->bootEloquent(); // register eloquent $app->eloquent = $capsule; }
public function __construct() { parent::__construct(['mode' => 'production']); // setup database connection $capsule = new \Illuminate\Database\Capsule\Manager(); $capsule->addConnection(array('driver' => 'mysql', 'host' => 'localhost', 'database' => 'resapi', 'username' => 'root', 'password' => '', 'charset' => 'utf8', 'collation' => 'utf8_general_ci', 'prefix' => '')); $capsule->setAsGlobal(); $capsule->bootEloquent(); // add middleware $this->add(new MiddlewareMediatype()); $this->add(new MiddlewareAuthenticator()); // add error message $this->notFound(function () { echo json_encode(['errmsg' => 'Not Found Request']); }); Routing::setupRouting($this); }
/** * */ public function testIlluminateConnection() { Illuminate\Database\Capsule\Manager::schema()->create('test', function (Blueprint $table) { $table->increments('id'); $table->string('email')->unique(); $table->timestamps(); }); \Illuminate\Database\Capsule\Manager::table('test')->insert(['email' => '*****@*****.**']); $test = \Illuminate\Database\Capsule\Manager::table('test')->first(); $this->assertNotEmpty($test); \Illuminate\Database\Capsule\Manager::schema()->drop('test'); }
public static function setUpBeforeClass() { $connection = []; switch (getenv('DB_ADAPTER')) { case 'sqlite': $connection['driver'] = 'sqlite'; $connection['database'] = getenv('DB_NAME'); break; case 'mysql': $connection['driver'] = 'mysql'; $connection['host'] = getenv('DB_HOST'); $connection['port'] = getenv('DB_PORT'); $connection['database'] = getenv('DB_NAME'); $connection['username'] = getenv('DB_USER'); $connection['password'] = getenv('DB_PASS'); $connection['charset'] = getenv('DB_CHARSET'); $connection['collation'] = getenv('DB_COLLATION'); break; } $capsule = new \Illuminate\Database\Capsule\Manager(); $capsule->addConnection($connection); $capsule->setAsGlobal(); $capsule->bootEloquent(); }
<?php Illuminate\Database\Capsule\Manager::schema($connectName)->create('profiles', function ($table) { $table->increments('id'); $table->integer('user_id')->unsigned()->unique(); $table->string('nick')->nullable(); $table->tinyInteger('sex')->default(0); $table->date('birthday')->nullable(); $table->string('city')->nullable(); $table->string('hobby')->nullable(); $table->integer('rating')->default(0); $table->string('phone')->nullable(); $table->string('url')->nullable(); $table->text('custom_data')->nullable(); $table->timestamps(); });
<?php require __DIR__ . '/../vendor/autoload.php'; $capsule = new Illuminate\Database\Capsule\Manager(); $capsule->addConnection(require __DIR__ . '/config/database.php'); $capsule->setEventDispatcher(new Illuminate\Events\Dispatcher(new Illuminate\Container\Container())); $capsule->bootEloquent(); $capsule->setAsGlobal(); $__autoload_paths = array('models', 'migrators', 'seeders'); foreach ($__autoload_paths as $path) { foreach (glob(__DIR__ . "/{$path}/*.php") as $dep) { require_once $dep; } } require __DIR__ . '/suite/CommentableTestCase.php';
<?php ini_set('error_reporting', E_ALL); ini_set('display_errors', '1'); ini_set('display_startup_errors', '1'); // Composer autoloader require __DIR__ . '/../vendor/autoload.php'; // Boot Aspect Mock $kernel = \AspectMock\Kernel::getInstance(); $src = __DIR__ . '/../src'; $eloquent = __DIR__ . '/../vendor/illuminate/database/Illuminate/Database/Eloquent'; $kernel->init(['debug' => true, 'cacheDir' => '/tmp/flexible', 'includePaths' => [$src, $eloquent]]); // Boot the Eloquent component $capsule = new \Illuminate\Database\Capsule\Manager(); $capsule->addConnection(array('driver' => 'sqlite', 'database' => __DIR__ . '/database/testing.sqlite', 'prefix' => '')); $capsule->bootEloquent();
<?php $capsule = new \Illuminate\Database\Capsule\Manager(); $capsule->addConnection($app->getContainer()->get('settings')["database"]); $capsule->setAsGlobal(); $capsule->bootEloquent();
<?php Illuminate\Database\Capsule\Manager::schema($connectName)->create('user_providers', function ($table) { $table->increments('id'); $table->string('user_id'); $table->string('provider_name', 255); $table->string('provider_id', 255); $table->timestamps(); });
<?php // DIC configuration $container = $app->getContainer(); // view renderer $container['renderer'] = function ($c) { $settings = $c->get('settings')['renderer']; return new Slim\Views\PhpRenderer($settings['template_path']); }; // monolog $container['logger'] = function ($c) { $settings = $c->get('settings')['logger']; $logger = new Monolog\Logger($settings['name']); $logger->pushProcessor(new Monolog\Processor\UidProcessor()); $logger->pushHandler(new Monolog\Handler\StreamHandler($settings['path'], Monolog\Logger::DEBUG)); return $logger; }; // database $container['db'] = function ($c) { $settings = $c->get('database')['mysql']; $db = new \Illuminate\Database\Capsule\Manager(); $db->addConnection($settings); $db->setAsGlobal(); $db->bootEloquent(); return $db; };
<?php Illuminate\Database\Capsule\Manager::schema($connectName)->create('feedback_posts', function ($table) { $table->increments('id'); $table->string('name', 100); $table->string('email'); $table->text('message'); $table->boolean('readed')->default(false); $table->boolean('closed')->default(false); $table->string('hash', 128); $table->integer('user_id')->unsigned()->default(0); $table->string('ip', 64)->default('127.0.0.1'); // ipv6 & ipv4 $table->timestamps(); });
<?php Illuminate\Database\Capsule\Manager::schema($connectName)->create('roles', function ($table) { $table->increments('id'); $table->string('name'); $table->text('permissions'); $table->timestamps(); }); $now = date('Y-m-d H:i:s', time()); Illuminate\Database\Capsule\Manager::connection($connectName)->table('roles')->insert([['name' => 'OnlyRead', 'permissions' => '', 'created_at' => $now, 'updated_at' => $now], ['name' => 'User', 'permissions' => 'global/write;global/file', 'created_at' => $now, 'updated_at' => $now], ['name' => 'Moderator', 'permissions' => 'global/write;global/modify;global/file', 'created_at' => $now, 'updated_at' => $now], ['name' => 'Admin', 'permissions' => 'global/all', 'created_at' => $now, 'updated_at' => $now]]);
/** * Compile Eloquent Queries * * @return string */ protected function _compile_eloquent() { $output = array(); // hack to make eloquent not throw error for now $this->CI->load->model('eloquent/assets/action'); if (!class_exists('Illuminate\\Database\\Capsule\\Manager')) { $output = 'Illuminate\\Database has not been loaded.'; } else { // Load the text helper so we can highlight the SQL $this->CI->load->helper('text'); // Key words we want bolded $highlight = array('SELECT', 'DISTINCT', 'FROM', 'WHERE', 'AND', 'LEFT JOIN', 'ORDER BY', 'GROUP BY', 'LIMIT', 'INSERT', 'INTO', 'VALUES', 'UPDATE', 'OR ', 'HAVING', 'OFFSET', 'NOT IN', 'IN', 'LIKE', 'NOT LIKE', 'COUNT', 'MAX', 'MIN', 'ON', 'AS', 'AVG', 'SUM', '(', ')'); $total = 0; // total query time $queries = Illuminate\Database\Capsule\Manager::getQueryLog(); foreach ($queries as $q) { $time = number_format($q['time'] / 1000, 4); $total += $q['time'] / 1000; $query = interpolateQuery($q['query'], $q['bindings']); foreach ($highlight as $bold) { $query = str_ireplace($bold, '<b>' . $bold . '</b>', $query); } $output[][$time] = $query; } if (count($output) == 0) { $output = $this->CI->lang->line('profiler_no_queries'); } else { $total = number_format($total, 4); $output[][$total] = 'Total Query Execution Time'; } } return $output; }
<?php $container = $app->getContainer(); // Database $container['capsule'] = function ($c) { $capsule = new Illuminate\Database\Capsule\Manager(); $capsule->addConnection(['driver' => 'mysql', 'host' => getenv('DB_HOST'), 'database' => getenv('DB_DATABASE'), 'username' => getenv('DB_USERNAME'), 'password' => getenv('DB_PASSWORD'), 'charset' => 'utf8', 'collation' => 'utf8_general_ci', 'prefix' => '']); return $capsule; }; // Twig $container['view'] = function ($c) { $view = new \Slim\Views\Twig('./resources/views'); $view->addExtension(new \Slim\Views\TwigExtension($c['router'], $c['request']->getUri())); return $view; };
<?php $config = []; $config['eloquentModelTemplate'] = function ($container) { return file_get_contents(realpath(__DIR__ . '/../templates') . '/ModelTemplate.txt'); }; $config['SlimApi\\Model\\ModelInterface'] = function ($container) { return new \SlimApi\Eloquent\Model\EloquentModelService($container->get('eloquentModelTemplate'), $container->get('namespace')); }; $config['database.configForEloquent'] = function ($container) { $standardisedConfig = $container['database.config']; $eloquentConfig = ['driver' => $standardisedConfig['adapter'], 'host' => $standardisedConfig['host'], 'database' => $standardisedConfig['name'], 'username' => $standardisedConfig['user'], 'password' => $standardisedConfig['pass'], 'charset' => $standardisedConfig['charset'], 'collation' => 'utf8_unicode_ci', 'prefix' => '']; return $eloquentConfig; }; $config['database.connectEloquent'] = function ($container) { $config = $container['database.configForEloquent']; $manager = new \Illuminate\Database\Capsule\Manager(); $manager->addConnection($config); // Set the event dispatcher used by Eloquent models... (optional) $manager->setEventDispatcher(new \Illuminate\Events\Dispatcher(new \Illuminate\Container\Container())); // Make this Capsule instance available globally via static methods... (optional) $manager->setAsGlobal(); // Setup the Eloquent ORM... (optional; unless you've used setEventDispatcher()) $manager->bootEloquent(); return $manager; }; $config['SlimApi\\Eloquent\\Init'] = function ($container) { $container['database.connectEloquent']; }; return $config;
protected function boot() { $this->database->setAsGlobal(); $this->database->bootEloquent(); }
$conn = PdoLite::dbConnect($settings['dsn'],$settings['username'],$settings['password']); */ PdoLite::$cfg = $settings = $c->get('settings')['pdolite']; $conn = PdoLite::dbConnect($settings['dsn'], $settings['username'], $settings['password']); return $conn; }; $container['pdo'] = function ($c) { $settings = $c->get('settings')['pdo']; print_r($settings); $conn = new PDO($settings['dsn'], $settings['username'], $settings['password']); echo "<br />Connect Info: "; print_r($conn); return $conn; }; $container['capsule'] = function ($c) { $capsule = new Illuminate\Database\Capsule\Manager(); $capsule->addConnection($c['settings']['db']); return $capsule; }; // View $container['view'] = function ($c) { $view = new \Slim\Views\Twig($c['settings']['view']['template_path'], $c['settings']['view']['twig']); // Add extensions // echo "uri: ".$c['request']->getUri(); $view->addExtension(new Slim\Views\TwigExtension($c['router'], $c['request']->getUri())); $view->addExtension(new Twig_Extension_Debug()); // $view->addExtension(new MVC4Slim\TwigExtension($c['flash'])); $view->addExtension(new TwigExtension($c['flash'])); return $view; }; // CSRF guard
<?php /** * Access - Laravel 4 RBAC * * @author Andreas Lutro <*****@*****.**> * @license http://opensource.org/licenses/MIT * @package anlutro/access */ require_once __DIR__ . '/../vendor/autoload.php'; require_once __DIR__ . '/TestCase.php'; foreach (glob(__DIR__ . '/../src/migrations/*.php') as $filename) { require_once $filename; } foreach (glob(__DIR__ . '/migrations/*.php') as $filename) { require_once $filename; } foreach (glob(__DIR__ . '/models/*.php') as $filename) { require_once $filename; } $capsule = new Illuminate\Database\Capsule\Manager(); $capsule->addConnection(['driver' => 'sqlite', 'database' => ':memory:', 'prefix' => '']); $capsule->setAsGlobal(); $capsule->bootEloquent();