Keep id and id_user equal in updateOrCreate

Question

Keep id and id_user equal in updateOrCreate

Navigation

#1 by (1 votes)

1

Hi, I am trying to make a updateOrCreate :

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

The problem is that when doing update it has to keep id_usuario and id , I thought about putting id_usuario on the first "[]" but it gives 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, how can I solve it?

Follow the model of the Events table:

<?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"];

    }

?>

php laravel-eloquent slim

asked by anonymous 02.02.2018 / 14:19

1 answer

Get Off "Scroll" Slow and Automatic Page with JavaScript How to implement a Thread to allow StringGrid fill in Delphi?

score 1 · Accepted Answer

The executed code updateOrCreate is: / p>

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 correct one would be:

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

where the search is by its identification, even in its model has the wrong configuration, where id does not 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();

You can also create a scope in your 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);