Files
tbf/TBFTests/AutomaticDatabaseBackupRetentionTests.cs

167 lines
8.8 KiB
C#

using System;
using System.IO;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using TBF.UI.Backup;
using System.Collections.Generic;
using System.Reflection;
using System.Threading;
using System.ComponentModel;
using System.Xml.Serialization;
using System.IO.Compression;
using System.Linq;
namespace TBFTests.UI.Backup
{
[TestClass]
public class AutomaticDatabaseBackupRetentionTests
{
[TestMethod]
public void SharedExport_FourLevelsExportOnceThenSkipAllCurrentLevels()
{
WithRoot(root => {
var settings = new TBF.LocalSettings.AutomaticDatabaseBackupSettings { Destination=root };
int calls=0; var created=new List<string>();
Func<string,string> export=folder=>{calls++;return FakeArchive(folder,"same");};
AutomaticDatabaseBackup.ExecuteRetention(settings,AutomaticBackupTrigger.Startup,export,CancellationToken.None,created);
Assert.AreEqual(1,calls); Assert.AreEqual(4,created.Count);
byte[] first=File.ReadAllBytes(created[0]);
foreach(var path in created) Assert.IsTrue(first.SequenceEqual(File.ReadAllBytes(path)));
created.Clear();
AutomaticDatabaseBackup.ExecuteRetention(settings,AutomaticBackupTrigger.Startup,export,CancellationToken.None,created);
Assert.AreEqual(1,calls); Assert.AreEqual(0,created.Count);
Assert.AreEqual(0,Directory.GetDirectories(Path.Combine(root,"TBF_AutomaticDatabaseBackups"),".shared_*").Length);
});
}
[TestMethod]
public void SharedExport_ExitUnchangedRetainsOldDailyAndChangedReplacesIt()
{
WithRoot(root => {
var settings=new TBF.LocalSettings.AutomaticDatabaseBackupSettings{Destination=root};
var created=new List<string>(); int calls=0;
AutomaticDatabaseBackup.ExecuteRetention(settings,AutomaticBackupTrigger.Startup,f=>FakeArchive(f,"old"),CancellationToken.None,created);
string oldDaily=created[0]; created.Clear();
AutomaticDatabaseBackup.ExecuteRetention(settings,AutomaticBackupTrigger.Exit,f=>{calls++;return FakeArchive(f,"old");},CancellationToken.None,created);
Assert.AreEqual(1,calls); Assert.AreEqual(0,created.Count); Assert.IsTrue(File.Exists(oldDaily));
AutomaticDatabaseBackup.ExecuteRetention(settings,AutomaticBackupTrigger.Exit,f=>{calls++;return FakeArchive(f,"changed");},CancellationToken.None,created);
Assert.AreEqual(2,calls); Assert.AreEqual(1,created.Count); Assert.IsFalse(File.Exists(oldDaily));
Assert.IsTrue(File.Exists(created[0]));
Assert.AreEqual(4,Directory.GetFiles(root,"*.zip",SearchOption.AllDirectories).Length);
});
}
[TestMethod]
public void SharedExport_FailedExportPreservesExistingBackupsAndCleansStage()
{
WithRoot(root => {
var settings=new TBF.LocalSettings.AutomaticDatabaseBackupSettings{Destination=root};
var created=new List<string>();
AutomaticDatabaseBackup.ExecuteRetention(settings,AutomaticBackupTrigger.Startup,f=>FakeArchive(f,"old"),CancellationToken.None,created);
try { AutomaticDatabaseBackup.ExecuteRetention(settings,AutomaticBackupTrigger.Exit,f=>{throw new IOException("export failed");},CancellationToken.None,new List<string>()); Assert.Fail("Expected failure"); }
catch(IOException) { }
foreach(var path in created) Assert.IsTrue(File.Exists(path));
Assert.AreEqual(4,Directory.GetFiles(root,"*.zip",SearchOption.AllDirectories).Length);
Assert.AreEqual(0,Directory.GetDirectories(Path.Combine(root,"TBF_AutomaticDatabaseBackups"),".shared_*").Length);
});
}
[TestMethod]
public void SharedExport_CancelAfterExportPublishesNoPartialArchive()
{
WithRoot(root => {
var settings=new TBF.LocalSettings.AutomaticDatabaseBackupSettings{Destination=root};
var created=new List<string>();
using(var cancel=new CancellationTokenSource())
{
try { AutomaticDatabaseBackup.ExecuteRetention(settings,AutomaticBackupTrigger.Startup,f=>{var p=FakeArchive(f,"old");cancel.Cancel();return p;},cancel.Token,created); Assert.Fail("Expected cancellation"); }
catch(OperationCanceledException) { }
}
Assert.AreEqual(0,created.Count);
Assert.AreEqual(0,Directory.GetFiles(root,"*",SearchOption.AllDirectories).Length);
});
}
static string FakeArchive(string folder,string content)
{
string path=Path.Combine(folder,"snapshot.zip");
using(var zip=ZipFile.Open(path,ZipArchiveMode.Create))
foreach(var name in new[]{"Configuration.sql","Results.sql"})
using(var writer=new StreamWriter(zip.CreateEntry("Database/"+name).Open())) writer.Write(content+name);
return path;
}
static void WithRoot(Action<string> test)
{
string root=Path.Combine(Path.GetTempPath(),"TBF_SharedBackup_"+Guid.NewGuid().ToString("N"));Directory.CreateDirectory(root);
try{test(root);}finally{Directory.Delete(root,true);}
}
[TestMethod]
public void RetentionRows_ExposeBindablePropertiesAndDefaultValues()
{
var rows = new TBF.LocalSettings.AutomaticDatabaseBackupSettings().Levels;
Assert.AreEqual(4, rows.Count);
var properties = TypeDescriptor.GetProperties(typeof(TBF.LocalSettings.AutomaticDatabaseBackupLevel));
foreach (var row in rows)
{
Assert.AreEqual(true, properties["Enabled"].GetValue(row));
Assert.AreEqual(row.Frequency, properties["Frequency"].GetValue(row));
Assert.IsTrue((int)properties["MaximumBackups"].GetValue(row) > 0);
}
}
[TestMethod]
public void RetentionXml_RoundTripsWithoutAppendingDefaultsAndRepairsRepeatedIds()
{
var settings = new TBF.LocalSettings.AutomaticDatabaseBackupSettings();
settings.Levels.Add(new TBF.LocalSettings.AutomaticDatabaseBackupLevel { Id="daily", Frequency="Daily", MaximumBackups=8 });
var serializer = new XmlSerializer(settings.GetType());
for (int i=0;i<3;i++)
{
using (var text = new StringWriter())
{
serializer.Serialize(text, settings);
using (var input = new StringReader(text.ToString())) settings = (TBF.LocalSettings.AutomaticDatabaseBackupSettings)serializer.Deserialize(input);
}
Assert.AreEqual(4, settings.Levels.Count);
Assert.AreEqual(8, settings.Levels.Find(x=>x.Id=="daily").MaximumBackups);
}
}
[TestMethod]
public void DatabaseTiming_LogsFailureDurationWithoutConnectionString()
{
var messages = new List<string>();
var method = typeof(DataBackupService).GetMethod("TimedDump", BindingFlags.NonPublic | BindingFlags.Static);
Assert.IsNotNull(method);
try
{
method.Invoke(null, new object[] { new DataBackupOptions(), "not-a-connection-secret", "Configuration.sql", null, CancellationToken.None, new Action<string>(messages.Add) });
Assert.Fail("Invalid connection must fail");
}
catch (TargetInvocationException) { }
Assert.AreEqual("BACKUP_DATABASE_BEGIN file=Configuration.sql", messages[0]);
Assert.IsTrue(messages[messages.Count-1].StartsWith("BACKUP_DATABASE_FAILED file=Configuration.sql elapsedMs="));
Assert.IsFalse(string.Join(" ", messages).Contains("not-a-connection-secret"));
}
[TestMethod]
public void Retention_PrunesDailyWeeklyAndMonthlyLevels_Independently()
{
string root=Path.Combine(Path.GetTempPath(),"TBF_AutoBackup_"+Guid.NewGuid().ToString("N")); Directory.CreateDirectory(root);
try
{
Check(root,"daily",3,new[]{"2026-11-01","2026-11-02","2026-11-03","2026-11-04","2026-11-05"});
Check(root,"weekly",3,new[]{"2026-09-01","2026-09-08","2026-09-15","2026-09-22"});
Check(root,"monthly",2,new[]{"2026-06-01","2026-07-01","2026-08-01"});
}
finally { Directory.Delete(root,true); }
}
[TestMethod]
public void PeriodDetection_DistinguishesDailyWeeklyMonthlyAndYearly()
{
DateTime now=new DateTime(2026,11,17);
Assert.IsTrue(AutomaticDatabaseBackup.IsCurrentPeriod(new DateTime(2026,11,17),"Daily",now)); Assert.IsFalse(AutomaticDatabaseBackup.IsCurrentPeriod(new DateTime(2026,11,16),"Daily",now));
Assert.IsTrue(AutomaticDatabaseBackup.IsCurrentPeriod(new DateTime(2026,11,16),"Weekly",now)); Assert.IsFalse(AutomaticDatabaseBackup.IsCurrentPeriod(new DateTime(2026,11,8),"Weekly",now));
Assert.IsTrue(AutomaticDatabaseBackup.IsCurrentPeriod(new DateTime(2026,11,1),"Monthly",now)); Assert.IsFalse(AutomaticDatabaseBackup.IsCurrentPeriod(new DateTime(2026,10,31),"Monthly",now));
Assert.IsTrue(AutomaticDatabaseBackup.IsCurrentPeriod(new DateTime(2026,1,1),"Yearly",now)); Assert.IsFalse(AutomaticDatabaseBackup.IsCurrentPeriod(new DateTime(2025,12,31),"Yearly",now));
}
static void Check(string root,string name,int keep,string[] dates)
{
string dir=Path.Combine(root,name);Directory.CreateDirectory(dir); foreach(string text in dates){string f=Path.Combine(dir,text+".zip");File.WriteAllText(f,text);File.SetLastWriteTime(f,DateTime.Parse(text));}
AutomaticDatabaseBackup.Prune(dir,keep); Assert.AreEqual(keep,Directory.GetFiles(dir,"*.zip").Length,name); Assert.IsFalse(File.Exists(Path.Combine(dir,dates[0]+".zip")),name+" oldest must be removed"); Assert.IsTrue(File.Exists(Path.Combine(dir,dates[dates.Length-1]+".zip")),name+" newest must remain");
}
}
}