// 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(); }