HYTOS

    def get_selected_nd(self, row_id, unit):

        res = None

        try:

            conn = sqlite3.connect(self.activeDrawing.path)

            conn.execute('PRAGMA foreign_keys = ON')

            # Get a cursor object

            cursor = conn.cursor()

            if unit == 'in':

                sql = 'select Inch from NominalDiameter where rowid <= ?'

            elif unit == 'mm':

                sql = 'select Milimeter from NominalDiameter where rowid <= ?'

            param = (row_id,)

            cursor.execute(sql, param)

            rows = cursor.fetchall()

            for row in rows:

                res = row[0]

        except Exception as ex:

            from App import App

            # Roll back any change if something goes wrong

            conn.rollback()

            message = 'error occurred({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename,

                                                           sys.exc_info()[-1].tb_lineno)

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

        finally:

            # Close the db connection

            conn.close()

        return res

    def get_row_id(self, size, unit):

        res = None

        try:

            conn = sqlite3.connect(self.activeDrawing.path)

            conn.execute('PRAGMA foreign_keys = ON')

            # Get a cursor object

            cursor = conn.cursor()

            if unit == 'in':

                sql = 'select count(*) from NominalDiameter where Inch <= ?'

            elif unit == 'mm':

                sql = 'select count(*) from NominalDiameter where Milimeter <= ?'

            param = (size,)

            cursor.execute(sql, param)

            rows = cursor.fetchall()

            for row in rows:

                res = row[0]

        except Exception as ex:

            from App import App

            # Roll back any change if something goes wrong

            conn.rollback()

            message = 'error occurred({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename,

                                                           sys.exc_info()[-1].tb_lineno)

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

        finally:

            # Close the db connection

            conn.close()

        return res