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...");
}
