public void ElementsTest()
{
var e1 = new Message()
{
From = new Jid("from@s/R"),
To = new Jid("to@s/R"),
Type = MessageType.headline,
Body = "body",
Subject = "subject",
};
var e2 = new Message()
{
From = new Jid("from@s/R"),
To = new Jid("to@s/R"),
Type = MessageType.headline,
Body = "body",
Subject = "subject",
};
var key = "key";
storage.SaveElement(e1.To, key + "|1", e1);
storage.SaveElement(e2.To, key + "|2", e2);
var fromdb = storage.GetElements(Jid.Empty, key);
CollectionAssert.IsEmpty(fromdb);
fromdb = storage.GetElements(e1.To, key + "%");
Assert.AreEqual(2, fromdb.Count());
Assert.AreEqual(e1.ToString(), fromdb.ElementAt(0).ToString());
Assert.AreEqual(e2.ToString(), fromdb.ElementAt(1).ToString());
var frome = storage.GetElement(e1.To, key + "|1");
Assert.AreEqual(e1.ToString(), frome.ToString());
frome = storage.GetElement(e2.To, key + "|2");
Assert.AreEqual(e2.ToString(), frome.ToString());
fromdb = storage.GetElements(e1.To, key + "|1");
Assert.AreEqual(1, fromdb.Count());
Assert.AreEqual(e1.ToString(), fromdb.ElementAt(0).ToString());
storage.RemoveElements(e1.To, key + "|1");
fromdb = storage.GetElements(e1.To, key + "|1");
CollectionAssert.IsEmpty(fromdb);
fromdb = storage.GetElements(e1.To, "%");
Assert.AreEqual(1, fromdb.Count());
Assert.AreEqual(e2.ToString(), fromdb.ElementAt(0).ToString());
storage.RemoveElements(e1.To, "%");
fromdb = storage.GetElements(e1.To, key);
CollectionAssert.IsEmpty(fromdb);
}
public bool RemoveUser(string username)
{
CheckUsername(username);
var affected = 0;
using (var db = GetDb())
{
affected = db.ExecuteNonQuery(new SqlDelete("jabber_user").Where("username", username));
}
elements.RemoveElements(new Jid(username), "%");
return(0 < affected);
}
public static void RemoveOfflines(this IXmppElementStorage storage, Jid jid)
{
storage.RemoveElements(jid, "offline|%");
}