// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, CalmContext calmContext)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
if (Configuration.GetValue("UseHttpsRedirection", defaultValue: true) is true)
{
app.UseHttpsRedirection();
}
app.UseRouting();
app.UseCors(CorsPolicyName);
app.UseAuthorization();
app.UseSwagger();
app.UseSwaggerUI(c =>
{
c.SwaggerEndpoint("/swagger/v0/swagger.json", "My API V1");
});
calmContext.Database.Migrate();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
}
private void OpenContext()
{
connection = new System.Data.SQLite.SQLiteConnection("Data Source=:memory:");
connection.Open();
var temp = new CalmContext(
new DbContextOptionsBuilder <CalmContext>()
.UseSqlite(connection)
.Options);
temp.Database.Migrate();
Seeder.Seed(temp);
temp.SaveChanges();
temp.Dispose();
}
public static void Seed(CalmContext context)
{
context.Links.RemoveRange(context.Links);
context.Admins.RemoveRange(context.Admins);
context.Users.RemoveRange(context.Users);
context.Gatherings.RemoveRange(context.Gatherings);
context.Citys.RemoveRange(context.Citys);
context.SaveChanges();
Func <string, int> CityId = x =>
{
return((from item in context.Citys.ToList()
where item.city.Contains(x)
select item.Id).FirstOrDefault());
};
Func <string, int> UserId = x =>
{
return((from item in context.Users.ToList()
where item.FName.Contains(x)
select item.Id).FirstOrDefault());
};
Func <string, string, string, string, bool, string, string, Gathering> gather =
(title, details, occurance, map, isEvent, u1, u2) =>
new Gathering()
{
Title = title,
details = details,
occurrenceData = occurance,
organizerId = context.Admins.FirstOrDefault().user.Id,
MapDataId = CityId(map),
isEvent = isEvent,
links = new List <Link>
{
new Link {
userId = UserId(u1)
},
new Link {
userId = UserId(u2)
}
}
};
context.Citys.AddRange(
new Mapdata()
{
city = "Houston, TX"
},
new Mapdata()
{
city = "Dallas, TX"
},
new Mapdata()
{
city = "Nashville, TN"
},
new Mapdata()
{
city = "Minneapolis, MN"
},
new Mapdata()
{
city = "Kansas City, MI"
},
new Mapdata()
{
city = "New York, NY"
},
new Mapdata()
{
city = "Los Angeles, CA"
},
new Mapdata()
{
city = "Chicago, IL"
},
new Mapdata()
{
city = "Seattle, WA"
},
new Mapdata()
{
city = "Atlanta, GA"
},
new Mapdata()
{
city = "Orlando, FL"
},
new Mapdata()
{
city = "Washington DC,"
},
new Mapdata()
{
city = "New Orleans, LA"
},
new Mapdata()
{
city = "Denver, CO"
},
new Mapdata()
{
city = "San Francisco, CA"
},
new Mapdata()
{
city = "Detroit, MI"
},
new Mapdata()
{
city = "Online"
});
context.SaveChanges();
context.Admins.AddRange(new AdminInfo()
{
SuperAdmin = true,
user = new User()
{
FName = "admin", LName = "user", Username = "******", Password = "******", MapDataId = CityId("Houston")
}
});
context.Users.AddRange(
new User()
{
FName = "Samuel", LName = "Philander", Username = "******", Password = "******", MapDataId = CityId("Dallas")
},
new User()
{
FName = "Andrew", LName = "Jackson", Username = "******", Password = "******", MapDataId = CityId("Houston")
},
new User()
{
FName = "Ulysses", LName = "Grant", Username = "******", Password = "******", MapDataId = CityId("Dallas")
},
new User()
{
FName = "Rutherford", LName = "Hayes", Username = "******", Password = "******", MapDataId = CityId("Houston")
},
new User()
{
FName = "James", LName = "Garfield", Username = "******", Password = "******", MapDataId = CityId("Houston")
},
new User()
{
FName = "Chester", LName = "Aurthur", Username = "******", Password = "******", MapDataId = CityId("Dallas")
},
new User()
{
FName = "Grover", LName = "Cleveland", Username = "******", Password = "******", MapDataId = CityId("Dallas")
},
new User()
{
FName = "Benjamin", LName = "Harrison", Username = "******", Password = "******", MapDataId = CityId("Dallas")
},
new User()
{
FName = "Theadore", LName = "Roosevelt", Username = "******", Password = "******", MapDataId = CityId("Houston")
},
new User()
{
FName = "William", LName = "McKinley", Username = "******", Password = "******", MapDataId = CityId("Houston")
});
context.SaveChanges();
context.Gatherings.AddRange(
gather(
"Marvin’s Room: with guest Drake",
"Location: TBA",
"June 12th",
"Houston",
true,
"Samuel",
"Andrew"),
gather(
"Love and Happiness: with guest Kevin Love",
"",
"June 12th",
"Online",
true,
"Ulysses",
"Samuel"),
gather(
"Struggles of Balance: guest Demi Lovato",
"",
"August 1st",
"Online",
true,
"Ulysses",
"Andrew"),
gather(
"Generalized Anxiety",
"",
"Monday - Friday",
"Dallas",
false,
"Samuel",
"Rutherford"),
gather(
"Post Traumatic Anxiety Disorder",
"",
"Monday - Friday",
"Dallas",
false,
"Grover",
"Chester"),
gather(
"Social Anxiety",
"",
"Monday - Friday",
"Online",
false,
"James",
"Ulysses"),
gather(
"Panic Disorder",
"",
"Monday - Friday",
"Dallas",
false,
"Samuel",
"James"),
gather(
"Obsessive Compulsive Disorder",
"",
"Monday - Friday",
"Online",
false,
"Theadore",
"William"),
gather(
"Specific phobias",
"",
"Monday - Friday",
"Dallas",
false,
"Samuel",
"Benjamin"));
context.SaveChanges();
}
public ActionResult SeedData([FromServices] CalmContext context)
{
Seeder.Seed(context);
return(Ok());
}
