Duplicate entries when assigning custom id to Laravel Model

» php » Duplicate entries when assigning custom id to Laravel Model

By : อภิชาติ วงษ์ปลั่ง

Date : November 27 2020, 09:01 AM

it fixes the issue So i'm populating my database from a CRM and i'm trying to use the provided id for each item as my primary key (I feel like this will make things less complicated, but if this is bad practice please let me know). The problem is that when the table already has some data and i rerun the function, i get this error: , Use findOrNew + fill instead of create and you're good:

code :

$listing = Property::findOrNew($property['@attributes']['id'])
   ->fill([
     'id' => $property['@attributes']['id'],
     'house_flat_number' => $property['address']['name'],
     // ...
   ])->save();

Share :

asp.net mvc adding entity into it's own db model and into a list of another db model gets duplicate entries

By : Justine Traclet

Date : March 29 2020, 07:55 AM

Any of those help So i figured out what was wrong and it was a really dumb mistake. my logic is in the controllers on viewmodels which is totally wrong.

code :

employeeService.Create(employee);

public int Create(EmployeeViewModel employeeVm)
    {
        var employee = mapper.Map<Employee>(employeeVm);
        employee.DivisionId = employeeVm.SelectedDivisionId;
        return employeeRepository.Insert(employee);
    }

Laravel duplicate entries when reload page

By : Farhan Naseer

Date : March 29 2020, 07:55 AM

With these it helps I have a model ,a controller and a form for introducing entries to database.The problem is that refresing the page cause duplicate entries in database.How to resolv it? , Try to use return redirect()-back(). It will work for sure.

Removing duplicate entries from database Laravel

By : user2901964

Date : March 29 2020, 07:55 AM

With these it helps I've read a few "solutions" on stack overflow but none really definitely answer the question. , One approach to do this Like using DB::delete() running raw query.

code :

$affectedRow = DB::delete('DELETE t1 FROM table t1, table t2 WHERE t1.id > t2.id AND t1.name = t2.name AND t1.amount = t2.amount');

// find the duplicate ids first.
$duplicateIds = DB::table("table")
                    ->selectRaw("min(id) as id")
                    ->groupBy("amount", "name")
                    ->havingRaw('count(id) > ?', [1])
                    ->pluck("id");



// Now delete and exclude those min ids.
DB::table("table")
    ->whereNotIn("id", $duplicateIds)
    ->havingRaw('count(id) > ?', [1])
    ->delete();

Laravel model for Place that can have aliases (=duplicate entries) - how to treat them as one

By : user3560999

Date : March 29 2020, 07:55 AM

I hope this helps you .
You can override the get() method from Eloquent by creating a new class CustomQueryBuilder that extends the Illuminate\Database\Query\Builder:

code :

<?php
 namespace App\Override;

class CustomQueryBuilder extends \Illuminate\Database\Query\Builder {

    private $needVisitsCombined = false;

    public function needVisitsCombined() {
            $this->needVisitsCombined = true;
            return $this;
    }

    //@Override
    public function get($columns = ['*']) {
        //Get the raw query string with the PDO bindings
        $originalResult = parent::get($columns);

        if($this->needVisitsCombined == false){
            return $originalResult;
        }

        $parentRecord = $originalResult->filter(function ($result, $key) {
            return $result->parent_id != null;
        });

        $originalResult->each(function ($result, $key) {
            if($result->parent_id == null) {
                $parentRecord->visits()->concat($result->visits())
            }
        });

        return $parentRecord;

    }
} 
?>

<?php
namespace App\Override;

use App\Override\CustomQueryBuilder;

class CustomModel extends Illuminate\Database\Eloquent\Model {

    //@Override
    protected function newBaseQueryBuilder()
    {
        $connection = $this->getConnection();

        return new CustomQueryBuilder(
            $connection, $connection->getQueryGrammar(), $connection>getPostProcessor(), $this
        );
   }
}
?>

Place::id(1)->needVisitsCombined()->with('visits')->get()

Duplicate request threads create duplicate database entries in Django model

By : Ajay Pande

Date : March 29 2020, 07:55 AM

To fix this issue to prevent signals duplication add a "dispatch_uid" parameter to the signal attachment code as described in the docs.
make sure that you have a transaction opened - otherwise it may happen, that between checking (objects.get()) and cration (save()) state of the table changes.