public HttpResponseMessage BulkGetDocs(string dbName, bool revs, bool latest, [FromBody] object msg)
{
Console.WriteLine("Bulk Get");
Console.WriteLine(msg.ToString());
JObject msgJson = JObject.Parse(msg.ToString());
var data = msgJson["docs"];
// TODO: CHANGE TO ALSO GET MuLTIPLE AT ONCE!!!
int length = data.Count();
List <string> _ids = new List <string>();
List <string> _revs = new List <string>();
List <object> results = new List <object>();
for (int i = 0; i < length; i++)
{
_ids.Add(data[i]["id"].ToString());
_revs.Add(data[i]["rev"].ToString());
// Returns id and latest doc with given id and rev
List <PouchData> cData = new List <PouchData>();
using (DatabaseContext db = new DatabaseContext())
{
if (dbName.Equals("Tickets"))
{
List <Ticket> ctempData = db.Tickets.ToList();
foreach (Ticket cTicket in ctempData)
{
if (cTicket._rev.Equals(_revs[i]) && cTicket._id.Equals(_ids[i]))
{
cData.Add(cTicket);
}
}
}
}
List <object> cDocs = new List <object>();
using (ReturnParser parser = new ReturnParser())
{
cDocs = parser.ParseGetDocs(cData, _ids[i]);
}
object cObject = new
{
id = _ids[i],
docs = cDocs
};
results.Add(cObject);
}
using (MessageControllerHelper helper = new MessageControllerHelper())
{
return(helper.GetJsonResponse(HttpStatusCode.OK, new StringContent(JsonConvert.SerializeObject(new { results = results }))));
}
}
public HttpResponseMessage GetAllDocs(string dbName, bool conflicts, bool include_docs, [FromBody] object msg)
{
// TODO: all docs returns too much!!!
// Maybe unambigous because mulitple docs with same id returned!!!
// TODO: FIX!
Console.WriteLine(msg.ToString());
JObject AskedForIds = JObject.Parse(msg.ToString());
var AskedForIdsParsed = AskedForIds["keys"];
List <string> AskedIdsList = AskedForIdsParsed.ToObject <List <string> >();
List <List <PouchData> > AskedDataList = new List <List <PouchData> >();
using (DatabaseContext db = new DatabaseContext())
{
foreach (string cId in AskedIdsList)
{
List <PouchData> cDataList = new List <PouchData>();
// TODO: make smarter
if (dbName.Equals("Tickets"))
{
cDataList.AddRange(db.Tickets.Where(entity => entity._id.Equals(cId)).ToList());
}
AskedDataList.Add(cDataList);
}
}
string retMessage = "";
using (ReturnParser parser = new ReturnParser())
{
retMessage = parser.ParseAllDocsReturn(AskedDataList);
}
using (MessageControllerHelper helper = new MessageControllerHelper())
{
return(helper.GetJsonResponse(HttpStatusCode.OK, new StringContent(retMessage)));
}
}
public HttpResponseMessage GetRevisionDifferences(string db, [FromBody] object msg)
{
// Parse Post Message in correct format (dict of ids with rev arrays)
JObject parameters = JObject.Parse(msg.ToString());
Dictionary <string, object> parametersDict = parameters.ToObject <Dictionary <string, object> >();
// Get used Ids
List <string> Ids = new List <string>();
foreach (string cId in parametersDict.Keys)
{
Ids.Add(cId);
}
// Find revs for every id
List <List <string> > Revisions = new List <List <string> >();
foreach (string cId in Ids)
{
Revisions.Add(JsonConvert.DeserializeObject <List <string> >(parametersDict[cId].ToString()));
}
// Find missing revisions and Ids
List <Tuple <string, List <string> > > Missing = new List <Tuple <string, List <string> > >();
using (DatabaseContext _db = new DatabaseContext())
{
List <string> cMissingRevs = new List <string>();
// Check each id if it exists
for (int i = 0; i < Ids.Count; i++)
{
List <Ticket> ctempData = _db.Tickets.ToList();
// Find missing ids in general
List <string> allIds = new List <string>();
foreach (Ticket cTicket in ctempData)
{
allIds.Add(cTicket._id);
}
// Is completely missing add all and break
bool foundId = false;
foreach (string id in Ids)
{
if (id.Equals(Ids[i]))
{
if (!allIds.Contains(id))
{
Missing.Add(new Tuple <string, List <string> >(id, Revisions[i]));
foundId = true;
continue;
}
}
}
if (foundId)
{
continue;
}
// bool missingFound = false;
// Get revision List
List <string> allRevisions = new List <string>();
foreach (Ticket cData in ctempData)
{
allRevisions.Add(cData._rev);
}
// Check all for missing ones
cMissingRevs = new List <string>();
foreach (string cRevision in Revisions[i])
{
if (!allRevisions.Contains(cRevision))
{
cMissingRevs.Add(cRevision);
}
}
Missing.Add(new Tuple <string, List <string> >(Ids[i], cMissingRevs));
/*
* foreach (Ticket cData in ctempData)
* if (cData._id.Equals(Ids[i]))
* {
* foreach (string cRevision in Revisions[i])
* {
* if (!cRevision.Equals(cData._rev))
* {
* Console.WriteLine("Found Missing Rev: " + cRevision);
*
* cMissingRevs.Add(cRevision);
* missingFound = true;
* }
* }
* }
*
* if (missingFound)
* Missing.Add(new Tuple<string, List<string>>(Ids[i], cMissingRevs));
*/
}
}
using (MessageControllerHelper helper = new MessageControllerHelper())
{
string temp;
using (ReturnParser parser = new ReturnParser())
{
temp = parser.GetRevisionDifferenceReturns(Missing);
}
return(helper.GetJsonResponse(HttpStatusCode.OK, new StringContent(temp)));
}
}
public HttpResponseMessage GetChanges(string db, string style, string since, int limit)
{
Console.WriteLine("In Changes, db: " + db + ", style: " + style + ", since: " + since + ", limit: " + limit);
// Get Revisions from DB
List <Change> revsList = new List <Change>();
// Get Data for revision Ids
List <PouchData> pouchDataList = new List <PouchData>();
using (DatabaseContext _db = new DatabaseContext())
{
// only take limit if there is more than limit in db
int RevsCount = _db.Changes.Where(e => e.DatabaseName.Equals(db)).ToList().Count();
if (RevsCount < limit)
{
limit = RevsCount;
}
revsList = _db.Changes.Where(e => e.DatabaseName.Equals(db)).OrderByDescending(e => e.seq).Take(limit).ToList();
// Remove all before Since
using (MessageControllerHelper helper = new MessageControllerHelper())
{
if (!since.Equals("") && !since.Equals("0"))
{
revsList = helper.FindRevsAfterSince(since, revsList);
}
}
// Get Data to look for revision ids
// TODO: Smarter solution!!
if (db.Equals("Tickets"))
{
// not sure if limit here would be working as intended as i don't know the ordering
// _db.Tickets.Take(limit).ToList();
// take the list and convert it into a json string
var tempString = JsonConvert.SerializeObject(_db.Tickets.ToList());
// If we now deserialize it, only the inclusive Parameters stay
pouchDataList = JsonConvert.DeserializeObject <List <PouchData> >(tempString);
}
else
{
Console.WriteLine("ERROR!!! Read TODOs. We may have other stuff than only Tickets");
}
}
// Get highest Sequence Number (Find latest Change)
int _seq = 0, highestSequenceId = 0;
string highestSequence = "";
List <Change> tempRevsList = new List <Change>();
foreach (Change cChange in revsList)
{
_seq = 0;
using (MessageControllerHelper helper = new MessageControllerHelper())
{
_seq = helper.ParseSeqId(cChange.seq);
}
if (highestSequenceId < _seq)
{
highestSequenceId = _seq;
highestSequence = cChange.seq;
}
// Remove first element since it is the same
if (!since.Equals("") && !since.Equals("0"))
{
continue;
}
tempRevsList.Add(cChange);
}
revsList = tempRevsList;
using (MessageControllerHelper helper = new MessageControllerHelper())
{
string temp;
using (ReturnParser parser = new ReturnParser())
{
temp = parser.GetChangesReturn(revsList, pouchDataList, highestSequence);
}
return(helper.GetJsonResponse(HttpStatusCode.OK, new StringContent(temp)));
}
}