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; }