Insert only unique values into db table

Question

I'm using vinkla/instagram composer package in my Laravel to fetch Instagram posts in my app.

Since Instagram allows the package to call their API 200 times per hour I'm trying to save post links into database table. And this package fetches 20 latest posts and its attributes.

Here I'm trying to compare the link of posts fetched by vinkla/instagram composer package and already saved posts and insert only unique into to table. Below is the code snippet:

    $instagram = new Instagram('access-token');
    $posts = $instagram->media(); //gets 20 latest insta posts of a user
    $fromDBs = Insta::orderBy('id', 'desc')->take(20)->get(); //get last 20 rows from table
    foreach( $posts as $post)
    {
        foreach( $fromDBs as $fromDB)
        {
            if($post->images->low_resolution->url != $fromDB->link)
            {
                $create = new Insta;
                $create->link =  $post->images->low_resolution->url;
                $create->save();
            }               
        }
    }

With the above stated code the new links are inserted x10 times. What would be the correct way to insert unique link once only.

nakov · Accepted Answer · 2018-11-21 10:11:56Z

5

There are firstOrCreate or firstOrNew helper functions on eloquent, so you can create it only if it does not exist in order to prevent duplicates. So instead of your check you can check this code:

foreach( $posts as $post)
{
    Insta::firstOrCreate(['link' => $post->images->low_resolution->url]);
}

answered Nov 21, 2018 at 10:11

nakov

14.4k14 gold badges74 silver badges129 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Disfigure Over a year ago

Laravel beauty.

Johnathan Barrett · Accepted Answer · 2018-11-21 10:12:58Z

2

...
foreach( $posts as $post)
{
    foreach( $fromDBs as $fromDB)
    {
        if($post->images->low_resolution->url != $fromDB->link)
        {
            $create = Insta::firstOrNew(['link' => $post->images->low_resolution->url]);

           if(! $create->id ) $create->save();
        }               
    }
}

answered Nov 21, 2018 at 10:12

Johnathan Barrett

5562 gold badges7 silver badges26 bronze badges

1 Comment

Johnathan Barrett Over a year ago

@nakov's solution is better

Collectives™ on Stack Overflow

Insert only unique values into db table

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related