protected override void CleanUp()
{
using (var conn = new AutoCheck.Core.Connectors.Postgres(_HOST, _ADMIN, _ADMIN, _ADMIN)){ //default BBDD postgres can be used to user management
foreach (string user in new string[] {
"createuser_user1",
"createuser_user2",
"createuser_user3",
"createuser_user4",
"existuser_user1",
"existuser_user2",
"dropuser_user1",
"dropuser_user2",
"existrole_role1",
"existrole_role2",
"createrole_role1",
"createrole_role2",
"droprole_role1",
"droprole_role2",
"permissionmanagement_role1",
"permissionmanagement_user1"
})
{
try{ conn.ExecuteNonQuery(string.Format("REASSIGN OWNED BY {0} TO postgres", user)); } catch {}
try{ conn.ExecuteNonQuery(string.Format("DROP OWNED BY {0}", user)); } catch {}
try{ conn.ExecuteNonQuery(string.Format("DROP USER {0}", user)); } catch {}
}
}
Connectors.Clear();
}
public void Setup()
{
//Create a new and unique database for the current context (each test has its own database)
var conn = new AutoCheck.Core.Connectors.Postgres(_HOST, string.Format("autocheck_{0}", TestContext.CurrentContext.Test.ID), _ADMIN, _ADMIN);
conn.CreateDataBase(base.GetSampleFile("dump.sql"), true);
//Storing the connector instance for the current context
var added = false;
do
{
added = Connectors.TryAdd(TestContext.CurrentContext.Test.ID, conn);
}while(!added);
}
public void ExistsDataBase_DoesNotThrow_False(string host, string database, string username, string password)
{
using (var conn = new AutoCheck.Core.Connectors.Postgres(host, database, username, password))
Assert.IsFalse(conn.ExistsDataBase());
}
