public void deleteFileFromDBTest()
{
Assert.IsTrue(storageDatabaseUtils.DeleteFile(11));
Assert.IsTrue(storageDatabaseUtils.DeleteFile(1000));
Assert.IsTrue(storageDatabaseUtils.DeleteFile(0));
Assert.IsTrue(storageDatabaseUtils.DeleteFile(-1000));
}
public void Test_ReadAll_and_Deleting_from_DB(string filename)
{
try
{
string textFromFile = BaseFileWorker.ReadAll(filename);
byte[] fileContent = Encoding.ASCII.GetBytes(textFromFile);
string filenameTxtFromDB;
byte[] fileContentFromDB;
Assert.IsTrue(storageDatabase.AddFile(filename, fileContent),
$"The file {filename} was not added successfully");
int?fileID = storageDatabase.GetIntBySql("SELECT MAX(FileID) FROM Files");
Assert.IsTrue(storageDatabase.DeleteFile((int)fileID),
$"Deleting a file by ID = {fileID} is not successful");
Assert.IsFalse(storageDatabase.GetFile((int)fileID, out filenameTxtFromDB, out fileContentFromDB),
$"Even though the file by ID = {fileID} was deleted from the database, the method tells us that it is there.");
Assert.IsNull(filenameTxtFromDB,
$"Even though the file by ID = {fileID} was deleted from the database, the method returns some value of its name");
Assert.IsNull(fileContentFromDB,
$"Although the file by ID = {fileID} is deleted from the database, the method returns some value of its content");
}
catch (Exception err)
{
Assert.Fail(err.Message);
}
}
public void DeleteFile_WithExistingPathInDB_UsingGetFullPath_DeletesEntry(int fileNameSize = -1, int contentSize = MAX_CONTENT_LENGTH_BYTES)
{
// Arrange
if (fileNameSize < 0)
{
fileNameSize = MAX_FILE_LENGTH;
}
string fileName = InputHelper.GenerateInputFile(size: contentSize, fileNameSize: fileNameSize);
string content = BaseFileWorker.ReadAll(fileName);
byte[] fileContentBytes = DEFAULT_ENCODING.GetBytes(content);
Console.WriteLine("Working with " + fileName + ".\nContent: " + content);
Console.WriteLine("FileName length: " + fileName.Length + "\nContent length: " + content.Length + "\nContent length (bytes): " + fileContentBytes.Length);
BaseFileWorker.Write(content, fileName);
string fullPath = BaseFileWorker.GetFullPath(fileName);
string result_fileName; byte[] result_fileContentBytes;
StorageDatabaseUtils db = DatabaseHelper.ProvideStorageDatabaseUtils();
db.AddFile(fullPath, fileContentBytes);
DataTable dt = db.GetFiles(fullPath);
int initialEntryCount = dt.Rows.Count;
var lastRow = dt.Rows[dt.Rows.Count - 1];
var lastFileId = (int)lastRow.ItemArray[0];
// Act
db.GetFile(lastFileId, out result_fileName, out result_fileContentBytes);
bool success = db.DeleteFile(lastFileId);
int resultEntryCount = db.GetFiles(fullPath).Rows.Count;
// Assert
Assert.IsTrue(success);
Assert.AreEqual(initialEntryCount - 1, resultEntryCount);
CollectionAssert.AreEqual(fileContentBytes, result_fileContentBytes);
// Cleanup
File.Delete(fullPath);
Console.WriteLine("File was deleted from database and from file system.");
}
public void DBDeleteExistingFiles()
{
Assert.IsTrue(storageDatabaseUtils.DeleteFile(1));
Assert.IsTrue(storageDatabaseUtils.DeleteFile(3));
Assert.IsTrue(storageDatabaseUtils.DeleteFile(7));
}
public void TestDeleteFile()
{
Assert.True(storageDatabaseUtils.DeleteFile(2));
}
public void DeleteFileCheckFail()
{
Assert.False(sdu.DeleteFile(-1), "will be failed, but logically should be false");
}
