Skip to content

Development Tips

Darryl L. Pierce edited this page Mar 30, 2024 · 9 revisions

Database Issues

Batch Processing

Identify Records By Processing State

select d.comic_state, c.create_metadata_source, c.file_contents_loaded, c.blocked_pages_marked, c.update_metadata, c.organizing, c.recreating, count(*) as Instance 
  from comic_books c join comic_details d on c.Id = d.comic_book_id
  group by d.comic_state, c.create_metadata_source, c.file_contents_loaded, c.blocked_pages_marked, c.update_metadata, c.organizing, c.recreating;

Shows all comic records grouped by the various flags used for batch processing.

Clone this wiki locally