public IActionResult Generate(GenerateQueryReq generateQueryReq) { string operationName = generateQueryReq.Operation.ToLowerInvariant(); _logger.LogInformation($"Executing {operationName}"); var res = new GenerateQueryRes(); var operation = _operationResolver.ResolveOperation(operationName); res.SqlQuery = operation.GenerateQuery(generateQueryReq); return(Ok(res)); }
public string GenerateQuery(GenerateQueryReq req) { // Validate if (req == null || req.Operation != Operation) { throw new InvalidOperationException(); } // Form query return($"IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS" + $" WHERE TABLE_NAME = [{req.TableName}] AND COLUMN_NAME = [{req.ColumnName}] )" + $" BEGIN ALTER TABLE [{req.TableName}] " + $" DROP [{req.ColumnName}] End; "); }