aboutsummaryrefslogtreecommitdiff
path: root/tools
diff options
context:
space:
mode:
authorMakoto Onuki <omakoto@google.com>2015-05-13 15:46:19 -0700
committerMakoto Onuki <omakoto@google.com>2015-05-20 15:53:00 -0700
commit3c06f53e3301c46fb4b30dda37e2f8d668e2631f (patch)
tree5dd03d42ae03da58350d91361f3495ca9e47dcc2 /tools
parentec42144de58d90361cdd92640c2ca52e22a5708f (diff)
downloadContactsProvider-3c06f53e3301c46fb4b30dda37e2f8d668e2631f.tar.gz
Implement Data.CARRIER_PRESENCE (master cherry pick)
Also add a script to dump the DB schema. Bug 20257870 Change-Id: If336f7dfbab4aca9be8f168d1e8e5a555a9fe649
Diffstat (limited to 'tools')
-rwxr-xr-xtools/contacts-db-schema.sh31
1 files changed, 31 insertions, 0 deletions
diff --git a/tools/contacts-db-schema.sh b/tools/contacts-db-schema.sh
new file mode 100755
index 00000000..3aa164bc
--- /dev/null
+++ b/tools/contacts-db-schema.sh
@@ -0,0 +1,31 @@
+#!/bin/bash
+#
+# Copyright (C) 2015 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.
+#
+
+set -e
+
+db=/data/data/com.android.providers.contacts/databases/contacts2.db
+
+# Use ls to make sure the file already exists.
+# Otherwise sqlite3 would create an empty file owned by root.
+
+# Sed inserts a newline after each ( and ,
+adb shell "(ls $db >/dev/null)&& sqlite3 $db \"select name, sql from sqlite_master where type in('table','index') order by name\"" |
+ sed -e 's/\([(,]\)/\1\n /g'
+echo "> sqlite_stat1"
+adb shell "(ls $db >/dev/null)&& sqlite3 $db \"select * from sqlite_stat1 order by tbl, idx, stat\""
+
+