Ejemplo n.º 1
0
	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
Ejemplo n.º 2
0
	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