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]