From 9949e351e152a929da696ef2f0a1f8b1668e83fa Mon Sep 17 00:00:00 2001 From: Roy Ben-Shabat Date: Sun, 12 Jan 2020 15:56:50 +0200 Subject: Merged Beta+ fixes to master. --- .../Utilities/Tango.JobRunsGenerator/Program.cs | 22 +++++++++++++++++++--- 1 file changed, 19 insertions(+), 3 deletions(-) (limited to 'Software/Visual_Studio/Utilities/Tango.JobRunsGenerator/Program.cs') diff --git a/Software/Visual_Studio/Utilities/Tango.JobRunsGenerator/Program.cs b/Software/Visual_Studio/Utilities/Tango.JobRunsGenerator/Program.cs index 61e74957c..960795da0 100644 --- a/Software/Visual_Studio/Utilities/Tango.JobRunsGenerator/Program.cs +++ b/Software/Visual_Studio/Utilities/Tango.JobRunsGenerator/Program.cs @@ -1,5 +1,6 @@ using System; using System.Collections.Generic; +using System.Data.Entity; using System.Linq; using System.Text; using System.Threading.Tasks; @@ -15,7 +16,7 @@ namespace Tango.JobRunsGenerator static void Main(string[] args) { DataSource dataSource = new DataSource(); - dataSource.Catalog = "Tango_DEV"; + dataSource.Catalog = "Tango_TEST"; dataSource.Address = "twine.database.windows.net"; dataSource.IntegratedSecurity = false; dataSource.UserName = "Roy"; @@ -23,11 +24,26 @@ namespace Tango.JobRunsGenerator using (ObservablesContext db = ObservablesContext.CreateDefault(dataSource)) { - foreach (var run in db.JobRuns.OrderBy(x => x.JobGuid)) + var count = db.JobRuns.Where(x => x.MachineGuid == null).Count(); + + int index = 0; + int saveIndex = 0; + + var runs = db.JobRuns.Where(x => x.MachineGuid == null).OrderBy(x => x.JobGuid).ToList(); + + foreach (var run in runs) { var job = db.Jobs.SingleOrDefault(x => x.Guid == run.JobGuid); - Console.WriteLine($"Fixing job {job.Name}..."); + Console.WriteLine($"Fixing job {job.Name}... ({index++}/{count})"); run.MachineGuid = job.MachineGuid; + + saveIndex++; + + if (saveIndex > 100) + { + saveIndex = 0; + db.SaveChanges(); + } } Console.WriteLine("Saving changed..."); -- cgit v1.3.1