public static void UpdateStatus(TblMetaquery tblMetaquery, StatusMQ newStatus)
{
using (MetaqueriesContext context = new MetaqueriesContext())
{
tblMetaquery.FkStatusId = (int)(newStatus == StatusMQ.ExpandedAndDone ? StatusMQ.Done : newStatus);
if (newStatus == StatusMQ.WaitingToSolver)
{
tblMetaquery.StartTime = DateTime.Now;
}
if (newStatus == StatusMQ.Done || newStatus == StatusMQ.ExpandedAndDone)
{
tblMetaquery.FinishTime = DateTime.Now;
}
if (newStatus == StatusMQ.Expanded || newStatus == StatusMQ.ExpandedAndDone)
{
tblMetaquery.IsExpanded = true;
}
tblMetaquery.TblDatabaseManagement = null;
context.TblMetaqueries.Attach(tblMetaquery);
//context.Entry(tblMetaquery).State = System.Data.Entity.EntityState.Modified;
context.MarkAsModified(tblMetaquery);
context.SaveChanges();
}
}
public static void UpdateStatus(TblMetaquery tblMetaquery, StatusMQ newStatus)
{
using (MetaqueriesContext context = new MetaqueriesContext())
{
tblMetaquery.FkStatusId = (int)newStatus;
if (newStatus == StatusMQ.WaitingToSolver)
{
tblMetaquery.StartTime = DateTime.Now;
}
if (newStatus == StatusMQ.Done)
{
tblMetaquery.FinishTime = DateTime.Now;
}
context.TblMetaqueries.Attach(tblMetaquery);
//context.Entry(tblMetaquery).State = System.Data.Entity.EntityState.Modified;
context.MarkAsModified(tblMetaquery);
context.SaveChanges();
}
}
public static int StartSendMQToSolver()
{
List <TblMetaquery> lstMQ = MetaqueryDS.GetMQForSendToSolver();
int count = 0;
bool doStartExpandMQProcess = false, doStartIncreaseDBArity = false;
while (lstMQ.Count > 0)
{
RabbitProducer <string> producer = null;
foreach (TblMetaquery tblMetaquery in lstMQ)
{
TblDatabaseManagement curDB = tblMetaquery.TblDatabaseManagement;
if (!curDB.ForExperiment)
{
if (producer == null)
{
string queueToMQSolverName = ConfigurationManager.AppSettings["QueueToMQSolverName"];
producer = new RabbitProducer <string>(queueToMQSolverName);
}
Metaquery metaquery = new Metaquery(tblMetaquery.Metaquery);
//שליחה לסולבר
SendMQMessage message = new SendMQMessage()
{
ID = tblMetaquery.Id,
SupportThreshold = curDB.SupportThreshold,
ConfidenceThreshold = curDB.ConfidenceThreshold,
Head = metaquery.Head.Variables,
Body = metaquery.Body.GetVariables()
};
string strMessage = message.ToJson(); //JsonConvert.SerializeObject(message);
producer.SendMessage(strMessage);
MetaqueryDS.UpdateStatus(tblMetaquery, StatusMQ.WaitingToSolver);
}
else
{
RandomMQProbability randomMQProbability = new RandomMQProbability(curDB.SupportProbability.Value, curDB.ConfidenceProbability.Value, curDB.ProbabilityIncreaseByArity ?? 0, tblMetaquery.Arity);
tblMetaquery.FkResult = (int)randomMQProbability.GetRandomResultMQ();
StatusMQ statusMQ = (tblMetaquery.IsExpanded || tblMetaquery.Arity == tblMetaquery.TblDatabaseManagement.MaxArity ? StatusMQ.Done : StatusMQ.WaitingToExpand);
MetaqueryDS.UpdateStatus(tblMetaquery, statusMQ);
if (statusMQ == StatusMQ.WaitingToExpand)
{
doStartExpandMQProcess = true;
}
else if (statusMQ == StatusMQ.Done)
{
doStartIncreaseDBArity = true;
}
}
count++;
}
lstMQ = MetaqueryDS.GetMQForSendToSolver();
}
if (MQGenerator.IsAutoRunJobs)
{
if (doStartExpandMQProcess)
{
MQGenerator.StartExpandMQProcess();
}
else if (doStartIncreaseDBArity)
{
MQGenerator.StartIncreaseDBArity();
}
}
return(count);
}
public static void OnGetMessageFromSolver(string strMessage)
{
MQMessage message = null;
if (strMessage.Contains("Result")) //strMessage is MQResultMessage
{
message = JsonConvert.DeserializeObject <MQResultMessage>(strMessage);
}
else //strMessage is MQAssignmentResultMessage
{
message = JsonConvert.DeserializeObject <MQAssignmentResultMessage>(strMessage);
}
int metaqueryID = message.ID;
TblMetaquery tblMetaquery = MetaqueryDS.GetByID(metaqueryID);
try
{
if (tblMetaquery == null)
{
throw new UnknownMetaqueryException(string.Format("There is an unknown metaquery id sent from solver. message id: {0}. MQ Solver message :", metaqueryID, message.ToString()));
}
if (message is MQResultMessage)
{
MQResultMessage resultMessage = message as MQResultMessage;
tblMetaquery.FkResult = (int)resultMessage.Result;
StatusMQ statusMQ = (tblMetaquery.IsExpanded || tblMetaquery.Arity == tblMetaquery.TblDatabaseManagement.MaxArity ? StatusMQ.Done : StatusMQ.WaitingToExpand);
MetaqueryDS.UpdateStatus(tblMetaquery, statusMQ);
bool execSendMail = bool.Parse(ConfigurationManager.AppSettings["ExecSendMail"]);
if (execSendMail)
{
MQGeneratorMail.SendResultMail(tblMetaquery);
}
if (MQGenerator.IsAutoRunJobs)
{
if (statusMQ == StatusMQ.WaitingToExpand)
{
MQGenerator.StartExpandMQProcess();
}
else if (statusMQ == StatusMQ.Done)
{
MQGenerator.StartIncreaseDBArity();
}
}
}
else if (message is MQAssignmentResultMessage)
{
MQAssignmentResultMessage assignmentResultMessage = message as MQAssignmentResultMessage;
TblMetaqueriesResult tblMetaqueriesResult = new TblMetaqueriesResult()
{
FkMetaqueryId = metaqueryID,
Assignment = assignmentResultMessage.Assignment,
ConfidenceValue = assignmentResultMessage.ConfidenceValue,
SupportValue = assignmentResultMessage.SupportValue
};
MetaqueryResultDS.Create(tblMetaqueriesResult);
bool execSendMail = bool.Parse(ConfigurationManager.AppSettings["ExecSendMail"]);
if (execSendMail)
{
MQGeneratorMail.SendAssignmentMail(tblMetaqueriesResult, tblMetaquery.Metaquery);
}
if (MQGenerator.IsAutoRunJobs && !tblMetaquery.IsExpanded)
{
MQGenerator.StartExpandMQProcess();
}
}
else
{
throw new UnknownMetaqueryException("There is an unknown metaquery sent from solver. MQ Solver message :" + message.ToString());
}
}
catch (Exception ex)
{
MQGeneratorMail.SendExceptionMail(ex);
}
}
