HYTOS

        conn = self.project.database.connect()

        with conn:

            try:

                sql = "select UID,Name,Type1,Conditions1,Type2,Conditions2 from LineTypes order by Name"

                cursor.execute(sql)

                rows = cursor.fetchall()

        with self.project.database.connect() as conn:

            try:

                # Get a cursor object

                sql = "select a.*,b.Name,b.SymbolType_UID,b.[Type],b.OriginalPoint,b.ConnectionPoint,b.BaseSymbol," \

                      "b.AdditionalSymbol,b.HasInstrumentLabel,b.Flip as DetectFlip from Components a " \

        with self.project.database.connect() as conn:

            try:

                # Get a cursor object

                if target == "ALL" or target == '':

                    sql = "select (select Name from Drawings where UID=a.Drawings_UID) as Drawing," \

        with conn:

            try:

                # Get a cursor object

                sql = "select (select Name from Drawings where UID=a.From_Drawings_UID) as From_Drawing,\

                a.From_LineNo_UID as From_LineNo,\

        with conn:

            try:

                # Get a cursor object

                sql = f"select a.* from Points a join Components b on a.Components_UID=b.[UID] where Drawings_UID=" \

                      f"'{self.activeDrawing.UID}' order by Components_UID, [Index]"

        with conn:

            try:

                # Get a cursor object

                # sql = "select * from Associations where Components_UID='{}'".format(component)

                sql = "select a.* from Associations a \

        with conn:

            try:

                # Get a cursor object

                sql = "select a.*, b.* from Attributes a \

                            join SymbolAttribute b on a.SymbolAttribute_UID=b.UID \

        with conn:

            try:

                # Get a cursor object

                sql = "select * from PipeRuns where Owner='{}' order by [Index]".format(component)

                cursor.execute(sql)

        with conn:

            try:

                # Get a cursor object

                sql = "select * from PipeRunItems where PipeRuns_UID='{}' order by [Index]".format(pipe_run)

                cursor.execute(sql)

        with conn:

            try:

                # Get a cursor object

                sql = 'select UID, Code, Type, Allowables from SpecialItemTypes order by Code DESC'

                cursor.execute(sql)

        with conn:

            try:

                # Get a cursor object

                sql = "select a.UID,D.Name,E.Name as 'Drawing Name',C.Attribute,B.Value from Components a " \

                      "join Attributes B on a.UID=B.Components_UID " \

        with conn:

            try:

                # Get a cursor object

                sql = "select a.UID,D.Name,E.Name as 'Drawing Name',C.Attribute,B.Value,a.Symbol_UID from Components a " \

                      "join Attributes B on a.UID=B.Components_UID " \

        with conn:

            try:

                # Get a cursor object

                sql = "select a.UID,D.Name,E.Name as 'Drawing Name',C.Attribute,B.Value from Components a " \

                      "join Attributes B on a.UID=B.Components_UID " \

        with self.project.database.connect() as conn:

            try:

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

                    sql = 'select UID, [NAME], [DATETIME], IFNULL(B.[X], 0) as X, IFNULL(B.[Y], 0) as Y, ' \

                          'IFNULL(B.[Width], 0) as Width, IFNULL(B.[Height], 0) as Height from Drawings A ' \

        with self.project.database.connect() as conn:

            try:

                # Get a cursor object

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

                    cursor.execute('begin')