AndTweetDatabase.java :  » Blog-Twitter » andtweet » com » xorcode » andtweet » data » Android Open Source

/* 
 * Copyright (C) 2008 Torgny Bjers
 *
 * 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.xorcode.andtweet.data;

import android.net.Uri;
import android.provider.BaseColumns;

/**
 * Convenience definitions for AndTweetProvider
 * 
 * @author torgny.bjers
 */
public final class AndTweetDatabase {

  public static final String AUTHORITY = "com.xorcode.andtweet";
  public static final String TWITTER_DATE_FORMAT = "EEE MMM dd HH:mm:ss Z yyyy";

  // This class cannot be instantiated
  private AndTweetDatabase() {
  }

  /**
   * Tweets table
   * 
   * @author torgny.bjers
   */
  public static final class Tweets implements BaseColumns {
    public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITY + "/tweets");
    public static final Uri SEARCH_URI = Uri.parse("content://" + AUTHORITY + "/tweets/search");
        public static final Uri CONTENT_COUNT_URI = Uri.parse("content://" + AUTHORITY + "/tweets/count");
    public static final String CONTENT_TYPE = "vnd.android.cursor.dir/vnd.xorcode.andtweet.tweet";
    public static final String CONTENT_ITEM_TYPE = "vnd.android.cursor.item/vnd.xorcode.andtweet.tweet";
    public static final String DEFAULT_SORT_ORDER = "sent DESC";

    // Table columns
    public static final String AUTHOR_ID = "author_id";
    public static final String MESSAGE = "message";
    public static final String SOURCE = "source";
    public static final String TWEET_TYPE = "tweet_type";
    public static final String IN_REPLY_TO_STATUS_ID = "in_reply_to_status_id";
    public static final String IN_REPLY_TO_AUTHOR_ID = "in_reply_to_author_id";
    public static final String FAVORITED = "favorited";
    public static final String CREATED_DATE = "created";
    public static final String SENT_DATE = "sent";

        public static final int TIMELINE_TYPE_NONE = 0;
    public static final int TIMELINE_TYPE_FRIENDS = 1;
    public static final int TIMELINE_TYPE_MENTIONS = 2;
    /**
     * Messages are stored in separate database table, but we see them through the same base activity class,
     * this is why the type is here...
     */
        public static final int TIMELINE_TYPE_MESSAGES = 3;
        public static final int TIMELINE_TYPE_FAVORITES = 4;
  }

  /**
   * Direct Messages table
   * 
   * @author torgny.bjers
   */
  public static final class DirectMessages implements BaseColumns {
    public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITY + "/directmessages");
    public static final Uri SEARCH_URI = Uri.parse("content://" + AUTHORITY + "/directmessages/search");
        public static final Uri CONTENT_COUNT_URI = Uri.parse("content://" + AUTHORITY + "/directmessages/count");
    public static final String CONTENT_TYPE = "vnd.android.cursor.dir/vnd.xorcode.andtweet.directmessage";
    public static final String CONTENT_ITEM_TYPE = "vnd.android.cursor.item/vnd.xorcode.andtweet.directmessage";
    public static final String DEFAULT_SORT_ORDER = "sent DESC";

    // Table columns
    public static final String AUTHOR_ID = "author_id";
    public static final String MESSAGE = "message";
    public static final String CREATED_DATE = "created";
    public static final String SENT_DATE = "sent";
  }

  /**
   * Authors table
   * 
   * @author torgny.bjers
   */
  public static final class Users implements BaseColumns {
    public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITY + "/users");
    public static final String CONTENT_TYPE = "vnd.android.cursor.dir/vnd.xorcode.andtweet.users";
    public static final String CONTENT_ITEM_TYPE = "vnd.android.cursor.item/vnd.xorcode.andtweet.users";
    public static final String DEFAULT_SORT_ORDER = "author_id ASC";

    // Table columns
    public static final String AUTHOR_ID = "author_id";
    public static final String FOLLOWING = "following";
    public static final String AVATAR_IMAGE = "avatar_blob";
    public static final String MODIFIED_DATE = "modified";
    public static final String CREATED_DATE = "created";
  }
}