/// <summary>
/// returns the list of databases
/// </summary>
public static List <CompletionItem> GetDbList()
{
if (_dataBases.Count <= 0)
{
return(new List <CompletionItem>());
}
return(_dataBases.Select(@base => new CompletionItem {
DisplayText = @base.LogicalName,
Type = CompletionType.Database,
FromParser = false,
Ranking = AutoComplete.FindRankingOfDatabaseItem(@base.LogicalName),
Flag = 0
}).ToList());
}
/// <summary>
/// Returns the list of tables for a given database
/// </summary>
/// <param name="dataBase"></param>
/// <returns></returns>
public static List <CompletionItem> GetTablesList(ParsedDataBase dataBase)
{
var output = new List <CompletionItem>();
if (dataBase == null || dataBase.Tables == null || dataBase.Tables.Count == 0)
{
return(output);
}
output.AddRange(dataBase.Tables.Select(table => new CompletionItem {
DisplayText = table.Name,
SubString = dataBase.LogicalName,
Type = CompletionType.Table,
FromParser = false,
Ranking = AutoComplete.FindRankingOfDatabaseItem(table.Name),
Flag = 0
}).ToList());
return(output);
}
/// <summary>
/// Returns the list of fields for a given table (it can also be a temp table!)
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public static List <CompletionItem> GetFieldsList(ParsedTable table)
{
var output = new List <CompletionItem>();
if (table == null)
{
return(output);
}
output.AddRange(table.Fields.Select(field => new CompletionItem {
DisplayText = field.Name,
Type = (field.Flag.HasFlag(ParsedFieldFlag.Primary)) ? CompletionType.FieldPk : CompletionType.Field,
FromParser = false,
SubString = field.Type.ToString(),
Ranking = AutoComplete.FindRankingOfDatabaseItem(field.Name),
Flag = (field.Flag.HasFlag(ParsedFieldFlag.Mandatory) ? ParseFlag.Mandatory : 0) |
(field.Flag.HasFlag(ParsedFieldFlag.Index) ? ParseFlag.Index : 0) |
(field.Flag.HasFlag(ParsedFieldFlag.Extent) ? ParseFlag.Extent : 0),
ParsedItem = table
}));
return(output);
}
