def insert(self, business_id, hours):
from datamodel.business import business
if len(business.select(business_id)) < 1:
business.insert(business_id, {})
for key, val in hours.items():
self.query_sql = \
u'INSERT INTO `hours`(`business_id`, `hours`) ' \
+ 'VALUES("%s", "%s")' % (business_id, key + "|" + val)
super().execute()
def insert(self, business_id, category):
from datamodel.business import business
if len(business.select(business_id)) < 1:
business.insert(business_id, {})
for key, val in category.items():
self.query_sql = \
u'INSERT INTO `category`(`business_id`, `category`) ' \
+ 'VALUES("%s", "%s")' \
% (business_id, val)
super().execute()
def insert(self, business_id, attribute):
from datamodel.business import business
if len(business.select(business_id)) < 1:
business.insert(business_id, {})
for key, val in attribute.items():
self.query_sql = \
u'INSERT INTO `attribute`(`business_id`, `name`, `value`) ' \
+ 'VALUES("%s", %s, %s)' \
% (business_id, self.quote_sql(key), self.val2sql(val))
super().execute()
def insert(self, business_id, photo):
from datamodel.business import business
if len(business.select(business_id)) < 1:
business.insert(business_id, {})
for key, val in photo.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 `photo`(%s) ' % (u','.join(k)) \
+ 'VALUES(%s)' % (u','.join(v))
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()