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                         if (helper.getConvFlag()){
  28                                 helper.convert(db, langId);
  29                                 Dao.getInstance().start(db);
  30
  31                                 helper.setLangId(DatabaseHelper.JAPANEASE_ID);
  32                                 p.update();
  33                         }
  34                         else {
  35                                 helper.setLangId(DatabaseHelper.JAPANEASE_ID);
  36                                 p.create(DatabaseHelper.JAPANEASE_ID);
  37                         }
  38
  39                         helper.setLangId(DatabaseHelper.ENGLISH_ID);
  40                         p.create(DatabaseHelper.ENGLISH_ID);
  41
  42                         helper.setLangId(DatabaseHelper.FRENCH_ID);
  43                         p.create(DatabaseHelper.FRENCH_ID);
  44
  45                         db.setTransactionSuccessful();
  46                 } catch (JmException e) {
  47                         // 失敗
  48                 } finally {
  49                         db.endTransaction();
  50                 }
  51                 helper.setLangId(DatabaseHelper.NONE_ID);
  52         }
  53
  54         @Override
  55         public void cancel() {
  56
  57         }
  58
  59         @Override
  60         public void done(boolean isCancel) {
  61
  62         }
  63
  64 }