Viewer.py 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459
  1. '''
  2. '''
  3. from PyQt5 import uic
  4. from PyQt5.Qt import Qt, QEvent, QGraphicsScene, QPointF, QFileDialog, \
  5. QApplication, QMessageBox, QTreeWidgetItem, \
  6. QGraphicsTextItem, QGraphicsItem, QGraphicsRectItem, \
  7. QBrush, QColor, QGraphicsLineItem, QLineF, \
  8. QPen, QPainter, QSvgGenerator, QSize, QRect, QGraphicsItemGroup, \
  9. QGraphicsColorizeEffect, QFont
  10. from PyQt5.QtWidgets import QMainWindow, QGraphicsView
  11. from path import Path
  12. from core import AccessObject
  13. import core
  14. Ui_window, _ = uic.loadUiType(Path(__file__).parent / 'qt_viewer.ui')
  15. palette = {
  16. "tables": QColor(240, 240, 20),
  17. "queries": QColor(210, 50, 210),
  18. "modules": QColor(220, 10, 33),
  19. "relations": QColor(122, 50, 209),
  20. "reports": QColor(25, 10, 220),
  21. "forms": QColor(10, 180, 220),
  22. "scripts": QColor(40, 220, 10),
  23. }
  24. v_spacing = 120
  25. cell_width = 150
  26. cell_spacing = 25
  27. class GraphicsObject(QGraphicsItemGroup):
  28. items = []
  29. def __init__(self, obj, parent=None):
  30. super(GraphicsObject, self).__init__(parent=parent)
  31. self.obj = obj
  32. self.links = []
  33. self._x = 0
  34. self._y = 0
  35. self.setFlag(QGraphicsItem.ItemIsMovable, True)
  36. self.setFlag(QGraphicsItem.ItemIsSelectable, True)
  37. self.setFlag(QGraphicsItem.ItemIsFocusable, True)
  38. self.setAcceptHoverEvents(True)
  39. self.label = QGraphicsTextItem()
  40. self.label.setTextWidth(cell_width)
  41. self.label.setZValue(2)
  42. self.setText()
  43. self.addToGroup(self.label)
  44. pen = QPen(palette[self.obj.type_].darker(150))
  45. pen.setWidth(2)
  46. self.rect = QGraphicsRectItem(self.label.boundingRect())
  47. self.rect.setPen(pen)
  48. self.rect.setBrush(palette[self.obj.type_].lighter(150))
  49. self.rect.setZValue(0)
  50. self.addToGroup(self.rect)
  51. self.topAnchorCoords = ((self.boundingRect().topLeft().x() + self.boundingRect().topRight().x() / 2), self.boundingRect().topLeft().y())
  52. self.bottomAnchorCoords = ((self.boundingRect().topLeft().x() + self.boundingRect().topRight().x() / 2), self.boundingRect().bottomLeft().y())
  53. self.top_anchor = QGraphicsRectItem(self.topAnchorCoords[0] - 3, self.topAnchorCoords[1] - 3, 6, 6)
  54. self.bottom_anchor = QGraphicsRectItem(self.bottomAnchorCoords[0] - 3, self.bottomAnchorCoords[1] - 3, 6, 6)
  55. for anchor in (self.top_anchor, self.bottom_anchor):
  56. anchor.setBrush(QBrush(QColor(255, 153, 51)))
  57. anchor.setZValue(1)
  58. self.addToGroup(anchor)
  59. effect = QGraphicsColorizeEffect()
  60. effect.setEnabled(False)
  61. self.rect.setGraphicsEffect(effect)
  62. GraphicsObject.items.append(self)
  63. def setText(self):
  64. self.label.setHtml("[{}]<br/><b>{}</b>".format(self.obj.type_, self.obj.nom))
  65. def topAnchorCenter(self):
  66. return self.mapToScene(QPointF(*self.topAnchorCoords))
  67. def bottomAnchorCenter(self):
  68. return self.mapToScene(QPointF(*self.bottomAnchorCoords))
  69. def update(self):
  70. if self.pos() is not QPointF(self._x, self._y):
  71. self.setPos(QPointF(self._x, self._y))
  72. for l in self.links:
  73. l.update()
  74. def paint(self, *args, **kwargs):
  75. super(GraphicsObject, self).paint(*args, **kwargs)
  76. self._x, self._y = self.pos().x(), self.pos().y()
  77. self.update()
  78. def setShining(self, active):
  79. self.rect.graphicsEffect().setEnabled(active)
  80. def hoverEnterEvent(self, *args, **kwargs):
  81. self.setShining(True)
  82. def hoverLeaveEvent(self, *args, **kwargs):
  83. self.setShining(False)
  84. class GraphicsRootObject(GraphicsObject):
  85. def __init__(self, obj, parent=None):
  86. super(GraphicsRootObject, self).__init__(obj, parent=parent)
  87. self.level = 0
  88. self.deps = []
  89. self.refs = []
  90. self._dep_emprise = 0
  91. self._ref_emprise = 0
  92. def xleft(self):
  93. return 0
  94. def compute_coords(self):
  95. return 0, 0
  96. def dep_emprise(self):
  97. if not self._dep_emprise:
  98. self._dep_emprise = sum([d.dep_emprise() for d in self.deps]) if self.deps else (cell_width + 2 * cell_spacing)
  99. return self._dep_emprise
  100. def ref_emprise(self):
  101. if not self._ref_emprise:
  102. self._ref_emprise = sum([r.ref_emprise() for r in self.refs]) if self.refs else (cell_width + 2 * cell_spacing)
  103. return self._ref_emprise
  104. class GraphicsDepObject(GraphicsObject):
  105. def __init__(self, obj, parentItem, parent=None):
  106. super(GraphicsDepObject, self).__init__(obj, parent=parent)
  107. self.deps = []
  108. self.parentItem = parentItem
  109. if parentItem:
  110. parentItem.deps.append(self)
  111. self.level = parentItem.level + 1
  112. self._dep_emprise = 0
  113. def xleft(self):
  114. x0 = sum([n.dep_emprise() for n in self.parentItem.deps[0:self.parentItem.deps.index(self)]])
  115. return self.parentItem.xleft() + x0
  116. def compute_coords(self):
  117. x0 = sum([n.dep_emprise() for n in self.parentItem.deps[0:self.parentItem.deps.index(self)]])
  118. x = self.parentItem.xleft() + (0.5 * self.dep_emprise() - (cell_width / 2 + cell_spacing)) + x0
  119. y = v_spacing * self.level
  120. return x, y
  121. def dep_emprise(self):
  122. if not self._dep_emprise:
  123. self._dep_emprise = sum([d.dep_emprise() for d in self.deps]) if self.deps else (cell_width + 2 * cell_spacing)
  124. return self._dep_emprise
  125. class GraphicsCloneDepObject(GraphicsDepObject):
  126. def __init__(self, obj, childItem, parent=None):
  127. super(GraphicsCloneDepObject, self).__init__(obj, childItem, parent)
  128. self.bottom_anchor.setBrush(QColor("red"))
  129. self.clone_of = next((item for item in GraphicsObject.items if item.obj == obj
  130. and type(item) is GraphicsDepObject
  131. or type(item) is GraphicsRefObject))
  132. def setText(self):
  133. self.label.setHtml("[{}]<br/><b>{}</b><br/>(!) Clône".format(self.obj.type_, self.obj.nom))
  134. @property
  135. def deps(self):
  136. return []
  137. @deps.setter
  138. def deps(self, value):
  139. pass
  140. def hoverEnterEvent(self, *args, **kwargs):
  141. self.setShining(True)
  142. self.clone_of.setShining(True)
  143. def hoverLeaveEvent(self, *args, **kwargs):
  144. self.setShining(False)
  145. self.clone_of.setShining(False)
  146. class GraphicsRefObject(GraphicsObject):
  147. def __init__(self, obj, childItem, parent=None):
  148. super(GraphicsRefObject, self).__init__(obj, parent=parent)
  149. self.refs = []
  150. self.childItem = childItem
  151. if childItem:
  152. childItem.refs.append(self)
  153. self.level = childItem.level - 1
  154. self._ref_emprise = 0
  155. def xleft(self):
  156. x0 = sum([n.ref_emprise() for n in self.childItem.refs[0:self.childItem.refs.index(self)]])
  157. return self.childItem.xleft() + x0
  158. def compute_coords(self):
  159. x0 = sum([n.ref_emprise() for n in self.childItem.refs[0:self.childItem.refs.index(self)]])
  160. return self.childItem.xleft() + (0.5 * self.ref_emprise() - (cell_width / 2 + cell_spacing)) + x0, v_spacing * self.level
  161. def ref_emprise(self):
  162. if not self._ref_emprise:
  163. self._ref_emprise = sum([d.ref_emprise() for d in self.refs]) if self.refs else (cell_width + 2 * cell_spacing)
  164. return self._ref_emprise
  165. class GraphicsCloneRefObject(GraphicsRefObject):
  166. def __init__(self, obj, childItem, parent=None):
  167. super(GraphicsCloneRefObject, self).__init__(obj, childItem, parent)
  168. self.top_anchor.setBrush(QColor("red"))
  169. self.clone_of = next((item for item in GraphicsObject.items if item.obj == obj
  170. and type(item) is GraphicsDepObject
  171. or type(item) is GraphicsRefObject))
  172. def setText(self):
  173. self.label.setHtml("[{}]<br/><b>{}</b><br/>(!) Clône".format(self.obj.type_, self.obj.nom))
  174. @property
  175. def refs(self):
  176. return []
  177. @refs.setter
  178. def refs(self, value):
  179. pass
  180. def hoverEnterEvent(self, *args, **kwargs):
  181. self.clone_of.setShining(True)
  182. def hoverLeaveEvent(self, *args, **kwargs):
  183. self.clone_of.setShining(False)
  184. class GraphicsLink(QGraphicsLineItem):
  185. items = []
  186. def __init__(self, topGraphicsObject, bottomGraphicsObject, parent=None):
  187. self.topGraphicsObject = topGraphicsObject
  188. self.topGraphicsObject.links.append(self)
  189. self.bottomGraphicsObject = bottomGraphicsObject
  190. self.bottomGraphicsObject.links.append(self)
  191. super(QGraphicsLineItem, self).__init__(parent=parent)
  192. self.update()
  193. def update(self):
  194. line = QLineF(self.mapToScene(self.topGraphicsObject.bottomAnchorCenter()), self.mapToScene(self.bottomGraphicsObject.topAnchorCenter()))
  195. self.setLine(line)
  196. def select(self, active):
  197. pen = QPen()
  198. if active:
  199. pen.setColor(QColor("blue"))
  200. pen.setWidth(2)
  201. else:
  202. pen.setColor(QColor("black"))
  203. pen.setWidth(1)
  204. self.setPen(pen)
  205. class Viewer(QMainWindow):
  206. def __init__(self):
  207. super (Viewer, self).__init__()
  208. self.createWidgets()
  209. def createWidgets(self):
  210. self.ui = Ui_window()
  211. self.ui.setupUi(self)
  212. self.ui.progressBar.setVisible(False)
  213. self.ui.stackedWidget.setCurrentIndex(0)
  214. self.ui.btn_test.clicked.connect(self.test)
  215. self.ui.btn_select.clicked.connect(self.selectSourceDir)
  216. self.ui.btn_zoom_plus.clicked.connect(self.zoom_plus)
  217. self.ui.btn_zoom_minus.clicked.connect(self.zoom_minus)
  218. self.ui.btn_zoom_view.clicked.connect(self.fit_in_view)
  219. self.ui.btn_save.clicked.connect(self.save_to_png)
  220. self.ui.treeWidget.itemClicked.connect(self.treeItemSelected)
  221. core.Analyse.report = self.update_progression
  222. self.ui.view.setViewportUpdateMode(QGraphicsView.BoundingRectViewportUpdate)
  223. self.ui.view.setTransformationAnchor(QGraphicsView.AnchorUnderMouse)
  224. self.ui.view.viewport().installEventFilter(self)
  225. self._scene = QGraphicsScene()
  226. self._scene.setItemIndexMethod(QGraphicsScene.BspTreeIndex)
  227. self.ui.view.setScene(self._scene)
  228. helpLabel = QGraphicsTextItem()
  229. helpLabel.setPlainText("Sélectionnez le répertoire contenant les sources de la base à analyser,\npuis sélectionnez dans la liste de droite un objet à partir duquel afficher les dépendances...")
  230. helpLabel.setTextWidth(600)
  231. font = QFont()
  232. font.setItalic(True)
  233. font.setWeight(63)
  234. helpLabel.setFont(font)
  235. self._scene.addItem(helpLabel)
  236. def eventFilter(self, _, event):
  237. if event.type() == QEvent.Wheel:
  238. if event.angleDelta().y() > 0:
  239. self.zoom_plus()
  240. elif event.angleDelta().y() < 0:
  241. self.zoom_minus()
  242. return True
  243. return False
  244. def fit_in_view(self):
  245. rect = self._scene.itemsBoundingRect()
  246. rect.adjust(-50, -50, 50, 50)
  247. self._scene.setSceneRect(rect)
  248. self.ui.view.fitInView(self._scene.sceneRect(), Qt.KeepAspectRatio)
  249. def zoom_plus(self):
  250. self.ui.view.scale(1.2, 1.2)
  251. def zoom_minus(self):
  252. self.ui.view.scale(0.8, 0.8)
  253. def save_to_png(self):
  254. fileName, _ = QFileDialog.getSaveFileName(self, "Save File", "", "Svg File (*.svg)")
  255. if not fileName:
  256. return
  257. gen = QSvgGenerator()
  258. gen.setFileName(fileName)
  259. gen.setSize(QSize(1000, 1000))
  260. gen.setViewBox(QRect(0, 0, 1000, 1000))
  261. gen.setTitle("SVG Generator Example Drawing")
  262. gen.setDescription("An SVG drawing created by the SVG Generator "
  263. "Example provided with Qt.")
  264. painter = QPainter(gen)
  265. self._scene.render(painter)
  266. painter.end()
  267. def update_progression(self, i, total, msg=""):
  268. self.ui.progressBar.setMaximum(total)
  269. self.ui.progressBar.setValue(i)
  270. if msg:
  271. self.ui.txtPanel.append(msg)
  272. QApplication.processEvents()
  273. def selectSourceDir(self):
  274. source_dir = QFileDialog.getExistingDirectory(self, "Sélectionner le répertoire des sources", "", QFileDialog.ShowDirsOnly)
  275. if not source_dir:
  276. return
  277. self.run(source_dir)
  278. def run(self, source_dir):
  279. self.ui.progressBar.setVisible(True)
  280. self.ui.lbl_repertoire.setText(source_dir)
  281. self.ui.txtPanel.clear()
  282. self.ui.treeWidget.clear()
  283. QApplication.setOverrideCursor(Qt.WaitCursor)
  284. core.Analyse.run(source_dir)
  285. QApplication.restoreOverrideCursor()
  286. QMessageBox.information(self, "test", "{} objets chargés".format(len(core.Analyse.objects)))
  287. self.ui.progressBar.setVisible(False)
  288. self.ui.stackedWidget.setCurrentIndex(1)
  289. self.ui.txtPanel.clear()
  290. topitem = QTreeWidgetItem()
  291. topitem.setText(0, "Objets")
  292. self.ui.treeWidget.addTopLevelItem(topitem)
  293. groupes = {}
  294. for index, obj in enumerate(core.Analyse.objects):
  295. if not obj.type_ in groupes:
  296. item = QTreeWidgetItem()
  297. item.setText(0, obj.type_)
  298. groupes[obj.type_] = item
  299. topitem.addChild(item)
  300. item = QTreeWidgetItem()
  301. item.setText(0, obj.nom)
  302. item.setData(1, 0, index)
  303. groupes[obj.type_].addChild(item)
  304. self.ui.treeWidget.setColumnHidden(1, True)
  305. self.ui.treeWidget.expandToDepth(1)
  306. def clear_scene(self):
  307. self._scene.clear()
  308. GraphicsObject.items = []
  309. def maj_scene_with(self, root_object):
  310. self.clear_scene()
  311. root = GraphicsRootObject(root_object)
  312. self._scene.addItem(root)
  313. def _addDeps(go):
  314. for dep in go.obj.deps:
  315. if dep not in [go.obj for go in GraphicsObject.items]:
  316. gdep = GraphicsDepObject(dep, go)
  317. else:
  318. gdep = GraphicsCloneDepObject(dep, go)
  319. self._scene.addItem(gdep)
  320. link = GraphicsLink(go, gdep)
  321. self._scene.addItem(link)
  322. if dep.deps:
  323. _addDeps(gdep)
  324. _addDeps(root)
  325. def _addRefs(go):
  326. for ref in go.obj.refs:
  327. if ref not in [go.obj for go in GraphicsObject.items]:
  328. gref = GraphicsRefObject(ref, go)
  329. else:
  330. gref = GraphicsCloneRefObject(ref, go)
  331. self._scene.addItem(gref)
  332. link = GraphicsLink(gref, go)
  333. self._scene.addItem(link)
  334. if ref.refs:
  335. _addRefs(gref)
  336. _addRefs(root)
  337. for item in GraphicsObject.items:
  338. item._x, item._y = item.compute_coords()
  339. if isinstance(item, GraphicsDepObject):
  340. item._x -= (root.dep_emprise() - (cell_width + 2 * cell_spacing)) / 2
  341. if isinstance(item, GraphicsRefObject):
  342. item._x -= (root.ref_emprise() - (cell_width + 2 * cell_spacing)) / 2
  343. item.update()
  344. self.ui.btn_save.setEnabled(True)
  345. self.fit_in_view()
  346. def treeItemSelected(self, item):
  347. index = item.data(1, 0)
  348. if not index:
  349. return
  350. obj = core.Analyse.objects[index]
  351. self.maj_scene_with(obj)
  352. def test(self):
  353. self.run(Path(__file__).parent / r"test\source")
  354. def keyPressEvent(self, e):
  355. if e.key() == Qt.Key_Control:
  356. self.ui.view.setDragMode(QGraphicsView.ScrollHandDrag)
  357. e.accept()
  358. def keyReleaseEvent(self, e):
  359. if e.key() == Qt.Key_Control:
  360. self.ui.view.setDragMode(QGraphicsView.RubberBandDrag)