Add MediaProvider/MediaScanner testing aid

Given a media provider database, this lets you recreate a file tree
that when scanned by the media scanner will give you largely the same
database again.

Change-Id: Ie675fa7bb565525e4907d542116cc4c6ffd55e45

13 files changed, 153 insertions, 0 deletions

diff --git a/tools/genfiles/genfiles.sh b/tools/genfiles/genfiles.sh
new file mode 100755
index 000000000..32d2352a8
--- /dev/null
+++ b/tools/genfiles/genfiles.sh
@@ -0,0 +1,145 @@
+#!/bin/bash
+
+#
+# Copyright (C) 2011 The Android Open Source Project
+#
+# Licensed under the Apache License, Version 2.0 (the "License");
+# you may not use this file except in compliance with the License.
+# You may obtain a copy of the License at
+#
+#      http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+
+
+
+
+# This script queries a media provider database, and generates a script to
+# approximately recreate the same file system structure on another device,
+# using dummy files.
+
+EXTERNAL=$2
+if [ "$EXTERNAL" == "" ]
+then
+    EXTERNAL="/storage"
+fi
+
+
+if [ "$ANDROID_HOST_OUT" == "" ]
+then
+    echo "Couldn't find sqlite3. Please run envsetup/lunch and build."
+    exit 1
+fi
+
+if [ "$1" == "" ]
+then
+    echo "Usage: $0 <file.db> [external storage root]"
+    exit 2
+fi
+
+if [ ! -f "$1" ]
+then
+    echo "Couldn't find file $1"
+    exit 3
+fi
+
+# generate script to generate directory structure and content
+$ANDROID_HOST_OUT/bin/sqlite3 $1 "select format, media_type, mime_type, _data from files where _data like '"$EXTERNAL"/%';" | {
+
+MKDIRS=/tmp/mkdirs$$
+CPFILES=/tmp/cpfiles$$
+
+IFS="|"
+while read format mediatype mimetype data;
+do
+    if [ "$format" == "14337" ]
+    then
+        # jpeg
+        echo "cat /storage/sdcard0/proto.jpg > \"$data\"" >> $CPFILES
+    elif [ "$format" == "14347" ]
+    then
+        # png
+        echo "cat /storage/sdcard0/proto.png > \"$data\"" >> $CPFILES
+    elif [ "$format" == "14343" -a "$mediatype" == "0" ]
+    then
+        # gif
+        echo "cat /storage/sdcard0/proto.gif > \"$data\"" >> $CPFILES
+    elif [ "$format" == "12292" -a "$mediatype" == "0" ]
+    then
+        # txt
+        echo "cat /storage/sdcard0/proto.txt > \"$data\"" >> $CPFILES
+    elif [ "$format" == "12293" -a "$mediatype" == "0" ]
+    then
+        # html
+        echo "cat /storage/sdcard0/proto.html > \"$data\"" >> $CPFILES
+    elif [ "$format" == "12297" ]
+    then
+        # mp3
+        echo "cat /storage/sdcard0/proto.mp3 > \"$data\"" >> $CPFILES
+    elif [ "$format" == "12296" ]
+    then
+        # wav
+        echo "cat /storage/sdcard0/proto.wav > \"$data\"" >> $CPFILES
+    elif [ "$format" == "12299" -a "$mediatype" == "0" ]
+    then
+        # m4v
+        echo "cat /storage/sdcard0/proto.m4v > \"$data\"" >> $CPFILES
+    elif [ "$format" == "12299" -a "$mediatype" == "3" ]
+    then
+        # mp4
+        echo "cat /storage/sdcard0/proto.m4v > \"$data\"" >> $CPFILES
+    elif [ "$format" == "12299" -a "$mediatype" == "2" ]
+    then
+        # m4a
+        echo "cat /storage/sdcard0/proto.m4a > \"$data\"" >> $CPFILES
+    elif [ "$format" == "47492" ]
+    then
+        # 3gp
+        echo "cat /storage/sdcard0/proto.3gp > \"$data\"" >> $CPFILES
+    elif [ "$format" == "47362" -a "$mediatype" == "2" ]
+    then
+        # ogg
+        echo "cat /storage/sdcard0/proto.ogg > \"$data\"" >> $CPFILES
+    elif [ "$format" == "12288" -a "$mediatype" == "0" ]
+    then
+        # unknown type
+        echo "cat /storage/sdcard0/proto.dat > \"$data\"" >> $CPFILES
+    elif [ "$format" == "12289" -a "$mediatype" == "0" ]
+    then
+        # directory, ignore
+        true
+    elif [ "$format" == "12288" -a "$mediatype" == "4" ]
+    then
+        # playlist, ignore
+        true
+    else
+        echo ignored: $format '|' $mediatype '|' $mimetype '|' $data
+    fi
+    echo mkdir -p \"$(dirname $data)\" >> $MKDIRS
+done
+
+sort -u $MKDIRS > mkfiles.sh
+cat $CPFILES >> mkfiles.sh
+rm -rf $MKDIRS $CPFILES
+
+}
+
+# generate playlist files
+$ANDROID_HOST_OUT/bin/sqlite3 $1 "select audio_playlists._data, audio._data from audio_playlists left outer join audio_playlists_map on audio_playlists._id=audio_playlists_map.playlist_id left outer join audio on audio_playlists_map.audio_id=audio._id order by audio_playlists_map.playlist_id,audio_playlists_map.play_order;" | {
+
+IFS="|"
+while read plist entry
+do
+    echo "echo \"$(basename $entry)\" >> \"$plist\"" >> mkfiles.sh
+done
+}
+
+echo mkfiles.sh generated. Now run:
+grep sdcard0\/proto mkfiles.sh |sed 's/cat \/storage\/sdcard0\//adb push /' | sed 's/ > .*/ \/storage\/sdcard0/'|sort -u
+echo adb push mkfiles.sh /storage/sdcard0
+echo adb shell sh /storage/sdcard0/mkfiles.sh
+
diff --git a/tools/genfiles/protos/proto.3gp b/tools/genfiles/protos/proto.3gp
new file mode 100644
index 000000000..4d97f4cfa
--- /dev/null
+++ b/tools/genfiles/protos/proto.3gp
diff --git a/tools/genfiles/protos/proto.dat b/tools/genfiles/protos/proto.dat
new file mode 100644
index 000000000..5c3118dc9
--- /dev/null
+++ b/tools/genfiles/protos/proto.dat
@@ -0,0 +1 @@
+dummy file
diff --git a/tools/genfiles/protos/proto.gif b/tools/genfiles/protos/proto.gif
new file mode 100644
index 000000000..86ead48c2
--- /dev/null
+++ b/tools/genfiles/protos/proto.gif
diff --git a/tools/genfiles/protos/proto.html b/tools/genfiles/protos/proto.html
new file mode 100644
index 000000000..eca61debc
--- /dev/null
+++ b/tools/genfiles/protos/proto.html
@@ -0,0 +1,6 @@
+<html>
+<head/>
+<body>
+hi!
+</body>
+</html>
diff --git a/tools/genfiles/protos/proto.jpg b/tools/genfiles/protos/proto.jpg
new file mode 100644
index 000000000..64f743911
--- /dev/null
+++ b/tools/genfiles/protos/proto.jpg
diff --git a/tools/genfiles/protos/proto.m4a b/tools/genfiles/protos/proto.m4a
new file mode 100644
index 000000000..a884dc2f9
--- /dev/null
+++ b/tools/genfiles/protos/proto.m4a
diff --git a/tools/genfiles/protos/proto.m4v b/tools/genfiles/protos/proto.m4v
new file mode 100644
index 000000000..c70c244f8
--- /dev/null
+++ b/tools/genfiles/protos/proto.m4v
diff --git a/tools/genfiles/protos/proto.mp3 b/tools/genfiles/protos/proto.mp3
new file mode 100644
index 000000000..647ad3442
--- /dev/null
+++ b/tools/genfiles/protos/proto.mp3
diff --git a/tools/genfiles/protos/proto.ogg b/tools/genfiles/protos/proto.ogg
new file mode 100644
index 000000000..30791a480
--- /dev/null
+++ b/tools/genfiles/protos/proto.ogg
diff --git a/tools/genfiles/protos/proto.png b/tools/genfiles/protos/proto.png
new file mode 100644
index 000000000..b0bfd4c58
--- /dev/null
+++ b/tools/genfiles/protos/proto.png
diff --git a/tools/genfiles/protos/proto.txt b/tools/genfiles/protos/proto.txt
new file mode 100644
index 000000000..5c3118dc9
--- /dev/null
+++ b/tools/genfiles/protos/proto.txt
@@ -0,0 +1 @@
+dummy file
diff --git a/tools/genfiles/protos/proto.wav b/tools/genfiles/protos/proto.wav
new file mode 100644
index 000000000..6f14469c8
--- /dev/null
+++ b/tools/genfiles/protos/proto.wav