def saveRelation(data):
try:
for item in data:
sql = "select id from t_page_stage_relation where page_url = '%s' and stage_id = %d and cmd_format = '%s' " % (
item['page_url'], int(item['stage_id']), item['cmd_format'])
if not Db.fetch_one(sql):
sql = "insert t_page_stage_relation(page_url,user_id,stage_id,cmd_format,create_time) values('%s',%d,%d,'%s',%d)" \
%(item['page_url'], 0,int(item['stage_id']),item['cmd_format'],int(time.time()))
Db.insert(sql)
return True
except Exception as err:
print(err)
return False
def getUser(id=1):
sql = 'select * from t_user where id = '+ str(id)
return Db.fetch_one(sql)
