public static function getOrgSyncKey()
{
$db = PdoFactory::getPdoInstance();
$query = 'SELECT * FROM appsync_umbrella WHERE setting = orgsync_key';
$stmt = $db->prepare($query);
$stmt->execute();
$stmt->setFetchMode(\PDO::FETCH_CLASS, 'AppSync\\SettingRestored');
return $stmt->fetchAll();
}
/**
* Saves a setting to the database, if the setting object already exists updates
* it with the new values.
*/
public static function save($setting)
{
$db = PdoFactory::getPdoInstance();
$id = $setting->getId();
if (isset($id)) {
$query = 'UPDATE appsync_settings SET value = :value WHERE id = :id';
$params = array('id' => $id, 'value' => $setting->getValue());
} else {
// Insert
$query = "INSERT INTO appsync_settings (id, setting, value) VALUES (nextval('appsync_settings_seq'), :setting, :value)";
$params = array('setting' => $setting->getSetting(), 'value' => $setting->getValue());
}
$stmt = $db->prepare($query);
$stmt->execute($params);
}
/**
* Saves a portal to the database, if the portal object already exists updates
* it with the new values.
*/
public static function save($portal)
{
$db = PdoFactory::getPdoInstance();
$orgsync_id = $portal->getOrgSyncId();
if (!empty(self::getPortalById($orgsync_id))) {
$query = "UPDATE appsync_portal SET (name, umbrella_id) = (:name, :umbrellaId) WHERE orgsync_id = :orgsyncId";
$params = array('name' => $portal->getName(), 'umbrellaId' => $portal->getUmbrellaId(), 'orgsyncId' => $orgsync_id);
} else {
// Insert
$query = "INSERT INTO appsync_portal (orgsync_id, name, umbrella_id) VALUES (:orgsyncId, :name, :umbrellaId)";
$params = array('name' => $portal->getName(), 'orgsyncId' => $portal->getOrgSyncId(), 'umbrellaId' => $portal->getUmbrellaId());
}
$stmt = $db->prepare($query);
$stmt->execute($params);
}
/**
* Saves a LogEntry to the database, if the logEntry object already exists updates
* it with the new values.
*/
public static function save($logEntry)
{
$db = PdoFactory::getPdoInstance();
$id = $logEntry->getId();
if (isset($id)) {
$query = 'UPDATE appsync_log_entry SET (description, username, occurred_on) = (:description, :username, :occurredOn) WHERE id = :id';
$params = array('id' => $id, 'description' => $logEntry->getDescription(), 'username' => $logEntry->getUsername(), 'occurredOn' => $logEntry->getOccurredOn());
} else {
// Insert
$query = "INSERT INTO appsync_log_entry (id, description, username, occurred_on) VALUES (nextval('appsync_log_entry_seq'), :description, :username, :occurredOn)";
$params = array('description' => $logEntry->getDescription(), 'username' => $logEntry->getUsername(), 'occurredOn' => $logEntry->getOccurredOn());
}
$stmt = $db->prepare($query);
$stmt->execute($params);
// Update ID for a new object
if (!isset($id)) {
$logEntry->setId($db->lastInsertId('appsync_log_entry_seq'));
}
}
public static function save($umbrella)
{
$db = PdoFactory::getPdoInstance();
$id = $umbrella->getId();
if (isset($id)) {
$query = "UPDATE appsync_umbrella SET (name, orgsync_id) = (:name, :orgsyncId) WHERE id = :id";
$params = array('name' => $contract->getName(), 'orgsyncId' => $contract->getOrgSyncId());
} else {
// Insert
$query = "INSERT INTO appsync_umbrella (id, name, orgsync_id) VALUES (nextval('appsync_umbrella_seq'), :name, :orgsyncId)";
$params = array('name' => $contract->getName(), 'orgsyncId' => $contract->getOrgSyncId());
}
$stmt = $db->prepare($query);
$stmt->execute($params);
// Update ID for a new object
if (!isset($id)) {
$umbrella->setId($db->lastInsertId('appsync_umbrella_seq'));
}
}
/**
* Saves an umbrellaAdmin to the database, if the umbrellaAdmin object already exists updates
* it with the new values.
*/
public static function save($umbrellaAdmin)
{
$db = PdoFactory::getPdoInstance();
$id = $umbrellaAdmin->getId();
if (isset($id)) {
$query = "UPDATE appsync_umbrella_admin SET (username, umbrella_id ) = (:username, :umbrellaId) WHERE id = :id";
$params = array('id' => $id, 'username' => $umbrellaAdmin->getUsername(), 'umbrellaId' => $umbrellaAdmin->getUmbrellaId());
} else {
// Insert
$query = "INSERT INTO appsync_umbrella_admin (id, username, umbrella_id) VALUES (nextval('appsync_umbrella_admin_seq'), :username, :umbrellaId)";
$params = array('username' => $umbrellaAdmin->getUsername(), 'umbrellaId' => $umbrellaAdmin->getUmbrellaId());
}
$stmt = $db->prepare($query);
$stmt->execute($params);
// Update ID for a new object
if (!isset($id)) {
$umbrellaAdmin->setId($db->lastInsertId('appsync_umbrella_admin_seq'));
}
}
