/**
* Creates the migration history table.
*/
protected function createMigrationHistoryTable()
{
$tableName = $this->migrationTable;
$this->stdout("Creating migration history table \"{$tableName}\"...", Console::FG_YELLOW);
$this->db->schema()->create($this->migrationTable, function (Blueprint $table) {
$table->string('version', 180);
$table->primary('version');
$table->integer('apply_time');
});
$this->addMigrationHistory(self::BASE_MIGRATION);
$this->stdout("Done.\n", Console::FG_GREEN);
}
/**
* Returns true if the specified table exists in the database.
*
* @param $table
*
* @return bool
*/
public function TableExists($table)
{
if ($this->capsule->schema()->hasTable($table)) {
return true;
}
return false;
}
/**
* Create Schema
*
* @return AdapterInterface
*/
public function createSchema()
{
/* @var \Illuminate\Database\Schema\Blueprint $table */
$this->adapter->schema()->create($this->tableName, function ($table) {
$table->string('version');
});
}
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');
}
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' => 'utf8', 'collation' => 'utf8_unicode_ci']);
$this->capsule->bootEloquent();
$this->capsule->setAsGlobal();
$this->schema = $this->capsule->schema();
}
/**
* Init the migration
*/
public function init()
{
//Get the Container
$container = $this->getContainer();
//Get Eloquent capsule
$this->capsule = $container['db'];
//Get schema builder instance
$this->schema = $this->capsule->schema();
}
/**
* Creates and seeds the order table.
*/
protected function createAndSeedOrdersTable()
{
/*
* @var $db Manager
*/
$this->db = Yii::$app->db;
$this->db->schema()->create('order', function ($table) {
$table->increments('id');
$table->string('name')->unique();
$table->timestamps();
});
Order::create(['name' => 'Test address']);
Order::create(['name' => 'Another test Address']);
}
public function setUp()
{
parent::setUp();
$this->mockWebApplication();
$this->db = Yii::$app->db;
$this->db->schema()->dropIfExists('order');
$this->db->schema()->create('order', function (Blueprint $table) {
$table->increments('id');
$table->string('address');
$table->timestamps();
});
$this->unloadFixtures();
$this->loadFixtures();
}
protected function migrateTables()
{
DB::schema()->create('posts', function ($table) {
$table->increments('id');
$table->integer('author_id')->unsigned();
$table->string('title');
$table->timestamps();
});
DB::schema()->create('comments', function ($table) {
$table->increments('id');
$table->integer('post_id')->unsigned();
$table->string('body');
$table->timestamps();
});
DB::schema()->create('people', function ($table) {
$table->increments('id');
$table->string('name');
$table->timestamps();
});
DB::schema()->create('messages', function ($table) {
$table->increments('id');
$table->integer('sender_id')->unsigned();
$table->integer('receiver_id')->unsigned();
$table->string('contents');
$table->timestamps();
});
}
/**
* command migrate
*/
private function runMigrations()
{
$files = glob($this->getMigrationPath() . '/*.php');
if (!Capsule::schema()->hasTable('migrations')) {
Capsule::schema()->create('migrations', function ($table) {
$table->string('migration');
$table->integer('batch');
});
}
$migrations = Migration::all();
foreach ($migrations as $migration) {
$filename = $this->getMigrationPath() . '/' . $migration->migration . '.php';
if (in_array($filename, $files)) {
$key = array_keys($files, $filename);
unset($files[$key[0]]);
}
}
$batch = Migration::all()->max('batch') + 1;
foreach ($files as $file) {
require_once $file;
$filename = basename($file, '.php');
$class = substr($filename, 18);
$migration = new $class();
$migration->up();
Migration::create(array('migration' => $filename, 'batch' => $batch));
$this->line("<success>File \"{$filename}.php\" processed</success>\n");
}
}
/**
* Migrates the tables required for testing.
*/
protected function migrateTables()
{
DB::schema()->create('users', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('email');
$table->timestamps();
});
DB::schema()->create('posts', function (Blueprint $table) {
$table->increments('id');
$table->string('title');
$table->text('body');
$table->unsignedInteger('user_id')->index();
$table->timestamps();
});
DB::schema()->create('tags', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->timestamps();
});
DB::schema()->create('post_tag', function (Blueprint $table) {
$table->unsignedInteger('tag_id')->index();
$table->unsignedInteger('post_id')->index();
});
DB::schema()->create('categories', function (Blueprint $table) {
$table->increments('id');
$table->string('title');
$table->text('description')->nullable();
$table->timestamps();
});
}
public function createTables()
{
Capsule::schema()->create('routes', function ($table) {
$table->increments('id');
$table->string('name')->nullable();
});
Capsule::schema()->create('methods', function ($table) {
$table->increments('id');
$table->string('tags');
$table->enum('method', ['GET', 'POST', 'PUT', 'DELETE']);
$table->text('description')->nullable();
$table->integer('route_id')->unsigned()->index();
$table->foreign('route_id')->references('id')->on('routes')->onDelete('cascade');
});
Capsule::schema()->create('parameters', function ($table) {
$table->increments('id');
$table->string('name');
$table->enum('in', ['formData', 'path']);
$table->text('description')->nullable();
$table->boolean('required');
$table->enum('type', ['string', 'file']);
$table->integer('method_id')->unsigned()->index();
$table->foreign('method_id')->references('id')->on('methods')->onDelete('cascade');
});
}
protected function createTables()
{
Manager::schema()->create('conv_users', function ($table) {
$table->integer('conv_id')->nullable();
$table->integer('user_id')->nullable();
$table->primary(array('conv_id', 'user_id'));
});
Manager::schema()->create('conversations', function ($table) {
$table->increments('id');
$table->softDeletes();
$table->timestamps();
});
Manager::schema()->create('messages', function ($table) {
$table->increments('id');
$table->integer('sender_id');
$table->integer('conv_id');
$table->text('content');
$table->timestamps();
$table->index('sender_id');
$table->index('conv_id');
});
Manager::schema()->create('messages_status', function ($table) {
$table->increments('id');
$table->integer('user_id');
$table->integer('msg_id');
$table->boolean('self');
$table->integer('status');
$table->index('msg_id');
});
}
/**
* To Perform migration to ensure the table and its properties
* are up-to-date
*
*/
public static function migration()
{
$tables = Migration::tables();
// Simple Filters.
if (!isset($tables)) {
return false;
}
foreach ($tables as $key => $value) {
if (empty($value) || is_null($value) || !isset($value)) {
continue;
}
loop:
if (Capsule::Schema()->hasTable($key)) {
foreach ($value as $column => $datatype) {
if (!Capsule::Schema()->hasColumn($key, $column)) {
//Assign the Name and Datatype for temporary access
self::$columns['name'] = $column;
self::$columns['datatype'] = $datatype;
Capsule::Schema()->table($key, function ($table) {
$column = self::$columns['name'];
$datatype = self::$columns['datatype'];
$table->{$datatype}($column)->after('id');
});
}
}
} else {
Capsule::schema()->create($key, function ($table) {
$table->increments('id');
$table->timestamps();
});
goto loop;
}
}
}
protected function migrateTables()
{
DB::schema()->create('models', function ($table) {
$table->increments('id');
$table->string('name');
$table->timestamps();
});
}
/**
* Create the users table.
*
* @return void
*/
protected function migrateDatabase()
{
Capsule::schema()->create('users', function ($table) {
$table->increments('id');
$table->string('name');
$table->string('email');
});
}
protected function setUp()
{
parent::setUp();
$this->schema = DB::schema();
$migration = App::make('CreatePageAndObjectTables');
$migration->down();
$migration->up();
}
/**
* Migrate test table.
*/
public function migrateTestTable()
{
DB::schema()->create('testing', function (Blueprint $table) {
$table->uuid('id');
$table->string('test');
$table->timestamps();
});
}
public function migrateTables()
{
DB::schema()->create('posts', function ($table) {
$table->increments('id');
$table->string('title');
$table->timestamps();
});
}
public function __construct($driver, $hostname, $username, $password, $database, $port = NULL, $prefix = NULL, $name = 'default')
{
$this->name = $name;
if (!in_array($driver, ['mysql', 'pgsql', 'sqlite', 'sqlsrv'])) {
exit('Error: Could not load database driver ' . $driver . '!');
}
$capsule = new Capsule();
$capsule->addConnection(['driver' => $driver, 'host' => $hostname, 'database' => $database, 'username' => $username, 'password' => $password, 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => $prefix, 'port' => $port], $name);
// Set the event dispatcher used by Eloquent models... (optional)
$capsule->setEventDispatcher(new Dispatcher(new Container()));
// Make this Capsule instance available globally via static methods... (optional)
$capsule->setAsGlobal();
// Setup the Eloquent ORM... (optional; unless you've used setEventDispatcher())
$capsule->bootEloquent();
$this->capsule = $capsule;
$this->connection = $this->capsule->schema($this->name)->getConnection();
}
/**
* Run the migration.
*
* @return void
*/
public function up()
{
if (Capsule::schema()->hasTable($this->table)) {
Capsule::schema()->table($this->table, function (Blueprint $table) {
$table->softDeletes();
});
}
}
public function setUp()
{
parent::setUp();
Capsule::schema()->create('issue1_model', function (Blueprint $table) {
$table->bigIncrements('id');
$table->longText('options');
});
$this->models = new Issue1Repository();
}
protected function migrateCategoryPostsTable()
{
DB::schema()->create('category_posts', function ($table) {
$table->increments('id');
$table->integer('category_id')->unsigned();
$table->integer('post_id')->unsigned();
$table->timestamps();
});
}
public function setUp()
{
date_default_timezone_set("UTC");
$database = __DIR__ . "/../databases/database.sqlite";
file_put_contents($database, "");
$this->capsule = new Capsule();
$this->capsule->addConnection(["driver" => "sqlite", "database" => $database, "prefix" => ""]);
$this->capsule->setAsGlobal();
$this->capsule->bootEloquent();
Capsule::schema()->create("roots", function ($table) {
$table->increments("id");
$table->string("test")->nullable();
$table->unsignedInteger("bar_id")->nullable();
$table->unsignedInteger("special_bar_id")->nullable();
$table->timestamps();
});
Capsule::schema()->create("bars", function ($table) {
$table->increments("id");
$table->unsignedInteger("root_id")->nullable();
$table->string("test");
$table->timestamps();
});
Capsule::schema()->create("foos", function ($table) {
$table->increments("id");
$table->unsignedInteger("root_id")->nullable();
$table->string("test");
$table->text("data");
$table->timestamps();
});
Capsule::schema()->create("polies", function ($table) {
$table->increments("id");
$table->unsignedInteger("root_id")->nullable();
$table->morphs("polyable");
$table->string("test");
$table->timestamps();
});
Capsule::schema()->create("customs", function ($table) {
$table->increments("id");
$table->unsignedInteger("root_id")->nullable();
$table->text("data");
$table->timestamps();
});
Capsule::schema()->create("resources", function ($table) {
$table->increments("id");
$table->unsignedInteger("root_id")->nullable();
$table->string("name");
$table->timestamps();
});
Capsule::schema()->create("resource_references", function ($table) {
$table->increments("id");
$table->unsignedInteger("root_id")->nullable();
$table->unsignedInteger("resource_id");
$table->unsignedInteger("referable_id");
$table->string("referable_type");
$table->timestamps();
});
}
function run()
{
Capsule::schema()->dropIfExists('users');
Capsule::schema()->create('users', function ($table) {
$table->increments('id');
$table->string('username');
$table->timestamps();
});
}
/**
* Setup the test table.
*
* @return void
*/
protected function migrateTable()
{
DB::schema()->create('models', function ($table) {
$table->increments('id');
$table->string('default');
$table->text('input');
});
Model::create(['default' => 'model', 'input' => '{"en":"translation","nl":"vertaling"}']);
}
function run()
{
Capsule::schema()->dropIfExists('friends');
Capsule::schema()->create('friends', function ($table) {
$table->integer('user_id')->index();
$table->integer('friend_id')->index();
$table->primary(['user_id', 'friend_id']);
});
}
/**
* Run the migration.
*
* @return void
*/
public function up()
{
if (!Capsule::schema()->hasTable($this->table)) {
Capsule::schema()->create($this->table, function (Blueprint $table) {
$table->increments('id');
$table->string('title');
$table->timestamps();
});
}
}
function run()
{
Capsule::schema()->dropIfExists('users');
Capsule::schema()->create('users', function ($table) {
$table->increments('id');
$table->string('email')->unique();
$table->string('password');
$table->timestamps();
});
}
/**
* Run the migrations.
*
* @return void
*/
public function run()
{
Capsule::schema()->dropIfExists('teams');
Capsule::schema()->create('teams', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('nationality', 2);
$table->timestamps();
});
}
