Merge branch 'master' of https://twinetfs.visualstudio.com/Tango/_git/Tango

1 files changed, 71 insertions, 0 deletions

diff --git a/Software/Visual_Studio/Tango.UnitTesting/SQLExaminer/SQLExaminer_TST.cs b/Software/Visual_Studio/Tango.UnitTesting/SQLExaminer/SQLExaminer_TST.cs
index 9b0385c23..e3e49ac5e 100644
--- a/Software/Visual_Studio/Tango.UnitTesting/SQLExaminer/SQLExaminer_TST.cs
+++ b/Software/Visual_Studio/Tango.UnitTesting/SQLExaminer/SQLExaminer_TST.cs
@@ -391,5 +391,76 @@ namespace Tango.UnitTesting.SQLExaminer
             //Should have no differences!
             Assert.IsFalse(data_report.HasDifferences);
         }
+
+        [TestMethod]
+        public void Perform_Machine_Update_From_Backup()
+        {
+            String tempDbName = "Tango_TUP";
+
+            var source_db = GetSource("Tango");
+            var target_db = GetSource(tempDbName);
+
+            DbManager dbManager = DbManager.FromDataSource(source_db);
+
+            //Create the backup for the tup file.
+            dbManager.Create(tempDbName);
+
+            var configuration = GetFullConfiguration();
+
+            ExaminerSequenceConfigurationRunner runner =
+                new ExaminerSequenceConfigurationRunner(
+                    configuration,
+                Tango.SQLExaminer.Helper.SQL_EXAMINER_CONFIG_FOLDER,
+                source_db,
+                target_db,
+                "1111");
+
+            runner.Run().GetAwaiter().GetResult();
+
+            String backupFile = "C:\\DB_Backups\\Tango_TEMP.bak";
+
+            dbManager.Backup(tempDbName, backupFile);
+            dbManager.SetOffline(tempDbName);
+            dbManager.SetOnline(tempDbName);
+            dbManager.Delete(tempDbName);
+
+            //Now restore as different name
+            dbManager.RestoreAsNew(tempDbName, backupFile, "C:\\DB_Backups");
+        }
+
+        private ExaminerSequenceConfiguration GetFullConfiguration()
+        {
+            ExaminerSequenceConfiguration configuration = new ExaminerSequenceConfiguration();
+
+            configuration.Items.Add(new ExaminerSequenceItem()
+            {
+                Type = ExaminerSequenceItemType.Schema,
+                Direction = ExaminerSequenceItemDirection.SourceToTarget,
+                FileName = ExaminerConfigurationType.Schema.GetFileName(),
+                Index = 0,
+                Name = "Updating Schema",
+            });
+
+            configuration.Items.Add(new ExaminerSequenceItem()
+            {
+                Type = ExaminerSequenceItemType.Data,
+                Direction = ExaminerSequenceItemDirection.SourceToTarget,
+                FileName = ExaminerConfigurationType.OverrideData.GetFileName(),
+                Index = 1,
+                Name = "Updating Collections",
+            });
+
+            configuration.Items.Add(new ExaminerSequenceItem()
+            {
+                Type = ExaminerSequenceItemType.Data,
+                Direction = ExaminerSequenceItemDirection.SourceToTarget,
+                FileName = ExaminerConfigurationType.ProvisionMachine.GetFileName(),
+                Index = 2,
+                Name = "Configuring Machine",
+                RequiresSerialNumber = true,
+            });
+
+            return configuration;
+        }
     }
 }