On Thu, 2017-04-13 at 20:59 +0000, Tony Arnold wrote: > On Thu, 2017-04-13 at 12:32 -0700, darkta...@911networks.com wrote: > > DT 2.2.4 > > > > I'm looking for a full list of the images with their current > > directory. > > > > Looking at library.db, I have found: > > > > images > filename > > > > is the directory in: film_rolls > folders? > > > > and the link: film_rolls.id = images.film_id? > > > > Is there a schema 'floating around' with the various links? > > Yes, the field images.film_id relates to film_rolls.id. With > suitable > select and join functions in SQL, you could get a complete list.
The following SQL statement should get you what you want. Run this against 'library.db' select folder,filename from film_rolls,images where images.film_id=film_rolls.id order by folder; HTH. Regards, Tony. > -- Tony Arnold MBCS, CITP | Senior IT Security Analyst | Directorate of IT Services | G64, Kilburn Building | The University of Manchester | Manchester M13 9PL | T: +44 161 275 6093 | M: +44 773 330 0039 ____________________________________________________________________________ darktable user mailing list to unsubscribe send a mail to darktable-user+unsubscr...@lists.darktable.or