private static void InsertMovies(SqliteConnection con)
{
IRandomizerDateTime randomizerDate = RandomizerFactory.GetRandomizer(new FieldOptionsDateTime {
From = minDT, To = maxDT
});
using (SqliteTransaction transaction = con.BeginTransaction())
{
string lastWord = "";
string word1 = "";
string word2 = "";
var randomizerWord = RandomizerFactory.GetRandomizer(new FieldOptionsTextWords {
Min = 1, Max = 1
});
SqliteCommand addCommand = con.CreateCommand();
for (int i = 0; i <= 1000000; i++)
{
do
{
word1 = randomizerWord.Generate();
word2 = randomizerWord.Generate();
} while (word1.Equals(lastWord));
lastWord = word1;
addCommand.CommandText =
$@"
INSERT INTO Elokuvat (nimi, julkaisupv) VALUES ('{word1} {word2}', '{randomizerDate.GenerateAsString()}')
";
System.Console.WriteLine($@"{i}. INSERT INTO Elokuvat (nimi, julkaisupv) VALUES ('{word1} {word2}', '{randomizerDate.GenerateAsString()}')");
addCommand.ExecuteNonQuery();
}
transaction.Commit();
}
}
private static void GetMoviesReleased(SqliteConnection con)
{
IRandomizerDateTime randomizerDate = RandomizerFactory.GetRandomizer(new FieldOptionsDateTime {
From = minDT, To = maxDT
});
System.Console.WriteLine("Haetaan elokuvia satunnaisilta vuosilta...");
int lastRandomYear = 0;
for (int i = 0; i <= 1000; i++)
{
int randomYear;
do
{
DateTime randomDate = (DateTime)randomizerDate.Generate();
randomYear = randomDate.Year;
} while (randomYear == lastRandomYear);
SqliteCommand searchCommand = con.CreateCommand();
searchCommand.CommandText =
$@"
SELECT COUNT(*)
FROM Elokuvat
WHERE julkaisupv BETWEEN '{randomYear}-01-01' AND '{randomYear}-12-31'
";
using (var reader = searchCommand.ExecuteReader())
{
while (reader.Read())
{
System.Console.WriteLine($"Julkaistujen elokuvien määrä vuonna {randomYear} on {reader.GetString(0)}");
}
}
}
}
public DataGenerator(IOptions <DataGeneratorSettings> options)
{
_settings = options.Value;
_randomizerByte = RandomizerFactory.GetRandomizer(new FieldOptionsByte
{
Min = 0,
Max = 9
});
_randomizerInteger = RandomizerFactory.GetRandomizer(new FieldOptionsInteger
{
Min = _settings.IntegerMin,
Max = _settings.IntegerMax
});
_randomizerString = RandomizerFactory.GetRandomizer(new FieldOptionsText
{
Min = _settings.StringMinLength,
Max = _settings.StringMaxLength,
UseSpecial = false,
});
_randomizerDateTime = RandomizerFactory.GetRandomizer(new FieldOptionsDateTime
{
From = _settings.DateTimeMin,
To = _settings.DateTimeMax,
IncludeTime = false
});
}
