public void setPreKey(uint preKeyId, PreKeyRecord preKey, string accountId) { dB.InsertOrReplace(new PreKeyTable() { id = PreKeyTable.generateId(preKeyId, accountId), preKeyId = preKeyId, accountId = accountId, preKey = preKey.serialize() }); }
public PreKeyRecord getPreKeyRecord(uint preKeyId, string accountId) { List <PreKeyTable> list = dB.Query <PreKeyTable>(true, "SELECT * FROM " + DBTableConsts.PRE_KEY_TABLE + " WHERE id = ?;", PreKeyTable.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.PRE_KEY_TABLE + " WHERE id = ?;", PreKeyTable.generateId(preKeyId, accountId)); }
public bool containsPreKeyRecord(uint preKeyId, string accountId) { List <PreKeyTable> list = dB.Query <PreKeyTable>(true, "SELECT * FROM " + DBTableConsts.PRE_KEY_TABLE + " WHERE id = ?;", PreKeyTable.generateId(preKeyId, accountId)); return(list.Count > 0); }