private void SetViewExists(string name, IGNQueriable queriable, ExistsEnum existsFunc)
{
var checkQuery = $"SELECT * FROM `INFORMATION_SCHEMA`.`VIEWS` WHERE `TABLE_SCHEMA` = database() AND `TABLE_NAME` = '{name}'";
var query = IGNQueriable.FromQueryString(checkQuery, this.email, this);
var result = ReadDataWithParameters(query, new List <IGNParameterValue>());
IGNQueriable.SetExists(result.Rows.Count > 0, queriable);
IGNQueriable.SetCanExecute(existsFunc, queriable);
}
private void SetIndexExists(string name, string table, IGNQueriable queriable, ExistsEnum existsFunc)
{
var checkQuery = $"SELECT * FROM sysindexes WHERE name='{name}'";
var query = IGNQueriable.FromQueryString(checkQuery, this.email, this);
var result = ReadDataWithParameters(query, new List <IGNParameterValue>());
IGNQueriable.SetExists(result.Rows.Count > 0, queriable);
IGNQueriable.SetCanExecute(existsFunc, queriable);
}
private void SetColumnExists(string name, string table, IGNQueriable queriable, ExistsEnum existsFunc)
{
var checkQuery = $"SELECT * FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE [TABLE_CATALOG] = DB_NAME() AND [TABLE_NAME] = '{table}' AND [COLUMN_NAME] = '{name}'";
var query = IGNQueriable.FromQueryString(checkQuery, this.email, this);
var result = ReadDataWithParameters(query, new List <IGNParameterValue>());
IGNQueriable.SetExists(result.Rows.Count > 0, queriable);
IGNQueriable.SetCanExecute(existsFunc, queriable);
}
private void SetStoresProcedureExists(string name, IGNQueriable queriable, ExistsEnum existsFunc)
{
var checkQuery = $"SELECT * FROM [INFORMATION_SCHEMA].[ROUTINES] WHERE [ROUTINE_NAME] = '{name}'";
var query = IGNQueriable.FromQueryString(checkQuery, this.email, this);
var result = ReadDataWithParameters(query, new List <IGNParameterValue>());
IGNQueriable.SetExists(result.Rows.Count > 0, queriable);
IGNQueriable.SetCanExecute(existsFunc, queriable);
}
