private static void LanguageInsert(string name, string iso) { int i = 0; SqlWrapper wrapper = new SqlWrapper(); FileInfo dictionary = new FileInfo(@"C:\Users\Bartosz\Documents\memoling-dictionaries\" + name + ".txt"); FileInfo db = new FileInfo(@"C:\Users\Bartosz\Documents\eclipse\Memoling\assets\TranslateMemo.sqlite"); wrapper.Connect(db.FullName); using (StreamReader sr = new StreamReader(dictionary.FullName)) { using (SQLiteTransaction trans = wrapper.connection.BeginTransaction()) { while (!sr.EndOfStream) { string line = sr.ReadLine(); string word = line.Split(';')[0]; if (word.Length < 3) { continue; } wrapper.ExecuteNonQuery( "INSERT INTO 'WordLists' VALUES (@Word, @Language)", trans, new Tuple <string, string>("@Word", word), new Tuple <string, string>("@Language", iso) ); i += line.Length; if (i % 1000 == 0) { Console.WriteLine((i * 100.0 / dictionary.Length).ToString("0.00")); } } trans.Commit(); } } wrapper.Close(); }
private static void LanguageInsert(string name, string iso) { int i = 0; SqlWrapper wrapper = new SqlWrapper(); FileInfo dictionary = new FileInfo(@"C:\Users\Bartosz\Documents\memoling-dictionaries\" + name + ".txt"); FileInfo db = new FileInfo(@"C:\Users\Bartosz\Documents\eclipse\Memoling\assets\TranslateMemo.sqlite"); wrapper.Connect(db.FullName); using (StreamReader sr = new StreamReader(dictionary.FullName)) { using (SQLiteTransaction trans = wrapper.connection.BeginTransaction()) { while (!sr.EndOfStream) { string line = sr.ReadLine(); string word = line.Split(';')[0]; if (word.Length < 3) continue; wrapper.ExecuteNonQuery( "INSERT INTO 'WordLists' VALUES (@Word, @Language)", trans, new Tuple<string, string>("@Word", word), new Tuple<string, string>("@Language", iso) ); i += line.Length; if (i % 1000 == 0) Console.WriteLine((i * 100.0 / dictionary.Length).ToString("0.00")); } trans.Commit(); } } wrapper.Close(); }