/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 vote274 views1 answer
Laravel truncate string laravel 8
PHP Laravel
0 vote346 views3 answers
Run queue after x minutes laravel
PHP Laravel
0 vote299 views1 answer
Update function laravel 7
PHP Laravel
3 votes294 views2 answers
Laravel check if laravel query is empty
PHP Laravel
1 vote300 views2 answers
Laravel collection implode
PHP Laravel
12 votes317 views6 answers
Laravel redirect back with input
PHP Laravel
1 vote316 views2 answers
Set nav link active on the basis of route laravel
PHP Laravel
0 vote309 views1 answer
The uploaded file exceeds the upload_max_filesize in laravel
PHP Laravel
-1 vote279 views2 answers
How to Delete Multiple Records using Checkbox in Laravel
PHP Laravel
0 vote330 views1 answer
Not get child all data in relationship with parent laravel eloquent
PHP Laravel