Actually I need to add some new data to all the databases and want to keep
the previous data inserted by the user. Now the problem is in the
onUpgrade() method i get only one db as a input parameter so how can i get
the previous data of user of other db.
On Sun, Jun 3, 2012 at 12:04 AM, lbendlin <l...@bendlin.us> wrote:
> what exactly do you need to upgrade? Can't you just run a few scripts in
> onUpgrade ?
>
>
> On Saturday, June 2, 2012 8:02:22 AM UTC-4, RawCoder wrote:
>>
>> Hi guys,
>>
>> I am working on an android application where i have to use multiple
>> databases. I have used previously created db file. Actually i am copying
>> the db file from asset folder.
>> Now there is option to add data for the user(add favorites). The user
>> data will be added in all three db.
>>
>> Now the problem is i need to upgrade all the db when there is a new
>> version of the app. I have to keep the user data inserted by the user and
>> add the changes of the new db.
>> I have done some googling and find solution to upgrade one db but i can
>> not find a solution to upgrade all the databases and keep the old versions
>> user data.
>>
>> Here is my dbhelper class:
>>
>> //////////////////////////////**//////////////////////////////**
>> //////////////////////////////**////////
>> package riskycoder.database.helper;
>>
>> import java.io.FileOutputStream;
>> import java.io.IOException;
>> import java.io.InputStream;
>> import java.io.OutputStream;
>> import java.util.Locale;
>>
>> import riskycoder.utils.**AppStaticValues;
>>
>> import android.content.Context;
>> import android.database.Cursor;
>> import android.database.SQLException;
>> import android.database.sqlite.**SQLiteDatabase;
>> import android.database.sqlite.**SQLiteException;
>> import android.database.sqlite.**SQLiteOpenHelper;
>> import android.util.Log;
>>
>> public class DataBaseHelper extends SQLiteOpenHelper {
>> private static String DB_PATH = "/data/data/riskycoder.login/**
>> databases/";
>> public static String DB_NAME = "datenbank_EN.sqlite";
>> private SQLiteDatabase myDataBase;
>> private final Context myContext;
>> private static final int DATABASE_VERSION = 1;
>> private static final String DB_NAME_ENG = "datenbank_EN.sqlite";
>> private static final String DB_NAME_GER = "datenbank_DE.sqlite";
>> private static final String DB_NAME_SPA = "datenbank_SP.sqlite";
>> private Cursor updateCursor;
>>
>> public static void setDataBaseName(String lan)
>> {
>> if(lan.equals("ENG"))
>> {
>> DB_NAME=DB_NAME_ENG;
>> }
>> else if(lan.equals("GER"))
>> {
>> DB_NAME=DB_NAME_GER;
>> }
>> else if(lan.equals("SPA"))
>> {
>> DB_NAME=DB_NAME_SPA;
>> }
>> }
>> public DataBaseHelper(Context context) {
>> super(context, DB_NAME, null, DATABASE_VERSION);
>> this.myContext = context;
>> updateCursor=null;
>> }
>>
>> public void createDataBase() throws IOException {
>> boolean dbExist = checkDataBase();
>> if (dbExist) {
>> this.getWritableDatabase();
>> } else {
>> this.getWritableDatabase();
>> try {
>> this.close();
>> copyDataBase();
>> } catch (IOException e) {
>> throw new Error("Error copying database");
>> }
>> }
>>
>> }
>>
>> private boolean checkDataBase() {
>> SQLiteDatabase checkDB = null;
>> try {
>> String myPath = DB_PATH + DB_NAME;
>> checkDB = SQLiteDatabase.openDatabase(**myPath, null,SQLiteDatabase.OPEN_
>> **READWRITE);
>> } catch (SQLiteException e) {
>> }
>> if (checkDB != null)
>> checkDB.close();
>> return checkDB != null ? true : false;
>> }
>>
>> private void copyDataBase() throws IOException {
>>
>> InputStream myInput = myContext.getAssets().open(DB_**NAME);
>> String outFileName = DB_PATH + DB_NAME;
>> OutputStream myOutput = new FileOutputStream(outFileName);
>> byte[] buffer = new byte[2048];
>> int length;
>> while ((length = myInput.read(buffer)) > 0) {
>> myOutput.write(buffer, 0, length);
>> }
>> myOutput.flush();
>> myOutput.close();
>> myInput.close();
>> //myDataBase.setVersion(**DATABASE_VERSION);
>> }
>>
>> public void openDataBase() throws SQLException {
>> String myPath = DB_PATH + DB_NAME;
>> myDataBase = SQLiteDatabase.openDatabase(**myPath,
>> null,SQLiteDatabase.OPEN_**READWRITE);
>> Log.d("Test", "Database version: " +myDataBase.getVersion());
>> if(updateCursor!=null && updateCursor.getCount()!=0)
>> {
>> updateCursor.moveToFirst();
>> do{
>> myDataBase.execSQL("UPDATE Content SET is_favourite='1' WHERE
>> content_id
>> ='"+updateCursor.getInt(**updateCursor.getColumnIndex("**content_id"))+"'
>> AND category_id = '"+updateCursor.getInt(**updateCursor.getColumnIndex("
>> **category_id"))+"'");
>> }while(updateCursor.**moveToNext());
>> updateCursor.close();
>> }
>> }
>>
>> @Override
>> public synchronized void close() {
>> if (myDataBase != null)
>> myDataBase.close();
>> super.close();
>> }
>> public Cursor Get_Header_Cursor(){
>> Cursor cursor;
>> cursor = myDataBase.rawQuery("select * from Headers ORDER BY
>> header_orderId",null);
>> return cursor;
>> }
>> public Cursor Get_Group_Cursor(int id){
>> Cursor cursor = myDataBase.rawQuery("select * from Categories where
>> header_id = "+id+" ORDER BY category_orderId",null);
>> return cursor;
>> }
>> public Cursor Get_Content_Cursor(int id){
>> Cursor cursor = myDataBase.rawQuery("select * from Content where
>> category_id = "+id,null);
>> return cursor;
>> }
>>
>> public Cursor Get_Favourite_Cursor(){
>> Cursor cursor = myDataBase.rawQuery("select * from Content where
>> is_favourite = 1",null);
>> return cursor;
>> }
>>
>> @Override
>> public void onCreate(SQLiteDatabase db) {
>> }
>>
>> @Override
>> public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
>> if(newVersion>oldVersion)
>> {
>> updateCursor = db.rawQuery("select * from Content where is_favourite =
>> 1",null);
>> Log.d("Test", "is fav"+updateCursor.getCount());
>> try {
>> copyDataBase();
>> } catch (IOException e) {
>> // TODO Auto-generated catch block
>> e.printStackTrace();
>> }
>> }
>>
>> }
>> }
>>
>> //////////////////////////////**//////////////////////////////**
>> //////////////////////////////**/////////////
>>
>> Please help how to upgrade all the databases.......
>>
> --
> You received this message because you are subscribed to the Google
> Groups "Android Developers" group.
> To post to this group, send email to android-developers@googlegroups.com
> To unsubscribe from this group, send email to
> android-developers+unsubscr...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/android-developers?hl=en
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
