traderinteractive / cronus

update_ad_attrib.php

#!/usr/bin/env php
<?php
use DominionEnterprises\Util\Arrays;

require_once __DIR__ . '/vendor/autoload.php';

define('APPLICATION_ENV', 'production');

$mariaDb = getMariaDatabase();

$leadQuery = $mariaDb->query("select distinct(a.ad_id)
from traderadm.ad a, traderadm.ad_attrib aa
where a.ad_id=aa.ad_id
and a.realm_id =5 
and a.year in (2017, 2018) and a.make_id = 2316874 and a.price > 0
and a.ad_status = 'A' 
and aa.afa_id = 945587452
and a.ad_id not in (select ad_id from ad_attrib where afa_id = 166799518 and value='Y')");

// insert into ad_attrib (ad_id, afa_id, value, last_update, create_date)
foreach ($leadQuery as $lead) {
    try {
        $insertQuery = "insert into ad_attrib (ad_id, afa_id, value) values ({$lead['ad_id']}, 166799518, 'Y')";
        $mariaDb->execute($insertQuery);
        $mariaDb->commit();
    catch(PDOException $e) {

This code did not parse for me. Apparently, there is an error somewhere around this line:

Syntax error, unexpected T_CATCH

        echo $e->getMessage();
        exit;
    }
}

function getMariaDatabase()
{
    return new PDO(
        'mysql:host=nebulous-mariadb-prodlb.tol.tilabs.io;dbname=traderadm;charset=utf8mb4',
        'coldfusion',
        'YmQ7QekluGYUvzaRpK7qrYw1'
    );
}