Android Open Source - Tweety Database Open Helper

• Back to Twitter/application  ↑

From Project

Back to project page Tweety.

License

The source code is released under:

Apache License

Java Source Code

/* ========================================================================
 * Copyright 2010, Handy Codeworks LLC/*w w w  .j a  va 2  s  .  com*/
 *
 * 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.handycodeworks.tweety;

import winterwell.jtwitter.Twitter;
import winterwell.jtwitter.Twitter.Status;
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.provider.BaseColumns;
import android.util.Log;

public class DatabaseOpenHelper extends SQLiteOpenHelper{
    static final String TAG = "DatabaseOpenHelper";
    static final String DATABASE_NAME = "timeline.sqlite";
    static final int DATABASE_VERSION = 7;
    static final String TABLE = "timeline";
    static final String C_ID = BaseColumns._ID;
    static final String C_CREATED_AT ="created_at";
    static final String C_TEXT ="status";
    static final String C_USER ="user";
    

    public DatabaseOpenHelper(Context context) {
  super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
  Twitter.Status.class.getMethods();
  String sql = String.format(
    "CREATE table %s (" +
    "%s integer NOT NULL primary key," +
    "%s timestamp, %s TEXT, %s TEXT)", TABLE, C_ID, C_CREATED_AT, C_TEXT, C_USER);
  Log.d(TAG, "Created SQLite database: " + sql);
  db.execSQL(sql);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  db.execSQL("DROP TABLE IF EXISTS "+TABLE+";");
  this.onCreate(db);
    }
    
    public static ContentValues statusToContentValues(Status status){
  ContentValues cv = new ContentValues();
  cv.put(C_ID, status.id.intValue());
  cv.put(C_CREATED_AT, status.createdAt.getTime());
  cv.put(C_TEXT, status.text);
  cv.put(C_USER, status.user.screenName);
  return cv;
    }
}

Java Source Code List

• Back to Twitter/application  ↑