public static void Main(string[] args)
{
var conn = new MySqlConnection("server=localhost;user=yelp_etl;password=P@ssword!;port=3306;");
Console.WriteLine("Creating database: yelp...");
try
{
DropDatabaseIfExist(conn);
conn.Open();
conn.Execute(File.ReadAllText(Path.Combine(Directory.GetCurrentDirectory(), "data", "yelp_db.sql")));
}
finally
{
conn.Close();
}
Console.WriteLine("Database created.");
try
{
Console.WriteLine("Starting load...");
//Long running task should start first
var t1 = Task.Run(() => BusinessLoader.Load(Helpers.CreateConnectionToYelpDb()));
var t2 = Task.Run(() => ReviewLoader.Load(Helpers.CreateConnectionToYelpDb()));
//Faster loaders can run sequencially
CheckinLoader.Load(Helpers.CreateConnectionToYelpDb());
TipLoader.Load(Helpers.CreateConnectionToYelpDb());
UserLoader.Load(Helpers.CreateConnectionToYelpDb());
Task.WaitAll(t1, t2);
Console.WriteLine("Load complete.");
}
catch (AggregateException aEx)
{
Console.WriteLine("Load Failure.");
foreach (var ex in aEx.Flatten().InnerExceptions)
{
Console.WriteLine(ex.Message);
}
throw;
}
catch (Exception ex)
{
Console.WriteLine($"Load Failure: {ex.Message}.");
DropDatabaseIfExist(conn);
}
conn.Dispose();
Console.WriteLine("Press any key to exit.");
Console.ReadLine();
}
// Start is called before the first frame update
void Start()
{
// Load up our reviews to use, do some debugging.
this.reviewloader = new ReviewLoader();
this.reviewloader.setReviews("BlastlandM.json");
howmany_reviews = this.reviewloader.allReviews.Length;
load_into_scene(howmany_reviews, spawn_radius);
reviews_on = true;
extendedReviewsOn = false;
}