/**
* @param Builder|\Illuminate\Database\Eloquent\Builder|Model $query
* @return mixed
*/
public function scopeVisible($query)
{
return $query->whereHas('profile', function ($query) {
/** @var Profile $query */
return $query->visible();
});
}
/**
* Undo the migration
*/
public function down()
{
//Remove Field
$this->schema->table('user_details', function ($table) {
$table->dropColumn('profile_picture');
});
}
/**
* Undo the migration
*/
public function down()
{
//Remove url column
$this->schema->table('notifications', function ($table) {
$table->dropColumn('url');
});
}
/**
* Undo the migration
*/
public function down()
{
$this->schema->table('user_works', function ($table) {
$table->dropForeign('user_works_user_id_foreign');
});
//Drop table
$this->schema->dropIfExists('user_works');
}
/**
* Undo the migration
*/
public function down()
{
$this->schema->table('users_basic_info', function ($table) {
$table->dropForeign('users_basic_info_user_id_foreign');
});
//Drop table
$this->schema->dropIfExists('users_basic_info');
}
/**
* Undo the migration
*/
public function down()
{
//Drop foreign
$this->schema->table('likes', function ($table) {
$table->dropForeign('likes_user_id_foreign');
});
$this->schema->dropIfExists('likes');
}
/**
*
*/
public function createDivision(Builder $schema, $table)
{
$schema->create($table, function (Blueprint $table) {
$table->engine = "InnoDB";
$table->string('id', 255);
$table = $this->setColumns($table);
$table->primary(array('id'));
});
}
/**
* Undo the migration
*/
public function down()
{
//Drop foreign
$this->schema->table('account_verification_tokens', function ($table) {
$table->dropForeign('account_verification_tokens_user_id_foreign');
});
//Drop the table
$this->schema->dropIfExists('account_verification_tokens');
}
/**
* Undo the migration
*/
public function down()
{
//Drop foreign keys
$this->schema->table('passwords', function ($table) {
$table->dropForeign('passwords_user_id_foreign');
});
//Drop passwords table
$this->schema->dropIfExists('passwords');
}
/**
* Undo the migration
*/
public function down()
{
//Drop foreign
$this->schema->table('user_details', function ($table) {
$table->dropForeign('user_details_user_id_foreign');
});
//Drop user details table
$this->schema->dropIfExists('user_details');
}
/**
* Handle the event.
*
* @param AssignmentWasDeleted $event
*/
public function handle(AssignmentWasDeleted $event)
{
$assignment = $event->getAssignment();
$fieldType = $assignment->getFieldType();
if (!$fieldType instanceof FilesFieldType) {
return;
}
$this->schema->dropIfExists($table = $assignment->getStreamPrefix() . $assignment->getStreamSlug() . '_' . $fieldType->getField());
}
public function __construct()
{
// get custom schema object
$this->schema = \DB::connection()->getSchemaBuilder();
// bind new blueprint class
$this->schema->blueprintResolver(function ($table, $callback) {
return new Blueprint($table, $callback);
});
}
/**
* Handle the event.
*
* @param AssignmentWasDeleted $event
*/
public function handle(AssignmentWasDeleted $event)
{
$assignment = $event->getAssignment();
$fieldType = $assignment->getFieldType();
if (!$fieldType instanceof MultipleFieldType) {
return;
}
$this->schema->dropIfExists($fieldType->getPivotTableName());
}
/**
* Install the extensions table.
*/
public function handle()
{
$this->schema->dropIfExists('addons_extensions');
$this->schema->create('addons_extensions', function (Blueprint $table) {
$table->increments('id');
$table->string('slug');
$table->boolean('installed')->default(0);
$table->boolean('enabled')->default(0);
});
}
public function upTable(Builder $builder)
{
$builder->create($this->table, function (Blueprint $blueprint) {
$blueprint->increments("id");
$blueprint->string("key")->unique();
$blueprint->string("tag");
$blueprint->text("value");
$blueprint->timestamp("created_at");
});
}
/**
* Undo the migration
*/
public function down()
{
//Drop foreign keys
$this->schema->table('friend_requests', function ($table) {
$table->dropForeign('friend_requests_sender_foreign');
$table->dropForeign('friend_requests_receiver_foreign');
});
//Drop table
$this->schema->dropIfExists('friend_requests');
}
/**
* Undo the migration
*/
public function down()
{
//Drop foreign keys
$this->schema->table('friends', function ($table) {
$table->dropForeign('friends_user_id_1_foreign');
$table->dropForeign('friends_user_id_2_foreign');
});
//Drop table
$this->schema->dropIfExists('friends');
}
/**
* Undo the migration
*/
public function down()
{
//Drop foreign keys
$this->schema->table('users', function ($table) {
$table->dropForeign('users_uom_id_foreign');
$table->dropForeign('users_account_status_foreign');
});
//Drop the table
$this->schema->dropIfExists('users');
}
/**
* Undo the migration
*/
public function down()
{
//Drop foreign keys
$this->schema->table('notifications', function ($table) {
$table->dropForeign('notifications_receiver_foreign');
$table->dropForeign('notifications_notifier_foreign');
});
//Drop notifications table
$this->schema->dropIfExists('notifications');
}
/**
* Undo the migration
*/
public function down()
{
//Drop foreign keys
$this->schema->table('lecturers_courses_faculties', function ($table) {
$table->dropForeign('lecturer_courses_faculties_uom_id_foreign');
$table->dropForeign('lecturer_courses_faculties_faculty_id_foreign');
$table->dropForeign('lecturer_courses_faculties_course_id_foreign');
});
//Drop table
$this->schema->dropIfExists('lecturers_courses_faculties');
}
/**
* To get all columns on caching
*
* @param \Illuminate\Database\Eloquent\Model $model
* @return array
*/
protected function getColumnsOnCache(Model $model)
{
/**
* In normal scenario tables and columns often is not changed.
* Therefore every time it is not need to access the database for knowing
* columns name. We don't want make preoccupy/busy to the database.
*/
$fullKey = $this->getFullName($model);
return $this->cache->remember($fullKey, $this->getRememberTime(), function () use($model) {
return $this->builder->getColumnListing($model->getTable());
});
}
/**
* Handle the event.
*
* @param AssignmentWasCreated $event
*/
public function handle(AssignmentWasCreated $event)
{
$assignment = $event->getAssignment();
$fieldType = $assignment->getFieldType();
if (!$fieldType instanceof FilesFieldType) {
return;
}
$table = $assignment->getStreamPrefix() . $assignment->getStreamSlug() . '_' . $fieldType->getField();
$this->schema->dropIfExists($table);
$this->schema->create($table, function (Blueprint $table) {
$table->integer('entry_id');
$table->integer('file_id');
$table->integer('sort_order')->nullable();
$table->primary(['entry_id', 'file_id']);
});
}
/**
* Create the token scopes table.
*
* @return void
*/
protected function createTokenScopesTable()
{
$this->schema->create($this->tables['token_scopes'], function ($table) {
$table->increments('id');
$table->string('token', 40)->index();
$table->string('scope')->index();
});
}
/**
* Handle the event.
*
* @param AssignmentWasCreated $event
*/
public function handle(AssignmentWasCreated $event)
{
$assignment = $event->getAssignment();
$fieldType = $assignment->getFieldType();
if (!$fieldType instanceof MultipleFieldType) {
return;
}
$table = array_get($fieldType->getConfig(), 'pivot_table', $assignment->getStreamPrefix() . $assignment->getStreamSlug() . '_' . $fieldType->getField());
$foreignKey = $fieldType->getForeignKey();
$otherKey = $fieldType->getOtherKey();
$this->schema->dropIfExists($table);
$this->schema->create($table, function (Blueprint $table) use($foreignKey, $otherKey) {
$table->increments('id');
$table->integer($foreignKey);
$table->integer($otherKey);
});
}
/**
* Drop a column.
*
* @param $table
* @param FieldType $type
*/
public function dropColumn($table, FieldType $type)
{
$schema = $type->getSchema();
if (!$this->schema->hasTable($table)) {
return;
}
$this->schema->table($table, function (Blueprint $table) use($schema) {
$schema->dropColumn($table);
});
}
/**
* Clean up abandoned streams.
*/
public function cleanup()
{
/* @var StreamInterface $stream */
foreach ($this->model->all() as $stream) {
if (!$this->schema->hasTable($stream->getEntryTableName())) {
$this->delete($stream);
}
}
$translations = $this->model->getTranslationModel();
$translations->leftJoin('streams_streams', 'streams_streams_translations.stream_id', '=', 'streams_streams.id')->whereNull('streams_streams.id')->delete();
}
/**
* POST and PUT requests must contain all attributes.
* This method returns all fillable attributes which are missing.
*
* @param Model $model
* @return array
*/
protected function getMissingUpdateAttributes(Model $model)
{
$keys = array_keys($this->body->getArray());
$columnNames = $this->schemaBuilder->getColumnListing($model->getTable());
$attributes = [];
foreach ($columnNames as $column) {
if ($model->isFillable($column) && !in_array($column, $keys)) {
$attributes[] = $column;
}
}
return $attributes;
}
/**
* Create table if not exist.
* @param string table
* @param \Closure $callback
*/
public function table($table, \Closure $callback)
{
try {
parent::create($table, $callback);
} catch (\Exception $e) {
try {
parent::table($table, $callback);
} catch (\Exception $e) {
echo $e->getMessage();
}
}
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
if ($connection = Capsule::connection($this->getConnection())) {
$connection->useDefaultSchemaGrammar();
} else {
$app = app();
$connection = $app['db']->connection($this->getConnection());
}
$schema = new Schema($connection);
if (!$schema->hasTable('salesforce_tokens')) {
$schema->create('salesforce_tokens', function (Blueprint $table) {
$table->bigIncrements('id');
$table->string('access_token');
$table->string('refresh_token');
$table->string('instance_base_url');
$table->bigInteger('user_id');
$table->datetime('expires')->nullable();
$table->timestamps();
$table->softDeletes();
});
}
}
/**
* Drop the field type column from the table.
*
* @param Blueprint $table
*/
public function dropColumn(Blueprint $table)
{
// Skip if no column type.
if (!$this->fieldType->getColumnType()) {
return;
}
// Skip if the column doesn't exist.
if (!$this->schema->hasColumn($table->getTable(), $this->fieldType->getColumnName())) {
return;
}
// Drop dat 'ole column.
$table->dropColumn($this->fieldType->getColumnName());
}
