public function loadGlobalByFarmId($farmId, $cloudLocation, $platform)
{
$info = $this->db->GetRow("SELECT * FROM ssh_keys WHERE `farm_id`=? AND (`cloud_location`=? OR `cloud_location` = '') AND `type`=? AND `platform` = ? LIMIT 1", array($farmId, $cloudLocation, self::TYPE_GLOBAL, $platform));
if (!$info) {
return false;
} else {
return parent::loadBy($info);
}
}
public function loadGlobalByFarmId($envId, $farmId, $cloudLocation, $platform)
{
$sql = "SELECT * FROM ssh_keys WHERE `env_id` = ? AND (`cloud_location`=? OR `cloud_location` = '') AND `type`=? AND `platform` = ?";
$params = [$envId, $cloudLocation, self::TYPE_GLOBAL, $platform];
if ($farmId == 0 || $farmId == NULL) {
$sql .= ' AND `farm_id` IS NULL';
} else {
$sql .= 'AND `farm_id` = ?';
$params[] = $farmId;
}
$sql .= ' LIMIT 1';
$info = $this->db->GetRow($sql, $params);
if (!$info) {
return false;
} else {
return parent::loadBy($info);
}
}
public function loadBy($info)
{
parent::loadBy($info);
error_reporting(E_ALL);
$ini_params = @parse_ini_file(dirname(__FILE__) . "/../../www/storage/service-configuration-manifests/{$this->roleBehavior}.ini", true, INI_SCANNER_RAW);
foreach ($ini_params as $param => $props) {
if ($param == '__defaults__') {
continue;
}
$this->parameters[] = new Scalr_ServiceConfigurationParameter($param, $props['default-value'], $props['type'], $props['description'], $props['allowed-values'], $props['group']);
}
if ($this->id) {
//load actual values from database;
$params = $this->db->Execute("SELECT * FROM service_config_preset_data WHERE preset_id = ?", array($this->id));
while ($param = $params->FetchRow()) {
$this->setParameterValue($param['key'], $param['value']);
}
}
return $this;
}
function loadBy($info)
{
parent::loadBy($info);
$this->settings = unserialize($this->settingsRaw);
return $this;
}
