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