Config.swift

extension CloudFormation.RDSInstance {
	func authDb() throws -> Database<PostgresDatabaseConfiguration> {
		return Database(configuration: try databaseConfiguration(database: biqAuthDatabaseName))
	}
	func databaseConfiguration() throws -> PostgresDatabaseConfiguration {
		return try databaseConfiguration(database: biqAuthDatabaseName)
	}
	func databaseConfiguration(database: String) throws -> PostgresDatabaseConfiguration {
		return try .init(database: database, host: hostName, port: hostPort, username: userName, password: password)
	}

	func initBiqDatabase() throws {
		do {
			let postgresConfig = try databaseConfiguration(database: "postgres")
			let db = Database(configuration: postgresConfig)
			struct PGDatabase: Codable, TableNameProvider {
				static var tableName = "pg_database"
				let datname: String
			}
			let count = try db.table(PGDatabase.self).where(\PGDatabase.datname == biqAuthDatabaseName).count()
			if count == 0 {
				try db.sql("CREATE DATABASE \(biqAuthDatabaseName)")
			}
		}
	}
}