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); }