Habe Probleme bei der abfrage mit der distinct() methode. In der Objektstruktur sind viele Attribute enthalten, die QListView zeigt nur point_name an (funktioniert auch):
Code: Alles auswählen
def data(self, index, role):
if role == Qt.ItemDataRole.DisplayRole or role == Qt.ItemDataRole.EditRole:
return self._measure_point_data[index.row()].point_name
Code: Alles auswählen
@classmethod
def get_all_objects_by_measuring_id(cls, session, measuring_id):
stmt = select(cls).distinct(cls.point_name).where(cls.measuring_id == measuring_id)
print(stmt)
result = session.execute(stmt).scalars().all()
return sorted(result, key=lambda x: int(x.point_name[1:]), reverse=False)
Code: Alles auswählen
SELECT DISTINCT part_measuring_piece.id, part_measuring_piece.measuring_id, part_measuring_piece.point_name, part_measuring_piece.point_type, .....
FROM part_measuring_piece
WHERE part_measuring_piece.measuring_id = :measuring_id_1