//private DBEngine<int, DBElement<int, List<int>>> keysFromQuery = new DBEngine<int, DBElement<int, List<int>>>();
public string query(XDocument message) {//method used to handle queries
string reply;
List<int> children = new List<int>();
XElement element = message.Element("Message").Element("QueryType");
Query<int, int, string> query1 = new Query<int, int, string>(db);
switch(element.Value){
case "the value of specified key":
element = message.Element("Message").Element("Key");
DBElement<int, string> elem = new DBElement<int, string>();
query1.checkValueByKey(Int32.Parse(element.Value), out elem);
reply = ("The value of specified key " + element.Value + " is\n" + elem.showElement<int, string>());
break;
case "the children of specified key":
element = message.Element("Message").Element("Key");
children = query1.childrenByKey(Int32.Parse(element.Value));
reply = ("The children of specified key " + element.Value + " is\n");
reply = this.addChildToStr(children, reply);
break;
case "the keys share a same pattern":
element = message.Element("Message").Element("Pattern");
Query<string, int, string> queryString = new Query<string, int, string>(dbString);
List<string> keyString = new List<string>();
keyString = queryString.keysWithPattern(dbString,element.Value);
reply = ("The keys share a same pattern \"" + element.Value + "\" is\n");
foreach(var key in keyString)
reply += (String.Format("{0}\n", key.ToString()));
break;
case "the keys share same pattern in their metadata":
element = message.Element("Message").Element("Pattern");
children = query1.keysSameMdataPattern(element.Value);
reply = ("The keys share same pattern " + element.Value + " is\n");
reply = this.addChildToStr(children, reply);
break;
case "the keys of value created in the same time interval":
List<DateTime> dts = new List<DateTime>();
dts = this.getDTS(message);
children = query1.keysSameTinterval(dts[0], dts[1]);
reply = ("The keys of value created in the same time interval between " + dts[0].ToString() + " and " + dts[1]).ToString()+"\n";
reply = this.addChildToStr(children, reply);
break;
default:
reply = ("Invalid editing type.");
break;
}
return reply;
}
void TestR7()
{
"Demonstrating Requirement #7".title();
Write("\n\n --- Query the value of specified key Start---\n");
Query<int, int, string> query = new Query<int, int, string>(db);
DBElement<int, string> elemR7 = new DBElement<int, string>();
query.checkValueByKey(2, out elemR7);
elemR7.showElement();
Write("\n\n --- Query the value of specified key End---\n");
WriteLine();
/*****************************************************************/
Write("\n\n --- Query the children of specified key Start---\n");
Write("Children of value with key #2");
List<int> children = new List<int>();
children = query.childrenByKey(2);
foreach(var child in children)
Write("\n"+child);
Write("\n\n --- Query the children of specified key End---\n");
/*****************************************************************/
Write("\n\n --- Query the keys share a same pattern Start---\n");
DBElement<int, string> elemR701 = new DBElement<int, string>();
elemR701.name = "r701";
elemR701.descr = "su cs";
elemR701.timeStamp = DateTime.Now;
elemR701.children.AddRange(new List<int>{ 1, 2, 3 });
elemR701.payload = "cs";
dbString.insert("SU cs dep", elemR701);
DBElement<int, string> elemR702 = new DBElement<int, string>();
elemR702.name = "r702";
elemR702.descr = "su math";
elemR702.timeStamp = DateTime.Now;
elemR702.children.AddRange(new List<int>{ 4, 5, 2 });
elemR702.payload = "math";
dbString.insert("SU math dep", elemR702);
DBElement<int, string> elemR703 = new DBElement<int, string>();
elemR703.name = "r703";
elemR703.descr = "cornell math";
elemR703.timeStamp = DateTime.Now;
elemR703.children.AddRange(new List<int>{ 4, 5, 2 });
elemR703.payload = "music";
dbString.insert("CORNELL music dep", elemR703);
IEnumerable<string> keys = dbString.Keys();
Write("All keys in this database:");
foreach(var key in keys)
Write("\n"+key);
Query<string, int, string> queryString = new Query<string, int, string>(dbString);
List<string> keyString = new List<string>();
keyString = queryString.keysWithPattern(dbString,"SU");
Write("\n\nKeys with pattern SU:");
foreach(var key in keyString)
Write("\n"+key);
Write("\n\n --- Query the keys share a same pattern End---\n");
/*****************************************************************/
Write("\n\n --- Query the keys share a same pattern Start---\n");
db.showDB();
Write("\n\nKeys with pattern ‘description’ in there metadata(name & descr):");
List<int> keyslist = new List<int>();
keyslist = query.keysSameMdataPattern("description");
foreach(var key in keyslist)
Write("\n"+key);
Write("\n\n --- Query the keys share a same pattern End---\n");
/*****************************************************************/
Write("\n\n --- Query the keys of value created in the same time interval Start---\n");
DBElement<int, string> temp = new DBElement<int, string>();
db.getValue(7, out temp);
temp.timeStamp = new DateTime(1991, 4, 15, 8, 9, 05);
db.getValue(82, out temp);
temp.timeStamp = new DateTime(1994, 9, 7, 10, 8, 55);
db.showDB();
DateTime dt1 = new DateTime(1990, 4, 15, 5, 9, 05);
DateTime dt2 = new DateTime(1995, 9, 7, 5, 8, 05);
Write("\n\nkeys of value created after 1990/4/15 05:09:05 but before 1995/9/7 05:08:05:");
keyslist = query.keysSameTinterval(dt1, dt2);
foreach(var key in keyslist)
Write("\n"+key);
Write("\n\n --- Query the keys of value created in the same time interval Start---\n");
}