def view_user(user_id):
friends = {}
for one_id in friend.select(user_id):
friend_dict = user.select(one_id)
if 'name' in friend_dict:
friends[one_id] = friend_dict
return render_template('user.html',
user=user.select(user_id),
friend=friends
)
def search(key, value, lag, lng):
business_list = business.sort_by({key: value}, [key], [u'='], u'*', u'*')
# user_loc = (40.12889642298632,-88.22373041280238)
user_loc = (float(lag), float(lng))
RS = recommender(business_list, user_loc)
business_list = RS.recommend()
page, per_page, offset = get_page_args(page_parameter='page',
per_page_parameter='per_page')
per_page = 10
pagination = Pagination(page=page,
per_page=per_page,
total=len(business_list),
search=False,
record_name='results')
business_list = business_list[(page - 1) * per_page:page * per_page]
category_list = []
checkin_list = []
review_list = []
user_list = []
for business_item in business_list:
business_id = business_item[u'id']
category_list.append(category.select(business_id))
checkin_list.append(checkin.select(business_id))
review_items = review.select(business_id, u'*')
keys = list(review_items.keys())
if len(keys) > 0:
user_list.append(user.select(review_items[keys[0]][u'user_id']))
s = review_items[keys[0]]['text']
s2 = ' '.join(s.split(' ')[0:80]) + "..."
review_list.append(s2)
else:
user_list.append({})
review_list.append(review_items)
num_checkin_list = []
for c in checkin_list:
num_checkin_list.append(sum(list(c.values())))
# When the search result lists are generated.
laglng_list = [[b['name'], b['latitude'], b['longitude']]
for b in business_list]
result_list = list()
for idx in range(0, len(business_list)):
result = dict()
result['category'] = ', '.join(list(category_list[idx].values()))
result['business'] = business_list[idx]
result['num_checkin'] = num_checkin_list[idx]
result['review'] = review_list[idx]
result['user'] = user_list[idx]
result_list.append(result)
return render_template(
u'search.html',
# business = business_list[0] if len(business_list) > 0 else None,
result_list=result_list,
laglng_list=laglng_list,
page=page,
per_page=per_page,
pagination=pagination)
def insert(self, user_id, friend):
from datamodel.user import user
if len(user.select(user_id)) < 1:
user.insert(user_id, {})
for key in friend:
self.query_sql = \
u'INSERT INTO `friend`(`user_id`, `friend_id`) ' \
+ 'VALUES("%s", "%s")' % (user_id, key)
super().execute()
def insert(self, user_id, elite_years):
from datamodel.user import user
if len(user.select(user_id)) < 1:
user.insert(user_id, {})
for key in elite_years:
self.query_sql = \
u'INSERT INTO `elite_years`(`user_id`, `year`) ' \
+ 'VALUES("%s", "%s")' % (user_id, key)
super().execute()
def insert(self, business_id, user_id, tip):
from datamodel.business import business
if len(business.select(business_id)) < 1:
business.insert(business_id, {})
from datamodel.user import user
if len(user.select(user_id)) < 1:
user.insert(user_id, {})
for key, val in tip.items():
k = []
v = []
for attr in self.dm_attr:
k.append(attr)
v.append(self.quote_sql(val[attr]))
self.query_sql = u'INSERT INTO `tip`(%s) ' % (u','.join(k)) \
+ 'VALUES(%s)' % (u','.join(v))
super().execute()
def insert(self, business_id, user_id, review):
from datamodel.business import business
if len(business.select(business_id)) < 1:
business.insert(business_id, {})
from datamodel.user import user
if len(user.select(user_id)) < 1:
user.insert(user_id, {})
for key, val in review.items():
k = [u'id']
v = [self.quote_sql(key)]
for attr in self.dm_attr:
if attr in val and attr != u'id':
k.append(attr)
v.append(self.quote_sql(val[attr]))
self.query_sql = u'INSERT INTO `review`(%s) ' % (u','.join(k)) \
+ 'VALUES(%s)' % (u','.join(v))
super().execute()
def view_friend():
url_for('static', filename='css/user.css')
return render_template('friend.html',
user=user.select("user_id not defined"),
)