/**
* Setup eloquent database
* @param \Illuminate\Database\Capsule\Manager $capsule
* @throws \Lassi\App\Exception\NotFoundException
* @return \Lassi\App\Database
*/
private function _makeEloquent(Capsule $capsule)
{
// Throw exception if minimum requirements not met
if (!getenv('db_driver') || !getenv('db_name')) {
throw new NotFoundException('App configurations not found.');
}
// Get capsule instance
$this->capsule = $capsule;
// Cache db driver
$db_driver = getenv('db_driver');
// Setup connection defaults
$configs = array('driver' => $db_driver, 'database' => getenv('db_name'), 'prefix' => getenv('db_prefix'), 'charset' => getenv('db_charset'), 'collation' => getenv('db_collation'));
// Add extras depending on type of driver/connection
if ($db_driver !== 'sqlite') {
if (getenv('db_host')) {
$configs['host'] = getenv('db_host');
}
if (getenv('db_username')) {
$configs['username'] = getenv('db_username');
}
if (getenv('db_password')) {
$configs['password'] = getenv('db_password');
}
}
// Setup connection
$this->capsule->addConnection($configs);
// Set as global
$this->capsule->setAsGlobal();
// Boot eloquent
$this->capsule->bootEloquent();
return $this;
}
public function init()
{
$this->capsule = new Capsule();
$this->capsule->addConnection(['driver' => 'mysql', 'host' => DB_HOST, 'port' => DB_PORT, 'database' => DB_NAME, 'username' => DB_USER, 'password' => DB_PASSWORD, 'charset' => DB_CHARSET, 'collation' => DB_COLLATION]);
$this->capsule->bootEloquent();
$this->capsule->setAsGlobal();
}
private function __construct()
{
$this->capsule = new Capsule();
$this->capsule->addConnection(['driver' => 'mysql', 'host' => DB_HOST, 'database' => DB_NAME, 'username' => DB_USER, 'password' => DB_PASSWORD, 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '']);
$this->capsule->setEventDispatcher(new Dispatcher(new Container()));
$this->capsule->setAsGlobal();
}
protected function setConnection(array $connection)
{
$this->capsule = new Capsule();
$this->capsule->addConnection($connection);
$this->capsule->setAsGlobal();
$this->capsule->bootEloquent();
}
protected function setUpDatabase()
{
$db = new DB();
$db->addConnection(['driver' => 'sqlite', 'database' => ':memory:'], 'default');
$db->addConnection(['driver' => 'sqlite', 'database' => ':memory:'], 'alt');
$db->bootEloquent();
$db->setAsGlobal();
}
/**
* @return \Illuminate\Database\Capsule\Manager
*/
public function getCapsule()
{
if (!$this->capsule) {
$this->capsule = new Capsule();
$this->capsule->addConnection($this->configuration);
$this->capsule->setAsGlobal();
}
return $this->capsule;
}
protected function createConnection()
{
$this->capsule = new Capsule();
$this->capsule->addConnection(['driver' => 'sqlite', 'database' => __DIR__ . '/db/testing.sqlite', 'prefix' => '']);
$this->capsule->setFetchMode(PDO::FETCH_CLASS);
$this->capsule->setAsGlobal();
$this->capsule->bootEloquent();
$this->capsule->getConnection()->enableQueryLog();
}
/**
* {@inheritdoc}
*/
public function bootstrap($app)
{
$this->capsule = new Manager();
$this->capsule->addConnection(['driver' => $this->driver, 'host' => $this->host, 'database' => $this->database, 'username' => $this->username, 'password' => $this->password, 'charset' => $this->charset, 'collation' => $this->collation, 'prefix' => $this->prefix]);
$this->capsule->setEventDispatcher(new Dispatcher(new Container()));
$this->capsule->setAsGlobal();
$this->capsule->bootEloquent();
$app->set('db', $this->capsule);
}
/**
* set up eloquent for test
*/
public static function setUpBeforeClass()
{
parent::setUpBeforeClass();
self::$manager = new Manager();
// TODO: add dotenv and extract for reuse
self::$manager->addConnection(['driver' => 'mysql', 'host' => 'localhost', 'database' => 'grimm', 'username' => 'homestead', 'password' => 'secret', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => false, 'engine' => null]);
self::$manager->setAsGlobal();
self::$manager->bootEloquent();
}
/**
* @param array $credentials
*/
public function addDbConnection($credentials = [])
{
if (empty($credentials)) {
$bitrixDbCredentials = \Bitrix\Main\Application::getInstance()->getConnection()->getConfiguration();
$credentials = ['driver' => 'mysql', 'database' => $bitrixDbCredentials['database'], 'username' => $bitrixDbCredentials['login'], 'password' => $bitrixDbCredentials['password'], 'host' => $bitrixDbCredentials['host'], 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => false];
}
$this->capsule->addConnection($credentials);
$this->capsule->setAsGlobal();
$this->capsule->bootEloquent();
}
/**
* Database constructor.
*/
public function __construct()
{
$this->capsule = new Manager();
/**
* Add a connection
*/
$this->capsule->addConnection($this->GetDatabaseSettings());
/**
* Globalise it
*/
$this->capsule->setAsGlobal();
}
/**
* Open the database connection with the credentials from application/config/config.php
*/
private function openDatabaseConnection()
{
$capsule = new Capsule();
if (DB_DRIVER == 'sqlite') {
$capsule->addConnection(['driver' => 'sqlite', 'database' => __DIR__ . '/../database/api.sqlite3', 'prefix' => '']);
}
if (DB_DRIVER == 'mysql') {
$capsule->addConnection(['driver' => 'mysql', 'host' => '127.0.0.1', 'port' => '3306', 'database' => DB_NAME, 'username' => DB_USER, 'password' => DB_PASS, 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => false]);
}
$capsule->setAsGlobal();
//make connection available globally
$capsule->bootEloquent();
}
/**
* @return \Illuminate\Database\Capsule\Manager
*/
public static function instance()
{
if (static::$_instance === null) {
$config = Config::get("database");
static::$_instance = new \Illuminate\Database\Capsule\Manager();
if ($config["connections"] && is_array($config["connections"])) {
foreach ($config["connections"] as $key => $cfg) {
static::$_instance->addConnection($cfg, $key);
}
}
static::$_instance->setAsGlobal();
}
return static::$_instance;
}
/**
* Create the connection
*
* @return bool
*/
public function CreateConnection()
{
$information = $this->GetInformation();
if ($information == null) {
return false;
}
try {
$this->database->addConnection($information);
$this->database->setAsGlobal();
} catch (\Exception $error) {
return false;
}
return true;
}
public function __construct()
{
$config = Tempest::get()->config->get('db');
if (!empty($config)) {
$config = array_merge(array('driver' => 'mysql', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci'), $config);
$connection = $this->parseConnectionString(ObjectUtil::getDeepValue($config, 'connection'));
$connection = array_merge($config, $connection);
$this->_capsule = new Manager();
$this->_capsule->addConnection($connection);
$this->_capsule->setAsGlobal();
$this->_capsule->bootEloquent();
} else {
throw new Exception('No database connection details were provided by the application.');
}
}
public function setUp()
{
$this->capsule = new \Illuminate\Database\Capsule\Manager();
$this->capsule->addConnection(['driver' => 'sqlite', 'database' => ':memory:']);
$this->capsule->setAsGlobal();
$this->capsule->bootEloquent();
$ddl = <<<SQL
CREATE TABLE `sessions` (
`id` varchar(255) NOT NULL UNIQUE,
`payload` text NOT NULL,
`last_activity` int(11) NOT NULL
)
SQL;
$this->capsule->getConnection()->getPdo()->exec($ddl);
}
/**
* Init capsule
*/
public function initCapsule()
{
$this->capsule = new Capsule();
switch ($this->configDatabase['driver']) {
case 'mysql':
$configConnection = ['driver' => 'mysql', 'host' => $this->configDatabase['host'], 'database' => $this->configDatabase['database'], 'username' => $this->configDatabase['username'], 'password' => $this->configDatabase['password'], 'charset' => $this->configDatabase['charset'], 'collation' => $this->configDatabase['collation']];
if (isset($this->configDatabase['prefix'])) {
$configConnection['prefix'] = $this->configDatabase['prefix'];
}
$this->capsule->addConnection($configConnection);
break;
}
$this->capsule->setAsGlobal();
$this->capsule->bootEloquent();
}
/**
* Build console entry point
* @param array|null $services
* @throws \Ffcms\Core\Exception\NativeException
*/
public static function init(array $services = null)
{
self::$Properties = new Properties();
self::$Input = new Input();
self::$Output = new Output();
// establish database link
if (Obj::isArray(self::$Properties->get('database')) && (isset($services['Database']) && $services['Database'] === true || $services === null)) {
self::$Database = new Capsule();
self::$Database->addConnection(self::$Properties->get('database'));
// Make this Capsule instance available globally via static methods... (optional)
self::$Database->setAsGlobal();
// Setup the Eloquent ORM... (optional; unless you've used setEventDispatcher())
self::$Database->bootEloquent();
}
}
public function boot()
{
$capsule = new Capsule();
$config = app()->make('config')->get('database.connections');
foreach ($config as $k => $v) {
$capsule->addConnection($v, $k);
}
$default = app()->make('config')->get('database')['default'];
if ($default) {
if (isset($config[$default])) {
$capsule->addConnection($config[$default], 'default');
}
}
$capsule->bootEloquent();
}
/**
* Adds a connection
*/
public function AddConnection()
{
/**
* Lets get our database settings
*/
$settings = Settings::GetDatabaseSettings();
/**
* Then lets start a connection
*/
$this->capsule->addConnection($settings);
/**
* Then lets globalise this connection
*/
$this->capsule->setAsGlobal();
}
/**
* Configure the database
*/
private function configureDatabase()
{
$db = new DB();
$db->addConnection(['driver' => 'sqlite', 'database' => ':memory:', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '']);
$db->bootEloquent();
$db->setAsGlobal();
}
public static function createConn()
{
$capsule = new DB();
$capsule->addConnection(parse_ini_file("./config/config.ini"));
$capsule->setAsGlobal();
$capsule->bootEloquent();
}
public function __construct()
{
$capsule = new Capsule();
$capsule->addConnection(['driver' => 'mysql', 'host' => 'localhost', 'database' => 'designpatternscourse', 'username' => 'homestead', 'password' => 'secret', 'charset' => 'utf8', 'collation' => 'utf8_general_ci', 'prefix' => '']);
$capsule->setEventDispatcher(new Dispatcher(new Container()));
$capsule->bootEloquent();
}
public function __construct($config = [])
{
$capsule = new Capsule;
$capsule->addConnection($config);
$capsule->bootEloquent();
return $capsule;
}
public function __construct()
{
$capsule = new Capsule();
$capsule->addConnection(["driver" => "mysql", "host" => "localhost", "database" => "development", "username" => "developer", "password" => "developer", "charset" => "utf8", "collation" => "utf8_general_ci", "prefix" => ""]);
$capsule->setEventDispatcher(new Dispatcher(new Container()));
$capsule->bootEloquent();
}
/**
* Connect to the Wordpress database
*
* @param array $params
*/
public static function connect(array $params)
{
$capsule = new Capsule();
$params = array_merge(static::$baseParams, $params);
$capsule->addConnection($params);
$capsule->bootEloquent();
}
/**
* @param MvcEvent $event
*/
public function onBootstrap(MvcEvent $event)
{
$eventManager = $event->getApplication()->getEventManager();
$moduleRouteListener = new ModuleRouteListener();
$moduleRouteListener->attach($eventManager);
$app = $event->getApplication();
$serviceManager = $app->getServiceManager();
// Set the Query Profiler
$profiler = new DoplioFirePhpProfiler();
$capsule = new Capsule();
$config = $serviceManager->get('config')['database'];
foreach ($config as $connName => $dbConfig) {
$capsule->addConnection($dbConfig, $connName);
if (isset($dbConfig['profiler']) && $dbConfig['profiler'] === TRUE) {
$profiler->enable();
}
}
// $capsule->setCacheManager();
$capsule->bootEloquent();
$serviceManager->setService('Doplio', $capsule);
$serviceManager->setService('DoplioFirePhpProfiler', $profiler);
$eventManager->attach(MvcEvent::EVENT_FINISH, function () use($capsule, $config, $profiler) {
if ($profiler->isDisabled()) {
return;
}
foreach ($config as $connectionName => $notUsed) {
$connection = $capsule->getConnection($connectionName);
foreach ($connection->getQueryLog() as $query) {
$profiler->addQuery($query, $connectionName);
}
}
$profiler->showTables();
});
}
public function setUp()
{
Eloquent::unguard();
$db = new DB();
$db->addConnection(['driver' => 'sqlite', 'database' => ':memory:']);
$db->bootEloquent();
$db->setAsGlobal();
$this->schema()->create('users', function ($table) {
$table->increments('id');
$table->string('email');
$table->string('first_name');
$table->string('last_name');
$table->timestamps();
});
$this->schema()->create('subscriptions', function ($table) {
$table->increments('id');
$table->string('subscription_id');
$table->string('plan_id');
$table->integer('user_id')->index()->unsigned();
$table->integer('quantity')->default(1);
$table->integer('last_four')->nullable();
$table->timestamp('ends_at')->nullable();
$table->timestamp('trial_ends_at')->nullable();
$table->timestamp('next_billing_at')->nullable();
$table->timestamps();
});
$this->schema()->create('addons', function ($table) {
$table->increments('id');
$table->integer('subscription_id')->index()->unsigned();
$table->string('addon_id');
$table->integer('quantity')->default(0);
$table->timestamps();
});
}
public static function setupBeforeClass()
{
$db = new DB();
$db->addConnection(['driver' => 'sqlite', 'database' => ':memory:', 'prefix' => '']);
$db->setAsGlobal();
$db->bootEloquent();
$db->schema()->create('voucher_campaigns', function ($table) {
$table->increments('id');
$table->timestamps();
$table->string('name');
$table->string('brand');
$table->string('urn')->unique();
$table->integer('expiry_limit')->default('14');
$table->boolean('is_active')->default('1');
});
$db->schema()->create('voucher_entries', function ($table) {
$table->increments('id');
$table->timestamps();
$table->string('hash')->unique();
$table->integer('campaign_id');
$table->boolean('is_redeemed')->default('0');
$table->datetime('redeemed_at')->default('0000-00-00 00:00:00');
$table->boolean('is_expired')->default('0');
$table->datetime('expired_at')->default('0000-00-00 00:00:00');
$table->boolean('is_valid')->default('1');
});
parent::setupBeforeClass();
static::$fm->seed(5, 'Fastwebmedia\\LaravelVouchering\\Models\\Campaign');
static::$fm->seed(5, 'Fastwebmedia\\LaravelVouchering\\Models\\Voucher');
}
/**
* Create fake sqlite database connection
*/
protected function setupDatabase()
{
$database = new DB();
$database->addConnection(["driver" => "sqlite", "database" => ":memory:"]);
// $database->bootEloquent();
$database->setAsGlobal();
}
