private static void InitTestData()
{
using (var db = new StarWarsContext())
{
if (db.Humans.Any())
{
return;
}
const int numberOfHumans = 1000;
const int numberOfDroids = 1000;
const int numberOfFriendships = 1500;
const int numberOfAppearancesPerType = 1250;
var random = new Random();
db.Humans.RemoveRange(db.Humans);
db.Droids.RemoveRange(db.Droids);
db.Episodes.RemoveRange(db.Episodes);
db.Friendships.RemoveRange(db.Friendships);
db.DroidAppearances.RemoveRange(db.DroidAppearances);
db.HumanAppearances.RemoveRange(db.HumanAppearances);
// Humans
db.Humans.AddRange(Enumerable.Range(1, numberOfHumans).Select(id => new Human
{
HumanId = id,
Name = Faker.Name.First(),
HomePlanet = Faker.Company.BS()
}));
// Droids
db.Droids.AddRange(Enumerable.Range(1, numberOfDroids).Select(id => new Droid
{
DroidId = id,
Name = $"{(char)Faker.RandomNumber.Next('A', 'Z')}"
+ $"{Faker.RandomNumber.Next(1, 9)}"
+ $"{(char)Faker.RandomNumber.Next('A', 'Z')}"
+ $"{Faker.RandomNumber.Next(1, 9)}"
}));
// Episodes
db.Episodes.AddRange(new[]
{
new Episode {
EpisodeId = 4, Name = "A New Hope", Year = "1978"
},
new Episode {
EpisodeId = 5, Name = "Rise of the Empire", Year = "1980"
},
new Episode {
EpisodeId = 6, Name = "Return of the Jedi", Year = "1983"
}
});
// Friendships
db.Friendships.AddRange(Enumerable.Range(1, numberOfFriendships).Select(_ => new Friendship
{
DroidId = random.Next(1, numberOfDroids),
HumanId = random.Next(1, numberOfHumans)
}));
// Appearances (Droid)
db.DroidAppearances.AddRange(Enumerable.Range(1, numberOfAppearancesPerType).Select(_ => new DroidAppearance
{
EpisodeId = random.Next(4, 6),
DroidId = random.Next(1, numberOfDroids)
}));
// Appearances (Human)
db.HumanAppearances.AddRange(Enumerable.Range(1, numberOfAppearancesPerType).Select(_ => new HumanAppearance
{
EpisodeId = random.Next(4, 6),
HumanId = random.Next(1, numberOfHumans)
}));
// Save
var count = db.SaveChanges();
Console.WriteLine("{0} records saved to database", count);
}
}
public GraphQLUserContext(DataLoaderContext loadContext, StarWarsContext dataContext)
{
DataContext = dataContext;
LoadContext = loadContext;
}
