public HttpResponseMessage CheckExistence(string db)
{
// TODO: check correclty. Check in datacontext.ExistingTables.Contains
bool exists = false;
// TODO: check correctly
bool insufficientPriviledges = false;
object temp;
if (insufficientPriviledges)
{
temp = new { error = "unauthorized", reason = "could not open unauthorized to access or create database" };
using (MessageControllerHelper helper = new MessageControllerHelper())
return(helper.GetJsonResponse(HttpStatusCode.Unauthorized, new StringContent(JsonConvert.SerializeObject(temp))));
}
if (exists)
{
temp = new { ok = true };
using (MessageControllerHelper helper = new MessageControllerHelper())
return(helper.GetJsonResponse(HttpStatusCode.OK, new StringContent(JsonConvert.SerializeObject(temp))));
}
else
{
temp = new { error = "db_not_found", reason = "could not open source" };
using (MessageControllerHelper helper = new MessageControllerHelper())
return(helper.GetJsonResponse(HttpStatusCode.NotFound, new StringContent(JsonConvert.SerializeObject(temp))));
}
}
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 BulkAllDocs(string dbName, [FromBody] object msg)
{
Console.WriteLine("Adding Bulk of new Docs");
JObject msgJson = JObject.Parse(msg.ToString());
var data = msgJson["docs"];
List <PouchData> newData = new List <PouchData>();
foreach (var cPouchData in data)
{
Console.WriteLine(JsonConvert.SerializeObject(cPouchData));
//TODO: Make this smarter!!!
if (dbName.Equals("Tickets"))
{
newData.Add(JsonConvert.DeserializeObject <Ticket>(JsonConvert.SerializeObject(cPouchData)));
}
}
using (DatabaseContext db = new DatabaseContext())
{
if (dbName.Equals("Tickets"))
{
List <Ticket> ticketsToAdd = new List <Ticket>();
foreach (Ticket cTicket in newData)
{
if (MessageController.AlreadyExists(cTicket, "Tickets"))
{
// tempItemToAdd = DatabaseHelper.Instance.EditItem(tempItem, "Tickets");
Console.WriteLine(cTicket._rev + " already exists, skipping (change to edit if different)");
continue;
}
ticketsToAdd.Add(cTicket);
}
db.Tickets.AddRange(ticketsToAdd);
}
db.SaveChanges();
}
// TODO: Add new edits. What is it used for?
// msgJson["new_edits"];
// Add new Changes
foreach (PouchData cPouchData in newData)
{
using (MessageControllerHelper helper = new MessageControllerHelper())
{
helper.AddNewChange(cPouchData, dbName);
}
}
using (MessageControllerHelper helper = new MessageControllerHelper())
{
return(helper.GetJsonResponse(HttpStatusCode.OK, new StringContent("[]")));
}
}
public HttpResponseMessage PutDatabase(string db)
{
// TODO: Check if DB already exists
// If it does, do nothing
// TODO: Generate Table
// As we are using EF, the database already has to exist before
object temp = new { ok = "ok" };
using (MessageControllerHelper helper = new MessageControllerHelper())
return(helper.GetJsonResponse(HttpStatusCode.OK, new StringContent(JsonConvert.SerializeObject(temp))));
}
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 GetPeersInformation()
{
try
{
using (MessageControllerHelper helper = new MessageControllerHelper())
{
ConnectorInfo TempConnI = new ConnectorInfo();
try
{
// TODO: Secure this, what if db info gets deleted while programm is running
using (DatabaseContext db = new DatabaseContext())
TempConnI = db.Info.First();
}
catch (Exception e)
{
Console.WriteLine("Error when getting data from Info, e: " + e.Message);
throw new Exception(e.Message);
}
object tempRetObject = new
{
instance_start_time = TempConnI.InstanceStartTime,
update_seq = TempConnI.UpdateSeq,
version = TempConnI.Version,
vendor = TempConnI.Vendor
};
return(helper.GetJsonResponse(HttpStatusCode.OK, new StringContent(JsonConvert.SerializeObject(tempRetObject))));
}
}
catch (Exception e)
{
Console.WriteLine("Exception in Init Db, e: " + e.Message);
object tempRetObject = new { exception = e.Message };
using (MessageControllerHelper helper = new MessageControllerHelper())
return(helper.GetJsonResponse(HttpStatusCode.InternalServerError, new StringContent(JsonConvert.SerializeObject(tempRetObject))));
}
}
public HttpResponseMessage RetriveReplicationLogs(string database, string documentId)
{
try
{
bool found = false;
List <ReplicationLog> ReplicationLogs;
try
{
using (DatabaseContext db = new DatabaseContext())
{
ReplicationLogs = db.ReplicationLog.Where(entity => entity.DatabaseName.Equals(database) && entity.DocumentId.Equals(documentId)).ToList();
if (ReplicationLogs.Count > 0)
{
found = true;
}
}
}
catch (Exception e)
{
Console.WriteLine("Exception in RetriveReplicationLogs, e: " + e.Message);
throw new Exception(e.Message);
}
object temp;
if (found)
{
try
{
// TODO: Implement Parse of the whole replication log, for more info look in v3, already done there but not complete
using (ReplicationLogParser RepParser = new ReplicationLogParser())
temp = RepParser.Parse(ReplicationLogs);
using (MessageControllerHelper helper = new MessageControllerHelper())
return(helper.GetJsonResponse(HttpStatusCode.OK, new StringContent(JsonConvert.SerializeObject(temp))));
}
catch (Exception e)
{
Console.WriteLine("Exception in RetriveReplicationLogs, e: " + e.Message);
throw new Exception(e.Message);
}
}
else
{
temp = new
{
error = "not_found",
reason = "missing"
};
using (MessageControllerHelper helper = new MessageControllerHelper())
return(helper.GetJsonResponse(HttpStatusCode.OK, new StringContent(JsonConvert.SerializeObject(temp))));
}
}
catch (Exception e)
{
Console.WriteLine("Exception in RetriveReplicationLogs" + e.Message);
object tempRetObject = new { exception = e.Message };
using (MessageControllerHelper helper = new MessageControllerHelper())
return(helper.GetJsonResponse(HttpStatusCode.InternalServerError, new StringContent(JsonConvert.SerializeObject(tempRetObject))));
}
}
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)));
}
}