def getNewConcertList(user_name): sf_db = SFDBManager.SFDBManager() concert_query_sentence = """SELECT DISTINCT concert_id, title FROM concert WHERE create_time > (SELECT last_access_time FROM user WHERE user_name = %s)""" concert_user_set = [user_name] concert_list = sf_db.query_data(concert_query_sentence, concert_user_set) return concert_list
def checkIsLiked(username,artistname): sf_db = SFDBManager.SFDBManager() check_ulikea_query_sentence = """SELECT * FROM like_artist WHERE from_user =%s AND to_artist = %s""" check_ulikea_set = [username,artistname] check_ulikea_list = sf_db.query_data(check_ulikea_query_sentence, check_ulikea_set) if check_ulikea_list: return True else: return False