/ - Diff - HYTOS - 일정관리

HYTOS/HYTOS/App.py
24	24	import locale
25	25	from AppDocData import AppDocData
26	26
	27
27	28	super(App, self).__init__(args)
28	29	app_doc_data = AppDocData.instance()
29	30	app_style = app_doc_data.loadAppStyle()

     class AppDocData(SingletonInstane):
         def __init__(self):
             from DisplayColors import DisplayColors
             self._imgFilePath = None
             self.imgName = None
             self.imgWidth = 0
-...
                 # Creates or opens a file called mydb with a SQLite3 DB
                 conn = sqlite3.connect(appDatabaseFilePath)
                 conn.execute('PRAGMA foreign_keys = ON')
                 with conn:
                     # Get a cursor object
                     cursor = conn.cursor()
-...
             res = []
             conn = sqlite3.connect(self.activeDrawing.path)
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 try:
                     conn.row_factory = sqlite3.Row
-...
         def getInsideDiameter(self, nominaldiameter_uid, schedule_uid):
             res = []
             try:
                 db = sqlite3.connect(self.activeDrawing.path)
                 conn = sqlite3.connect(self.activeDrawing.path)
                 conn.execute('PRAGMA foreign_keys = ON')
                 # Get a cursor object
                 cursor = db.cursor()
                 cursor = conn.cursor()
                 sql = """select UID
                               , Milimeter
-...
             # Catch the exception
             except Exception as ex:
                 # Roll back any change if something goes wrong
                 db.rollback()
                 conn.rollback()
                 print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))
             finally:
                 # Close the db connection
                 db.close()
                 conn.close()
             return res
-...
             res = []
             conn = sqlite3.connect(self.activeDrawing.path)
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 try:
                     # Get a cursor object
-...
             # Creates or opens a file called mydb with a SQLite3 DB
             conn = sqlite3.connect(self.activeDrawing.path)
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 try:
                     # Get a cursor object
-...
                 # Creates or opens a file called mydb with a SQLite3 DB
                 dbPath = self.getAppDbPath()
                 conn = sqlite3.connect(dbPath)
                 conn.execute('PRAGMA foreign_keys = ON')
                 # Get a cursor object
                 cursor = conn.cursor()
-...
                 # Creates or opens a file called mydb with a SQLite3 DB
                 dbPath = self.getAppDbPath()
                 conn = sqlite3.connect(dbPath)
                 conn.execute('PRAGMA foreign_keys = ON')
                 # Get a cursor object
                 cursor = conn.cursor()
-...
             try:
                 # Creates or opens a file called mydb with a SQLite3 DB
                 conn = sqlite3.connect(self.activeDrawing.path)
                 conn.execute('PRAGMA foreign_keys = ON')
                 # Get a cursor object
                 cursor = conn.cursor()
                 # 0. Delete Points
                 sql = "delete from Points where Components_UID in (select UID from Components where Drawings_UID = '{}')".format(uid)
                 cursor.execute(sql)
                 # 1. Delete HMB
                 sql = "delete from HMB where Components_UID in (select UID from Components where Drawings_UID = '{}')".format(uid)
                 cursor.execute(sql)
                 # 2. Delete Components
                 sql = "delete from Components where Drawings_UID='{}'".format(uid)
                 sql = "delete from Components"
                 cursor.execute(sql)
                 conn.commit()
-...
         def deleteDrawingByName(self, drawingName):
             """ delete given drawing """
             conn = sqlite3.connect(self.getAppDbPath())
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 try:
                     # Get a cursor object
-...
                 # Creates or opens a file called mydb with a SQLite3 DB
                 dbPath = self.getAppDbPath()
                 conn = sqlite3.connect(dbPath)
                 conn.execute('PRAGMA foreign_keys = ON')
                 # Get a cursor object
                 cursor = conn.cursor()
-...
             ret = None
             conn = sqlite3.connect(self.activeDrawing.path)
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 cursor = conn.cursor()
-...
             ret = []
             conn = sqlite3.connect(self.activeDrawing.path)
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 cursor = conn.cursor()
-...
             try:
                 # Creates or opens a file called mydb with a SQLite3 DB
                 dbPath = os.path.join(self.activeDrawing.path)
                 db = sqlite3.connect(dbPath)
                 db.row_factory = sqlite3.Row
                 conn = sqlite3.connect(dbPath)
                 conn.execute('PRAGMA foreign_keys = ON')
                 conn.row_factory = sqlite3.Row
                 # Get a cursor object
                 cursor = db.cursor()
                 cursor = conn.cursor()
                 sql = """select UID
                               , Method
