diff options
author | Makoto Onuki <omakoto@google.com> | 2015-05-13 15:46:19 -0700 |
---|---|---|
committer | Makoto Onuki <omakoto@google.com> | 2015-05-20 15:53:00 -0700 |
commit | 3c06f53e3301c46fb4b30dda37e2f8d668e2631f (patch) | |
tree | 5dd03d42ae03da58350d91361f3495ca9e47dcc2 /tools | |
parent | ec42144de58d90361cdd92640c2ca52e22a5708f (diff) | |
download | ContactsProvider-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-x | tools/contacts-db-schema.sh | 31 |
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\"" + + |