def queryPrivateSetting(self, user_id): conn = self._pool.connection() cursor = conn.cursor() try: sql = "select * from fd_t_privatesetting where user_id = %s" paras = (user_id, ) row_count = cursor.execute(sql, paras) if row_count <= 0: user_log.error("No private setting data! User id: %s", user_id) return None row = cursor.fetchone() setting = {} setting["favoriteEnable"] = row["save_enable"] setting["fansEnable"] = row["fans_enable"] setting["visitEnable"] = row["visit_enable"] return setting except MySQLdb.Error, e: user_log.error( "Query private setting failed! sql: %s, paras: %s, exception: %s", sql, paras, e) user_log.exception(e) return None
def insertPrivateSetting(self, user_id): conn = self._pool.connection() cursor = conn.cursor() try: sql = "insert into fd_t_privatesetting set (user_id, save_enable, fans_enable, visit_enable) values (%s, 1, 1, 1)" paras = (user_id,) row_count = cursor.execute(sql, paras) if row_count <= 0: return False return True except MySQLdb.Error, e: user_log.error("Query private setting failed! sql: %s, paras: %s, exception: %s", sql, paras, e) user_log.exception(e) return None
def insertPrivateSetting(self, user_id): conn = self._pool.connection() cursor = conn.cursor() try: sql = "insert into fd_t_privatesetting set (user_id, save_enable, fans_enable, visit_enable) values (%s, 1, 1, 1)" paras = (user_id, ) row_count = cursor.execute(sql, paras) if row_count <= 0: return False return True except MySQLdb.Error, e: user_log.error( "Query private setting failed! sql: %s, paras: %s, exception: %s", sql, paras, e) user_log.exception(e) return None
def getAddressID(self): conn = self._pool.connection() cursor = conn.cursor() try: sql = "select fd_func_nextvalue('FD_ADDRESS_ID') as addr_id from dual" row_count = cursor.execute(sql) if row_count <= 0: user_log.error("Get address id failed") conn.rollback() return None row = cursor.fetchone() addr_id = row["addr_id"] conn.commit() return addr_id except MySQLdb.Error, e: user_log.exception(e) conn.rollback() return None
def queryPrivateSetting(self, user_id): conn = self._pool.connection() cursor = conn.cursor() try: sql = "select * from fd_t_privatesetting where user_id = %s" paras = (user_id,) row_count = cursor.execute(sql, paras) if row_count <= 0: user_log.error("No private setting data! User id: %s", user_id) return None row = cursor.fetchone() setting = {} setting["favoriteEnable"] = row["save_enable"] setting["fansEnable"] = row["fans_enable"] setting["visitEnable"] = row["visit_enable"] return setting except MySQLdb.Error, e: user_log.error("Query private setting failed! sql: %s, paras: %s, exception: %s", sql, paras, e) user_log.exception(e) return None
row_count = cursor.execute(sql) if row_count <= 0: user_log.error("Get address id failed") conn.rollback() return None row = cursor.fetchone() addr_id = row["addr_id"] conn.commit() return addr_id except MySQLdb.Error, e: user_log.exception(e) conn.rollback() return None except Exception, e: user_log.exception(e) conn.rollback() return None finally: cursor.close() conn.close() def addAddress(self, user_id, name, phone, address, postcode, province_id, city_id): conn = self._pool.connection() cursor = conn.cursor() try: addr_id = self.getAddressID() if addr_id is None: user_log.error("Get address id failed!")
sql = "insert into fd_t_privatesetting set (user_id, save_enable, fans_enable, visit_enable) values (%s, 1, 1, 1)" paras = (user_id, ) row_count = cursor.execute(sql, paras) if row_count <= 0: return False return True except MySQLdb.Error, e: user_log.error( "Query private setting failed! sql: %s, paras: %s, exception: %s", sql, paras, e) user_log.exception(e) return None except Exception, e: user_log.error("Query private setting failed! Exception: %s", e) user_log.exception('e') return None finally: cursor.close() conn.close() def queryPrivateSetting(self, user_id): conn = self._pool.connection() cursor = conn.cursor() try: sql = "select * from fd_t_privatesetting where user_id = %s" paras = (user_id, ) row_count = cursor.execute(sql, paras) if row_count <= 0:
cursor = conn.cursor() try: sql = "insert into fd_t_privatesetting set (user_id, save_enable, fans_enable, visit_enable) values (%s, 1, 1, 1)" paras = (user_id,) row_count = cursor.execute(sql, paras) if row_count <= 0: return False return True except MySQLdb.Error, e: user_log.error("Query private setting failed! sql: %s, paras: %s, exception: %s", sql, paras, e) user_log.exception(e) return None except Exception, e: user_log.error("Query private setting failed! Exception: %s", e) user_log.exception('e') return None finally: cursor.close() conn.close() def queryPrivateSetting(self, user_id): conn = self._pool.connection() cursor = conn.cursor() try: sql = "select * from fd_t_privatesetting where user_id = %s" paras = (user_id,) row_count = cursor.execute(sql, paras) if row_count <= 0:
row_count = cursor.execute(sql) if row_count <= 0: user_log.error("Get address id failed") conn.rollback() return None row = cursor.fetchone() addr_id = row["addr_id"] conn.commit() return addr_id except MySQLdb.Error, e: user_log.exception(e) conn.rollback() return None except Exception, e: user_log.exception(e) conn.rollback() return None finally: cursor.close() conn.close() def addAddress(self, user_id, name, phone, address, postcode, province_id, city_id): conn = self._pool.connection() cursor = conn.cursor() try: addr_id = self.getAddressID() if addr_id is None: user_log.error("Get address id failed!") return None