public int IssueCollectionTasks()
{
int tasksIssued = 0;
//Query Collection Tasks
LinqToSqlDataContext context = new LinqToSqlDataContext();
IQueryable <HaystackLibrary.CollectionTask> results =
from r in context.CollectionTasks
where r.State == CollectionsTaskState.Approved.ToString()
select r;
//Write Queue Message, Update State to "Issued"
foreach (HaystackLibrary.CollectionTask r in results)
{
r.State = CollectionsTaskState.Issued.ToString();
r.Issued = DateTime.UtcNow;
string message = CollectionsTaskHelper.DatabaseTaskToMessage(r);
StorageClientHelper.AddQueueMessage(QueueType.Collections, SourceType.Twitter, 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 = StorageClientHelper.GetQueueMessages(QueueType.Processing, SourceType.Twitter, 32);
int messageCount = queueMessages.Count <CloudQueueMessage>();
if ((messageCount < 1) || (messageCount == null))
{
Console.WriteLine("No Messages");
loop = false;
}
else
{
Console.WriteLine("GetQueueMessage = " + queueMessages.Count <CloudQueueMessage>());
foreach (CloudQueueMessage queueMessage in queueMessages)
{
//1. Get Queue
HaystackLibrary.CollectionTask newTask = CollectionsTaskHelper.MessageToDatabaseTask(queueMessage.AsString);
string taskString = CollectionsTaskHelper.DatabaseTaskString(newTask);
Console.WriteLine(taskString);
//2. Get Blob
CloudBlob blob = StorageClientHelper.GetBlobReference(newTask.Project, newTask.BlobName);
string blobText = blob.DownloadText();
//TODO: Blob Validate Hash
Console.WriteLine(blobText);
//3. Update Database: Results
//TODO: Update Database: Results
//4. Update Database: Tasks
LinqToSqlDataContext context = new LinqToSqlDataContext();
CollectionTask oldTask = (from t in context.CollectionTasks
where t.Id == newTask.Id
orderby t.Id descending
select t).First <CollectionTask>();
oldTask.State = CollectionsTaskState.Processed.ToString();
oldTask.Collected = newTask.Collected;
oldTask.Station = newTask.Station;
oldTask.Collector = newTask.Collector;
oldTask.BlobName = newTask.BlobName;
oldTask.BlobHash = blob.Attributes.Properties.ContentMD5;
oldTask.Processed = DateTime.UtcNow;
context.SubmitChanges();
//5. Update Blob Metadata
blob.Attributes.Metadata["State"] = CollectionsTaskState.Processed.ToString();
//6. Delete Queue
StorageClientHelper.DeleteQueueMessage(QueueType.Processing, SourceType.Twitter, queueMessage);
//7. Print Success
string output = CollectionsTaskHelper.DatabaseTaskString(newTask);
Console.WriteLine(output);
}
}
}
}
