public IActionResult SelectTableToInsertInMySql(string table, string password) { if (password.Equals(_configuration["ConnectionStrings:PasswordToAccess"])) { string connectionString = _configuration["ConnectionStrings:OKRCoachDB"]; string schemaToLoad = _configuration["ConnectionStrings:SchemaToLoad"]; string schemaToInsert = _configuration["ConnectionStrings:SchemaToInsert"]; try { MySqlOperations.SelectTableToInsertInMySql(connectionString, schemaToLoad, schemaToInsert, table); return(Ok()); } catch (Exception e) { string error = e.InnerException.Message; Console.WriteLine("IOException source: {0}", error); return(BadRequest(error)); } } else { return(BadRequest()); } }
public IActionResult SelectAllTablesToInsertInMySql(string password) { if (password.Equals(_configuration["ConnectionStrings:PasswordToAccess"])) { string connectionString = _configuration["ConnectionStrings:OKRCoachDB"]; string schemaToLoad = _configuration["ConnectionStrings:SchemaToLoad"]; string schemaToInsert = _configuration["ConnectionStrings:SchemaToInsert"]; try { var lines = MySqlOperations.SelectAllTablesToInsertInMySql(connectionString, schemaToLoad, schemaToInsert); byte[] linesAsBytes = lines.SelectMany(s => Encoding.ASCII.GetBytes(s)).ToArray(); return(File(linesAsBytes, "application/sql", $"Dump_{schemaToLoad}.sql")); } catch (Exception e) { string error = e.InnerException.Message; Console.WriteLine("IOException source: {0}", error); return(BadRequest(error)); } } else { return(BadRequest()); } }