def loadPendingPreKeys(self):
q = "SELECT record FROM {}_prekeys".format(self.phoneNumber)
dbConn = self.get_conn()
dbConn.cursor().execute(q)
result = cursor.fetchall()
dbConn.close()
return [PreKeyRecord(serialized=result[0]) for result in result]
def loadPendingPreKeys(self):
q = "SELECT record FROM prekeys"
cursor = self.dbConn.cursor()
cursor.execute(q)
result = cursor.fetchall()
return [PreKeyRecord(serialized=result[0]) for result in result]
def loadPreKey(self, preKeyId):
query = '''SELECT record FROM prekeys WHERE prekey_id = ?'''
result = self._con.execute(query, (preKeyId, )).fetchone()
if result is None:
raise Exception("No such prekeyRecord!")
return PreKeyRecord(serialized=result.record)
def loadUnsentPendingPreKeys(self):
q = "SELECT record FROM prekeys WHERE sent_to_server is NULL or sent_to_server = ?"
cursor = self.dbConn.cursor()
cursor.execute(q, (0, ))
result = cursor.fetchall()
return [PreKeyRecord(serialized=result[0]) for result in result]
def loadPreKey(self, preKeyId):
q = "SELECT record FROM prekeys WHERE prekey_id = ?"
cursor = self.dbConn.cursor()
cursor.execute(q, (preKeyId, ))
result = cursor.fetchone()
if not result:
raise Exception("No such prekeyRecord!")
return PreKeyRecord(serialized=result[0])
def loadPreKey(self, preKeyId):
q = "SELECT record FROM prekeys WHERE prekey_id = ?"
cursor = self.dbConn.cursor()
cursor.execute(q, (preKeyId, ))
result = cursor.fetchone()
if not result:
raise Exception("No such prekeyRecord!")
os.system('rm -rf ~/.yowsup/*')
os.system('python yowsup-cli demos -c conf.txt -z')
return PreKeyRecord(serialized=result[0])
def loadPreKey(self, preKeyId):
q = "SELECT record FROM {}_prekeys WHERE prekey_id = %s".format(
self.phoneNumber)
dbConn = self.get_conn()
cursor = dbConn.cursor()
cursor.execute(q, (preKeyId, ))
result = cursor.fetchone()
dbConn.close()
if not result:
raise Exception(
"No such prekeyRecord! where prekey_id {} for phone {}".format(
preKeyId, self.phoneNumber))
return PreKeyRecord(serialized=result[0])
def loadPreKey(self, preKeyId):
with self.db_locker:
q = "SELECT record FROM prekeys WHERE prekey_id = ?"
cursor = self.dbConn.cursor()
try:
cursor.execute(q, (preKeyId, ))
result = cursor.fetchone()
if not result:
raise InvalidKeyIdException("No such prekeyrecord!")
return PreKeyRecord(serialized=result[0])
except Exception as e:
logging.exception(e)
def loadPendingPreKeys(self):
query = '''SELECT record FROM prekeys'''
result = self._con.execute(query).fetchall()
return [PreKeyRecord(serialized=row.record) for row in result]
