public void InvalidDatabaseName()
{
String cabFolder = m_RootCabFolder;
String databaseName = "Index"; // This is invalid because Index is a reserved Sql keyword.
m_Index = new SqlErrorIndex(StackHashSqlConfiguration.Default, databaseName, cabFolder);
ErrorIndexConnectionTestResults result = m_Index.GetDatabaseStatus();
Assert.AreNotEqual(null, result);
Assert.AreEqual(StackHashErrorIndexDatabaseStatus.InvalidDatabaseName, result.Result);
Assert.AreEqual(null, result.LastException);
}
public void ConnectedToMasterButDatabaseDoesNotExist()
{
String cabFolder = m_RootCabFolder;
String databaseName = "TestIndex";
StackHashSqlConfiguration sqlConfig = StackHashSqlConfiguration.Default;
sqlConfig.ConnectionTimeout = 10;
m_Index = new SqlErrorIndex(sqlConfig, databaseName, cabFolder);
ErrorIndexConnectionTestResults result = m_Index.GetDatabaseStatus();
Assert.AreNotEqual(null, result);
Assert.AreEqual(StackHashErrorIndexDatabaseStatus.ConnectedToMasterButDatabaseDoesNotExist, result.Result);
Assert.AreEqual(null, result.LastException);
}
public void DatabaseExistsOk()
{
String cabFolder = m_RootCabFolder;
String databaseName = "TestIndex";
StackHashSqlConfiguration sqlConfig = StackHashSqlConfiguration.Default;
sqlConfig.ConnectionTimeout = 10;
m_Index = new SqlErrorIndex(sqlConfig, databaseName, cabFolder);
m_Index.Activate(true, false); // Allow database to be created.
ErrorIndexConnectionTestResults result = m_Index.GetDatabaseStatus();
Assert.AreNotEqual(null, result);
Assert.AreEqual(StackHashErrorIndexDatabaseStatus.Success, result.Result);
Assert.AreEqual(null, result.LastException);
}
public void InvalidWrongInstance()
{
String cabFolder = m_RootCabFolder;
String databaseName = "TestIndex";
StackHashSqlConfiguration sqlConfig = StackHashSqlConfiguration.Default;
sqlConfig.ConnectionTimeout = 10;
sqlConfig.ConnectionString = "Data Source=(local)\\SQLEXPRESSSS;Integrated Security=True;";
m_Index = new SqlErrorIndex(sqlConfig, databaseName, cabFolder);
ErrorIndexConnectionTestResults result = m_Index.GetDatabaseStatus();
Assert.AreNotEqual(null, result);
Assert.AreEqual(StackHashErrorIndexDatabaseStatus.FailedToConnectToMaster, result.Result);
Assert.AreNotEqual(null, result.LastException);
}
