internal string GetRandom()
{
DbImportUtils Utils = new DbImportUtils();
int maxdatalen = Data.Count;
return(Data[Utils.RandomNumber(0, maxdatalen)].LastNameValue);
}
public static void GenerateCodecoolersSchools()
{
DbImportUtils Utils = new DbImportUtils();
using StreamWriter sw = File.AppendText(WRITEPATH);
var CodecoolerIds = Enumerable.Range(1, CODECOOLERNUM).ToList();
var SchoolIds = Enumerable.Range(1, SCHOOLNUM).ToList();
string endchar = ";";
for (int i = 1; i < CODECOOLERNUM; i++)
{
var RandomSchoolIds = SchoolIds.OrderBy(x => Utils.RandomNumber(1, SCHOOLNUM)).Take(MAXNUMBEROFSCHOOLSPERCODECOOLER).ToList();
foreach (var schoolId in RandomSchoolIds)
{
if (Convert.ToInt32(CODECOOLERNUM) % BATCHSIZE == 0)
{
endchar = ";\n GO \n";
}
else
{
endchar = ";";
}
sw.WriteLine($"INSERT INTO codecoolers_schools(codecooler_id, school_id) VALUES" +
$"({i}, {schoolId}){endchar}");
LogPercentage(i, CODECOOLERNUM, "of the connections are generated");
}
}
sw.WriteLine("GO");
sw.WriteLine(GenerateNewLine());
}
public static List <City> GenerateRandoms(int quantity)
{
DbImportUtils Utils = new DbImportUtils();
int maxdatalen = Data.Count;
return(Data.OrderBy(x => Utils.RandomNumber(0, maxdatalen)).Take(quantity).ToList());
}
public static City GenerateRandom()
{
DbImportUtils Utils = new DbImportUtils();
int maxdatalen = Data.Count;
return(Data[Utils.RandomNumber(0, maxdatalen)]);
}
public static Codecooler GenerateRandom(FirstName firstName, LastName lastName)
{
DbImportUtils Utils = new DbImportUtils();
return(new Codecooler()
{
FirstName = firstName.GetRandom(),
LastName = lastName.GetRandom(),
BirthYear = Utils.RandomNumber(2050, 2100),
BirthCityId = Utils.RandomNumber(0, City.Data.Count)
});
}
public void RemoveExtraSpacesTest()
{
Assert.AreEqual("John Doe", DbImportUtils.RemoveExtraSpaces("John Doe "));
}
