// }\r
\r
\r
- // edit {\r
- public PatternList() throws JmException {\r
+ public PatternList() {\r
+ \r
+ }\r
+ \r
+ public void create() throws JmException {\r
//言語別設定追加\r
\r
DatabaseHelper helper = DatabaseHelper.getInstance();\r
setPackage03();\r
setPackage04();\r
setPackage05();\r
- setPackage06();\r
break;\r
default:\r
setPackage01En();\r
- setPackage06En();\r
break;\r
}\r
}\r
-\r
- // }\r
\r
+ public void update() throws JmException {\r
+ int type = 6;\r
+ int count = count(type);\r
+ \r
+ if (count <= 0){\r
+ DatabaseHelper helper = DatabaseHelper.getInstance();\r
+ switch (helper.getLangId()){\r
+ case DatabaseHelper.JAPANEASE_ID:\r
+ setPackage06();\r
+ break;\r
+ default:\r
+ setPackage06En();\r
+ break;\r
+ }\r
+ }\r
+ }\r
+\r
/*\r
public PatternList(Runnable parent, int index) throws JmException {\r
// edit\r
// }\r
}\r
\r
+ private int count(int type) throws JmException {\r
+ return Dao.getInstance().count(type); \r
+ }\r
+ \r
// edit {\r
// private boolean delete(int index) {\r
// if (patterns.isEmpty()) return false;\r
}\r
return count;\r
}\r
+\r
+ public int count(int type) throws JmException{\r
+ int count = -1;\r
+ try {\r
+ DatabaseHelper helper = DatabaseHelper.getInstance();\r
+ SQLiteDatabase db = helper.getReadableDatabase();\r
+ String sql = "select count(*) from pattern where type = " + type + " and lang = " + helper.getLangId() + ";";\r
+ Cursor c = db.rawQuery(sql, null);\r
+ c.moveToFirst();\r
+ count = c.getInt(0); // count;\r
+ c.close();\r
+ } catch (SQLException e){\r
+ throw new JmException(e);\r
+ }\r
+ return count;\r
+ }\r
}\r
int count;\r
count = Dao.getInstance().count();\r
Dao.getInstance().start(db);\r
+ PatternList p = new PatternList();\r
if (count <= 0) {\r
- new PatternList();\r
+ p.create();\r
}\r
+ p.update();\r
}\r
\r
public DatabaseHelper(Context context) {\r
try {\r
if (oldVersion == 1 && newVersion == 2) {\r
db.execSQL("ALTER TABLE pattern ADD COLUMN lang integer;");\r
- db.execSQL("UPDATE pattern set LANG = " + JAPANEASE_ID + ";");\r
+ // 既存のデータは、日本語のデータに変換\r
+ db.execSQL("UPDATE pattern set LANG = " + JAPANEASE_ID + " WHERE TYPE <> 6;");\r
+ // ただし、マイパターンは、システムの言語に\r
+ db.execSQL("UPDATE pattern set LANG = " + langId + " WHERE TYPE = 6;");\r
db.execSQL("create index langindex on pattern(lang);");\r
}\r
} catch (Exception e) {\r
- e.printStackTrace();\r
+ e.printStackTrace(); // TODO\r
}\r
} \r
\r