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)

    def getPyImageOnRect(self, rect):

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

    def getQImageOnRect(self, rect):

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

class AppDocData(SingletonInstane):

    def __init__(self):

        self.imgName = None

        self.imgWidth = 0

        self.imgHeight = 0

        self._areas = []

        self.equipments = []

        self.equipmentDataList = []

        self.lineNos = []

    def setCurrentPidSource(self, image):

        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 = 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 = 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 = 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

    '''

    def getTargetSymbolList(self):

        targetSymbolList = []

        try:

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

            conn = sqlite3.connect(dbPath)

            cursor = conn.cursor()

            sql = 'SELECT * FROM Symbol WHERE isExceptDetect = 0'

            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

    '''

    def setCurrentProject(self, project):

        self.project = project

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

            fileNames = os.listdir(os.path.join(os.path.dirname(os.path.realpath(__file__)), 'Scripts'))

            for fileName in fileNames:

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

                    try:

                        file = QFile(os.path.join(os.path.dirname(os.path.realpath(__file__)), 'Scripts', fileName))

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

                    tokens = row[2].split(',')

                    area.x = float(tokens[0])

                    area.y = float(tokens[1])

                    area.width = float(tokens[2])

                    area.height = float(tokens[3])

                    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 = 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  set area list

    '''

    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 = 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, area.x, area.y, area.width, 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

    '''

    def getNomialPipeSizeData(self):

        res = []

        try:

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

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

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

            sql = "select Code,Metric,Inch,InchStr,MetricStr from 'NOMINAL PIPE SIZE'"

            cursor.execute(sql)

            rows = cursor.fetchall()

            for row in rows:

                pipeSize = NominalPipeSize(row[0], float(row[1]) if row[1] is not None else -1, float(row[2]) if row[2] is not None else -1, row[3], row[4])

                pipeSize.sizeUnit = sizeUnit

                res.append(pipeSize)

        # 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 equipment data list

        @author     humkyung

        @date       2018.05.03

    '''

    def getEquipmentDataList(self):

        from EquipmentData import EquipmentData

        if not self.equipmentDataList:

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

                sql = 'select TAG_NO from EQUIPMENT_DATA_LIST'

                cursor.execute(sql)

                rows = cursor.fetchall()

                for row in rows:

                    data = EquipmentData(row[0])

                    self.equipmentDataList.append(data)

            # 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.equipmentDataList 

    '''

        @brief      set equipment data list

        @author     humkyung

        @date       2018.05.03

    '''

    def setEquipmentDataList(self, dataList):

        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 data in dataList:

                sql = "insert or replace into EQUIPMENT_DATA_LIST(UID,TAG_NO) values(lower(hex(randomblob(16))),'{}')".format(data.tagNo)

                cursor.execute(sql)

            conn.commit()

            self.equipmentDataList = dataList

        # 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 IsOriginDetect ComboBox Items

    '''

    def getIsOriginDetectComboBoxItems(self):

        return [("원본 도면", 0), ("텍스트 제거 도면", 1)]

    '''

        @brief  get IsOriginDetect ComboBox Items

    '''

    def getOcrOptionComboBoxItems(self):

        return [("OCR 미적용", 0), ("일반 심볼", 1), ("Instrument 계통", 2)]

    '''

        @brief      Return Symbol Type Items

        @author     Jeongwoo

        @date       18.04.20

        @history    .

    '''

    def getSymbolTypeList(self):

        symbolTypeList = []

        try:

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

            conn = sqlite3.connect(dbPath)

            cursor = conn.cursor()

            sql = 'SELECT * FROM SymbolType ORDER BY type ASC'

            try:

                cursor.execute(sql)

                rows = cursor.fetchall()

                for row in rows:

                    symbolTypeList.append(row[1]) # Type 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 symbolTypeList

    '''

        @brief      Return Symbol Type Items with "None"

        @author     Jeongwoo

        @date       18.04.06

        @history    Seperate SymbolTypeList and "None"

    '''

    def getSymbolTypeComboBoxItems(self):

        symbolTypeList = self.getSymbolTypeList()

        symbolTypeList.insert(0, "None")

        return symbolTypeList

    '''

        @brief  get Base Symbol ComboBox Items

    '''

    def getBaseSymbolComboBoxItems(self, type = None):

        bsymbolNameList = self.getSymbolNameListByType(type)

        bsymbolNameList.sort()

        bsymbolNameList.insert(0, "None")

        return bsymbolNameList

    '''

        @brief  get Additional Symbol ComboBox Items

    '''

    def getAdditionalSymbolComboBoxItems(self):

        asymbolNameList = self.getSymbolNameList()

        asymbolNameList.sort()

        asymbolNameList.insert(0, "None")

        return asymbolNameList

    '''

        @brief  get Additional Symbol's default direction ComboBox Items

    '''

    def getDefaultSymbolDirectionComboBoxItems(self):

        return [("UP", 0), ("DOWN", 2), ("LEFT", 3), ("RIGHT", 1)]

    pass