public void CreateMessageStoreTable() { using (var connection = new MySqlConnection(_mysqlSettings.TestsBrighterConnectionString)) { _tableName = $"`message_{_tableName}`"; var createTableSql = MySqlMessageStoreBuilder.GetDDL(_tableName); connection.Open(); using (var command = connection.CreateCommand()) { command.CommandText = createTableSql; command.ExecuteNonQuery(); } } }
private static void CreateMessageTable(string dataSourceTestDb, string tableNameMessages) { try { using (var sqlConnection = new MySqlConnection(dataSourceTestDb)) { sqlConnection.Open(); using (var command = sqlConnection.CreateCommand()) { command.CommandText = MySqlMessageStoreBuilder.GetDDL(tableNameMessages); command.ExecuteScalar(); } } } catch (System.Exception e) { Console.WriteLine($"Issue with creating MessageStore table, {e.Message}"); } }
private static MySqlConnection SetupMessageDb(string connectionStringPath) { var connectionString = "DataSource=\"" + connectionStringPath + "\""; return(CreateDatabaseWithTable(connectionString, MySqlMessageStoreBuilder.GetDDL(TableNameMessages))); }