public void setPreKey(uint preKeyId, PreKeyRecord preKey, string accountId)
{
dB.InsertOrReplace(new OmemoPreKeyTable
{
id = OmemoPreKeyTable.generateId(preKeyId, accountId),
preKeyId = preKeyId,
accountId = accountId,
preKey = preKey.serialize()
});
}
public void setPreKeys(IList <PreKeyRecord> preKeys, string accountId)
{
dB.BeginTransaction();
deletePreKeys(accountId);
foreach (PreKeyRecord key in preKeys)
{
dB.InsertOrReplace(new OmemoPreKeyTable
{
id = OmemoPreKeyTable.generateId(key.getId(), accountId),
preKeyId = key.getId(),
accountId = accountId,
preKey = key.serialize()
});
}
dB.Commit();
}
public PreKeyRecord getPreKeyRecord(uint preKeyId, string accountId)
{
List <OmemoPreKeyTable> list = dB.Query <OmemoPreKeyTable>(true, "SELECT * FROM " + DBTableConsts.OMEMO_PRE_KEY_TABLE + " WHERE id = ?;", OmemoPreKeyTable.generateId(preKeyId, accountId));
if (list.Count <= 0)
{
return(null);
}
return(new PreKeyRecord(list[0].preKey));
}
public void deletePreKey(uint preKeyId, string accountId)
{
dB.Execute("DELETE FROM " + DBTableConsts.OMEMO_PRE_KEY_TABLE + " WHERE id = ?;", OmemoPreKeyTable.generateId(preKeyId, accountId));
}
public bool containsPreKeyRecord(uint preKeyId, string accountId)
{
List <OmemoPreKeyTable> list = dB.Query <OmemoPreKeyTable>(true, "SELECT * FROM " + DBTableConsts.OMEMO_PRE_KEY_TABLE + " WHERE id = ?;", OmemoPreKeyTable.generateId(preKeyId, accountId));
return(list.Count > 0);
}
