private void toolbuttonResolve_Click(object sender, EventArgs e)
{
if (rootNode != null)
{
using (Context context = ContextManager.Instance.CreateContext(ConnectionMode.AutoOpen, TransactionMode.AutoCommit))
{
//try
//{
SqlParser.QuerySpecification qs = rootNode.FindDescendant <SqlParser.QueryExpression>().FindDescendant <SqlParser.QuerySpecification>();
//Jhu.Graywulf.Schema.SqlServerSchemaManager sm = new Schema.SqlServerSchemaManager();
Jhu.Graywulf.Schema.SchemaManager sm =
new Jhu.Graywulf.Schema.GraywulfSchemaManager(context,
Jhu.Graywulf.Registry.AppSettings.FederationName);
// *** Add test datasets here
sm.Datasets["MYDB"] = new Jhu.Graywulf.Schema.SqlServer.SqlServerDataset("MYDB", "Data Source=localhost;Integrated Security=true;Initial Catalog=GraywulfSchemaTest");
//sm.Datasets.Add(new Jhu.Graywulf.Schema.MySqlDataset("MYSQL", "..."));
var qf = new Jhu.Graywulf.Jobs.Query.SqlQueryFactory();
var nr = qf.CreateNameResolver();
nr.SchemaManager = sm;
nr.DefaultTableDatasetName = "MYDB";
nr.Execute((SqlParser.SelectStatement)rootNode);
//List<SqlParser.TableReference> rt = new List<SqlParser.TableReference>(qs.e);
List <SqlParser.SearchConditionReference> pc = new List <SqlParser.SearchConditionReference>(qs.EnumerateConditions());
SqlParser.SelectList sl = qs.FindDescendant <SqlParser.SelectList>();
List <SqlParser.ColumnExpression> ce = new List <SqlParser.ColumnExpression>(sl.EnumerateDescendants <SqlParser.ColumnExpression>());
parsed.Text = Jhu.Graywulf.SqlParser.SqlCodeGen.SqlServerCodeGenerator.GetCode(rootNode, true);
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message);
//}
}
}
}
private void toolbuttonResolve_Click(object sender, EventArgs e)
{
if (rootNode != null)
{
using (Context context = ContextManager.Instance.CreateContext(ConnectionMode.AutoOpen, TransactionMode.AutoCommit))
{
//try
//{
SqlParser.QuerySpecification qs = rootNode.FindDescendant<SqlParser.QueryExpression>().FindDescendant<SqlParser.QuerySpecification>();
//Jhu.Graywulf.Schema.SqlServerSchemaManager sm = new Schema.SqlServerSchemaManager();
Jhu.Graywulf.Schema.SchemaManager sm =
new Jhu.Graywulf.Schema.GraywulfSchemaManager(context,
Jhu.Graywulf.Registry.Federation.AppSettings.FederationName);
// *** Add test datasets here
sm.Datasets["MYDB"] = new Jhu.Graywulf.Schema.SqlServer.SqlServerDataset("MYDB", "Data Source=localhost;Integrated Security=true;Initial Catalog=GraywulfSchemaTest");
//sm.Datasets.Add(new Jhu.Graywulf.Schema.MySqlDataset("MYSQL", "..."));
var qf = new Jhu.Graywulf.Jobs.Query.SqlQueryFactory();
var nr = qf.CreateNameResolver();
nr.SchemaManager = sm;
nr.DefaultTableDatasetName = "MYDB";
nr.Execute((SqlParser.SelectStatement)rootNode);
//List<SqlParser.TableReference> rt = new List<SqlParser.TableReference>(qs.e);
List<SqlParser.SearchConditionReference> pc = new List<SqlParser.SearchConditionReference>(qs.EnumerateConditions());
SqlParser.SelectList sl = qs.FindDescendant<SqlParser.SelectList>();
List<SqlParser.ColumnExpression> ce = new List<SqlParser.ColumnExpression>(sl.EnumerateDescendants<SqlParser.ColumnExpression>());
parsed.Text = Jhu.Graywulf.SqlParser.SqlCodeGen.SqlServerCodeGenerator.GetCode(rootNode, true);
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message);
//}
}
}
}
