private List <string> GetEnabledDisabledIndexNames(ITableInfo tableInfo, bool isEnabled)
{
var indexNamesTemplate = new GetIndexes(tableInfo.DbName, tableInfo.SchemaName, tableInfo.TableName, isEnabled);
var indexNamesQuery = indexNamesTemplate.TransformText();
Console.WriteLine(indexNamesQuery);
DataTable indexNamesTable;
try
{
indexNamesTable = _queryHelper.ExecuteQueryWithoutParams(tableInfo.DbConnectionString, indexNamesQuery);
}
catch (Exception ex)
{
throw new IndexServiceException("An error happened while trying to get index names.", ex);
}
var columnNames = new List <string>();
foreach (var rowObject in indexNamesTable.Rows)
{
var row = (DataRow)rowObject;
columnNames.Add((string)row[0]);
}
return(columnNames);
}
public Dictionary <string, string> GetColumnNamesAndTypes(ITableInfo tableInfo, List <string> columnNames)
{
var columnTypesTemplate = new GetColumnTypes(tableInfo.DbName, tableInfo.SchemaName, tableInfo.TableName, columnNames);
var columnTypesQuery = columnTypesTemplate.TransformText();
//Console.WriteLine(columnTypesQuery);
DataTable columnTypesTable;
try
{
columnTypesTable = _queryHelper.ExecuteQueryWithoutParams(tableInfo.DbConnectionString, columnTypesQuery);
}
catch (Exception ex)
{
throw new ColumnTypesException("An error happened while trying to get column types.", ex);
}
var columnsAndTypes = new Dictionary <string, string>();
foreach (var rowObject in columnTypesTable.Rows)
{
var row = (DataRow)rowObject;
columnsAndTypes.Add((string)row[GetColumnTypes.columnName],
(string)row[GetColumnTypes.columnType]);
}
return(columnsAndTypes);
}
public bool IsWhereConditionValid(string connectionString, TableConfig tableConfig)
{
if (string.IsNullOrEmpty(tableConfig.Where))
{
return(true);
}
try
{
_sqlHelper.ExecuteQueryWithoutParams(connectionString, $"select top (1)* from {tableConfig.FullTableName} where {tableConfig.Where};");
return(true);
}
catch (SqlException ex)
{
Log.Error($"Error while checking the where condition of table {tableConfig.FullTableName}. Connection string: {connectionString}." +
$"Message: {ex.Message}.");
return(false);
}
}
protected override List <string> GetLinkedServerNames(string connectionString)
{
return(_queryHelper.ExecuteQueryWithoutParams(connectionString, "select * from sys.servers;").AsEnumerable().Select(r => r.Field <string>(1))
.Select(x => "[" + x + "]").ToList());;
}