--- /dev/null
+/*
+ * Copyright (C) 2007 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.
+ */
+
+package com.android.deskclock;
+
+import android.content.ContentProvider;
+import android.content.ContentUris;
+import android.content.ContentValues;
+import android.content.Context;
+import android.content.UriMatcher;
+import android.database.Cursor;
+import android.database.SQLException;
+import android.database.sqlite.SQLiteDatabase;
+import android.database.sqlite.SQLiteOpenHelper;
+import android.database.sqlite.SQLiteQueryBuilder;
+import android.net.Uri;
+import android.text.TextUtils;
+
+public class AlarmProvider extends ContentProvider {
+ private SQLiteOpenHelper mOpenHelper;
+
+ private static final int ALARMS = 1;
+ private static final int ALARMS_ID = 2;
+ private static final UriMatcher sURLMatcher = new UriMatcher(
+ UriMatcher.NO_MATCH);
+
+ static {
+ sURLMatcher.addURI("com.android.deskclock", "alarm", ALARMS);
+ sURLMatcher.addURI("com.android.deskclock", "alarm/#", ALARMS_ID);
+ }
+
+ private static class DatabaseHelper extends SQLiteOpenHelper {
+ private static final String DATABASE_NAME = "alarms.db";
+ private static final int DATABASE_VERSION = 5;
+
+ public DatabaseHelper(Context context) {
+ super(context, DATABASE_NAME, null, DATABASE_VERSION);
+ }
+
+ @Override
+ public void onCreate(SQLiteDatabase db) {
+ db.execSQL("CREATE TABLE alarms (" +
+ "_id INTEGER PRIMARY KEY," +
+ "hour INTEGER, " +
+ "minutes INTEGER, " +
+ "daysofweek INTEGER, " +
+ "alarmtime INTEGER, " +
+ "enabled INTEGER, " +
+ "vibrate INTEGER, " +
+ "message TEXT, " +
+ "alert TEXT);");
+
+ // insert default alarms
+ String insertMe = "INSERT INTO alarms " +
+ "(hour, minutes, daysofweek, alarmtime, enabled, vibrate, message, alert) " +
+ "VALUES ";
+ db.execSQL(insertMe + "(8, 30, 31, 0, 0, 1, '', '');");
+ db.execSQL(insertMe + "(9, 00, 96, 0, 0, 1, '', '');");
+ }
+
+ @Override
+ public void onUpgrade(SQLiteDatabase db, int oldVersion, int currentVersion) {
+ if (Log.LOGV) Log.v(
+ "Upgrading alarms database from version " +
+ oldVersion + " to " + currentVersion +
+ ", which will destroy all old data");
+ db.execSQL("DROP TABLE IF EXISTS alarms");
+ onCreate(db);
+ }
+ }
+
+ public AlarmProvider() {
+ }
+
+ @Override
+ public boolean onCreate() {
+ mOpenHelper = new DatabaseHelper(getContext());
+ return true;
+ }
+
+ @Override
+ public Cursor query(Uri url, String[] projectionIn, String selection,
+ String[] selectionArgs, String sort) {
+ SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
+
+ // Generate the body of the query
+ int match = sURLMatcher.match(url);
+ switch (match) {
+ case ALARMS:
+ qb.setTables("alarms");
+ break;
+ case ALARMS_ID:
+ qb.setTables("alarms");
+ qb.appendWhere("_id=");
+ qb.appendWhere(url.getPathSegments().get(1));
+ break;
+ default:
+ throw new IllegalArgumentException("Unknown URL " + url);
+ }
+
+ SQLiteDatabase db = mOpenHelper.getReadableDatabase();
+ Cursor ret = qb.query(db, projectionIn, selection, selectionArgs,
+ null, null, sort);
+
+ if (ret == null) {
+ if (Log.LOGV) Log.v("Alarms.query: failed");
+ } else {
+ ret.setNotificationUri(getContext().getContentResolver(), url);
+ }
+
+ return ret;
+ }
+
+ @Override
+ public String getType(Uri url) {
+ int match = sURLMatcher.match(url);
+ switch (match) {
+ case ALARMS:
+ return "vnd.android.cursor.dir/alarms";
+ case ALARMS_ID:
+ return "vnd.android.cursor.item/alarms";
+ default:
+ throw new IllegalArgumentException("Unknown URL");
+ }
+ }
+
+ @Override
+ public int update(Uri url, ContentValues values, String where, String[] whereArgs) {
+ int count;
+ long rowId = 0;
+ int match = sURLMatcher.match(url);
+ SQLiteDatabase db = mOpenHelper.getWritableDatabase();
+ switch (match) {
+ case ALARMS_ID: {
+ String segment = url.getPathSegments().get(1);
+ rowId = Long.parseLong(segment);
+ count = db.update("alarms", values, "_id=" + rowId, null);
+ break;
+ }
+ default: {
+ throw new UnsupportedOperationException(
+ "Cannot update URL: " + url);
+ }
+ }
+ if (Log.LOGV) Log.v("*** notifyChange() rowId: " + rowId + " url " + url);
+ getContext().getContentResolver().notifyChange(url, null);
+ return count;
+ }
+
+ @Override
+ public Uri insert(Uri url, ContentValues initialValues) {
+ if (sURLMatcher.match(url) != ALARMS) {
+ throw new IllegalArgumentException("Cannot insert into URL: " + url);
+ }
+
+ ContentValues values;
+ if (initialValues != null)
+ values = new ContentValues(initialValues);
+ else
+ values = new ContentValues();
+
+ if (!values.containsKey(Alarm.Columns.HOUR))
+ values.put(Alarm.Columns.HOUR, 0);
+
+ if (!values.containsKey(Alarm.Columns.MINUTES))
+ values.put(Alarm.Columns.MINUTES, 0);
+
+ if (!values.containsKey(Alarm.Columns.DAYS_OF_WEEK))
+ values.put(Alarm.Columns.DAYS_OF_WEEK, 0);
+
+ if (!values.containsKey(Alarm.Columns.ALARM_TIME))
+ values.put(Alarm.Columns.ALARM_TIME, 0);
+
+ if (!values.containsKey(Alarm.Columns.ENABLED))
+ values.put(Alarm.Columns.ENABLED, 0);
+
+ if (!values.containsKey(Alarm.Columns.VIBRATE))
+ values.put(Alarm.Columns.VIBRATE, 1);
+
+ if (!values.containsKey(Alarm.Columns.MESSAGE))
+ values.put(Alarm.Columns.MESSAGE, "");
+
+ if (!values.containsKey(Alarm.Columns.ALERT))
+ values.put(Alarm.Columns.ALERT, "");
+
+ SQLiteDatabase db = mOpenHelper.getWritableDatabase();
+ long rowId = db.insert("alarms", Alarm.Columns.MESSAGE, values);
+ if (rowId < 0) {
+ throw new SQLException("Failed to insert row into " + url);
+ }
+ if (Log.LOGV) Log.v("Added alarm rowId = " + rowId);
+
+ Uri newUrl = ContentUris.withAppendedId(Alarm.Columns.CONTENT_URI, rowId);
+ getContext().getContentResolver().notifyChange(newUrl, null);
+ return newUrl;
+ }
+
+ public int delete(Uri url, String where, String[] whereArgs) {
+ SQLiteDatabase db = mOpenHelper.getWritableDatabase();
+ int count;
+ long rowId = 0;
+ switch (sURLMatcher.match(url)) {
+ case ALARMS:
+ count = db.delete("alarms", where, whereArgs);
+ break;
+ case ALARMS_ID:
+ String segment = url.getPathSegments().get(1);
+ rowId = Long.parseLong(segment);
+ if (TextUtils.isEmpty(where)) {
+ where = "_id=" + segment;
+ } else {
+ where = "_id=" + segment + " AND (" + where + ")";
+ }
+ count = db.delete("alarms", where, whereArgs);
+ break;
+ default:
+ throw new IllegalArgumentException("Cannot delete from URL: " + url);
+ }
+
+ getContext().getContentResolver().notifyChange(url, null);
+ return count;
+ }
+}