/** * */ 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'); }
<?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]]);
<?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 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('content_ratings', function ($table) { $table->increments('id'); $table->integer('content_id'); $table->integer('user_id'); $table->string('type')->default('unknown'); $table->timestamps(); });
<?php Illuminate\Database\Capsule\Manager::schema($connectName)->create('comment_answers', function ($table) { $table->increments('id'); $table->integer('comment_id')->unsigned(); $table->integer('user_id')->unsigned(); $table->string('guest_name', 100); $table->text('message'); $table->string('lang', 32)->default('en'); $table->string('ip', 64)->default('127.0.0.1'); // ipv4 and ipv6 (32 chars + 7 digits is max) $table->boolean('moderate')->default(false); $table->timestamps(); });
/** * Created by PhpStorm. * User: Stefano "Yoghi" Tamagnini * Date: 23/09/15 - 21:32 * */ function setup($config) { foreach ($config['databases'] as $name => $database) { if (!file_exists($config['uploads_dir'])) { mkdir($config['uploads_dir']); } if ($database['driver'] == 'sqlite') { $dbh = new PDO('sqlite:' . $database['database']); $dbh = null; } if (!Illuminate\Database\Capsule\Manager::schema($name)->hasTable('annotations')) { Illuminate\Database\Capsule\Manager::schema($name)->create('annotations', function ($table) { $table->increments('id'); $table->string('author'); $table->string('source'); $table->string('sourceId'); $table->text('text'); $table->text('textHtml'); $table->string('hashtags'); $table->softDeletes(); $table->timestamps(); }); echo "<h3>{$name} - Annotations table created</h3>"; } else { echo "<h3>{$name} - Annotations table ok</h3>"; } if (!Illuminate\Database\Capsule\Manager::schema($name)->hasTable('attachments')) { Illuminate\Database\Capsule\Manager::schema($name)->create('attachments', function ($table) { $table->increments('id'); $table->integer('annotation_id'); $table->string('source'); $table->string('fileName'); $table->string('filePath')->unique(); // http://laravel.com/docs/5.0/schema#foreign-keys $table->foreign('annotation_id')->references('id')->on('annotations'); $table->softDeletes(); $table->timestamps(); }); echo "<h3>{$name} - Attachments table created</h3>"; } else { echo "<h3>{$name} - Attachments table ok</h3>"; } if (!Illuminate\Database\Capsule\Manager::schema($name)->hasTable('evaluations')) { Illuminate\Database\Capsule\Manager::schema($name)->create('evaluations', function ($table) { $table->increments('id'); $table->integer('annotation_id'); $table->string('sessione'); $table->integer('evento'); $table->integer('punteggio'); $table->foreign('annotation_id')->references('id')->on('annotations'); $table->softDeletes(); $table->timestamps(); }); echo "<h3>{$name} - Evaluations table created</h3>"; } else { echo "<h3>{$name} - Evaluations table ok</h3>"; } if ($name == 'testing' && !Illuminate\Database\Capsule\Manager::schema($name)->hasTable('inbox')) { Illuminate\Database\Capsule\Manager::schema($name)->create('inbox', function ($table) { $table->increments('ID'); $table->string('SenderNumber'); $table->string('TextDecoded'); }); echo "<h3>{$name} - Inbox SMS table created</h3>"; } else { echo "<h3>{$name} - Inbox SMS table ok</h3>"; } } }
<?php Illuminate\Database\Capsule\Manager::schema($connectName)->create('user_notifications', function ($table) { $table->increments('id'); $table->string('user_id'); $table->string('msg', 2048); $table->string('uri', 2048); $table->binary('vars')->nullable(); $table->boolean('readed')->default(false); $table->timestamps(); });
<?php Illuminate\Database\Capsule\Manager::schema($connectName)->create('profile_fields', function ($table) { $table->increments('id'); $table->enum('type', ['text', 'link']); $table->text('name'); $table->string('reg_exp', 512)->nullable(); $table->tinyInteger('reg_cond')->default(0); $table->timestamps(); });