// creates the seed database by reading in sqlite commands from the included seed.txt file in the repository (does not overwrite an existing database)
public void CreateSeed()
{
Console.WriteLine("Creating database schema and seeding database...");
if (!DbExists())
{
IDbCommand dbcmd = Connection.CreateCommand();
string command = File.ReadAllText(ENV.GetSeedData());
dbcmd.CommandText = command;
try
{
dbcmd.ExecuteNonQuery();
Console.WriteLine("Data entries added to database.");
}
catch (Exception ex)
{
Console.WriteLine($"An error occurred while creating seed database: {ex.Message}");
}
}
else
{
Console.WriteLine("Local database already has entries. Stopped seeding process.");
}
}
public DbManager()
{
DatabaseURI = ENV.GetURI();
}