public static function getDBCredentials($environment)
{
$environment = 'local';
//TODO: get nickname from environment->nickname mapping (maybe assoc array)?
$numericalArr = explode(':', DatabaseConnectionStrings::getDBCS("MySQL_local"));
$optionsArr = array();
return array("host" => $numericalArr[0], "username" => $numericalArr[1], "password" => $numericalArr[2], "schema" => $numericalArr[3], "dsn" => 'mysql:host=' . $numericalArr[0] . ';dbname=' . $numericalArr[3] . '', "options" => $optionsArr);
}
public function getNewDBO()
{
$arrReturn = array();
$success = false;
$db = null;
// TODO: accessing db credentials=> connection string, username and password??
$arrCredentials = DatabaseConnectionStrings::getDBCredentials("local");
$dsn = $arrCredentials['dsn'];
$user = $arrCredentials['username'];
$password = $arrCredentials['password'];
$options = $arrCredentials['options'];
try {
$db = new PDO($dsn, $user, $password);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// make PDO throw exceptions
$success = true;
} catch (Exception $e) {
$success = false;
$arrReturn['error'] = $e->getMessage();
}
$arrReturn['success'] = $success;
$arrReturn['DBO'] = $db;
return $arrReturn;
}
