Keep id and id_user equal on updateOrCreate

Question

Hi, using the Slim Framework for php, I’m trying to make a updateOrCreate:

$eventos = Eventos::updateOrCreate(
     ["id" => $id, "id_usuario" => $id_usuario], 
     ["nome" => $nome, "descricao" => $descricao]
);

The problem is that when you do the update he has to keep the id_usuario and the id, I thought I’d put the id_usuario in the first "[]" but it gives the following error:

SQLSTATE[23000]: Integrity Constraint Violation: 1062 Duplicate entry '91' for key 'PRIMARY' (SQL: Insert into eventos (id, id_usuario, nome) values (91, 1, Kashmir))

It gives Insert instead of update because, how can I fix it ?

---

Follow the Events table model:

<?php

    class Eventos extends BaseModel{

        protected $table = "eventos";

        const UPDATED_AT = 'atualizado_em';
        const CREATED_AT = 'criado_em';

        protected $dateFormat = 'U';
        protected $fillable = ["id", "nome", "descricao", "id_thumbnail", "local", "endereco", "place_id", "data_hora_inicio", "data_hora_fim", "responsavel", "telefone1", "telefone2", "email", "site", "nota", "status", "categoria", "facebook_page_url", "id_usuario", "preco"];

    }

?>

Answer 1

The code executed updateOrCreate is:

public static function updateOrCreate(array $attributes, array $values = array())
{
    $instance = static::firstOrNew($attributes);
    $instance->fill($values)->save();
    return $instance;
}

---

public static function firstOrNew(array $attributes)
{
    if ( ! is_null($instance = static::where($attributes)->first()))
    {
        return $instance;
    }
    return new static($attributes);
}

then the right thing would be:

$eventos = Eventos::updateOrCreate(
    ["id" => $id], 
    ["nome" => $nome, "descricao" => $descricao, "id_usuario" => $id_usuario]
);

where the search is for its identification, including in its model has the wrong configuration, where the id don’t have to stay inside $fillable, because it is automatically generated by the bank, then:

class Eventos extends BaseModel
{

    protected $table = "eventos";

    const UPDATED_AT = 'atualizado_em';
    const CREATED_AT = 'criado_em';

    protected $dateFormat = 'U';
    protected $fillable = ["nome","descricao", "id_thumbnail", 
                           "local", "endereco", "place_id", 
                           "data_hora_inicio", "data_hora_fim", 
                           "responsavel", "telefone1", 
                           "telefone2", "email", "site", "nota", 
                           "status", "categoria", 
                           "facebook_page_url", "id_usuario","preco"];

}

---

I would particularly do so:

$evento = Eventos::find($id);
if (!$evento) 
{
    $evento = new Eventos();
    $evento->fill(["nome"=>$nome,"descricao"=>$descricao,"id_usuario"=>$id_usuario]);
}
else
{
    $evento->fill(["nome"=>$nome,"descricao"=>$descricao]);
}
$evento->save();

Can also be created a Scope in his model:

class Eventos extends BaseModel
{

    protected $table = "eventos";

    const UPDATED_AT = 'atualizado_em';
    const CREATED_AT = 'criado_em';

    protected $dateFormat = 'U';
    protected $fillable = ["nome","descricao", "id_thumbnail", 
                           "local", "endereco", "place_id", 
                           "data_hora_inicio", "data_hora_fim", 
                           "responsavel", "telefone1", 
                           "telefone2", "email", "site", "nota", 
                           "status", "categoria", 
                           "facebook_page_url", "id_usuario","preco"];

    public function scopeGeneration($query, $id, $values = array())
    {
        $m = $query->find($id);
        if (!m)
        {
           $m = new Eventos();                              
        }  
        else
        {
          unset($values['id_usuario']);
        }          
        $m ->fill($values);
        $m->save();
        return $m;
    }

}

How to use:

$values = ["nome"=>$nome,"descricao"=>$descricao,"id_usuario"=>$id_usuario];
$evento = Eventos::generation($id,$values);