/// <summary> /// The main method of the program. /// </summary> public static void Main() { var databaseSettings = new DatabaseConnectionSettings { Host = "localhost", Database = "mqtt", Port = 5432, Username = "******", Password = "******" }; userRepository = new UserRepository(databaseSettings); databaseVersionRepository = new DatabaseVersionRepository(databaseSettings); whitelistRepository = new WhitelistRepository(databaseSettings); blacklistRepository = new BlacklistRepository(databaseSettings); databaseHelper = new DatabaseHelper(databaseSettings); Console.WriteLine("Delete database..."); databaseHelper.DeleteDatabase(databaseSettings.Database); Console.WriteLine("Create database..."); databaseHelper.CreateDatabase(databaseSettings.Database); Console.WriteLine("Setting up the database tables..."); databaseHelper.CreateAllTables(true); Console.WriteLine("Adding seed data..."); SeedData(); Console.WriteLine("Press any key to close this window..."); Console.ReadKey(); }
/// <summary> /// The main method of the program. /// </summary> /// <returns>A <see cref="Task" />.</returns> public static async Task Main() { var connectionSettings = await ReadSettingsFile(); userRepository = new UserRepository(connectionSettings); databaseVersionRepository = new DatabaseVersionRepository(connectionSettings); whitelistRepository = new WhitelistRepository(connectionSettings); databaseHelper = new DatabaseHelper(connectionSettings); Console.WriteLine("Setting up the database..."); Console.WriteLine("Deleting database..."); await databaseHelper.DeleteDatabase(connectionSettings.Database); Console.WriteLine("Creating database..."); await databaseHelper.CreateDatabase(connectionSettings.Database); Console.WriteLine("Adding TimeScaleDB extension..."); await databaseHelper.EnableTimeScaleDbExtension(); Console.WriteLine("Adding Orleans tables..."); await databaseHelper.CreateOrleansTables(); Console.WriteLine("Creating tables..."); await databaseHelper.CreateAllTables(true); Console.WriteLine("Creating hyper tables..."); await databaseHelper.CreateHyperTables(); Console.WriteLine("Creating compound index..."); await databaseHelper.CreateCompoundIndex(); Console.WriteLine("Adding seed data..."); await SeedData(); Console.WriteLine("Press any key to close this window..."); Console.ReadKey(); }
/// <inheritdoc /> public DatabaseSetupRepository(ConnectionString connectionString, ILogger logger) : base(connectionString, logger) { _databaseVersionRepository = new DatabaseVersionRepository(connectionString, logger); }