#!/bin/bash
. .env
fp=${PICTURES}/face-data
cat << EOF | ./query.sh
update photos set faces=-1 where faces!=-1;
delete from photos where deleted=1;
delete from facedescriptors where id>0;
delete from sqlite_sequence where name='facedescriptors';
delete from faces where id>0;
delete from sqlite_sequence where name='faces';
EOF
find ${fp} -type f -delete
find ${fp} -empty -delete
mkdir ${fp}