HYTOS

# coding: utf-8

import sys

import os

from PyQt5.QtCore import *

import sqlite3

import datetime

from PIL import PngImagePlugin, JpegImagePlugin

from PIL import Image

from PIL.ImageQt import ImageQt

try:

    from PyQt5.QtCore import QBuffer

    from PyQt5.QtGui import QImage, QPixmap

except ImportError:

    from PyQt4.QtCore import QBuffer

    from PyQt4.QtGui import QImage, QPixmap

import numpy as np

from SingletonInstance import SingletonInstane

import Project

import SymbolBase

import symbol

from EquipmentData import EquipmentData

class Source:

    def __init__(self, source):

        if type(source) is np.ndarray:

            self.source = Image.fromarray(source)

        elif type(source) is PngImagePlugin.PngImageFile or type(source) is JpegImagePlugin.JpegImageFile:

            self.source = source

        elif type(source) is QImage:

            self.source = Image.fromqimage(source)

        elif type(source) is QPixmap:

            self.source = Image.fromqpixmap(source)

    '''

        @history    2018.05.18  Jeongwoo    When Parameter [rect] is None, return whole image

    '''

    def getPyImageOnRect(self, rect = None):

        if rect is not None:

            return self.source.copy().crop((rect.left(), rect.top(), rect.right(), rect.bottom()))

        else:

            return self.source.copy()

    def getQImageOnRect(self, rect = None):

        image = ImageQt(self.getPyImageOnRect(rect))

        return image.convertToFormat(QImage.Format_RGBA8888)

class Area:

    def __init__(self):

        self.name = None

        self.x = None

        self.y = None

        self.width = None

        self.height = None

    '''

        @brief  parse area

        @author humkyung

        @date   2018.06.29

    '''

    def parse(self, strArea):

        import re

        found = re.findall('\d+', strArea)

        if len(found) == 4:

            self.x = int(found[0])

            self.y = int(found[1])

            self.width = int(found[2])

            self.height = int(found[3])

    '''

        @brief  to string

        @author humkyung

        @date   2018.06.30

    '''

    def toString(self):

        return '({},{}),({},{})'.format(self.x, self.y, self.width, self.height)

    '''

        @brief  clone an object

    '''

    def clone(self):

        clone = Area()

        clone.x = self.x

        clone.y = self.y

        clone.width = self.width

        clone.height = self.height

class Config:

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

        self.section = section

        self.key = key

        self.value = value

