/PHP/Laravel/Multiple primary key defined laravel

Multiple primary key defined laravel

Laravel eloquent multiple primary key

protected $primaryKey = ['user_id', 'stock_id'];
public $incrementing = false;

Source: stackoverflow.com

Laravel eloquent multiple primary key

/**
 * Set the keys for a save update query.
 *
 * @param  \Illuminate\Database\Eloquent\Builder  $query
 * @return \Illuminate\Database\Eloquent\Builder
 */
protected function setKeysForSaveQuery(Builder $query)
{
    $keys = $this->getKeyName();
    if(!is_array($keys)){
        return parent::setKeysForSaveQuery($query);
    }

    foreach($keys as $keyName){
        $query->where($keyName, '=', $this->getKeyForSaveQuery($keyName));
    }

    return $query;
}

/**
 * Get the primary key value for a save query.
 *
 * @param mixed $keyName
 * @return mixed
 */
protected function getKeyForSaveQuery($keyName = null)
{
    if(is_null($keyName)){
        $keyName = $this->getKeyName();
    }

    if (isset($this->original[$keyName])) {
        return $this->original[$keyName];
    }

    return $this->getAttribute($keyName);
}

Source: stackoverflow.com

Multiple primary key defined laravel

public function up()
{
    Schema::create('spins', function (Blueprint $table) {
        $table->engine = 'MyISAM';
        $table->integer('rid')->unsigned();
        $table->bigInteger('pid');
        $table->integer('result');
        $table->integer('bet');
        $table->timestamps();
        $table->primary(array('rid', 'pid'));

        DB::statement('ALTER TABLE spins MODIFY rid INTEGER NOT NULL AUTO_INCREMENT');
    });
}

Source: stackoverflow.com

Similar codes

0 vote346 views3 answers
Laravel model where in
PHP Laravel
5 votes408 views5 answers
Unique laravel migration
PHP Laravel
0 vote385 views1 answer
Laravel check if api request
PHP Laravel
0 vote346 views2 answers
Laravel filesystem
PHP Laravel
0 vote372 views1 answer
Trying to access variable outside laravel collection
PHP Laravel
0 vote326 views2 answers
Sortbydesc on a collection laravel
PHP Laravel
2 votes414 views2 answers
Increase memory laravel controller
PHP Laravel
13 votes323 views6 answers
Laravel array validation
PHP Laravel
16 votes343 views4 answers
Wherenotnull laravel
PHP Laravel
46 votes435 views6 answers
Add new column in existing table in laravel migration
PHP Laravel