HYTOS

import symbol

from NominalPipeSize import NominalPipeSize

class Config:

    def __init__(self, section, key, value):

        self.section = section

        @author humkyung

        @date   2018.04.24

    '''

    def sizeValue(self):

        return self.inchStr if 'Inch' == self.sizeUnit else self.metricStr

'''

    @brief  Pipe color class

'''

class Color:

    def __init__(self, index, red, green, blue):

        self.index = index

        self.green = green

        self.blue = blue

'''

    @brief      MessageType

    @author     humkyung 

    @date       2018.07.31

'''

class MessageType(Enum):

    Normal = 1

    Error = 2

class AppDocData(SingletonInstane):

    DATABASE = 'ITI_PID.db'

    def __init__(self):

        from DisplayColors import DisplayColors

        @author     humkyung

        @date       2018.09.06

    '''

    def clear(self):

        self._imgFilePath = None

        self.imgName = None

        @author     euisung

        @date       2018.09.28

    '''

    def getDrawingFileList(self):

        """ get drawing files which's extension is .png or jpg from drawing folder """

        try:

            project = AppDocData.instance().getCurrentProject()

            path = project.getDrawingFilePath()

            drawingFileList.sort()

        except Exception as ex:

        return drawingFileList

        @author     euisung

        @date       2018.10.16

    '''

    def getTrainingFileList(self):

        try:

            project = AppDocData.instance().getCurrentProject()

            drawingFileList = os.listdir(path)

            drawingFileList.sort()

        except Exception as ex:

            App.mainWnd().addMessage.emit(MessageType.Error, message)

        return drawingFileList

        @date       2018.06.27

        @history    2018.06.29  Jeongwoo    Change method to get template db path

    '''

    def getTemplateDbPath(self):

        path = os.path.join(os.getenv('ALLUSERSPROFILE'), 'Digital PID')

        templateDbPath = os.path.join(path, 'Template.db')

        path = os.path.join(os.getenv('ALLUSERSPROFILE'), 'Digital PID')

        app_database = os.path.join(path, 'App.db')

    '''

        @brief  getter of colors 

        @author humkyung

        @date   2018.06.18

    '''

    @property

    def colors(self):

        import random

                        self._colors.append(Color(int(row[0]), int(row[1]), int(row[2]), int(row[3])))

                # Catch the exception

                except Exception as ex:

                    App.mainWnd().addMessage.emit(MessageType.Error, message)

        return self._colors.pop(random.randrange(0, len(self._colors)))

        @author humkyung

        @date   2018.06.18

    '''

    @colors.setter

    def colors(self, value):

        self._colors = value

        @author     humkyung

        @date       2018.07.30

    '''

    def setImgFilePath(self, path):

        self._imgFilePath = path

        self.imgName = os.path.splitext(os.path.basename(self._imgFilePath))[0]

        import numpy as np

        import cv2

        _bytes = bytearray(stream.read())

        numpyArray = np.asarray(_bytes, dtype=np.uint8)

        return cv2.imdecode(numpyArray, cv2.IMREAD_UNCHANGED)

        @author     humkyung

        @date       2018.07.30

    '''

    @property

    def imgSrc(self):

        import cv2

        if self._imgSrc is None and self._imgFilePath is not None and os.path.isfile(self._imgFilePath):

            self._imgSrc = cv2.cvtColor(AppDocData.my_imread(self._imgFilePath), cv2.COLOR_BGR2GRAY)

            self._imgSrc = cv2.filter2D(self._imgSrc, -1, kernel)

            configs = AppDocData.instance().getConfigs('Filter', 'DilateSize')

            if 1 == len(configs) and int(configs[0].value) is not 0:

                size = int(configs[0].value)

                kernel = np.ones((size, size), np.uint8)

                self._imgSrc = cv2.erode(self._imgSrc, kernel, iterations=1)

        return self._imgSrc

    '''

        @author     humkyung

        @date       2018.07.30

    '''

    @imgSrc.setter

    def imgSrc(self, value):

        self._imgSrc = value

        @author     humkyung

        @date       2018.07.30

    '''

    def resetImgSrc(self):

        self._imgSrc = None

        @author humkyung

        @date   2018.06.28

    '''

    @property

    def lineTypeConfigs(self):

        from PyQt5.QtCore import Qt

        if self._lineTypeConfigs is None:

            self._lineTypeConfigs = []

            configs = self.getConfigs('LineTypes')

            for config in configs:

                matches = [param for param in styleMap if param[0] == _style]

                style = matches[0][1] if matches else Qt.SolidLine

                self._lineTypeConfigs.append((config.key, color, int(width), style, float(transparent)))

        return self._lineTypeConfigs

    '''

        @author humkyung

        @date   2018.06.28

    '''

    @lineTypeConfigs.setter

    def lineTypeConfigs(self, value):

        self._lineTypeConfigs = value

        @author     humkyung

        @date       2018.07.16

    '''

    @property

    def hmbTable(self):

        from HMBTable import HMBTable

        if self._hmbTable is None:

            self._hmbTable = HMBTable()

            self._hmbTable.loadData()

        return self._hmbTable

    '''

        @author     humkyung

        @date       2018.07.16

    '''

    @hmbTable.setter

    def hmbTable(self, value):

        self._hmbTable = value

        @author humkyung

        @date   2018.06.28

    '''

    def getLineTypeConfig(self, lineType):

        from PyQt5.QtCore import Qt

        matches = [config for config in self.lineTypeConfigs if config[0] == lineType]

    def getCurrentPidSource(self):

        return self.activeDrawing.currentPidSource

        @author     Jeongwoo

        @date       2018.05.03

    '''

    def isExistFileName(self, name):

        rows = None

        conn = self.project.database.connect()

        with conn:

            try:

                cursor = conn.cursor()

                cursor.execute(sql)

                rows = cursor.fetchall()

            # Catch the exception

            except Exception as ex:

                # Roll back any change if something goes wrong

                conn.rollback()

            finally:

                if rows is not None and len(rows) > 0:

                    return True

        @author     Jeongwoo

        @date       2018.05.03

    '''

    def insertSymbol(self, symbol):

        isAdded = False

        conn = self.project.database.connect()

                """)

                cursor = conn.cursor()

                cursor.execute(sql, query)

                conn.commit()

                isAdded = True

                # Roll back any change if something goes wrong

                conn.rollback()

                App.mainWnd().addMessage.emit(MessageType.Error, message)

            finally:

                return (isAdded, symbol.getType(), symbol.getName(), symbol.getPath())

        @author     Jeongwoo

        @date       2018.05.03

    '''

    def updateSymbol(self, symbol):

        isUpdated = False

                        baseSymbol = ?, additionalSymbol = ?, isExceptDetect = ?, hasInstrumentLabel = ?, width = ?, height = ?, flip = ?

                    WHERE uid = ?

                """)

                cursor = conn.cursor()

                query = (symbol.getName(), symbol.getType(), symbol.getThreshold()

                cursor.execute(sql, query)

                conn.commit()

                isUpdated = True

                # Roll back any change if something goes wrong

                conn.rollback()

                App.mainWnd().addMessage.emit(MessageType.Error, message)

            finally:

                return (isUpdated, symbol.getType(), symbol.getName(), symbol.getPath())

        @date       18.04.24

        @history    humkyung 2018.06.28 select symbol order by threshold descending

    '''

    def getTargetSymbolList(self):

        targetSymbolList = []

                cursor.execute(sql)

                rows = cursor.fetchall()

                for row in rows:

                    targetSymbolList.append(sym)

            except Exception as ex:

        return targetSymbolList

        @author humkyung

        @date   2018.04.20

    '''

    def buildAppDatabase(self):

        try:

            path = os.path.join(os.getenv('ALLUSERSPROFILE'), 'Digital PID')

        except Exception as ex:

            # Roll back any change if something goes wrong

            conn.rollback()

        finally:

            # Close the db connection

            conn.close()

        @author humkyung

        @date   2018.04.20

    '''

    def loadAppStyle(self):

        style = 'Fusion'

            # Get a cursor object

            cursor = conn.cursor()

            cursor.execute(sql)

            rows = cursor.fetchall()

            style = rows[0][0] if 1 == len(rows) else 'Fusion'

        except Exception as ex:

            # Roll back any change if something goes wrong

            conn.rollback()

        finally:

            # Close the db connection

            conn.close()

        @author humkyung

        @date   2018.04.20

    '''

    def loadAppStyles(self):

        styles = []

        except Exception as ex:

            # Roll back any change if something goes wrong

            conn.rollback()

        finally:

            # Close the db connection

            conn.close()

        @brief  Set current Project

        @history    2018.06.27  Jeongwoo    If DB file is not, copy DB file from ProgramData

    '''

    def setCurrentProject(self, project):

        self.project = project

        self.makeChildDir()

            if self.project.database.db_type == 'SQLite':

                # Creates or opens a file called mydb with a SQLite3 DB

                db_path = self.project.database.file_path

                if not os.path.isfile(db_path):

                    templatePath = self.getTemplateDbPath()

                    templateFile = QFile(templatePath)

                        for fileName in fileNames:

                            if fileName.endswith(".sql") and (1 == len(os.path.splitext(fileName)[0].split('.'))):

                                try:

                                    file.open(QFile.ReadOnly)

                                    sql = file.readAll()

                                    sql = str(sql, encoding='utf8')

                                    file.close()

                        conn.commit()

                except Exception as ex:

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

        finally:

            pass

                    humkyung 2018.07.09 make drawing folder if not exists

                    euisung 2018.09.28 make training folder if not exists

    '''

    def makeChildDir(self):

        project = AppDocData.instance().getCurrentProject()

        dbDir = project.getDbFilePath()

        trainingPath = project.getTrainingFilePath()

        if not os.path.exists(trainingPath):

            os.makedirs(trainingPath)

        path = os.path.join(tempDir, 'Tile')

        if not os.path.exists(path):

            os.makedirs(path)

    '''

        @brief  Get current Project

    '''

    def getCurrentProject(self):

        return self.project

        @brief      return project database path

        @history    humkyung 2018.04.19 return Project.db in Program Data folder instead of PROJECT_DB_PATH variable

    '''

    def getPrjDatabasePath(self):

        path = os.path.join(os.getenv('ALLUSERSPROFILE'), 'Digital PID')

        if not os.path.exists(path): os.makedirs(path)

        except Exception as ex:

            # Roll back any change if something goes wrong

            conn.rollback()

        finally:

            # Close the db connection

            conn.close()

        return prjDatabaseFilePath

    def getErrorItemSvgPath(self):

                    if originTitleBlockProp[0] == titleBlockProp[0]:

                        break

                deletedTitleBlockProps.append(originTitleBlockProp[0])

            # Creates or opens a file called mydb with a SQLite3 DB

            conn = self.project.database.connect()

            with conn:

                        cursor.execute(sql)

                    for titleBlockProp in titleBlockProps:

                        cursor.execute(sql, param)

                    conn.commit()

                    # Catch the exception

                except Exception as ex:

                    # Roll back any change if something goes wrong

                    conn.rollback()

        # Catch the exception

        except Exception as ex:

        self._titleBlockProperties = None

    def getTitleBlockProperties(self):

        '''

            @brief  return title block properties

            @date   2018.11.09

        '''

        res = None

            self._titleBlockProperties = []

            # Creates or opens a file called mydb with a SQLite3 DB

                    # Get a cursor object

                    cursor = conn.cursor()

                    cursor.execute(sql)

                    rows = cursor.fetchall()

                    for row in rows:

                            continue

                        else:

                            attr = []

                            self._titleBlockProperties.append(attr)

                    res = self._titleBlockProperties

                # Catch the exception

                except Exception as ex:

        else:

            res = self._titleBlockProperties

        @author humkyung

        @date   2018.04.09

    '''

    def getLineProperties(self):

        from SymbolAttr import SymbolAttr

                    # Get a cursor object

                    cursor = conn.cursor()

                    cursor.execute(sql)

                    rows = cursor.fetchall()

                    for row in rows:

                        attr.AttributeType = row[3]

                        attr.Length = row[4]

                        self._lineNoProperties.append(attr)

                    res = self._lineNoProperties

                # Catch the exception

                except Exception as ex:

        else:

            res = self._lineNoProperties

        @author humkyung

        @date   2018.04.09

    '''

    def getLinePropertiesByUID(self, UID):

        from SymbolAttr import SymbolAttr

                # Get a cursor object

                cursor = conn.cursor()

                cursor.execute(sql)

                rows = cursor.fetchall()

                for row in rows:

                    res.append(attr)

            # Catch the exception

            except Exception as ex:

        return res

        @author humkyung

        @date   2018.06.27

    '''

    def getLineTypes(self):

        from LineTypeConditions import LineTypeConditions

        with conn:

            try:

                cursor = conn.cursor() if self.project.database.db_type == 'SQLite' else conn.cursor(as_dict=True)

                cursor.execute(sql)

                rows = cursor.fetchall()

                for row in rows:

                    res.append(line_type)

            # Catch the exception

            except Exception as ex:

        return res

        @date       2018.04.06

        @history    humkyung 2018.04.19 use getPrjDatabasePath function instead of PROJECT_DB_PATH variable

    '''

    def insertProjectInfo(self, desc, prj_unit, dir):

        prjDatabaseFilePath = self.getPrjDatabasePath()

        conn = sqlite3.connect(prjDatabaseFilePath)

                    nowDate = datetime.datetime.now().strftime('%Y.%m.%d %H:%M')

                    sql = "insert or replace into Projects(Name, [Desc], [Unit], Path, CreatedDate, UpdatedDate) values(?, ?, ?, ?, ?, ?)"

                    param = (folderName, desc, prj_unit, dir, nowDate, nowDate)

                    cursor = conn.cursor()

                    cursor.execute(sql, param)

                    conn.commit()

            except Exception as ex:

                # Roll back any change if something goes wrong

                conn.rollback()

    def removeProjectInfo(self, targetProject):

        '''

            except Exception as ex:

                # Roll back any change if something goes wrong

                conn.rollback()

    '''

        @brief      update project

        @date       2018.04.06

        @history    humkyung 2018.04.19 use getPrjDatabasePath function instead of PROJECT_DB_PATH variable

    '''

    def updateProjectUpdatedDate(self, project):

        prjDatabaseFilePath = self.getPrjDatabasePath()

        conn = sqlite3.connect(prjDatabaseFilePath)

                sql = 'insert or replace into DBSettings(Projects_UID, DBTypes_UID, Host, User, Password, FilePath) values(?,(select UID from DBTypes where Name=?),?,?,?,?)'

                cur = conn.cursor()

                conn.commit()

            except Exception as ex:

                # Roll back any change if something goes wrong

                conn.rollback()

    '''

        @brief  get project list from database

        @history    humkyung 2018.04.18 add only project which's project exists

    '''

    def getProjectList(self):

        from Project import Project

                cursor.execute(sql)

                rows = cursor.fetchall()

                for row in rows:

                        projectList.append(Project(row))

            except Exception as ex:

        return projectList

        @brief  get sliding window size

        @author humkyung

    '''

    def getSlidingWindowSize(self):

        try:

            configs = self.getConfigs('Sliding Window')

            for config in configs:

                    res[1] = int(config.value)

        # Catch the exception

        except Exception as ex:

        return res

    '''

        @author humkyung

        @date   2018.04.16

    '''

    def getLineNoConfiguration(self):

        res = None

                        res = rows[0][2].split(delimiter)

            # Catch the exception

            except Exception as ex:

        return res

    '''

        @author humkyung

        @history    euisung     2018.11.20 (0,0),(0,0) process add

    '''

    def getAreaList(self):

        from Area import Area

                        self._areas.append(area)

                # Catch the exception

                except Exception as ex:

    '''

        @brief  get area of given name

        @author humkyung

        @date   2018.04.07

    '''

    def getArea(self, name):

        areas = self.getAreaList()

        if 1 == len(matches) and matches[0].height is not 0 and matches[0].width is not 0:

            return matches[0]

                    cursor = conn.cursor()

                    sql = "select * from configuration"

                    cursor.execute(sql)

                    rows = cursor.fetchall()

                    for row in rows:

                        self._configs.append(Config(row[0], row[1], row[2]))

                # Catch the exception

                except Exception as ex:

        if key is not None:

            return [con for con in self._configs if con.section == section and con.key == key]

                    res.append(Config(row[0], row[1], row[2]))

            # Catch the exception

            except Exception as ex:

        return res

        @history    humkyung 2018.07.03 replace ' with " if value has '

                    kyouho 2018.07.09 change query method

    '''

    def saveConfigs(self, configs):

        conn = self.project.database.connect()

        with conn:

                        if type(value) is str and "'" in value:

                            value = value.replace("'", "''")

                        param = (config.section, config.key, str(value), config.section, config.key)

                        cursor.execute(sql, param)

                        param = (str(value), config.section, config.key)

                        cursor.execute(sql, param)

                    elif hasattr(config, 'toSql'):

                        else:

                            if sql is not None and 2 == len(sql):

                                cursor.execute(self.project.database.to_sql(sql[0]), sql[1])

                conn.commit()

            # Catch the exception

            except Exception as ex:

                # Roll back any change if something goes wrong

                conn.rollback()

                App.mainWnd().addMessage.emit(MessageType.Error, message)

    def saveAppConfigs(self, configs):

            except Exception as ex:

                # Roll back any change if something goes wrong

                conn.rollback()

    '''

        @brief  delete configurations

        @author humkyung

        @date   2018.06.29

    '''

    def deleteConfigs(self, section, key=None):

        conn = self.project.database.connect()

        with conn:

            except Exception as ex:

                # Roll back any change if something goes wrong

                conn.rollback()

    def deleteAppConfigs(self, section, key=None):

        """

            except Exception as ex:

                # Roll back any change if something goes wrong

                conn.rollback()

    '''

        @brief      set area list

        @history    humkyung 2018.05.18 round area coordinate and dimension before saving

        @history    euisung  2018.11.20 add self._area reset process

    '''

    def setAreaList(self, areas):

        for area in areas:

            if 1 == len(matches):

                matches[0].x = area.x

                matches[0].y = area.y

                    sql = "insert into configuration select 'Area','{}','({},{}),({},{})' where not exists(select 1 from configuration where Section='Area' and [Key]='{}')".format(

                        area.name, round(area.x), round(area.y), round(area.width), round(area.height), area.name)

                    cursor.execute(sql)

                    cursor.execute(sql)

                conn.commit()

            # Catch the exception

                # Roll back any change if something goes wrong

                conn.rollback()

                App.mainWnd().addMessage.emit(MessageType.Error, message)

            finally:

                # Close the db connection

                self._areas = []

    def getSymbolNameList(self):

        """ get symbol name list """

        symbolNametList = []

                cursor.execute(sql)

                rows = cursor.fetchall()

                for row in rows:

            except Exception as ex:

        return symbolNametList

        @date       18.04.06

        @history    .

    '''

    def getSymbolNameListByType(self, type):

        symbolNametList = []

                    cursor.execute(sql, (type,))

                    rows = cursor.fetchall()

                    for row in rows:

                except Exception as ex:

        return symbolNametList

    '''

        @brief  delete added symbol data

    '''

    def deleteSymbol(self, fileName):

        ret = False

                    ret = True

                except Exception as ex:

                    conn.rollback()

                    ret = False

            finally:

                return (ret, fileName)

    '''

        @brief  get symbol name

        @history    18.04.24    Jeongwoo    Add isExceptDetect Field

    '''

    def getSymbolByQuery(self, fieldName, param):

        ret = None

                if rows is not None and len(rows) > 0:

                    symbolTuple = rows[0]

                    ret = symbol.SymbolBase(symbolTuple[1], symbolTuple[2], symbolTuple[3]

            except Exception as ex:

        return ret

        @brief  get symbol name list

        @history    18.04.24    Jeongwoo    Add isExceptDetect Field

    '''

    def getSymbolListByType(self, field_name=None, param=None):

        ret = []

            if field_name is not None and param is not None:

                sql = """SELECT a.UID,a.Name,b.Type,a.Threshold,a.MinMatchPoint,a.IsDetectOrigin,a.RotationCount,a.OCROption,a.IsContainChild,a.OriginalPoint,a.ConnectionPoint,

                        a.BaseSymbol,a.AdditionalSymbol,a.IsExceptDetect,a.HasInstrumentLabel,a.flip

            else:

                sql = """SELECT a.UID,a.Name,b.Type,a.Threshold,a.MinMatchPoint,a.IsDetectOrigin,a.RotationCount,a.OCROption,a.IsContainChild,a.OriginalPoint,a.ConnectionPoint,

                        a.BaseSymbol,a.AdditionalSymbol,a.IsExceptDetect,a.HasInstrumentLabel,a.flip FROM Symbol a inner join SymbolType b on a.SymbolType_UID=b.UID"""

                if rows is not None and len(rows) > 0:

                    for symbolTuple in rows:

                        sym = symbol.SymbolBase(symbolTuple[1], symbolTuple[2], symbolTuple[3], symbolTuple[4]

                        ret.append(sym)

            except Exception as ex:

        return ret

                    kyouho 2018.07.04 forCheckLineNumber get only inch or metric

                    kyouho 2018.07.16 edit query order by code

    '''

        res = []

        configs = self.getConfigs('Line No', 'Size Unit')

        sizeUnit = configs[0].value if 1 == len(configs) else 'Metric'

                # Get a cursor object

                cursor = conn.cursor()

                cursor.execute(sql)

                rows = cursor.fetchall()

                for row in rows:

                    pipeSize.sizeUnit = sizeUnit

                    if forCheckLineNumber:

                        if sizeUnit == 'Inch' and pipeSize.inchStr:

                        res.append(pipeSize)

            # Catch the exception

            except Exception as ex:

                App.mainWnd().addMessage.emit(MessageType.Error, message)

        return res

        @author     kyouho

        @date       2018.07.16

    '''

    def insertNomialPipeSize(self, pipeSizes):

        conn = self.project.database.connect()

        with conn:

                conn.rollback()

                from App import App

                App.mainWnd().addMessage.emit(MessageType.Error, message)

    '''

        @author     kyouho

        @date       2018.07.16

    '''

    def deleteNomialPipeSize(self):

        conn = self.project.database.connect()

        with conn:

                conn.commit()

            except Exception as ex:

                conn.rollback()

    '''

        @brief      convert inch to metric

        @author     kyouho

        @date       2018.07.09

    '''

    def convertInchToMetric(self, inch):

        result = ''

        conn = self.project.database.connect()

            try:

                # Get a cursor object

                cursor = conn.cursor()

                sql = "select MetricStr from NominalDiameter WHERE InchStr = ?"

                param = (inch,)

                cursor.execute(sql, param)

                    result = rows[0][0]

                # Catch the exception

            except Exception as ex:

        return result

        @author     kyouho

        @date       2018.07.03

    '''

    def getMaxColorUID(self):

        result = 0

                result = rows[0][0]

                # Catch the exception

            except Exception as ex:

        return result

        @author     kyouho

        @date       2018.07.09

    '''

    def setPropertyColor(self, _color):

        conn = self.project.database.connect()

        with conn:

            except Exception as ex:

                # Roll back any change if something goes wrong

                conn.rollback()

    '''

        @brief      delete Color property

        @author     kyouho

        @date       2018.07.09

    '''

    def deletePropertyColor(self, property):

        conn = self.project.database.connect()

        with conn:

            except Exception as ex:

                # Roll back any change if something goes wrong

                conn.rollback()

    '''

        @brief      get Fluid Code

        @date       2018.07.03

        @history    kyouho 2018.07.04 kyouho 2018.07.04 forCheckLineNumber get only code

    '''

        from FluidCodeData import FluidCodeData

        result = []

                        result.append(data)

                # Catch the exception

            except Exception as ex:

        return result

        @author     kyouho

        @date       2018.07.18

    '''

    def checkAttribute(self, attr):

        conn = self.project.database.connect()

        with conn:

                    return False

                # Catch the exception

            except Exception as ex:

        return False

        @date       2018.07.18

        @history    humkyung 2018.10.13 load expression

    '''

    def getSymbolAttribute(self, _type):

        import uuid

        from SymbolAttr import SymbolAttr

                # Get a cursor object

                cursor = conn.cursor()

                param = (_type,)

                cursor.execute(sql, param)

                rows = cursor.fetchall()

                    result.append(attr)

            # Catch the exception

            except Exception as ex:

                App.mainWnd().addMessage.emit(MessageType.Error, message)

        return result

        @date       2018.08.17

        @history    humkyung 2018.10.13 load expression

    '''

    def getSymbolAttributeByUID(self, UID):

        from SymbolAttr import SymbolAttr

                # Get a cursor object

                cursor = conn.cursor()

                cursor.execute(sql)

                rows = cursor.fetchall()

                if len(rows):

                # Catch the exception

            except Exception as ex:

                from App import App

                App.mainWnd().addMessage.emit(MessageType.Error, message)

        return res

        @date       2018.08.14

        @history    humkyung 2018.10.13 save expression

    '''

    def saveSymbolAttributes(self, type, attrs):

        conn = self.project.database.connect()

        with conn:

                cursor.execute(sql, param)

                for attr in attrs:

                    attr.insert(1, type)

                    cursor.execute(sql, tuple(attr))

            except Exception as ex:

                # Roll back any change if something goes wrong

                conn.rollback()

                App.mainWnd().addMessage.emit(MessageType.Error, message)

    '''

        @author     humkyung

        @date       2018.08.14

    '''

    def saveLineAttributes(self, attrs):

        conn = self.project.database.connect()

        with conn:

                cursor.execute(sql)

                for attr in attrs:

                    cursor.execute(sql, tuple(attr))

                conn.commit()

            except Exception as ex:

                # Roll back any change if something goes wrong

                conn.rollback()

                App.mainWnd().addMessage.emit(MessageType.Error, message)

    '''

        @author     kyouho

        @date       2018.08.17

    '''

    def getSymbolTypeId(self, symbolType):

        result = []

                param = (symbolType,)

                cursor.execute(sql, param)

                rows = cursor.fetchall()

                if len(rows):