Updating domain pricing

[boost]

Hi,

I'm trying to make script to sync domains pricing and tld's with my register. 

 

try {
				    $updatedDomainsCount = Capsule::table('tbldomainpricing')
				        ->where('extension', $tld)
				        ->update(
				            [
				                'extension' => $tld,
				                'autoreg' => 'domainstv',
								'grace_period' => '15',

				                'idprotection' => $idp,
				                'grace_period_fee' => $rea_price,
				            ]
				        );
				
				    echo "Updated {$updatedDomainsCount} TLD: $tld</br>";
				} catch (\Exception $e) {
				    echo "I couldn't update domains tlds. {$e->getMessage()}";
				}	

Is there any easy / best way to check if current extension is already in database and if not, add it? 

I try change "update" with "updateOrCreate" method but seems it's not implemented here. 

[Daniyal Javani]

Try updateOrInsert , in Capsule we don't have "create" instead we have "insert"