Skip to content

Instantly share code, notes, and snippets.

@yangyushi

yangyushi/clean segmenter database

Created March 5, 2019 09:43
Show Gist options
  • Save yangyushi/b60da7abdf486640421ff86d98f85ae4 to your computer and use it in GitHub Desktop.
Save yangyushi/b60da7abdf486640421ff86d98f85ae4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
clean segmenter database
DELETE FROM raw_image WHERE id NOT IN (SELECT raw_image_id FROM result);
DELETE FROM image WHERE id NOT IN (SELECT image_id FROM result);
DELETE FROM image_parameter WHERE id NOT IN (SELECT image_parameter_id FROM result);
DELETE FROM segment_parameter WHERE id NOT IN (SELECT segment_parameter_id FROM result);
DELETE FROM result_tag WHERE id_result NOT IN (SELECT id FROM result);
VACUUM;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment