public CExplainableQuery(IQueryableConnection connection, StoredQuery query)
{
this.connection = connection;
this.query = query;
InitExplanation();
}
public CExplainableQuery(IQueryableConnection connection, StoredQuery query)
{
this.connection = connection;
this.query = query;
InitExplanation();
}
public void Initialize(AppDBQueryLink linkQueryRow, IQueryableConnection connection)
{
currentQuery = linkQueryRow;
completionHelper = QueryComposerResources.ComposerHelper(connection);
Reset();
}
public void Initialize(AppDBQueryLink linkQueryRow, IQueryableConnection connection)
{
currentQuery = linkQueryRow;
completionHelper = QueryComposerResources.ComposerHelper(connection);
Reset();
}
public static QueryComposerHelper ComposerHelper(IQueryableConnection connection)
{
QueryComposerHelper composer;
if (!Composers.TryGetValue(connection, out composer))
{
composer = new QueryComposerHelper(connection);
Composers.Add(connection, composer);
}
return(composer);
}
public void LoadConnectionSettings()
{
// todo: doesn't have to be MySQL, use some kind of factory that returns an interface to do queries with
DBConnection = ConnectionFactory.NewConnection((int)type, connectionString);
if (DBConnection == null)
{
throw new QDConnectionTypeNotSupportedException();
}
if (!DBConnection.Connect())
{
throw new QDConnectionFailedException();
}
}
public void LoadConnectionSettings()
{
// todo: doesn't have to be MySQL, use some kind of factory that returns an interface to do queries with
DBConnection = ConnectionFactory.NewConnection((int)type, connectionString);
if (DBConnection == null)
{
throw new QDConnectionTypeNotSupportedException();
}
if (!DBConnection.Connect())
{
throw new QDConnectionFailedException();
}
}
public static CExplainableQuery NewExplain(IQueryableConnection connection, StoredQuery query)
{
if (query.SQL.StartsWith("select", StringComparison.OrdinalIgnoreCase))
{
if (connection is MySQLQueryableConnection)
{
return(new MySQLQueryExplanation(connection, query));
}
else if (connection is MSSQLQueryableConnection)
{
return(null); // new MSSQLQueryExplanation(connection, query);
}
}
return(null);
}
public MSSQLQueryExplanation(IQueryableConnection connection, StoredQuery query)
: base(connection, query)
{
}
public static CExplainableQuery NewExplain(IQueryableConnection connection, StoredQuery query)
{
if (query.SQL.StartsWith("select", StringComparison.OrdinalIgnoreCase))
{
if (connection is MySQLQueryableConnection)
{
return new MySQLQueryExplanation(connection, query);
}
else if (connection is MSSQLQueryableConnection)
{
return null; // new MSSQLQueryExplanation(connection, query);
}
}
return null;
}
public static void UnsetComposerHelper(IQueryableConnection connection)
{
Composers.Remove(connection);
}
public QueryComposerHelper(IQueryableConnection connection)
{
this.connection = connection;
InitializeLayout();
}
public static void UnsetComposerHelper(IQueryableConnection connection)
{
Composers.Remove(connection);
}
public static QueryComposerHelper ComposerHelper(IQueryableConnection connection)
{
QueryComposerHelper composer;
if (!Composers.TryGetValue(connection, out composer))
{
composer = new QueryComposerHelper(connection);
Composers.Add(connection, composer);
}
return composer;
}
public QueryComposerHelper(IQueryableConnection connection)
{
this.connection = connection;
InitializeLayout();
}
public MySQLQueryExplanation(IQueryableConnection connection, StoredQuery query) : base(connection, query)
{
}
