public void setSignedPreKey(uint signedPreKeyId, SignedPreKeyRecord signedPreKey, string accountId)
{
dB.InsertOrReplace(new OmemoSignedPreKeyTable
{
id = OmemoSignedPreKeyTable.generateId(signedPreKeyId, accountId),
signedPreKeyId = signedPreKeyId,
accountId = accountId,
signedPreKey = signedPreKey.serialize()
});
}
public SignedPreKeyRecord getSignedPreKey(uint signedPreKeyId, string accountId)
{
List <OmemoSignedPreKeyTable> list = dB.Query <OmemoSignedPreKeyTable>(true, "SELECT * FROM " + DBTableConsts.OMEMO_SIGNED_PRE_KEY_TABLE + " WHERE id = ?;", OmemoSignedPreKeyTable.generateId(signedPreKeyId, accountId));
return(list.Count <= 0 ? null : new SignedPreKeyRecord(list[0].signedPreKey));
}
public void deleteSignedPreKey(uint signedPreKeyId, string accountId)
{
dB.Execute("DELETE FROM " + DBTableConsts.OMEMO_SIGNED_PRE_KEY_TABLE + " WHERE id = ?;", OmemoSignedPreKeyTable.generateId(signedPreKeyId, accountId));
}
//--------------------------------------------------------Misc Methods:---------------------------------------------------------------\\
#region --Misc Methods (Public)--
public bool containsSignedPreKey(uint signedPreKeyId, string accountId)
{
List <OmemoSignedPreKeyTable> list = dB.Query <OmemoSignedPreKeyTable>(true, "SELECT * FROM " + DBTableConsts.OMEMO_SIGNED_PRE_KEY_TABLE + " WHERE id = ?;", OmemoSignedPreKeyTable.generateId(signedPreKeyId, accountId));
return(list.Count > 0);
}
