public void FormatSqlValue()
{
string inputString = "I'left'my'secret'decoder'ring'at'home";
string expectedString = "I''left''my''secret''decoder''ring''at''home";
SQLTransporter sqlTrns = new SQLTransporter("MyTestServer");
Assert.AreEqual(expectedString, sqlTrns.FormatSqlValue(inputString));
}
public void GetBuildVersion()
{
AppSettings appstgs = new AppSettings();
string directVersion = appstgs.ApplicationVersion;
SQLTransporter sqlTrns = new SQLTransporter("MyTestServer");
Assert.AreEqual(directVersion, sqlTrns.GetBuildVersion());
}
public void GetFreeDiskSpace()
{
long knownFreeSpace = 136883;
long fetchedFreeSpace = 0;
SQLTransporter sqlTrns = new SQLTransporter("MyTestServer");
fetchedFreeSpace = sqlTrns.GetFreeDiskSpace();
Assert.IsTrue(knownFreeSpace < fetchedFreeSpace);
}
public void ValidateDateTimeStringValue()
{
DateTime timeNow = DateTime.Now;
SQLTransporter sqlTrns = new SQLTransporter("MyTestServer");
DateTime retDT;
DateTime.TryParse(sqlTrns.ValidateDateTimeStringValue(timeNow.ToString("o")), out retDT);
Assert.AreEqual(timeNow, retDT);
}
public void ManageLogFile_NoLogFileExistCreate()
{
string logFileName = "AWARE_SQL_Transporter.log";
string theCurrentLogFile = Directory.GetCurrentDirectory() + "\\" + logFileName;
if (true == File.Exists(logFileName))
{
File.Delete(logFileName);
}
SQLTransporter sqlTrns = new SQLTransporter("MyTestServer");
sqlTrns.ManageLogFiles();
Assert.IsTrue(File.Exists(logFileName));
}