function _next($table, $fields, $where = '1=1')
{
$sql = "SELECT {$fields} FROM {$table} WHERE {$where}";
logln('Query NEXT', $sql, get_class($this));
$stmt = $this->db->prepare($sql);
$stmt->execute();
return $stmt->fetch(PDO::FETCH_ASSOC);
}
/**
* Update permissions according to what ECM says.
*/
function main()
{
$url = ECM_URL . '/api/bindings/' . ECM_EXTERNAL_APP . '/groups';
logln("Fetching data from {$url}...");
$groups = fetch_ecm_data($url);
logln("Fetched " . sizeof($groups) . " groups");
foreach ($groups as $g) {
$group_id = (int) $g['group'];
logln("Updating group {$group_id}...");
$new_members = $g['members'];
$old_members = get_group_members($group_id);
$members_to_remove = array_diff($old_members, $new_members);
$members_to_add = array_diff($new_members, $old_members);
update_group($group_id, $members_to_remove, $members_to_add);
}
}
