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