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