1d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd#!/bin/bash
2d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd#  Copyright (C) 2015 The Android Open Source Project
3d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd#
4d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd#  Licensed under the Apache License, Version 2.0 (the "License");
5d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd#  you may not use this file except in compliance with the License.
6d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd#  You may obtain a copy of the License at
7d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd#
8d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd#       http://www.apache.org/licenses/LICENSE-2.0
9d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd#
10d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd#  Unless required by applicable law or agreed to in writing, software
11d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd#  distributed under the License is distributed on an "AS IS" BASIS,
12d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd#  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd#  See the License for the specific language governing permissions and
14d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd#  limitations under the License.
15d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd
16d3b009ae55651f1e60950342468e3c37fdeb0796Mike Doddusage='buglesql [-c] [-r] sql
17d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd  -c display in columns with headers (default)
18d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd  -r display as records'
19d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd
20d3b009ae55651f1e60950342468e3c37fdeb0796Mike Doddopts='-column -header'
21d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd
22d3b009ae55651f1e60950342468e3c37fdeb0796Mike Doddwhile test $# -gt 0
23d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodddo
24d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd    case $1 in
25d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd        -c)
26d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd            opts='-column -header'
27d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd            shift
28d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd            ;;
29d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd        -r)
30d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd            opts='-line'
31d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd            shift
32d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd            ;;
33d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd        *)
34d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd            break;
35d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd    esac
36d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodddone
37d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd
38d3b009ae55651f1e60950342468e3c37fdeb0796Mike Doddif [ $# -lt 1 ]; then
39d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd    echo "$usage"
40d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd    exit 1
41d3b009ae55651f1e60950342468e3c37fdeb0796Mike Doddfi
42d3b009ae55651f1e60950342468e3c37fdeb0796Mike Dodd
43d3b009ae55651f1e60950342468e3c37fdeb0796Mike Doddadb shell su -c sqlite3 $opts data/data/com.android.messaging/databases/bugle_db "$1"
44