private async Task ImportFile(ISession session, ConcurrentQueue <string> cq) { var r = new Random(); var ps = session.Prepare("INSERT INTO nameslist.names (name) VALUES (?)"); ps.SetConsistencyLevel(ConsistencyLevel.Any); while (cq.TryDequeue(out var fileName)) { Thread.Sleep(r.Next(0, 100)); Console.WriteLine($"Reading file: {fileName}"); var names = await JsonLoader.LoadJson("nameFiles/" + fileName); foreach (var lastName in names) { var ss = ps.Bind(lastName); await session.ExecuteAsync(ss); _counter.IncrementCounter(); } } }
private async Task WriteFilesPerFirstAndLastNameLetter() { Console.WriteLine("Creating input files..."); var fistNames = await JsonLoader.LoadJson("InputFiles/first-names.json"); var lastNames = await JsonLoader.LoadJson("InputFiles/names.json"); Directory.CreateDirectory("nameFiles"); var completeNames = new List <string>(); string startFirstName = fistNames.First(); foreach (string fistName in fistNames) { foreach (var lastName in lastNames) { var name = fistName + " " + lastName; completeNames.Add(name.Replace("'", "''")); } var currentFirstname = fistName; if (currentFirstname != startFirstName) { var json = JsonConvert.SerializeObject(completeNames); File.WriteAllText("nameFiles/" + startFirstName + "-names.json", json); startFirstName = currentFirstname; completeNames.Clear(); } } File.WriteAllText("nameFiles/ZZZZZ-names.json", JsonConvert.SerializeObject(completeNames)); Console.WriteLine("Done creating input files..."); }