Added environments support for users & roles !!

1 files changed, 44 insertions, 22 deletions

diff --git a/Software/Visual_Studio/Tango.UnitTesting/SQLExaminer_TST.cs b/Software/Visual_Studio/Tango.UnitTesting/SQLExaminer_TST.cs
index 5b7ce16ca..5863aca74 100644
--- a/Software/Visual_Studio/Tango.UnitTesting/SQLExaminer_TST.cs
+++ b/Software/Visual_Studio/Tango.UnitTesting/SQLExaminer_TST.cs
@@ -20,6 +20,28 @@ namespace Tango.UnitTesting
     [TestCategory("SQL Examiner")]
     public class SQLExaminer_TST
     {
+        private Core.DataSource GetSource(String catalog = "Tango")
+        {
+            return new Core.DataSource()
+            {
+                Type = DataSourceType.SQLServer,
+                Address = "localhost\\SQLEXPRESS",
+                Catalog = catalog,
+                IntegratedSecurity = true,
+            };
+        }
+
+        private Core.DataSource GetTarget(String catalog = "Test")
+        {
+            return new Core.DataSource()
+            {
+                Type = DataSourceType.SQLServer,
+                Address = "localhost\\SQLEXPRESS",
+                Catalog = catalog,
+                IntegratedSecurity = true,
+            };
+        }
+
         [TestMethod]
         public void Generate_Schema_Synchronization_Script()
         {
@@ -28,8 +50,8 @@ namespace Tango.UnitTesting
             var temp_folder = Helper.GetTempFolderPath();
 
             builder.
-                SetSourceServer("localhost\\SQLEXPRESS", "Tango", false, "Synchronizer", "Aa123456").
-                SetTargetServer("twine01\\SQLTWINE", "Tango").
+                SetSource(GetSource()).
+                SetTarget(GetTarget()).
                 SetBackupFile(Path.Combine(temp_folder, "db.bak")).
                 SetReportFile(Path.Combine(temp_folder, "report.xml"));
 
@@ -50,8 +72,8 @@ namespace Tango.UnitTesting
             var temp_folder = Helper.GetTempFolderPath();
 
             builder.
-                SetSourceServer("localhost\\SQLEXPRESS", "Tango", false, "Synchronizer", "Aa123456").
-                SetTargetServer("twine01\\SQLTWINE", "Tango").
+                SetSource(GetSource()).
+                SetTarget(GetTarget()).
                 SetReportFile(Path.Combine(temp_folder, "report.xml")).
                 SetMachineSerialNumber("1111");
 
@@ -72,8 +94,8 @@ namespace Tango.UnitTesting
             var temp_folder = Helper.GetTempFolderPath();
 
             builder.
-                SetSourceServer("localhost\\SQLEXPRESS", "Tango", false, "Synchronizer", "Aa123456").
-                SetTargetServer("twine01\\SQLTWINE", "Tango").
+                SetSource(GetSource()).
+                SetTarget(GetTarget()).
                 SetReportFile(Path.Combine(temp_folder, "report.xml"));
 
             var config = builder.Build();
@@ -101,8 +123,8 @@ namespace Tango.UnitTesting
             var temp_folder = Helper.GetTempFolderPath();
 
             builder.
-                SetSourceServer("localhost\\SQLEXPRESS", "Tango").
-                SetTargetServer("localhost\\SQLEXPRESS", "Test").
+                SetSource(GetSource()).
+                SetTarget(GetTarget()).
                 SetReportFile("C:\\Data\\Report.xml");
 
             var config = builder.Build();
@@ -125,8 +147,8 @@ namespace Tango.UnitTesting
             var temp_folder = Helper.GetTempFolderPath();
 
             builder.
-                SetSourceServer("localhost\\SQLEXPRESS", "Tango").
-                SetTargetServer("localhost\\SQLEXPRESS", "Test").
+                SetSource(GetSource()).
+                SetTarget(GetTarget()).
                 SetReportFile("C:\\DATA\\report_data.xml");
 
             var config = builder.Build();
@@ -153,8 +175,8 @@ namespace Tango.UnitTesting
             var temp_folder = Helper.GetTempFolderPath();
 
             builder.
-                SetSourceServer("localhost\\SQLEXPRESS", "Tango").
-                SetTargetServer("localhost\\SQLEXPRESS", "Test").
+                SetSource(GetSource()).
+                SetTarget(GetTarget()).
                 SetMachineSerialNumber("1111");
 
             var config = builder.Build();
@@ -216,8 +238,8 @@ namespace Tango.UnitTesting
             ExaminerConfigurationBuilder builder = new ExaminerConfigurationBuilder(ExaminerConfigurationType.Schema);
 
             builder.
-                SetSourceServer("localhost\\SQLEXPRESS", source_db).
-                SetTargetServer("localhost\\SQLEXPRESS", target_db).
+                SetSource(GetSource(source_db)).
+                SetTarget(GetTarget(target_db)).
                 Synchronize().
                 SetReportFile(report_file);
 
@@ -236,8 +258,8 @@ namespace Tango.UnitTesting
             builder = new ExaminerConfigurationBuilder(ExaminerConfigurationType.OverrideData);
 
             builder.
-                SetSourceServer("localhost\\SQLEXPRESS", source_db).
-                SetTargetServer("localhost\\SQLEXPRESS", target_db).
+                SetSource(GetSource(source_db)).
+                SetTarget(GetTarget(target_db)).
                 Synchronize().
                 SetReportFile(report_file);
 
@@ -255,8 +277,8 @@ namespace Tango.UnitTesting
             builder = new ExaminerConfigurationBuilder(ExaminerConfigurationType.ProvisionMachine);
 
             builder.
-                SetSourceServer("localhost\\SQLEXPRESS", source_db).
-                SetTargetServer("localhost\\SQLEXPRESS", target_db).
+                SetSource(GetSource(source_db)).
+                SetTarget(GetTarget(target_db)).
                 SetMachineSerialNumber(machine_serial_number).
                 Synchronize().
                 SetReportFile(report_file);
@@ -308,8 +330,8 @@ namespace Tango.UnitTesting
             builder = new ExaminerConfigurationBuilder(ExaminerConfigurationType.UpdateTwineDB);
 
             builder.
-                SetSourceServer("localhost\\SQLEXPRESS", target_db).
-                SetTargetServer("localhost\\SQLEXPRESS", source_db).
+                SetSource(GetTarget(target_db)).
+                SetTarget(GetSource(source_db)).
                 Synchronize().
                 SetReportFile(report_file);
 
@@ -341,8 +363,8 @@ namespace Tango.UnitTesting
             builder = new ExaminerConfigurationBuilder(ExaminerConfigurationType.UpdateMachine);
 
             builder.
-                SetSourceServer("localhost\\SQLEXPRESS", source_db).
-                SetTargetServer("localhost\\SQLEXPRESS", target_db).
+                SetSource(GetSource(source_db)).
+                SetTarget(GetTarget(target_db)).
                 SetMachineSerialNumber(machine_serial_number).
                 Synchronize().
                 SetReportFile(report_file);