Lightroom: Is there a way to re-associate converted DNG files with the original RAW files?

Edit Subject

import sqlite3



            lrCatCon = None


            try:


                lrCatCon = sqlite3.connect( self.catPath )


                # works: cur = lrCatCon.execute( "select Adobe_images.id_global, Adobe_images.orientation, AgLibraryFile.id_global from Adobe_images INNER JOIN AgLibraryFile ON Adobe_images.rootFile = AgLibraryFile.id_local" )


                cur = lrCatCon.execute( "select Adobe_images.id_global, Adobe_images.orientation, AgLibraryFile.id_global, AgLibraryFile.idx_filename, AgLibraryFolder.pathFromRoot, AgLibraryRootFolder.absolutePath from Adobe_images INNER JOIN AgLibraryFile ON Adobe_images.rootFile = AgLibraryFile.id_local INNER JOIN AgLibraryFolder ON AgLibraryFile.folder = AgLibraryFolder.id_local INNER JOIN AgLibraryRootFolder ON AgLibraryFolder.rootFolder = AgLibraryRootFolder.id_local" )


                all = cur.fetchall()


                print "initializing photo-info from db"


                count = 0


                for row in all:


                    entry = dict()


                    entry["photoId"] = row[0] # redundent, but convenient.


                    entry["orientation"] = row[1]


                    entry["previewId"] = row[2]


                    filename = row[3]


                    pathFromRoot = row[4]


                    rootFolder = row[5]


                    photoFolder = os.path.join( rootFolder, pathFromRoot )


                    photoPath = os.path.normpath( os.path.join( photoFolder, filename ) ) # *** beware: join does not use backslashes on windows unless it starts that way or something.


                    entry["photoPath"] = photoPath


                    ###2 more?


                    # print photoPath # very verbose if catalog large.


                    self.photoIdToPhotoInfo[row[0]] = entry


                    self.photoPathToPhotoInfo[photoPath] = entry


                    count = count + 1


                print "{0} db rows processed".format( count )


                break


            except sqlite3.OperationalError:


                errm = str( sys.exc_info()[1] )


                print errm


                if errm == "database is locked":


                    answer = MsgBox.showWarning( self.frame, "Lightroom catalog ({0}) is locked - if Lightroom is already running, close it now, then click 'OK' to try again (use 'Task Manager/Force Quit' if necessary).".format(self.catPath), wx.OK | wx.CANCEL )


                    if answer != wx.ID_OK:


                        self.close( False )


                else:


                    MsgBox.showError( self.frame, "Operational error accessing lrcat file ({0}) - try again? (possibly bad sql)".format( self.catPath ), errm, wx.OK | wx.CANCEL )


                    if answer != wx.ID_OK:


                        self.close( False )


            except:


                errm = str( sys.exc_info()[1] )


                print errm


                MsgBox.showError( self.frame, "Unknown error accessing lrcat file ({0}) - try again?".format( self.catPath ), errm, wx.OK | wx.CANCEL )


                if answer != wx.ID_OK:


                    self.close( False )


            finally:


                if lrCatCon:


                    lrCatCon.close()


                    lrCatCon = None

update table_a set name = (select table_b.name from table_b where table_b.id = table_a.id)