private void _SQLColumnSampleData(SqlInstances sqlInstances) { if (0 == databases.Count) { sD = new SQLDatabase(credentials); sD.SetInstance(sqlInstances.ServerInstance); if (nodefaults) { sD.EnableNoDefaultsFilter(); } if (hasAccess) { sD.EnableHasAccessFilter(); } if (sysadmin) { sD.EnableSysAdminFilter(); } sD.Query(); databases = sD.GetResults(); } SQLColumnSampleData sCSD = new SQLColumnSampleData(credentials); Console.WriteLine("====="); Console.WriteLine("Instance : {0}", sqlInstances.ServerInstance); Console.WriteLine("====="); Console.WriteLine("{0,-20}{1,-20}{2,-20}{3,-20}", "Database", "Table", "Column", "Data"); Console.WriteLine("{0,-20}{1,-20}{2,-20}{3,-20}", "========", "=====", "======", "===="); sCSD.SetComputerName(sqlInstances.Server); sCSD.SetInstance(sqlInstances.ServerInstance); var results = new List <SQLColumnSampleData.SampleData>(); foreach (var d in sD.GetResults()) { sCSD.SetDatabase(d.DatabaseName); foreach (var f in SearchKeywords.Split(',')) { sCSD.AddSearchKeywords(f); } if (ValidateCC) { sCSD.EnableValidateCC(); } if (!string.IsNullOrEmpty(SampleSize)) { int size = 5; if (int.TryParse(SampleSize, out size)) { sCSD.SetSampleSize(size); } } sCSD.Query(); var r = sCSD.GetResults(); results.AddRange(r); foreach (var s in r) { Console.WriteLine("{0,-20}{1,-20}{2,-20}{3,-20}", s.DatabaseName, s.TableName, s.ColumnName, s.ColumnData); } } _PrintOutput(results); }
/// <summary> /// Constructor. /// </summary> /// <param name="searchKeywords">SearchKeywords</param> public SetSearchKeywordsAction(SearchKeywords searchKeywords) { this.Action = "setSearchKeywords"; this.SearchKeywords = searchKeywords; }
public ZeroTouchSearchElement(FunctionDescriptor functionDescriptor) { this.functionDescriptor = functionDescriptor; Name = functionDescriptor.UserFriendlyName; if (functionDescriptor.IsOverloaded) { var parameters = new StringBuilder(); parameters.Append("("); parameters.Append(String.Join(", ", functionDescriptor.Parameters.Select(x => x.Name))); parameters.Append(")"); Parameters = parameters.ToString(); } FullCategoryName = functionDescriptor.Category; Description = functionDescriptor.Description; Assembly = functionDescriptor.Assembly; ElementType = ElementTypes.ZeroTouch; if (functionDescriptor.IsBuiltIn) { ElementType |= ElementTypes.BuiltIn; } if (functionDescriptor.IsPackageMember) { ElementType |= ElementTypes.Packaged; } inputParameters = new List <Tuple <string, string> >(functionDescriptor.InputParameters); outputParameters = new List <string>() { functionDescriptor.ReturnType.ToShortString() }; foreach (var tag in functionDescriptor.GetSearchTags()) { SearchKeywords.Add(tag); } var weights = functionDescriptor.GetSearchTagWeights(); foreach (var weight in weights) { // Search tag weight can't be more then 1. if (weight <= 1) { keywordWeights.Add(weight); } } int weightsCount = weights.Count(); // If there weren't added weights for search tags, then add default value - 0.5 if (weightsCount != SearchKeywords.Count) { int numberOfLackingWeights = SearchKeywords.Count - weightsCount; // Number of lacking weights should be more than 0. // It can be less then 0 only if there was some mistake in xml file. if (numberOfLackingWeights > 0) { for (int i = 0; i < numberOfLackingWeights; i++) { keywordWeights.Add(0.5); } } } iconName = GetIconName(); }
/// <summary> /// 將物件資料從檔案中讀取出來 /// </summary> public async Task ReadFromFileAsync() { Item = await IsolatedStorageJSON <SearchKeywords> .LoadFromFileAsync(this.DataFolderName, this.DataFileName); }