def query_towers_all(self):
rs = self.session_power.query(Towers).filter(Towers.deleted == 0).all()
trasnRs = []
for item in rs:
item.tower_idx = extractTowerName(item.tower_idx)
trasnRs.append(item)
return class_to_dict(trasnRs)
def query_line_pages(self, work_team, page_size, page_index):
q = self.session_power.query(Lines)
if work_team:
q = q.filter(Lines.lines_work_team == work_team)
lines = q.filter(Lines.deleted == 0).limit(page_size).offset(
(page_index - 1) * page_size).all()
return class_to_dict(lines)
def query_video(self, linename, videotime):
query = self.session_power.query(Video)
if linename != None:
query = query.filter(Video.video_line == linename)
if videotime != None:
query = query.filter(Video.video_time == videotime)
videos = query.all()
return class_to_dict(videos)
def query_photo_idx(self, photoidx):
rs = self.session_power.query(Photo).filter(
Photo.photo_id == photoidx).first()
#根据查到的线路id获取电压等级
lineinfo = self.session_power.query(Lines).filter(
Lines.lines_id == rs.photo_line).first()
dic = class_to_dict(rs)
dic['voltage'] = lineinfo.lines_voltage
return dic
def query_photo_condition(self, start_date, end_date, tower_id):
q = self.session_power.query(Photo)
if start_date != None:
q = q.filter(Photo.photo_date >= start_date)
if end_date != None:
q = q.filter(Photo.photo_date <= end_date)
if tower_id != None:
q = q.filter(Photo.photo_tower_id == tower_id)
photos = q.all()
return class_to_dict(photos)
def query_defect_photo(self, user, photo_id):
defects = self.session_power.query(Defect).filter(
Defect.tb_defect_photoid == photo_id).all()
self.session_power.rollback()
#photoids=[]
#for defect in defects:
# photoids.append(defect.tb_defect_photoid)
#photo = self.session_power.query(Photo).filter(Photo.photo_id.in_(photoids)).all()
#self.session_power.rollback()
return class_to_dict(defects)
def query_towers(self, linename):
if linename is not None:
rs = self.session_power.query(Towers).filter(
Towers.tower_linename == linename,
Towers.deleted == 0).order_by(Towers.tower_idx).all()
trasnRs = []
for item in rs:
item.tower_idx = extractTowerName(item.tower_idx)
trasnRs.append(item)
return class_to_dict(trasnRs)
else:
return self.query_towers_all()
def query_search(self, tower_id, photo_id):
defects = self.session_power.query(Defect).filter(
Defect.tb_defect_towerid == tower_id,
Defect.tb_defect_photoid == photo_id).all()
self.session_power.rollback()
photoids = []
for defect in defects:
photoids.append(defect.tb_defect_photoid)
photo = self.session_power.query(Photo).filter(
Photo.photo_id.in_(photoids)).all()
self.session_power.rollback()
return class_to_dict(photo)
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
def query_lines(self):
rs = self.session_power.query(Lines).filter(Lines.deleted == 0).all()
return class_to_dict(rs)
def dataservice_search(self, linename):
rs = self.session_power.query(DataService).filter(
DataService.tb_dataservice_linename == linename).all()
return class_to_dict(rs)
def query_line_fuzzy(self, linename):
filter = '%' + linename + '%'
rs = self.session_power.query(Lines).filter(
Lines.lines_name.like(filter)).all()
return class_to_dict(rs)
def query_towers(self):
rs = session_power.query(Towers).all()
return class_to_dict(rs)
def query_lines(self):
rs = session_power.query(Lines).all()
return class_to_dict(rs)
def query_photos(self):
rs = session_power.query(Photo).all()
return class_to_dict(rs)
def query_photos_time(self, towerIdx, photoDate):
rs = self.session_power.query(Photo).filter(
Photo.photo_tower_id == towerIdx,
Photo.photo_date == photoDate).all()
return class_to_dict(rs)
def query_lineVoltageBlur(self, voltage, linename):
rs = self.session_power.query(Lines).filter(
Lines.lines_voltage == voltage,
Lines.lines_name.like('%' + linename + '%')).all()
return class_to_dict(rs)
def query_photos(self, towerIdx):
rs = session_power.query(Photo).filter(
Photo.photo_tower_id == towerIdx).all()
return class_to_dict(rs)
def query_defect_level(self, user):
defectLevels = self.session_power.query(DefectLevel).all()
self.session_power.rollback()
return class_to_dict(defectLevels)
def query_lineVoltage(self, voltage):
rs = session_power.query(Lines).filter(
Lines.lines_voltage == voltage).all()
return class_to_dict(rs)
def query_defect_part(self, user):
defectParts = self.session_power.query(DefectPart).all()
self.session_power.rollback()
return class_to_dict(defectParts)
def query_towers(self, linename):
rs = session_power.query(Towers).filter(
Towers.tower_linename == linename).all()
return class_to_dict(rs)
def query_line(self, lineID):
rs = self.session_power.query(Lines).filter(Lines.lines_id == lineID,
Lines.deleted == 0).all()
return class_to_dict(rs)
