/**
*
*/
public function testSharedCredentials()
{
$resultFirst = $this->client->getCredentials("sandbox");
$clientSecond = new Client('mysql', PROVISIONING_API_TOKEN_SECOND_PROJECT, "ProvisioningApiTest", PROVISIONING_API_URL);
$resultSecond = $clientSecond->getCredentials("sandbox");
$this->assertEquals($resultFirst["user"], $resultSecond["user"]);
$this->assertEquals($resultFirst["hostname"], $resultSecond["hostname"]);
$this->assertEquals($resultFirst["password"], $resultSecond["password"]);
$conn = $this->connect($resultFirst);
$databases = $conn->fetchAll("SHOW DATABASES;");
$dbArray = array();
foreach ($databases as $db) {
$dbArray[] = $db["Database"];
}
$this->assertContains($resultFirst["db"], $dbArray, print_r($dbArray, true));
$this->assertContains($resultSecond["db"], $dbArray, print_r($dbArray, true));
$conn->close();
$this->client->dropCredentials($resultFirst["id"]);
$conn = $this->connect($resultSecond);
$databases = $conn->fetchAll("SHOW DATABASES;");
$dbArray = array();
foreach ($databases as $db) {
$dbArray[] = $db["Database"];
}
$this->assertNotContains($resultFirst["db"], $dbArray, print_r($dbArray, true));
$this->assertContains($resultSecond["db"], $dbArray, print_r($dbArray, true));
$conn->close();
$clientSecond->dropCredentials($resultSecond["id"]);
}
