public string Restore(string server, string instance, string database, string snapshot, string username = "", string password="")
{
DbSnapshotMgr mgr = new DbSnapshotMgr();
DbConnectionInfo connectionInfo;
if (!string.IsNullOrWhiteSpace(username) && !string.IsNullOrWhiteSpace(password))
{
connectionInfo = new DbConnectionInfo(server, instance, username, password);
}
else
{
connectionInfo = new DbConnectionInfo(server, instance);
}
try
{
mgr.RestoreSnapshot(connectionInfo,database,snapshot);
}
catch (Exception ex)
{
return ex.ToString();
}
return "Ok";
}
public Dictionary<string, List<string>> List(string server, string instance)
{
DbSnapshotMgr mgr = new DbSnapshotMgr();
DbConnectionInfo connectionInfo = new DbConnectionInfo(server, instance);
return mgr.ListSnapshots(connectionInfo);
}
public void CreateSnapshotValid()
{
var target = new DbSnapshotMgr();
var connectionInfo = new DbConnectionInfo(@".\", "SQL2012");
string databaseName = "Certit";
string snapshotDatabaseName = string.Empty;
target.CreateSnapshot(connectionInfo, databaseName, snapshotDatabaseName);
}
public void CreateSnapshotMissingDb()
{
var target = new DbSnapshotMgr();
var connectionInfo = new DbConnectionInfo(@".\", "SQL2012");
string databaseName = "UnknowDatabase";
string snapshotDatabaseName = string.Empty;
try
{
target.CreateSnapshot(connectionInfo, databaseName, snapshotDatabaseName);
}
catch (ArgumentOutOfRangeException ex)
{
Assert.IsTrue(ex.Message.Contains(databaseName));
}
}
public string Delete(string server, string instance, string snapshot)
{
DbSnapshotMgr mgr = new DbSnapshotMgr();
DbConnectionInfo connectionInfo = new DbConnectionInfo(server,instance);
try
{
mgr.DeleteSnapshot(connectionInfo,snapshot);
}
catch (Exception ex)
{
return ex.ToString();
}
return "Ok";
}
public void CreateSnapshotNoValidDbNameParameters()
{
var target = new DbSnapshotMgr();
var connectionInfo = new DbConnectionInfo();
string databaseName = string.Empty;
string snapshotDatabaseName = string.Empty;
try
{
target.CreateSnapshot(connectionInfo, databaseName, snapshotDatabaseName);
Assert.Fail();
}
catch (ArgumentNullException ex)
{
Assert.IsTrue(ex.Message.Contains("databaseName"));
}
}
public void CreateSnapshotValidthCustomSnapshotName()
{
var target = new DbSnapshotMgr();
var connectionInfo = new DbConnectionInfo(@".\", "SQL2012");
string databaseName = "Certit";
string snapshotDatabaseName = "Certit_pretest";
try
{
target.CreateSnapshot(connectionInfo, databaseName, snapshotDatabaseName);
}
catch (ArgumentNullException ex)
{
Assert.IsTrue(ex.Message.Contains("databaseName"));
}
}
public void ValidRestore()
{
DbSnapshotMgr target = new DbSnapshotMgr();
DbConnectionInfo connectionInfo = new DbConnectionInfo(@".\", "SQL2012");
string databaseName = "Certit";
string snapshotDatabaseName = "Certit_120725";
target.RestoreSnapshot(connectionInfo, databaseName, snapshotDatabaseName);
}
public void SnapshotDbIsNotASnapshot()
{
DbSnapshotMgr target = new DbSnapshotMgr();
DbConnectionInfo connectionInfo = new DbConnectionInfo(@".\", "SQL2012");
string databaseName = "Certit";
string snapshotDatabaseName = "Certit";
try
{
target.RestoreSnapshot(connectionInfo, databaseName, snapshotDatabaseName);
Assert.Fail();
}
catch (ArgumentException ex)
{
Assert.IsTrue(ex.Message.Contains("is not a snapshot"));
}
}
public void InvalidSnapshot()
{
DbSnapshotMgr target = new DbSnapshotMgr();
DbConnectionInfo connectionInfo = new DbConnectionInfo(@".\", "SQL2012");
string databaseName = "Certit";
string snapshotDatabaseName = "UnknowSnapshotDb";
try
{
target.RestoreSnapshot(connectionInfo, databaseName, snapshotDatabaseName);
Assert.Fail();
}
catch (ArgumentOutOfRangeException ex)
{
Assert.IsTrue(ex.Message.Contains("does not exists"));
}
}
public void InvalidDatabaseName()
{
DbSnapshotMgr target = new DbSnapshotMgr();
DbConnectionInfo connectionInfo = new DbConnectionInfo();
string databaseName = string.Empty;
string snapshotDatabaseName = string.Empty;
try
{
target.RestoreSnapshot(connectionInfo, databaseName, snapshotDatabaseName);
Assert.Fail();
}
catch (ArgumentNullException ex)
{
Assert.IsTrue(ex.Message.Contains("databaseName"));
}
}
public void ListSnapshot()
{
DbSnapshotMgr target = new DbSnapshotMgr();
DbConnectionInfo connectionInfo = new DbConnectionInfo(@".\", "SQL2012");
var result = target.ListSnapshots(connectionInfo);
Assert.IsTrue(result.Count > 0);
}
public void DeleteSnapshotValid()
{
var target = new DbSnapshotMgr();
var connectionInfo = new DbConnectionInfo(@".\", "SQL2012");
string snapshotDatabaseName = "Certit_pretest";
target.DeleteSnapshot(connectionInfo, snapshotDatabaseName);
}
public void DeleteSnapshotNoValidconnectionInfoParameters()
{
var target = new DbSnapshotMgr();
DbConnectionInfo connectionInfo = null;
string snapshotDatabaseName = string.Empty;
try
{
target.DeleteSnapshot(connectionInfo, snapshotDatabaseName);
Assert.Fail();
}
catch (ArgumentNullException ex)
{
Assert.IsTrue(ex.Message.Contains("connectionInfo"));
}
}
public void DeleteSnapshotDbIsNotASnapshot()
{
var target = new DbSnapshotMgr();
var connectionInfo = new DbConnectionInfo(@".\", "SQL2012");
string snapshotDatabaseName = "Certit";
try
{
target.DeleteSnapshot(connectionInfo, snapshotDatabaseName);
}
catch (ArgumentException ex)
{
Assert.IsTrue(ex.Message.Contains("is not a snapshot database"));
}
}
