public int IssueCollectionTasks() { int tasksIssued = 0; //Query Collection Tasks LinqToSqlAzureHaystackDataContext context = new LinqToSqlAzureHaystackDataContext(); IQueryable <T_CollectionTask> results = from r in context.T_CollectionTasks where r.State == StateTypeEnum.Approved.ToString() select r; //Write Queue Message, Update State to "Issued" foreach (T_CollectionTask r in results) { r.State = StateTypeEnum.Issued.ToString(); r.Issued = DateTime.UtcNow; string message = CollectionsTaskHelper.T_CollectionsTaskToMessage(r); QueueTypeEnum queueName; if (r.Command == TwitterCommandEnum.Followers.ToString()) { queueName = QueueTypeEnum.CollectionsTwitterFollowers; } else if (r.Command == TwitterCommandEnum.Friends.ToString()) { queueName = QueueTypeEnum.CollectionsTwitterFriends; } else if (r.Command == TwitterCommandEnum.Profile.ToString()) { queueName = QueueTypeEnum.CollectionsTwitterProfile; } else if (r.Command == TwitterCommandEnum.Search.ToString()) { queueName = QueueTypeEnum.CollectionsTwitterSearch; } else if (r.Command == TwitterCommandEnum.Tweets.ToString()) { queueName = QueueTypeEnum.CollectionsTwitterTweets; } else { throw new Exception("Command Not Found"); } AzureClientService.AddQueueMessage(queueName, message); tasksIssued++; string task = string.Format("{0} {1} {2} {3} {4} {5} {6} ", r.Id.ToString(), r.State, r.Created.ToString(), r.Project, r.Source, r.Command, r.Target); Console.WriteLine(task); } //Submit Changes context.SubmitChanges(); return(tasksIssued); }
public void ProccesCollectionTasks() { bool loop = true; while (loop) { IEnumerable <CloudQueueMessage> queueMessages = AzureClientService.GetQueueMessages(QueueTypeEnum.ProcessingTwitter, 32); int messageCount = queueMessages.Count <CloudQueueMessage>(); if (messageCount < 1) { Console.WriteLine("No Messages"); loop = false; } else { Console.WriteLine("GetQueueMessage = " + queueMessages.Count <CloudQueueMessage>()); foreach (CloudQueueMessage queueMessage in queueMessages) { //1. Get Queue T_CollectionTask t_newTask = CollectionsTaskHelper.MessageToT_CollectionTask(queueMessage.AsString); //string taskString = CollectionsTaskHelper.T_CollectionsTaskToMessage(newTask); //Console.WriteLine(taskString); //2. Get Blob CloudBlob blob = AzureClientService.GetBlobReference(t_newTask.Project, t_newTask.BlobName); string blobText = blob.DownloadText(); //TODO: Blob Validate Hash //Console.WriteLine(blobText); //3. Update Database: Results if (t_newTask.Command == TwitterCommandEnum.Followers.ToString()) { ProcessTwitterFollowers(blobText, t_newTask); } else if (t_newTask.Command == TwitterCommandEnum.Friends.ToString()) { ProcessTwitterFriends(blobText, t_newTask); } else if (t_newTask.Command == TwitterCommandEnum.Profile.ToString()) { ProcessTwitterProfile(blobText, t_newTask); } else if (t_newTask.Command == TwitterCommandEnum.Tweets.ToString()) { ProcessTwitterTweets(blobText, t_newTask); } else if (t_newTask.Command == TwitterCommandEnum.Search.ToString()) { ProcessTwitterSearch(blobText, t_newTask); } else { throw new NotImplementedException(); } //4. Update Database: Tasks LinqToSqlAzureHaystackDataContext context = new LinqToSqlAzureHaystackDataContext(); T_CollectionTask t_oldTask = (from t in context.T_CollectionTasks where t.Id == t_newTask.Id orderby t.Id descending select t).First <T_CollectionTask>(); t_oldTask.State = StateTypeEnum.Processed.ToString(); t_oldTask.Collected = t_newTask.Collected; t_oldTask.Station = t_newTask.Station; t_oldTask.Collector = t_newTask.Collector; t_oldTask.BlobName = t_newTask.BlobName; t_oldTask.ResultHash = blob.Attributes.Properties.ContentMD5; t_oldTask.Processed = DateTime.UtcNow; context.SubmitChanges(); //5. Update Blob Metadata blob.Attributes.Metadata["State"] = StateTypeEnum.Processed.ToString(); //6. Delete Queue AzureClientService.DeleteQueueMessage(QueueTypeEnum.ProcessingTwitter, queueMessage); //7. Print Success string output = CollectionsTaskHelper.T_CollectionsTaskToMessage(t_newTask); Console.WriteLine(output); } } } }