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); } }