-...
             # Catch the exception
             except Exception as ex:
                 # Roll back any change if something goes wrong
                 db.rollback()
                 conn.rollback()
                 print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))
             finally:
                 # Close the db connection
                 db.close()
                 conn.close()
             return res
-...
         def saveToDatabase(self, item, index):
             """ save given items to database """
             conn = sqlite3.connect(self.activeDrawing.path, isolation_level=None)
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 try:
                     # Get a cursor object
                     cursor = conn.cursor()
                     if index == 0:
                         # delete Points
                         sql = 'delete from Points'
                         cursor.execute(sql)
                         # delete HMB
                         sql = 'delete from HMB'
                         cursor.execute(sql)
                         # delete Components
                         sql = 'delete from Components'
                         cursor.execute(sql)
-...
             # Creates or opens a file called mydb with a SQLite3 DB
             dbPath = self.getAppDbPath()
             conn = sqlite3.connect(dbPath)
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 try:
                     conn.row_factory = sqlite3.Row
-...
                     cursor.execute(sql)
                     rows = cursor.fetchall()
                     for row in rows:
                         res.append(Drawing(row[0], row[1], row[2]))
                         if os.path.exists(row[1]):
                             res.append(Drawing(row[0], row[1], row[2]))
                 # Catch the exception
                 except Exception as ex:
                     # Roll back any change if something goes wrong
-...
             # Creates or opens a file called mydb with a SQLite3 DB
             dbPath = self.getAppDbPath()
             conn = sqlite3.connect(dbPath)
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 try:
                     # Get a cursor object
-...
             from shutil import copyfile
             conn = sqlite3.connect(self.getAppDbPath())
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 try:
                     # Get a cursor object
-...
             SymbolCategoryList = []
             conn = sqlite3.connect(self.activeDrawing.path)
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 cursor = conn.cursor()
                 sql = 'SELECT DISTINCT CATEGORY FROM SymbolType ORDER BY type ASC'
-...
             ComponentList = []
             conn = sqlite3.connect(self.activeDrawing.path)
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 try:
                     conn.row_factory = sqlite3.Row
-...
             res = None
             conn = sqlite3.connect(self.activeDrawing.path)
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 conn.row_factory = sqlite3.Row
                 cursor = conn.cursor()
-...
             unitsList = []
             conn = sqlite3.connect(drawing.path)
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 cursor = conn.cursor()
-...
             ComponentList = []
             conn = sqlite3.connect(drawing.path)
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 try:
                     conn.row_factory = sqlite3.Row
-...
             symbolTypeList = []
             conn = sqlite3.connect(self.activeDrawing.path)
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 cursor = conn.cursor()
                 sql = 'SELECT UID, Category, Type FROM SymbolType WHERE Category = "' + category + '"'
-...
             try:
                 conn = sqlite3.connect(self.activeDrawing.path)
                 conn.execute('PRAGMA foreign_keys = ON')
                 cursor = conn.cursor()
                 sql = 'Select UID, Key, Value From Units'
                 try:
