Warning, /graphics/digikam-test-data/core/tests/database/README is written in an unsupported language. File is not indexed.
0001 --- phase 1 ---
0002 010- start a fresh digikam with first album data/testimages/a1
0003 020- rebuild all thumbnails
0004 030- rebuild fingerprints
0005 040+ create tag tree
0006 050- add album data/testimages/a2
0007 060+ add tags to images
0008 065- rotate icc-test-farbkreis.jpg 90° right
0009 070- rebuild all thumbnails
0010 080- rebuild fingerprints
0011 090+ dump data from sqlite database
0012 100- convert to mysql
0013 110+ dump data from mysql database
0014
0015 --- phase 2 ---
0016 120- reset
0017 130- start a fresh digikam with first album data/testimages/a1
0018 140- convert to mysql
0019 150- rebuild all thumbnails
0020 160- rebuild fingerprints
0021 170+ create tag tree
0022 175- rotate icc-test-farbkreis.jpg 90° right
0023 180- add album data/testimages/a2
0024 190- rebuild all thumbnails
0025 200- rebuild fingerprints
0026 210+ add tags to images
0027 220+ dump data from mysql database
0028
0029 --- image tree ---
0030 drwx 4096 .
0031 drwx 4096 ./a1
0032 drwx 4096 ./a1/png
0033 -rw- 173933 ./a1/png/snap001.png
0034 -rw- 71056 ./a1/png/snap002.png
0035 drwx 4096 ./a1/jpg
0036 -rw- 105505 ./a1/jpg/foto001bw.jpg
0037 -rw- 145538 ./a1/jpg/foto001.jpg this image has geotags
0038 drwx 4096 ./a2
0039 -rw- 114493 ./a2/big-image.png this image has some tags already defined
0040 -rw- 50331 ./a2/icc-test-no-profile.jpg
0041 -rw- 99416 ./a2/Martian_face_viking.jpg
0042 -rw- 75675 ./a2/icc-test-farbkreis.jpg
0043 drwx 4096 ./a2/pgf
0044 drwx 4096 ./a2/pgf/link
0045 lrwx 16 ./a2/pgf/link/otherlink.pgf -> ../foto001q5.pgf
0046 lrwx 16 ./a2/pgf/link/foto001q5.pgf -> ../foto001q5.pgf
0047 -rw- 89012 ./a2/pgf/foto001q5.pgf
0048
0049
0050 --- phase 1 --- step 040
0051 --- phase 2 --- step 170
0052 SELECT CONCAT(SPACE(COUNT(parent.name) - 1), " + ", node.name, "(",
0053 node.pid, ":", node.id, ")") AS node
0054 FROM tags AS node, tags AS parent
0055 WHERE node.lft BETWEEN parent.lft AND parent.rgt
0056 GROUP BY node.name
0057 ORDER BY node.lft;
0058
0059 +----------------------+
0060 | node |
0061 +----------------------+
0062 | + tagl0a(0:1) |
0063 | + tagl1c(1:4) |
0064 | + tagl1b(1:3) |
0065 | + tagl2d(3:8) |
0066 | + tagl2c(3:7) |
0067 | + tagl2b(3:6) |
0068 | + tagl3b(6:10) |
0069 | + tagl3a(6:9) |
0070 | + tagl2a(3:5) |
0071 | + tagl1a(1:2) |
0072 | + tl0(0:11) |
0073 | + tl0b(11:13) |
0074 | + tl0a(11:12) |
0075 | + tl0a1(12:15) |
0076 | + tl0a0(12:14) |
0077 | + tagl1c(11:16) |
0078 +----------------------+
0079
0080 --- phase 1 --- step 060
0081 --- phase 2 --- step 210
0082 SELECT i.name AS image, GROUP_CONCAT(t.name) AS tag
0083 FROM imagetags AS it
0084 JOIN tags AS t
0085 ON t.id = it.tagid
0086 JOIN images AS i
0087 ON it.imageid = i.id
0088 GROUP BY i.id
0089
0090 foto001.jpg tl0a1
0091 snap001.png tagl1a,tagl1b,tagl1c,tagl2c,tagl2d,tagl3b
0092 snap002.png tagl2a,tl0a,tl0a0
0093 Martian_face_viking.jpg LadyMars
0094
0095 LadyMars tag is a "face tag"
0096
0097 additional operations on big-image.png
0098 - rate 5 stars
0099 - color label blue
0100 - flag accepted (green flag)
0101
0102 --- phase 1 --- step 090
0103 echo ".dump" | sqlite3 digikam4.db > sqlite_digikam4.db.data.sql
0104
0105 cp digikam4.db t1.db
0106 for i in $(echo ".tables" | sqlite3 t1.db) ; do
0107 echo "DELETE FROM $i;" | sqlite3 t1.db
0108 done
0109 echo ".dump" | sqlite3 t1.db > sqlite_digikam4.db.sql
0110 rm t1.db
0111
0112 # echo ".dump" | sqlite3 thumbnails-digikam.db > sqlite_thumbnails-digikam.db.data.sql
0113
0114 cp thumbnails-digikam.db t1.db
0115 for i in $(echo ".tables" | sqlite3 t1.db) ; do
0116 echo "DELETE FROM $i;" | sqlite3 t1.db
0117 done
0118 echo ".dump" | sqlite3 t1.db > sqlite_thumbnails-digikam.db.sql
0119 rm t1.db
0120
0121 --- phase 1 --- step 110
0122 db=digikam
0123 mysqldump -u"digikam" -p"digikam" -h"localhost" --no-data --routines $db > mysql_${db}.sql
0124 mysqldump -u"digikam" -p"digikam" -h"localhost" --routines $db > mysql_${db}_data.sql
0125
0126 --- phase 2 --- step 210
0127 db=digikam
0128 # EQUAL! mysqldump -u"digikam" -p"digikam" -h"localhost" --no-data --routines $db > mysql0_${db}.sql
0129 mysqldump -u"digikam" -p"digikam" -h"localhost" --routines $db > mysql0_${db}_data.sql