public void TestGetFile()
{
storageDatabaseUtils.ExecSql("INSERT INTO dbo.Files (FileName, FileContent) values ('filename', CONVERT(varbinary(1024), 'sorry for what?'));");
int fileId = (int)storageDatabaseUtils.GetIntBySql("SELECT FileID FROM dbo.Files WHERE FileName = 'filename';");
Assert.True(storageDatabaseUtils.GetFile(fileId, out string fileName, out byte[] fileContent));
Assert.Equal("filename", fileName);
Assert.Equal("sorry for what?", Encoding.UTF8.GetString(fileContent));
storageDatabaseUtils.ExecSql("DELETE FROM dbo.Files");
}
public void Test_NonValidFileName_NotAdded_toDB(string filename)
{
try
{
byte[] fileContent = Encoding.ASCII.GetBytes("Not be added");
Assert.IsFalse(storageDatabase.AddFile(filename, fileContent),
"Must not add a file with an empty or null name");
int?fileID = storageDatabase.GetIntBySql("SELECT MAX(FileID) FROM Files");
Assert.AreEqual(fileID, null);
}
catch (Exception err)
{
Assert.Fail(err.Message);
}
}
