Laravel Model with Two Primary Keys update [duplicate]

by

I’ve run into this problem a couple of times. You need to override some properties:

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

and methods (credit):

/**
 * 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);
}

Remember this code needs to reference Eloquent Builder class with

use Illuminate\Database\Eloquent\Builder;

I suggest putting those methods in a HasCompositePrimaryKey Trait so you can just use it in any of your models that need it.

More Related Contents:

  1. Laravel Check If Related Model Exists
  2. How can I convert many statement mysql to laravel eloquent?
  3. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  4. Laravel Checking If a Record Exists
  5. Laravel 5 hasMany relationship on two columns
  6. Difference between Eloquent\Model::get() and all()
  7. Eloquent Parent-Child relationship on same model
  8. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  9. Merge ‘with’ and ‘whereHas’ in Laravel 5
  10. How to Create Multiple Where Clause Query Using Laravel Eloquent?
  11. Get the Last Inserted Id Using Laravel Eloquent
  12. Laravel 5 – redirect to HTTPS
  13. Laravel : Syntax error or access violation: 1055 Error
  14. How to validate array in Laravel?
  15. How to alias a table in Laravel Eloquent queries (or using Query Builder)?
  16. What is the difference between find(), findOrFail(), first(), firstOrFail(), get(), list(), toArray()
  17. Can’t install laravel installer via composer
  18. Laravel: validate an integer field that needs to be greater than another
  19. Laravel Request::all() Should Not Be Called Statically
  20. Laravel catch TokenMismatchException
  21. How to exclude certains columns while using eloquent
  22. Laravel Eloquent, group by month/year
  23. How to select all column name from a table in laravel?
  24. Call to undefined method Maatwebsite\Excel\Excel::load()
  25. ErrorBag is always empty in Laravel 5.2
  26. Laravel 5.2 not reading env file
  27. disable csrf in laravel for specific route
  28. Natural ORDER in Laravel Eloquent ORM
  29. Laravel Middleware return variable to controller
  30. Laravel Eloquent update just if changes have been made

Leave a Comment