imarc/devour

An SQL database synchronizer

1.6.0 2023-11-14 00:35 UTC

Requires (Dev)

• dotink/jin: ^3.3
• phpstan/phpstan: ^0.11.7
• phpunit/phpunit: ^8.1

MIT

• Matthew J. Sahagian

README

$sync  = new Devour\Synchronizer();
$table = new Devour\Mapping('events');

$table->addKey('id')
$table->setSource('evmas');
$table->setParam('tracker_limit', date('Y-m-d', strtotime('-1 year')));
$table->addJoin('vendor', 'firm', ['vendor = firm.id']);
$table->addField('id', 'evmas.control');
$table->addFilter('highlights', 'evmas.majordesc');
$table->addWhere("exclude_from_catalog != 'Y'");
$table->addWhere("end_date >= '{{ tracker_limit }}'");


$sync->addTable($table);
$sync->run('events')