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