def _set_developer_consumed(self, developer):
query = 'UPDATE developer SET status=%s WHERE name=%s'
try:
MySQLDBUtil.update(query, (CONSUMED, developer), self._db_conn)
except Exception:
self.logger.exception('Set devloper %s as consumed error' %
developer)
def _set_package_consumed(self, package_name):
query = 'UPDATE similar_app SET status=%s WHERE package_name=%s'
try:
MySQLDBUtil.update(query, (CONSUMED, package_name), self._db_conn)
except Exception:
self.logger.exception('Set package name %s as consumed error' %
package_name)
def _set_category_consumed(self, category):
query = 'UPDATE category SET status=%s WHERE category=%s'
try:
MySQLDBUtil.update(query, (CONSUMED, category), self._db_conn)
except Exception:
self.logger.exception('Set category %s as consumed error' %
category)
def _update_status(self, status, category=None):
if not category:
query = 'UPDATE category SET status=%s'
else:
query = 'UPDATE category SET status=%s WHERE category=%s'
try:
if not category:
MySQLDBUtil.update(query, (status,), self._db_conn)
else:
MySQLDBUtil.update(query, (status, category), self._db_conn)
except Exception:
self.logger.exception('Update record status')
def _update_status(self, status, package_name=None):
if not package_name:
query = 'UPDATE package_name SET status=%s'
else:
query = 'UPDATE package_name SET status=%s WHERE package_name=%s'
try:
if not package_name:
MySQLDBUtil.update(query, (status,), self._db_conn)
else:
MySQLDBUtil.update(query, (status, package_name), self._db_conn)
except Exception:
self.logger.exception('Update record status')
def _update_status(self, status, developer=None):
if not developer:
query = 'UPDATE developer SET status=%s'
else:
query = 'UPDATE developer SET status=%s WHERE name=%s'
try:
if not developer:
MySQLDBUtil.update(query, (status, ), self._db_conn)
else:
MySQLDBUtil.update(query, (status, developer), self._db_conn)
except Exception:
self.logger.exception('Update record status')
def _update_status(self, status, key_word=None):
if not key_word:
query = 'UPDATE key_word SET status=%s'
else:
query = 'UPDATE key_word SET status=%s WHERE key_word=%s'
try:
if not key_word:
MySQLDBUtil.update(query, (status, ), self._db_conn)
else:
MySQLDBUtil.update(query, (status, key_word), self._db_conn)
except Exception:
self.logger.exception('Update record status')
def _update_status(self, record_id, status):
query = 'UPDATE raw_text SET status=%s WHERE id=%s'
try:
MySQLDBUtil.update(query, (status, record_id), self._db_conn)
except Exception:
self.logger.exception('Update raw_text table status error')
def _set_key_word_consumed(self, key_word):
query = 'UPDATE key_word SET status=%s WHERE key_word=%s'
try:
MySQLDBUtil.update(query, (CONSUMED, key_word), self._db_conn)
except Exception:
self.logger.exception('Set key word %s as consumed error' % key_word)
