projects
/
photo-tags.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
moved css files into their own directory
[photo-tags.git]
/
f-spot-db-reduce.sh
diff --git
a/f-spot-db-reduce.sh
b/f-spot-db-reduce.sh
index fc421feca89c6b452d8a1edbef0f3043093bfad5..436e6b1b13d739d23d3feaf5d1b488f5bc1a3ac0 100755
(executable)
--- a/
f-spot-db-reduce.sh
+++ b/
f-spot-db-reduce.sh
@@
-1,6
+1,6
@@
#!/bin/bash
#!/bin/bash
-# parse ini file
+# parse ini file
CONFIG_FILE="config.ini"
# copied and modified from http://mark.aufflick.com/blog/2007/11/08/parsing-ini-files-with-sed
CONFIG_FILE="config.ini"
# copied and modified from http://mark.aufflick.com/blog/2007/11/08/parsing-ini-files-with-sed
@@
-27,12
+27,12
@@
CL_INCLUDE=""
CL_EXCLUDE=""
for i in "$@"; do
CL_EXCLUDE=""
for i in "$@"; do
- case $i in
+ case $i in
--include=*)
--include=*)
- CL_INCLUDE=${i#*=}
+ CL_INCLUDE=${i#*=}
;;
--exclude=*)
;;
--exclude=*)
- CL_EXCLUDE=${i#*=}
+ CL_EXCLUDE=${i#*=}
;;
-h|--help)
usage
;;
-h|--help)
usage
@@
-69,7
+69,7
@@
fi
# test if localdb already exist:
# yes:
# see if photo-db is newer? yes: merge them; no: do nothing
# test if localdb already exist:
# yes:
# see if photo-db is newer? yes: merge them; no: do nothing
-# no:
+# no:
# create it
cp $REMOTEDB $LOCALDB
# create it
cp $REMOTEDB $LOCALDB
@@
-93,7
+93,7
@@
delete from tags where id not in (select distinct tag_id from photo_tags asc);
delete from rolls where id not in (select distinct roll_id from photos asc);
drop table rmphotoids;
delete from rolls where id not in (select distinct roll_id from photos asc);
drop table rmphotoids;
-drop table jobs;
+drop table jobs;
drop table exports;
vacuum;
drop table exports;
vacuum;