public Deserialize ( |
||
reader | ||
Résultat | void |
public IEnumerable <ParserItem> Find(string prefix) { if (s_Find == null) { var command = new SqliteCommand(); command.CommandText = "SELECT " + s_ItemColumns + " FROM Items WHERE FullName LIKE @FullName;"; command.CommandType = CommandType.Text; command.Parameters.Add("FullName", DbType.String); s_Find = command; } var find = s_Find.Clone() as SqliteCommand; find.Connection = m_conn; find.Parameters ["FullName"].Value = prefix.Replace("%", "\\%") + "%"; using (var reader = find.ExecuteReader()) { while (reader.Read()) { ParserItem item = new ParserItem(); item.Deserialize(reader); yield return(item); } } }
public IEnumerable <ParserItem> Find(string prefix, ParserItemType itemType, int depth) { if (s_FindWithType == null) { var command = new SqliteCommand(); command.CommandText = "SELECT " + s_ItemColumns + " FROM Items WHERE FullName LIKE @FullName"; command.CommandType = CommandType.Text; command.Parameters.Add("FullName", DbType.String); command.Parameters.Add("ItemType", DbType.Int32); s_FindWithType = command; // Race condition shouldn't matter } var findWithType = s_FindWithType.Clone() as SqliteCommand; if (itemType != ParserItemType.Any) { findWithType.CommandText += " AND ItemType == @ItemType"; findWithType.Parameters.Add("ItemType", DbType.Int32); findWithType.Parameters ["ItemType"].Value = (int)itemType; } if (depth >= 0) { findWithType.CommandText += " AND Depth == @Depth"; findWithType.Parameters.Add("Depth", DbType.Int32); findWithType.Parameters ["Depth"].Value = depth; } findWithType.Connection = m_conn; findWithType.Parameters ["FullName"].Value = prefix.Replace("%", "\\%") + "%"; using (var reader = findWithType.ExecuteReader()) { while (reader.Read()) { ParserItem item = new ParserItem(); item.Deserialize(reader); yield return(item); } } }
void CopyDatabase(SqliteConnection src) { Console.WriteLine("Migrating ironpython completion database to version {0}", s_version); int batchSize = 100; var cmd = new SqliteCommand("SELECT " + s_ItemColumns + " FROM Items;", src); var reader = cmd.ExecuteReader(); int i = 0; var items = new List <ParserItem> (); var rowsCommand = new SqliteCommand("SELECT count(*) FROM Items;", src); var count = (long)rowsCommand.ExecuteScalar(); var progress = IdeApp.Workbench.ProgressMonitors.GetBackgroundProgressMonitor("IronPython Completion Database", Gtk.Stock.Execute); progress.BeginTask("Migrating completion database", (int)count); while (reader.Read()) { var item = new ParserItem(); item.Deserialize(reader); items.Add(item); i++; if (i % batchSize == 0) { AddRange(items); progress.Step(items.Count); items.Clear(); } } if (items.Count > 0) { AddRange(items); } progress.Step(items.Count); items.Clear(); progress.Dispose(); }
void CopyDatabase(SqliteConnection src) { Console.WriteLine ("Migrating ironpython completion database to version {0}", s_version); int batchSize = 100; var cmd = new SqliteCommand ("SELECT " + s_ItemColumns + " FROM Items;", src); var reader = cmd.ExecuteReader (); int i = 0; var items = new List<ParserItem> (); var rowsCommand = new SqliteCommand ("SELECT count(*) FROM Items;", src); var count = (long)rowsCommand.ExecuteScalar (); var progress = IdeApp.Workbench.ProgressMonitors.GetBackgroundProgressMonitor ("IronPython Completion Database", Gtk.Stock.Execute); progress.BeginTask ("Migrating completion database", (int)count); while (reader.Read ()) { var item = new ParserItem (); item.Deserialize (reader); items.Add (item); i++; if (i % batchSize == 0) { AddRange (items); progress.Step (items.Count); items.Clear (); } } if (items.Count > 0) AddRange (items); progress.Step (items.Count); items.Clear (); progress.Dispose (); }
public IEnumerable<ParserItem> Find(string prefix, ParserItemType itemType, int depth) { if (s_FindWithType == null) { var command = new SqliteCommand (); command.CommandText = "SELECT " + s_ItemColumns + " FROM Items WHERE FullName LIKE @FullName"; command.CommandType = CommandType.Text; command.Parameters.Add ("FullName", DbType.String); command.Parameters.Add ("ItemType", DbType.Int32); s_FindWithType = command; // Race condition shouldn't matter } var findWithType = s_FindWithType.Clone () as SqliteCommand; if (itemType != ParserItemType.Any) { findWithType.CommandText += " AND ItemType == @ItemType"; findWithType.Parameters.Add ("ItemType", DbType.Int32); findWithType.Parameters ["ItemType"].Value = (int)itemType; } if (depth >= 0) { findWithType.CommandText += " AND Depth == @Depth"; findWithType.Parameters.Add ("Depth", DbType.Int32); findWithType.Parameters ["Depth"].Value = depth; } findWithType.Connection = m_conn; findWithType.Parameters ["FullName"].Value = prefix.Replace ("%", "\\%") + "%"; using (var reader = findWithType.ExecuteReader ()) { while (reader.Read ()) { ParserItem item = new ParserItem (); item.Deserialize (reader); yield return item; } } }
public IEnumerable<ParserItem> Find(string prefix) { if (s_Find == null) { var command = new SqliteCommand (); command.CommandText = "SELECT " + s_ItemColumns + " FROM Items WHERE FullName LIKE @FullName;"; command.CommandType = CommandType.Text; command.Parameters.Add ("FullName", DbType.String); s_Find = command; } var find = s_Find.Clone () as SqliteCommand; find.Connection = m_conn; find.Parameters ["FullName"].Value = prefix.Replace ("%", "\\%") + "%"; using (var reader = find.ExecuteReader ()) { while (reader.Read ()) { ParserItem item = new ParserItem (); item.Deserialize (reader); yield return item; } } }