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); //} } } }