-...
             if self.activeDrawing:
                 conn = sqlite3.connect(self.activeDrawing.path)
                 conn.execute('PRAGMA foreign_keys = ON')
                 with conn:
                     cursor = conn.cursor()
                     sql = """SELECT dn.DISPLAY_NAME
-...
             category = None
             conn = sqlite3.connect(self.activeDrawing.path)
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 try:
                     cursor = conn.cursor()

HYTOS/HYTOS/ConfigurationDialog.py
10	10	from App import App
11	11	from AppDocData import AppDocData
12	12	from AppDocData import Config
13		from AppDocData import Color
14	13	import Configuration_UI
15	14
16	15	class QConfigurationDialog(QDialog):

HYTOS/HYTOS/Fitting_2KDialog.py
10	10	from App import App
11	11	from AppDocData import AppDocData
12	12	from AppDocData import Config
13		from AppDocData import Color
14	13	import Fitting_2K_UI
15	14
16	15	class QFitting_2KDialog(QDialog):

HYTOS/HYTOS/Fitting_CraneKDialog.py
10	10	from App import App
11	11	from AppDocData import AppDocData
12	12	from AppDocData import Config
13		from AppDocData import Color
14	13	import Fitting_CraneK_UI
15	14
16	15	class QFitting_CraneKDialog(QDialog):

HYTOS/HYTOS/Fitting_EquivalentLengthDialog.py
9	9	from App import App
10	10	from AppDocData import AppDocData
11	11	from AppDocData import Config
12		from AppDocData import Color
13	12	import Fitting_EquivalentLength_UI
14	13
15	14	class QFitting_EquivalentLengthDialog(QDialog):

                 self._hmbs = []
                 conn = sqlite3.connect(drawing.path)
                 conn.execute('PRAGMA foreign_keys = ON')
                 with conn:
                     try:
                         cursor = conn.cursor()
-...
             app_doc_data = AppDocData.instance()
             conn = sqlite3.connect(app_doc_data.activeDrawing.path)
             conn.execute('PRAGMA foreign_keys = ON')
             with conn:
                 try:
                     # Get a cursor object

     # coding: utf-8
     # -*- coding: utf-8 -*-
     """ This is MainWindow module """
     import sys
-...
     import SymbolEditorDialog
     from UserInputAttribute import UserInputAttribute
     from TextItemFactory import TextItemFactory
     from DisplayColors import DisplayColors
     from DisplayColors import DisplayOptions
     import uuid
     class MainWindow(QMainWindow, MainWindow_UI.Ui_MainWindow, SingletonInstane):
-...
             try:
                 super(self.__class__, self).__init__()
                 self.setupUi(self)
                 self._label_mouse = QLabel(self.statusbar)
                 self._label_mouse.setText(self.tr('mouse pos : ({},{})'.format(0,0)))
                 self.statusbar.addWidget(self._label_mouse)
-...
                 action.triggered.connect(partial(self.load_language, file))
             # up to here
         def setMainWindowTitle(self, drawingName = None):
         def setMainWindowTitle(self, drawingName = None):
+            #
             _translate = QCoreApplication.translate
             version = QCoreApplication.applicationVersion()
             if drawingName is None:
                 self.setWindowTitle(_translate(App.NAME  + "({})".format(version), App.NAME + "({})".format(version)))
             else:
                 #drawingName = drawingName.encode('utf-8')
                 self.setWindowTitle(_translate(App.NAME  + "({}) - {}".format(version, drawingName), App.NAME + "({}) - {}".format(version, drawingName)))
-...
                     newDrawingAction.triggered.connect(lambda: self.newDrawingActionClickEvent(item))
                     menu.addAction(newDrawingAction)
                 elif level == 1:
                     saveAsDrawingAction = menu.addAction(self.tr("Save As..."))
                     saveAsDrawingAction.triggered.connect(lambda: self.saveAsDrawingActionClickEvent(item))
                     menu.addAction(saveAsDrawingAction)
                     #saveAsDrawingAction = menu.addAction(self.tr("Save As..."))
                     #saveAsDrawingAction.triggered.connect(lambda: self.saveAsDrawingActionClickEvent(item))
                     #menu.addAction(saveAsDrawingAction)
                     deleteDrawingAction = menu.addAction(self.tr("Delete"))
                     deleteDrawingAction.triggered.connect(lambda: self.deleteDrawingActionClickEvent(item))
-...
                     app_doc_data = AppDocData.instance()
                     app_doc_data.deleteDrawingByName(drawingPath)
                     if drawingName == app_doc_data.activeDrawing.name and drawingPath == app_doc_data.activeDrawing.path:
                         app_doc_data.activeDrawing = None
                     if app_doc_data.activeDrawing:
                         if drawingName == app_doc_data.activeDrawing.name and drawingPath == app_doc_data.activeDrawing.path:
                             app_doc_data.activeDrawing = None
                         if self.graphicsView.hasImage():
                             self.graphicsView.clearImage()
                             self.graphicsView.scene.clear()
                             if self.graphicsView.hasImage():
                                 self.graphicsView.clearImage()
                                 self.graphicsView.scene.clear()
                         self.initTableWidgetHMB()
                             self.initTableWidgetHMB()
                     self.load_drawing_list()
             except Exception as ex:
-...
                 self.open_drawing(path)
         def dbUpdate(self):
             '''
                 @brief      db update when save or recognition
                 @author     euisung
                 @date       2018.11.12
                 @history    2018.11.02      euisung     remove scene dependency
             '''
             from AppDocData import AppDocData
             try:
                 appDocData = AppDocData.instance()
                 titleBlockProps = appDocData.getTitleBlockProperties()
                 #items = self.graphicsView.scene.items()
                 items = appDocData.activeDrawing.allItems
                 titleBlockItems = []
                 for item in items:
                     #if type(item) is QEngineeringLineNoTextItem:
                     #    item.saveLineData()
                     if type(item) is QEngineeringTextItem:
                         for titleBlockProp in titleBlockProps:
                             if item.area == titleBlockProp[0]:
                                 titleBlockItems.append(item)
                 dbItems = [item for item in items if type(item) is QEngineeringInstrumentItem or type(item) is QEngineeringEquipmentItem or type(item) is QEngineeringReducerItem or\
                 type(item) is QEngineeringNoteItem or type(item) is SymbolSvgItem or type(item) is QEngineeringLineNoTextItem] + titleBlockItems
                 appDocData.saveToDatabase(dbItems)
             except Exception as ex:
                 message = 'error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno)
                 self.addMessage.emit(MessageType.Error, message)
         '''
             @brief      action save click event
             @author     kyouho

HYTOS/HYTOS/OptionsDialog.py
14	14	from App import App
15	15	from AppDocData import AppDocData
16	16	from AppDocData import Config
17		from AppDocData import Color
18	17	import Options_UI
19	18
20	19	class QOptionsDialog(QDialog):

HYTOS/HYTOS/RoughnessDialog.py
10	10	from App import App
11	11	from AppDocData import AppDocData
12	12	from AppDocData import Config
13		from AppDocData import Color
14	13	import Roughness_UI
15	14
16	15	class QRoughnessDialog(QDialog):

     CREATE TABLE IF NOT EXISTS Components (
         UID          TEXT NOT NULL,
         Drawings_UID TEXT NOT NULL,
         Symbols_UID  TEXT NOT NULL,
         Name         TEXT,
         X            REAL,
-...
         Scale        REAL DEFAULT (1),
         CONSTRAINT PK_Components PRIMARY KEY (
             UID
         ),
         CONSTRAINT FK_Drawings_UID FOREIGN KEY (
             Drawings_UID
+        )
         REFERENCES Drawings (UID),
         ),
         CONSTRAINT FK_Symbols_UID FOREIGN KEY (
             Symbols_UID
+        )
-...
+        )
     );
     CREATE TABLE IF NOT EXISTS Drawings (
         UID      TEXT NOT NULL,
         NAME     TEXT NOT NULL,
         DATETIME TEXT NOT NULL,
         CONSTRAINT PK_Drawings PRIMARY KEY (
             UID
         ),
         CONSTRAINT UQ_Drawings UNIQUE (
             NAME
+        )
     );
     CREATE TABLE IF NOT EXISTS DrawingsUnits (
         UID          TEXT NOT NULL,
         Drawings_UID TEXT NOT NULL,
         Units        TEXT NOT NULL,
         Units_UID    TEXT NOT NULL,
         CONSTRAINT PK_DrawingsUnits PRIMARY KEY (
             UID
         ),
         CONSTRAINT FK_Drawings_UID FOREIGN KEY (
             Drawings_UID
+        )
         REFERENCES Drawings (UID),
         ),
         CONSTRAINT FK_Units_UID FOREIGN KEY (
             Units_UID
+        )
-...
         CONSTRAINT FK_Components_UID FOREIGN KEY (
             Components_UID
+        )
         REFERENCES Components (UID)
         REFERENCES Components (UID) ON DELETE CASCADE
     );
     CREATE TABLE IF NOT EXISTS Fittings_CraneK (
-...
         CONSTRAINT FK_Components_UID FOREIGN KEY (
             Components_UID
+        )
         REFERENCES Components (UID)
         REFERENCES Components (UID) ON DELETE CASCADE
     );
     CREATE TABLE IF NOT EXISTS Fittings_EquivalentLength (
-...
         CONSTRAINT FK_Components_UID FOREIGN KEY (
             Components_UID
+        )
         REFERENCES Components (UID)
         REFERENCES Components (UID) ON DELETE CASCADE
     );
     CREATE TABLE IF NOT EXISTS HMB (
-...
         CONSTRAINT FK_Components_UID FOREIGN KEY (
             Components_UID
+        )
         REFERENCES Components (UID),
         REFERENCES Components (UID) ON DELETE CASCADE,
         CONSTRAINT UQ_HMB UNIQUE (
             Components_UID,
             Stream_No
-...
         CONSTRAINT FK_Components_UID FOREIGN KEY (
             Components_UID
+        )
         REFERENCES Components (UID)
         REFERENCES Components (UID) ON DELETE CASCADE
     );
     CREATE TABLE IF NOT EXISTS Roughness (

             dbUid = symbolInfo.uid
             uid = self.uid
             cols = ['UID', 'Drawings_UID', 'Symbols_UID']
             values = ['?','?','?']
             param = [str(uid), str(appDocData.activeDrawing.UID), str(dbUid)]
             cols = ['UID', 'Symbols_UID']
             values = ['?','?']
             param = [str(uid), str(dbUid)]
             sql = 'insert or replace into Components({}) values({})'.format(','.join(cols), ','.join(values))
             res.append((sql, tuple(param)))

             rect = self.sceneBoundingRect()
             cols = ['UID', 'Drawings_UID', 'Symbols_UID', 'X', 'Y', 'Rotation', 'Scale']
             values = ['?','?','?', '?', '?', '?', '?']
             param = [str(self.uid), str(appDocData.activeDrawing.UID), str(self.dbUid), rect.left(), rect.top(), str(self.angle), self.transform().m11()]
             cols = ['UID', 'Symbols_UID', 'X', 'Y', 'Rotation', 'Scale']
             values = ['?','?', '?', '?', '?', '?']
             param = [str(self.uid), str(self.dbUid), rect.left(), rect.top(), str(self.angle), self.transform().m11()]
             sql = 'insert or replace into Components({}) values({})'.format(','.join(cols), ','.join(values))
             res.append((sql, tuple(param)))

ID	d4ca9bd34004491b72500f8be6af4f3b15d18d2d
상위	5ddf3ffe
하위	340d0023

프로젝트

일반

사용자정보

HYTOS

개정판 d4ca9bd3

프로젝트

일반

사용자정보

HYTOS

개정판 d4ca9bd3

연결된 일감