예제 #1
0
		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;
				}
			}
		}
예제 #2
0
		void CopyDatabase (SqliteConnection src)
		{
			Console.WriteLine ("Migrating python 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 ("Python 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 ();
		}
예제 #3
0
		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;
				}
			}
		}