public static void BuildItemsDataBase()
{
MySQLiteHelper sql = MySQLiteHelper.Instance;
sql.GetConnectionWith(CommonData.dataBaseName, "/Users/houlianghong/Desktop/Unityfolder/TestOnSkills/Assets/StreamingAssets/Data");
// sql.CreatTable (CommonData.itemsTable,
// new string[] {"itemId","itemName","itemGeneralDescription","spriteName","itemType","itemNameInEnglish",
// "attackGain","powerGain","magicGain","critGain","armorGain","manaResistGain",
// "dodgeGain","healthGain","strengthGain"},
// new string[] {"PRIMARY Key","UNIQUE NOT NULL","NOT NULL","NOT NULL","","UNIQUE","","","","","","","","",""},
// new string[] {"INTEGER","TEXT","TEXT","TEXT","INTEGER","TEXT","INTEGER","INTEGER","INTEGER",
// "INTEGER","INTEGER","INTEGER","INTEGER","INTEGER","INTEGER" });
//
// int[] stringTypeCols = new int[]{ 1, 2, 3, 5 };
//
// itemsProperties.Clear ();
//
// LoadItemsData ("itemsData.csv");
//
// sql.CheckFiledNames (CommonData.itemsTable,fieldNames);
//
// sql.DeleteAllDataFromTable (CommonData.itemsTable);
//
// for(int i = 0;i<itemsProperties.Count;i++){
// string[] values = itemsProperties [i];
//
// foreach (int j in stringTypeCols) {
// values [j] = "'" + values[j] + "'";
//
// }
//
// sql.InsertValues (CommonData.itemsTable, values);
// }
//
if (sql.CheckTableExist(CommonData.CET4Table))
{
sql.DeleteTable(CommonData.CET4Table);
}
sql.CreateTable(CommonData.CET4Table,
new string[] { "wordId", "spell", "phoneticSymbol", "explaination", "example", "learnedTimes", "ungraspTimes" },
new string[] { "PRIMARY KEY NOT NULL", "NOT NULL", "NOT NULL", "NOT NULL", "NOT NULL", "NOT NULL", "NOT NULL" },
new string[] { "INTEGER", "TEXT", "TEXT", "TEXT", "TEXT", "INTEGER DEFAULT 0", "INTEGER DEFAULT 0" });
// sql.CreateTable (CommonData.CET4Table,
// new string[]{ "wordId", "spell", "phoneticSymbol", "explaination", "example","learnedTimes","ungraspTimes" },
// new string[]{ "PRIMARY KEY NOT NULL", "UNIQUE NOT NULL", "", "NOT NULL", "","",""},
// new string[]{ "INTEGER", "TEXT", "TEXT", "TEXT", "TEXT","INTEGER DEFAULT 0","INTEGER DEFAULT 0" });
// 为单词表创建索引，以id为索引
sql.CreateIndex("wordId_index", CommonData.CET4Table, new string[] { "wordId" }, true);
// 为单词表创建索引，以学习次数为索引
sql.CreateIndex("learnedTimes_index", CommonData.CET4Table, new string[] { "learnedTimes" }, false);
// 为单词表创建索引，以点击 不熟悉&选错 的次数 为索引
sql.CreateIndex("ungraspTimes_index", CommonData.CET4Table, new string[] { "ungraspTimes" }, false);
int[] stringTypeCols = new int[] { 1, 2, 3, 4 };
itemsProperties.Clear();
LoadCET4WordsData();
// sql.CheckFiledNames (CommonData.CET4Table, fieldNames);
sql.BeginTransaction();
for (int i = 0; i < itemsProperties.Count; i++)
{
string[] values = itemsProperties [i];
foreach (int j in stringTypeCols)
{
// string sqliteStr = SqliteEscape (values [j]);
string sqliteStr = values [j];
values [j] = "'" + sqliteStr + "'";
}
sql.InsertValues(CommonData.CET4Table, values);
}
sql.EndTransaction();
sql.CloseConnection(CommonData.dataBaseName);
}
