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 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
