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