167 lines
8.8 KiB
C#
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");
|
|
}
|
|
}
|
|
}
|