public override void Run() { using (Context context = ContextManager.Instance.CreateContext(ConnectionMode.AutoOpen, TransactionMode.AutoCommit)) { EntityFactory ef = new EntityFactory(context); Federation f = (Federation)ef.LoadStronglyTypedEntity(Federation.AppSettings.FederationName); QueryFactory qf = new SqlQueryFactory(); QueryBase query = qf.CreateQuery(File.ReadAllText(inputFile), ExecutionMode.Graywulf, outputTable, taskName); string queuename = String.Format("{0}.{1}", f.ControllerMachine.GetFullyQualifiedName(), queueName); JobInstance job = qf.ScheduleAsJob(query, queueName); job.Save(); } }
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); //} } } }
protected Guid ScheduleQueryJob(string query, QueueType queueType) { var queue = String.Format("QueueInstance:Graywulf.Controller.Controller.{0}", queueType.ToString()); using (var context = ContextManager.Instance.CreateContext(ConnectionMode.AutoOpen, TransactionMode.AutoCommit)) { SignInTestUser(context); var f = new SqlQueryFactory(context); var q = f.CreateQuery(query); var ji = f.ScheduleAsJob(q, queue, "testjob"); ji.Save(); return ji.Guid; } }
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); //} } } }