#!/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.

usage='mmssql [-c] [-r] sql
  -c display in columns with headers (default)
  -r display as records'

opts='-column -header'

while test $# -gt 0
do
    case $1 in
        -c)
            opts='-column -header'
            shift
            ;;
        -r)
            opts='-line'
            shift
            ;;
        *)
            break;
    esac
done

if [ $# -lt 1 ]; then
    echo "$usage"
    exit 1
fi

adb shell su -c sqlite3 $opts data/data/com.android.providers.telephony/databases/mmssms.db "$1"