staudenmeir / laravel-merged-relations Goto Github PK

CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `username`@`ip` 
    SQL SECURITY DEFINER
VIEW `database`.`participants` AS
    SELECT 
        `database`.`users`.`username` AS `username`,
        `database`.`users`.`id` AS `laravel_foreign_key`,
        'App\Models\User' AS `laravel_model`,
        '' AS `laravel_placeholders`,
        '' AS `laravel_with`
    FROM
        `database`.`users`
    WHERE
        (`database`.`users`.`deleted_at` IS NULL) 
    UNION ALL SELECT 
        `database`.`users`.`username` AS `username`,
        `database`.`users`.`id` AS `laravel_foreign_key`,
        'App\Models\User' AS `laravel_model`,
        '' AS `laravel_placeholders`,
        '' AS `laravel_with`
    FROM
        `database`.`users`
    WHERE
        (`database`.`users`.`deleted_at` IS NULL) 
    UNION ALL SELECT DISTINCT
        `database`.`users`.`username` AS `username`,
        `database`.`blog_comments`.`blog_id` AS `laravel_foreign_key`,
        'App\Models\User' AS `laravel_model`,
        '' AS `laravel_placeholders`,
        '' AS `laravel_with`
    FROM
        (`database`.`users`
        JOIN `database`.`blog_comments` ON ((`database`.`users`.`id` = `database`.`blog_comments`.`user_id`)))
    WHERE
        (`database`.`users`.`deleted_at` IS NULL)

class Blog extends Model
{
    use \Staudenmeir\LaravelMergedRelations\Eloquent\HasMergedRelationships;

    public function user(): BelongsTo
    {
        return $this->belongsTo(User::class);
    }

    public function creator(): BelongsTo
    {
        return $this->belongsTo(User::class);
    }

    public function commenters(): BelongsToMany
    {
        return $this->belongsToMany(User::class, BlogComment::class)->distinct();
    }

    /**
     * Get participants in the blog.
     *
     * @todo: We should get the users who comments + creator + user
     * 
     * @return MergedRelation
     */
    public function participants(): MergedRelation
    {
        return $this->mergedRelationWithModel(User::class, 'participants');
    }
}

  public function connections(): MergedRelation
  {
      return $this->mergedRelationWithModel(User::class, 'connections_view');
  }

  public function up()
  {
      Schema::createMergeView(
          'connections_view',
          [(new User())->acceptedConnectionsFrom(), (new User())->acceptedConnectionsTo()]
      );
  }

  public function test_try_to_seed_user_with_friends() 
  {
      $user = User::factory()
                  ->hasConnections(10)
                  ->create();
  }

  SQLSTATE[HY000]: General error: 1 table users has no column named laravel_foreign_key (SQL: insert into "users" ("name", "email", "email_verified_at", "password", "remember_token", "userable_id", "userable_type", "laravel_foreign_key", "updated_at", "created_at") values (Kareem Jast I, [email protected], 2022-11-04 14:22:07, $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi, CqbC0RCmTK, 2, App\Models\Site, 1, 2022-11-04 14:22:07, 2022-11-04 14:22:07))

Relation::enforceMorphMap([
            'dropbox' => Dropbox::class,
            'ftp' => Ftp::class,
            's3' => S3::class,
            'user' => User::class,
        ]);

public function c()
{
	return $this->hasManyDeepFromRelations($this->b(), (new B)->c());
}

Schema::createMergeViewWithoutDuplicates(
        'all_cs',
        [(new A)->c()]
);

CREATE OR REPLACE
ALGORITHM = UNDEFINED VIEW `all_cs` AS
select
    `cs`.`id` AS `id`,
    `cs`.`name` AS `name`,
    `cs`.`created_at` AS `created_at`,
    `cs`.`updated_at` AS `updated_at`,
    `bs`.`id` AS `laravel_foreign_key`,
    'App\\Models\\C' AS `laravel_model`,
    '' AS `laravel_placeholders`,
    '' AS `laravel_with`
from
...

    use Staudenmeir\LaravelMergedRelations\Facades\Schema;

    public function up()
    {
        Schema::createMergeView(
            'friends_view',
            [( new User())->acceptedFriendsOf(), ( new User())->acceptedFriendsOfMine()]
        );
    }

<warning>PHP Warning:  Undefined property: stdClass::$laravel_model in vendor/staudenmeir/laravel-merged-relations/src/Eloquent/Builder.php on line 23</warning>
<warning>PHP Warning:  Undefined property: stdClass::$laravel_placeholders in vendor/staudenmeir/laravel-merged-relations/src/Eloquent/Builder.php on line 27</warning>
PHP Error:  Class name must be a valid object or a string in vendor/staudenmeir/laravel-merged-relations/src/Eloquent/Builder.php on line 35

select `external_id` from `source_all_newsitems` where `source_all_newsitems`.`laravel_foreign_key` = ? and `source_all_newsitems`.`laravel_foreign_key` is not null"

    public function feedNewsItems()
    {
        return $this->hasManyThrough(NewsItem::class, Feed::class);
    }

    public function directNewsItems()
    {
        return $this->hasMany(NewsItem::class);
    }

    public function newsItems()
    {
        return $this->mergedRelationWithModel(NewsItem::class, 'source_all_newsitems');
    }

        Schema::createMergeView('source_all_newsitems', [
            (new \App\Models\Source())->feedNewsItems(),
            (new \App\Models\Source())->directNewsItems()
        ]);

<?php

use App\Models\Group;
use Illuminate\Database\Migrations\Migration;
use Staudenmeir\LaravelMergedRelations\Facades\Schema;

class CreateAllGroupMembersView extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::createOrReplaceMergeView(
            'all_group_members',
            [(new Group)->teachers(), (new Group)->students()]
        );
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropView('all_group_members');
    }
}

Schema::createMergeViewWithoutDuplicates(
    'business_all_gatherings',
    [(new \App\Models\Business())->productGatherings(), (new \App\Models\Business())->activityGatherings()]
);

SQLSTATE[42883]: Undefined function: 7 ERROR:  could not identify an equality operator for type json...

 SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name

Schema::createMergeViewWithoutDuplicates(
            'movie_recommended_view',
            [(new Movie())->recommended(), (new Movie)->recommendedFor()]
        );

    public function recommended(): BelongsToMany
    {
        return $this->belongsToMany(static::class, 'movie_recommended', 'movie_id', 'recommended_id' ,'tmdb_id' , 'tmdb_id');
    }

    public function recommendedFor(): BelongsToMany
    {
        return $this->belongsToMany(static::class, 'movie_recommended', 'recommended_id', 'movie_id' ,'tmdb_id' , 'tmdb_id');
    }