def add_photo(self, user, photo): usrDao = UserDAO() roles = usrDao.get_role(user) if '3' in roles: session_power.add(photo) session_power.commit() return 1 else: return -1
def add_tower(self, user, tower): usrDao = UserDAO() roles = usrDao.get_role(user) if '3' in roles: session_power.add(tower) session_power.commit() return 1 else: return -1
def add_lines(self, user, lines): usrDao = UserDAO() roles = usrDao.get_role(user) if '3' in roles: for item in lines: session_power.add(item) session_power.commit() return 1 else: return -1
def add_photo(self, user, photo): usrDao = UserDAO() roles = usrDao.get_role(user) if '3' in roles: self.session_power.add(photo) try: self.session_power.commit() except: self.session_power.rollback() return 1 else: return 3030701
def update_tower(self, user, tower): usrDao = UserDAO() roles = usrDao.get_role(user) if '3' in roles: self.session_power.merge(tower) try: self.session_power.commit() except: self.session_power.rollback() return 1 else: return 3020501
def add_line(self, user, line): usrDao = UserDAO() roles = usrDao.get_role(user) if '3' in roles: self.session_power.add(line) try: self.session_power.commit() except: self.session_power.rollback() return 1 else: return 3010901
def add_photos(self, user, photos): usrDao = UserDAO() roles = usrDao.get_role(user) if '3' in roles: for item in photos: self.session_power.add(item) try: self.session_power.commit() except: self.session_power.rollback() return 1 else: return 3030901
def query_tower_pages(self, user, voltage, work_team, line_name, page_size): q = self.session_power.query(Lines) usrDao = UserDAO() roles = usrDao.get_role(user) if voltage: q = q.filter(Lines.lines_voltage == voltage) if work_team: q = q.filter(Lines.lines_work_team == work_team) if line_name: q = q.filter(Lines.lines_name == line_name) lines = q.filter(Lines.deleted == 0).all() linenames = [] for line in lines: linenames.append(line.lines_name) towersNum = self.session_power.query(Towers).filter( Towers.tower_linename.in_(linenames)).count() / page_size + 1 item = {} item['pages'] = towersNum return item
def query_line_condition(self, user, voltage, work_team, line_name, page_size, page_index): q = self.session_power.query(Lines) usrDao = UserDAO() roles = usrDao.get_role(user) if voltage: q = q.filter(Lines.lines_voltage == voltage) if work_team: q = q.filter(Lines.lines_work_team == work_team) if line_name: q = q.filter(Lines.lines_name == line_name) lines = q.filter(Lines.deleted == 0).all() linenames = [] for line in lines: linenames.append(line.lines_name) if len(linenames) > 0: towers = self.session_power.query(Towers).filter( Towers.tower_linename.in_(linenames)).limit(page_size).offset( (page_index - 1) * page_size).all() return class_to_dict(towers) else: return None