public SourceQueryParameters PrepareCopyRemoteTable(TableReference table)
{
// Load schema
var sm = this.GetSchemaManager(false);
var ds = sm.Datasets[table.DatasetName];
// Graywulf dataset is to be converted to prevent registry access
if (ds is GraywulfDataset)
{
ds = new SqlServerDataset(ds);
}
var source = new SourceQueryParameters();
source.Dataset = ds;
// Find the query specification this table belongs to
var qs = ((TableSource)table.Node).QuerySpecification;
// Run the normalizer
var cnr = new SearchConditionNormalizer();
cnr.NormalizeQuerySpecification(qs);
var cg = SqlCodeGeneratorFactory.CreateCodeGenerator(ds);
source.Query = cg.GenerateMostRestrictiveTableQuery(table, true, 0);
return source;
}
/// <summary>
/// Composes a source query for a remote table
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public SourceTableQuery PrepareCopyRemoteTable(TableReference table)
{
// -- Load schema
var sm = this.GetSchemaManager(false);
var ds = sm.Datasets[table.DatasetName];
// Graywulf dataset has to be converted to prevent registry access
if (ds is GraywulfDataset)
{
ds = new SqlServerDataset(ds);
}
// --- Generate most restrictive query
// Find the query specification this table belongs to
var qs = ((TableSource)table.Node).QuerySpecification;
// Run the normalizer to convert where clause to a normal form
var cnr = new SearchConditionNormalizer();
cnr.NormalizeQuerySpecification(qs);
var cg = SqlCodeGeneratorFactory.CreateCodeGenerator(ds);
var sql = cg.GenerateMostRestrictiveTableQuery(table, true, 0);
return new SourceTableQuery()
{
Dataset = ds,
Query = sql
};
}
private string[] GetWhereClauses(string query)
{
SearchConditionNormalizer cn = new SearchConditionNormalizer();
var select = CreateSelect(query);
var res = new List<string>();
foreach (var qs in select.EnumerateQuerySpecifications())
{
cn.NormalizeQuerySpecification(qs);
// TODO use qs.SourceTableReferences ???
foreach (var tr in qs.EnumerateSourceTableReferences(true))
{
WhereClause where = cn.GenerateWhereClauseSpecificToTable(tr);
if (where != null)
{
var cg = new SqlServerCodeGenerator();
cg.ResolveNames = true;
var sw = new StringWriter();
cg.Execute(sw, where);
res.Add(sw.ToString());
}
else
{
res.Add("");
}
}
}
return res.ToArray();
}