class NominalPipeSize:

    def __init__(self, code, metric, inch, inchStr, metricStr):

        self.code = code

        self.metric = metric

        self.inch = inch

        self.inchStr = inchStr

        self.metricStr = metricStr

        self.sizeUnit = 'Metric'

    '''

        @brief  return size value string

        @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.red = red

        self.green = green

        self.blue = blue

class AppDocData(SingletonInstane):

    def __init__(self):

        self.imgName = None

        self.imgWidth = 0

        self.imgHeight = 0

        self._areas = []

        self.equipments = []

        self.equipmentDataList = []

        self.lineNos = []

        self.lines = []

        self.symbols = []

        self._colors = None

        self._lineTypes = None

        self._lineTypeConfigs = None

    '''

        @brief      Get DB file path in ProgramData

        @author     Jeongwoo

        @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')

        return templateDbPath

    '''

        @brief  getter of colors 

        @author humkyung

        @date   2018.06.18

    '''

    @property

    def colors(self):

        if self._colors is None:

            self._colors = []

            try:

                dbPath = os.path.join(self.getCurrentProject().getDbFilePath() , 'ITI_PID.db')

                conn = sqlite3.connect(dbPath)

                cursor = conn.cursor()

                sql = 'SELECT UID,RED,GREEN,BLUE FROM Colors'

                cursor.execute(sql)

                rows = cursor.fetchall()

                for row in rows:

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

            # Catch the exception

            except Exception as ex:

                # Roll back any change if something goes wrong

                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:

                conn.close()

        return self._colors

    '''

        @brief  setter of colors

        @author humkyung

        @date   2018.06.18

    '''

    @colors.setter

    def colors(self, value):

        self._colors = value

    '''

        @brief  getter of line type configs

        @author humkyung

        @date   2018.06.28

    '''

    @property

    def lineTypeConfigs(self):

        from PyQt5.QtCore import Qt

        if self._lineTypeConfigs is None:

            self._lineTypeConfigs = []

            styleMap = [('SolidLine', Qt.SolidLine), ('DashLine', Qt.DashLine), ('DotLine', Qt.DotLine), ('DashDotLine', Qt.DashDotLine), 

                ('DashDotDotLine', Qt.DashDotDotLine), ('CustomDashLine', Qt.CustomDashLine)]

            configs = self.getConfigs('LineTypes')

            for config in configs:

                width, _style = config.value.split(',')

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

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

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

        return self._lineTypeConfigs

    '''

        @brief  setter of line type configs

        @author humkyung

        @date   2018.06.28

    '''

    @lineTypeConfigs.setter

    def lineTypeConfigs(self, value):

        self._lineTypeConfigs = value

    '''

        @brief  get line type config of given line type

        @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]

        return matches[0] if matches else (lineType, 5, Qt.SolidLine)        

    def setCurrentPidSource(self, image):

        self.imgWidth, self.imgHeight = image.size

        self.currentPidSource = Source(image)

    def getCurrentPidSource(self):

        return self.currentPidSource

    '''

        @brief      Check if Exist data or not, Moved from SG_DbHelper

        @author     Jeongwoo

        @date       2018.05.03

    '''

    def isExistData(self, fieldName, data):

        rows = None

        try:

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), "ITI_PID.db")

            conn = sqlite3.connect(dbPath)

            cursor = conn.cursor()

            sql = ""

            if isinstance(data, str):

                sql = "SELECT * FROM Symbol WHERE " + fieldName + " = '"+ data +"'"

            else:

                sql = "SELECT * FROM Symbol WHERE " + fieldName + " = "+ str(data) +""

            cursor.execute(sql)

            rows = cursor.fetchall()

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            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:

            conn.close()

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

                return True

            else:

                return False

    '''

        @brief      Check if exist file name or not, Moved from SG_DbHelper

        @author     Jeongwoo

        @date       2018.05.03

    '''

    def isExistFileName(self, name):

        rows = None

        try:

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), "ITI_PID.db")

            conn = sqlite3.connect(dbPath)

            cursor = conn.cursor()

            sql = "SELECT * FROM Symbol WHERE name = '"+ name +"'"

            cursor.execute(sql)

            rows = cursor.fetchall()

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            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:

            conn.close()

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

                return True

            else:

                return False

    '''

        @brief      Insert new symbol into Symbol Table, Moved from SG_DbHelper

        @author     Jeongwoo

        @date       2018.05.03

    '''

    def insertSymbol(self, symbol):

        isAdded = False

        try:

            dbPath = self.getCurrentProject().getDbFilePath() + "/ITI_PID.db"

            conn = sqlite3.connect(dbPath)

            INSERT_SYMBOL_SQL = '''

                INSERT INTO Symbol(symId, name, type, threshold, minMatchPoint, isDetectOrigin, rotationCount, ocrOption, isContainChild, originalPoint, connectionPoint, baseSymbol, additionalSymbol, isExceptDetect) 

                VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);

            '''

            cursor = conn.cursor()

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

                           , symbol.getMinMatchCount(), symbol.getIsDetectOnOrigin(), symbol.getRotationCount()

                           , symbol.getOcrOption(), symbol.getIsContainChild()

                           , symbol.getOriginalPoint(), symbol.getConnectionPoint()

                           , symbol.getBaseSymbol(), symbol.getAdditionalSymbol(), symbol.getIsExceptDetect())

            cursor.execute(INSERT_SYMBOL_SQL, query)

            conn.commit()

            isAdded = True

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            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:

            conn.close()

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

    '''

        @brief      Update symbol in Symbol Table, Moved from SG_DbHelper

        @author     Jeongwoo

        @date       2018.05.03

    '''

    def updateSymbol(self, symbol):

        isUpdated = False

        try:

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), "ITI_PID.db")

            conn = sqlite3.connect(dbPath)

            UPDATE_SYMBOL_SQL = '''

                UPDATE Symbol

                SET

                    symId = ?, name = ?, type = ?, threshold = ?, minMatchPoint = ?, isDetectOrigin = ?,

                    rotationCount = ?, ocrOption = ?, isContainChild = ?, originalPoint = ?, connectionPoint = ?,

                    baseSymbol = ?, additionalSymbol = ?, isExceptDetect = ?

                WHERE uid = ?

            '''

            cursor = conn.cursor()

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

                           , symbol.getMinMatchCount(), symbol.getIsDetectOnOrigin(), symbol.getRotationCount()

                           , symbol.getOcrOption(), symbol.getIsContainChild()

                           , symbol.getOriginalPoint(), symbol.getConnectionPoint()

                           , symbol.getBaseSymbol(), symbol.getAdditionalSymbol(), symbol.getIsExceptDetect(), symbol.getUid())

            cursor.execute(UPDATE_SYMBOL_SQL, query)

            conn.commit()

            isUpdated = True

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            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:

            conn.close()

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

    '''

        @brief      Get Detecting Target Symbol List (Field 'isExceptDetect' == False(0))

        @author     Jeongwoo

        @date       18.04.24

        @history    humkyung 2018.06.28 select symbol order by threshold descending

    '''

    def getTargetSymbolList(self):

        targetSymbolList = []

        try:

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), "ITI_PID.db")

            conn = sqlite3.connect(dbPath)

            cursor = conn.cursor()

            sql = 'SELECT * FROM Symbol WHERE isExceptDetect = 0 order by threshold desc'

            try:

                cursor.execute(sql)

                rows = cursor.fetchall()

                for row in rows:

                    sym = symbol.SymbolBase(row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[8], row[9], row[10], row[11], row[12], row[13], row[14], row[0]) ## uid is last item

                    targetSymbolList.append(sym)

            except Exception as ex:

                print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

        finally:

            conn.close()

        return targetSymbolList

    '''

        @brief  build application database

        @author humkyung

        @date   2018.04.20

    '''

    def buildAppDatabase(self):

        try:

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

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

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

            conn = sqlite3.connect(appDatabaseFilePath)

            # Get a cursor object

            cursor = conn.cursor()

            sqlFiles = ['App.Configuration.sql', 'App.Styles.sql']

            for sqlFile in sqlFiles:

                filePath = os.path.join(os.path.dirname(os.path.realpath(__file__)), 'Scripts', sqlFile)

                try:

                    file = QFile(filePath)

                    file.open(QFile.ReadOnly)

                    sql = file.readAll()

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

                    cursor.executescript(sql)

                finally:

                    file.close()

            conn.commit()

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            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

            conn.close()

    '''

        @brief  load app style

        @author humkyung

        @date   2018.04.20

    '''

    def loadAppStyle(self):

        style = 'Fusion'

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

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

        self.buildAppDatabase()

        try:

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

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

            conn = sqlite3.connect(appDatabaseFilePath)

            # Get a cursor object

            cursor = conn.cursor()

            sql = "select Value from Configuration where Section='App' and Key='Style'" 

            cursor.execute(sql)

            rows = cursor.fetchall()

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

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            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

            conn.close()

        return style

    '''

        @brief  load app styles and then return a list

        @author humkyung

        @date   2018.04.20

    '''

    def loadAppStyles(self):

        styles = []

        try:

            self.buildAppDatabase()

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

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

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

            conn = sqlite3.connect(appDatabaseFilePath)

            # Get a cursor object

            cursor = conn.cursor()

            sql = 'select UID,Value from Styles'

            cursor.execute(sql)

            rows = cursor.fetchall()

            for row in rows: styles.append(row[1])

            if 0 == len(rows): rows.append('fusion')

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            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

            conn.close()

        return styles

    '''

        @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()

        try:

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

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath() , "ITI_PID.db")

            if not os.path.isfile(dbPath):

                templatePath = self.getTemplateDbPath()

                templateFile = QFile(templatePath)

                templateFile.copy(dbPath)

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

        finally:

            pass

    '''

        @brief      Make Directory

        @author     Jeongwoo

        @date       18.05.08

        @history    humkyung 2018.06.19 make 'Tile' directory

    '''

    def makeChildDir(self):

        project = AppDocData.instance().getCurrentProject()

        dbDir = project.getDbFilePath()

        if not os.path.exists(dbDir):

            os.makedirs(dbDir)

        imgDir = project.getImageFilePath()

        if not os.path.exists(imgDir):

            os.makedirs(imgDir)

        svgDir = project.getSvgFilePath()

        if not os.path.exists(svgDir):

            os.makedirs(svgDir)

        outputDir = project.getOutputPath()

        if not os.path.exists(outputDir):

            os.makedirs(outputDir)

        tempDir = project.getTempPath()

        if not os.path.exists(tempDir):

            os.makedirs(tempDir)

        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)

        prjDatabaseFilePath = os.path.join(path, 'Project.db')

        try:

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

            conn = sqlite3.connect(prjDatabaseFilePath)

            # Get a cursor object

            cursor = conn.cursor()

            filePath = os.path.join(os.path.dirname(os.path.realpath(__file__)), 'Scripts', 'Project.Projects.sql')

            try:

                file = QFile(filePath)

                file.open(QFile.ReadOnly)

                sql = file.readAll()

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

                cursor.executescript(sql)

            finally:

                file.close()

            conn.commit()

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            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

            conn.close()

        return prjDatabaseFilePath

    '''

        @brief  return line properties

        @author humkyung

        @date   2018.04.09

    '''

    def getLineProperties(self):

        res = []

        try:

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

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), 'ITI_PID.db')

            db = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = db.cursor()

            sql = "select Name from LineProperties order by Name" 

            cursor.execute(sql)

            rows = cursor.fetchall()

            for row in rows:

                res.append(row[0])

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            db.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()

        return res

    '''

        @brief  return line types 

        @author humkyung

        @date   2018.06.27

    '''

    def getLineTypes(self):

        res = []

        try:

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

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), 'ITI_PID.db')

            db = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = db.cursor()

            sql = "select Name from LineTypes order by Name" 

            cursor.execute(sql)

            rows = cursor.fetchall()

            for row in rows:

                res.append(row[0])

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            db.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()

        return res

    '''

        @brief      Insert New Project Info

        @author     Jeongwoo

        @date       2018.04.06

        @history    humkyung 2018.04.19 use getPrjDatabasePath function instead of PROJECT_DB_PATH variable

    '''

    def insertProjectInfo(self, dir):

        try:

            prjDatabaseFilePath = self.getPrjDatabasePath()

            conn = sqlite3.connect(prjDatabaseFilePath)

            folderName = dir.split('/')[-1]

            if folderName:

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

                sql = "INSERT INTO Projects(Name, Path, CreatedDate, UpdatedDate) VALUES('" + folderName + "', '" + dir + "', '" + nowDate + "', '" + nowDate + "')"

                cur = conn.cursor()

                cur.execute(sql)

                conn.commit()

            else:

                print("Empty folder name")

        except Exception as ex:

            # Roll back any change if something goes wrong

            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:

            conn.close()

    '''

        @brief      Update Project UpdatedDate Field

        @author     Jeongwoo

        @date       2018.04.06

        @history    humkyung 2018.04.19 use getPrjDatabasePath function instead of PROJECT_DB_PATH variable

    '''

    def updateProjectUpdatedDate(self, id):

        try:

            prjDatabaseFilePath = self.getPrjDatabasePath()

            conn = sqlite3.connect(prjDatabaseFilePath)

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

            sql = '''

                UPDATE Projects

                SET UpdatedDate = ?

                WHERE Id = ?

            '''

            cur = conn.cursor()

            cur.execute(sql, (nowDate, id))

            conn.commit()

        except Exception as ex:

            # Roll back any change if something goes wrong

            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:

            conn.close()

    '''

        @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

        projectList = []

        try:

            conn = sqlite3.connect(self.getPrjDatabasePath())

            cursor = conn.cursor()

            sql = 'SELECT id,name,path,createddate,updateddate  FROM Projects ORDER BY UpdatedDate DESC'

            try:

                cursor.execute(sql)

                rows = cursor.fetchall()

                for row in rows:

                    if os.path.isdir(row[2]):   # check if folder exists

                        projectList.append(Project(row[0], row[1], row[2], row[3], row[4]))

            except Exception as ex:

                print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

        finally:

            conn.close()

        return projectList

    '''

        @brief  get sliding window size

        @author humkyung

    '''

    def getSlidingWindowSize(self):

        res = [10,10]

        try:

            configs = self.getConfigs('Sliding Window')

            for config in configs:

                if config.key == 'Width':

                    res[0] = int(config.value)

                elif config.key == 'Height':

                    res[1] = int(config.value)

        # Catch the exception

        except Exception as ex:

            print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

        return res

    '''

        @brief  get line no configuration

        @author humkyung

        @date   2018.04.16

    '''

    def getLineNoConfiguration(self):

        res = None

        try:

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

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), 'ITI_PID.db')

            conn = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = conn.cursor()

            delimiter = None

            sql = "select * from configuration where section='Line No' and key='Delimiter"

            cursor.execute(sql)

            rows = cursor.fetchall()

            if len(rows) == 1:

                delimiter = rows[0][2]

            if delimiter is not None:

                sql = "select * from configuration where section='Line No' and key='Configuration'"

                cursor.execute(sql)

                rows = cursor.fetchall()

                if len(rows) == 1:

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

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            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

            conn.close()

        return res

    '''

        @brief  get area list

        @author humkyung

    '''

    def getAreaList(self):

        if len(self._areas) == 0:

            try:

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

                dbPath = self.getCurrentProject().getDbFilePath() + "/ITI_PID.db"

                conn = sqlite3.connect(dbPath)

                # Get a cursor object

                cursor = conn.cursor()

                sql = "select * from configuration where section='Area'"

                cursor.execute(sql)

                rows = cursor.fetchall()

                for row in rows:

                    area = Area()

                    area.name = row[1]

                    area.parse(row[2])

                    self._areas.append(area)

            # Catch the exception

            except Exception as ex:

                # Roll back any change if something goes wrong

                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

                conn.close()

        return self._areas 

    '''

        @brief  get area of given name

        @author humkyung

        @date   2018.04.07

    '''

    def getArea(self, name):

        areas = self.getAreaList()

        matches = [area for area in areas if area.name==name]

        if 1 == len(matches): return matches[0]

        return None

    '''

        @brief  get configurations

        @author humkyung

        @date   2018.04.16

    '''

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

        res = []

        try:

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

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), 'ITI_PID.db')

            conn = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = conn.cursor()

            if key is not None:

                sql = "select * from configuration where section='{}' and key='{}'".format(section, key)

            else:

                sql = "select * from configuration where section='{}'".format(section)

            cursor.execute(sql)

            rows = cursor.fetchall()

            for row in rows:

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

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            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

            conn.close()

        return res

    '''

        @brief  save configurations

        @author humkyung

        @date   2018.04.16

    '''

    def saveConfigs(self, configs):

        try:

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

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), "ITI_PID.db")

            conn = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = conn.cursor()

            for config in configs:

                sql = "insert or replace into configuration values('{}','{}','{}')".format(config.section, config.key, config.value)

                cursor.execute(sql)

            conn.commit()

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            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

            conn.close()

    '''

        @brief  delete configurations

        @author humkyung

        @date   2018.06.29

    '''

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

        try:

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

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), "ITI_PID.db")

            conn = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = conn.cursor()

            if key is not None:

                sql = "delete from configuration where section='{}' and key='{}'".format(section, key)

            else:

                sql = "delete from configuration where section='{}'".format(section)

            cursor.execute(sql)

            conn.commit()

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            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

            conn.close()

    '''

        @brief      set area list

        @history    humkyung 2018.05.18 round area coordinate and dimension before saving

    '''

    def setAreaList(self, areas):

        for area in areas:

            matches = [x for x in self._areas if x.name==area.name]

            if 1 == len(matches):

                matches[0].x = area.x

                matches[0].y = area.y

                matches[0].width = area.width

                matches[0].height = area.height

            elif 0 == len(matches):

                self._areas.append(area)

        try:

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

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), "ITI_PID.db")

            conn = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = conn.cursor()

            for area in self._areas:

                sql = "insert or replace into configuration values('Area','{}','({},{}),({},{})')".format(area.name, round(area.x), round(area.y), round(area.width), round(area.height))

                cursor.execute(sql)

            conn.commit()

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            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

            conn.close()

    '''

        @brief  get symbol name list

    '''

    def getSymbolNameList(self):

        symbolNametList = []

        try:

            dbPath = self.getCurrentProject().getDbFilePath() + "/ITI_PID.db"

            conn = sqlite3.connect(dbPath)

            cursor = conn.cursor()

            sql = 'SELECT * FROM SymbolName'

            try:

                cursor.execute(sql)

                rows = cursor.fetchall()

                for row in rows:

                    symbolNametList.append(row[2]) # Name String

            except Exception as ex:

                print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

        finally:

            conn.close()

        return symbolNametList

    '''

        @brief      get symbol name list by symbol Type

        @author     Jeongwoo

        @date       18.04.06

        @history    .

    '''

    def getSymbolNameListByType(self, type):

        symbolNametList = []

        try:

            dbPath = self.getCurrentProject().getDbFilePath() + "/ITI_PID.db"

            conn = sqlite3.connect(dbPath)

            cursor = conn.cursor()

            sql = ''

            if type is not None:

                sql = 'SELECT * FROM SymbolName WHERE type = "' + type + '"'

                try:

                    cursor.execute(sql)

                    rows = cursor.fetchall()

                    for row in rows:

                        symbolNametList.append(row[2]) # Name String

                except Exception as ex:

                    print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

        finally:

            conn.close()

        return symbolNametList

    '''

        @brief  delete added symbol data

    '''

    def deleteSymbol(self, fileName):

        ret = False

        try:

            dbPath = self.getCurrentProject().getPath() + "/db/ITI_PID.db"

            conn = sqlite3.connect(dbPath)

            cursor = conn.cursor()

            sql = "DELETE FROM Symbol WHERE name = ?"

            try:

                cursor.execute(sql, (fileName,))

                conn.commit()

                ret = True

            except Exception as ex:

                print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

                ret = False

        finally:

            conn.close()

            return (ret, fileName)

    '''

        @brief  get symbol name

        @history    18.04.24    Jeongwoo    Add isExceptDetect Field

    '''

    def getSymbolByQuery(self, fieldName, param):

        ret = None

        try:

            dbPath = self.getCurrentProject().getDbFilePath() + "/ITI_PID.db"

            conn = sqlite3.connect(dbPath)

            cursor = conn.cursor()

            sql = 'SELECT * FROM Symbol WHERE ' + fieldName + ' = "' + param + '"'

            try:

                cursor.execute(sql)

                rows = cursor.fetchall()

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

                    symbolTuple = rows[0]

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

                                            , symbolTuple[5], symbolTuple[6], symbolTuple[7], symbolTuple[8], symbolTuple[9]

                                            , symbolTuple[10], symbolTuple[11], symbolTuple[12], symbolTuple[13], symbolTuple[14], symbolTuple[0]) ## uid is last item

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

                    #                        , symbolTuple[5], symbolTuple[6], symbolTuple[7], symbolTuple[8], symbolTuple[9]

                    #                        , symbolTuple[10], symbolTuple[11], symbolTuple[12], symbolTuple[13], symbolTuple[14], symbolTuple[0]) ## uid is last item

            except Exception as ex:

                print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

        finally:

            conn.close()

        return ret

    '''

        @brief  get symbol name list

        @history    18.04.24    Jeongwoo    Add isExceptDetect Field

    '''

    def getSymbolListByQuery(self, fieldName=None, param=None):

        ret = []

        try:

            dbPath = self.getCurrentProject().getDbFilePath() + "/ITI_PID.db"

            conn = sqlite3.connect(dbPath)

            cursor = conn.cursor()

            if fieldName is not None and param is not None:

                sql = 'SELECT * FROM Symbol WHERE ' + fieldName + ' = "' + param + '"'

            else:

                sql = 'SELECT * FROM Symbol'

            try:

                cursor.execute(sql)

                rows = cursor.fetchall()

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

                    for symbolTuple in rows:

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

                                                , symbolTuple[5], symbolTuple[6], symbolTuple[7], symbolTuple[8], symbolTuple[9]

                                                , symbolTuple[10], symbolTuple[11], symbolTuple[12], symbolTuple[13], symbolTuple[14], symbolTuple[0]) ## uid is last item

                        ret.append(sym)

            except Exception as ex:

                print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

        finally:

            conn.close()

        return ret

    '''

        @brief      get nominal pipe size

        @author     humkyung

        @date       2018.04.20

        @history    humkyung 2018.04.24 read MetricStr column and set size unit

    '''