workspace/JuggleMaster/src/com/jm/db/InitDB.java

   1 package com.jm.db;
   2
   3 import android.content.Context;
   4 import android.database.sqlite.SQLiteDatabase;
   5
   6 import com.jm.PatternList;
   7 import com.jm.utility.AsyncTaskIF;
   8 import com.jm.utility.JmException;
   9
  10 public class InitDB implements AsyncTaskIF {
  11         public InitDB(Context context) {
  12                 //this.context = context;
  13         }
  14
  15         @Override
  16         public void doExecute() {
  17                 DatabaseHelper helper = DatabaseHelper.getInstance();
  18                 PatternList p = new PatternList();
  19                 SQLiteDatabase db = helper.getWritableDatabase();
  20
  21                 try {
  22                         helper.setLangId(DatabaseHelper.NONE_ID);
  23                         int langId = helper.getLangId();
  24
  25                         db.beginTransaction();
  26
  27                         boolean convFlag1to2 = helper.getConvFlag1to2();
  28                         if (helper.getConvFlag()){
  29                                 helper.convert(db, langId);
  30                                 Dao.getInstance().start(db);
  31                         }
  32
  33                         if (convFlag1to2){
  34                                 if (helper.getConvFlag()){
  35                                         helper.setLangId(DatabaseHelper.JAPANEASE_ID);
  36                                         p.update();
  37                                 }
  38                                 else {
  39                                         helper.setLangId(DatabaseHelper.JAPANEASE_ID);
  40                                         p.create(DatabaseHelper.JAPANEASE_ID);
  41                                 }
  42
  43                                 helper.setLangId(DatabaseHelper.ENGLISH_ID);
  44                                 p.create(DatabaseHelper.ENGLISH_ID);
  45
  46                                 helper.setLangId(DatabaseHelper.FRENCH_ID);
  47                                 p.create(DatabaseHelper.FRENCH_ID);
  48                         }
  49
  50                         db.setTransactionSuccessful();
  51                 } catch (JmException e) {
  52                         // 失敗
  53                 } finally {
  54                         db.endTransaction();
  55                 }
  56                 helper.setLangId(DatabaseHelper.NONE_ID);
  57         }
  58
  59         @Override
  60         public void cancel() {
  61
  62         }
  63
  64         @Override
  65         public void done(boolean isCancel) {
  66
  67         }
  68
  69 }