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)