/// <summary>
/// Get first callee for id
/// </summary>
/// <param name="id"></param>
/// <param name="pos"></param>
/// <returns></returns>
public string GetFirstCalleeFromId(int id, out Position pos)
{
using (var db = new DataModels.Symbols.SYMBOLDB(_dbProvider, _connectionString))
{
try
{
var res = (from i in db.CodeItems
join u in db.CodeItemUsages on i.Id equals u.CodeItemId
join f1 in db.Files on u.FileId equals f1.Id
where i.Id == id
select new { FileName = f1.Name, Position = new Position(u.StartLine, u.StartColumn) }).FirstOrDefault();
//var res = (from u in db.CodeItemUsages
// where u.CodeItemId == id
// group u by u.CodeItemId into grp
// join u1 in db.CodeItemUsages on grp.Key equals u1.CodeItemId
// join i in db.CodeItems on u1.CodeItemId equals i.Id
// join f1 in db.Files on i.FileId equals f1.Id
// select new { FileName=f1.Name, Count = grp.Count(), u1.StartLine, u1.StartColumn}).FirstOrDefault();
pos = res.Position;
return(res.FileName);
}
catch (Exception e)
{
MessageBox.Show($"SQLite: '{_connectionString}'\r\n\r\n{e}", "SQL errors find.");
pos = new Position(0, 0);
return("");
}
}
}
/// <summary>
/// Load items from data table.
/// - Only for Header or C-File
/// </summary>
/// <param name="workspace"></param>
/// <param name="dt"></param>
public int LoadItems(string workspace, DataTable dt)
{
int count = 0;
// create all files
using (var db = new DataModels.Symbols.SYMBOLDB(_dbProvider, _connectionString))
{
// all symbols
// - kind = files
// - only for C/H files
var items = from DataRow i in dt.Rows
join f in db.Files on Path.Combine(workspace.ToLower().Replace(@"\", "/"), i.Field <string>("File"))
.ToLower().Replace(@"\", "/") equals f.Name
join k in db.CodeItemKinds on i.Field <string>("Kind") equals k.Name
where i.Field <string>("Kind") != "File"
where IsCFile(f.LeafName) || IsHFile(f.LeafName) // only header and C-Files
let position = LspAnalyzerHelper.GetSymbolStartPosition(
i.Field <string>("Intern"),
i.Field <string>("Name"),
new OmniSharpPosition(i.Field <long>("StartLine"), i.Field <long>("StartChar")
))
select new
{
Signature = i.Field <string>("Intern"),
Name = i.Field <string>("Name"),
Kind = k.Id,
StartLine = i.Field <long>("StartLine"),
EndLine = i.Field <long>("EndLine"),
StartChar = i.Field <long>("StartChar"),
EndChar = i.Field <long>("EndChar"),
NameStartLine = position.Line,
NameStartChar = position.Character,
FileId = f.Id
};
db.BeginTransaction();
foreach (var i in items)
{
db.Insert <CodeItems>(new CodeItems
{
Name = i.Name,
Signature = i.Signature,
Kind = i.Kind,
StartLine = (int)i.StartLine,
StartColumn = (int)i.StartChar,
EndLine = (int)i.EndLine,
EndColumn = (int)i.EndChar,
NameStartLine = (int)i.NameStartLine,
NameStartColumn = (int)i.NameStartChar,
FileId = i.FileId
});
count += 1;
}
db.CommitTransaction();
}
return(count);
}
/// <summary>
/// Load files of workspace
/// </summary>
/// <param name="workspace"></param>
public void LoadFiles(string workspace)
{
using (SYMBOLDB db = new DataModels.Symbols.SYMBOLDB(_dbProvider, _connectionString))
{
// delete all
db
.GetTable <File>()
.Delete();
var files = from f in Directory.GetFiles(workspace, "*.*", SearchOption.AllDirectories)
where Path.GetExtension(f).ToLower().StartsWith(".c") ||
Path.GetExtension(f).ToLower().StartsWith(".h")
select f.ToLower().Replace(@"\", "/");
db.BeginTransaction();
foreach (var file in files)
{
long fid = (long)db
.InsertWithIdentity(
new File
{
Name = file,
LeafName = Path.GetFileName(file)
});
_dictFile.Add(file, (int)fid);
}
db.CommitTransaction();
}
}
/// <summary>
/// Get file name for id
/// </summary>
/// <param name="id"></param>
/// <param name="pos"></param>
/// <returns></returns>
public string GetFileNameFromId(int id, out Position pos)
{
using (var db = new DataModels.Symbols.SYMBOLDB(_dbProvider, _connectionString))
{
try
{
var res = (from i in db.CodeItems
join f1 in db.Files on i.FileId equals f1.Id
where i.Id == id
select new { FileName = f1.Name, Position = new Position(i.NameStartLine, i.NameStartColumn) }).FirstOrDefault();
pos = res.Position;
return(res.FileName);
}
catch (Exception e)
{
MessageBox.Show($"SQLite: '{_connectionString}'\r\n\r\n{e}", "SQL errors find.");
pos = new Position(0, 0);
return("");
}
}
}
/// <summary>
/// Output metrics of Code from symbol database
/// </summary>
public void Metrics()
{
using (var db = new DataModels.Symbols.SYMBOLDB(_dbProvider, _connectionString))
{
var itemMetrics = from func in db.CodeItems
join kind in db.CodeItemKinds on func.Kind equals kind.Id
orderby func.Name
group kind by kind.Name
into grp
select
$"{grp.Count(),7:N0}\t{grp.Max(x => x.Id)}\t{grp.Key}";
//Kind = grp.Key,
//Id = grp.Max(x => x.Id),
//Count = grp.Count()
string metricSymbols = String.Join("\r\n", itemMetrics);
var itemUsageMetrics = from func in db.CodeItems
join k1 in db.CodeItemKinds on func.Kind equals k1.Id
join u in db.CodeItemUsages on func.Id equals u.CodeItemId
orderby func.Name
group k1 by k1.Name
into grp
select $"{grp.Count(),7:N0}\t{grp.Max(x => x.Id)}\t{grp.Key}";
//{
// Kind = grp.Key,
// Id = $"{grp.Max(x => x.Id)}",
// Count = $"{grp.Count(),1:N0}"
//};
string metricUsage = String.Join("\r\n", itemUsageMetrics);
string text = $" Count\tId\tKind\r\n{metricSymbols}\r\n\r\n\t\tUsage Count\r\n{metricUsage}";
MessageBox.Show(text, "Code Metrics, see also Clipboard");
Clipboard.SetText(text);
}
}
/// <summary>
/// Gen data table with required features from a file/directory
/// </summary>
public DataTable DataTableFromRequiredFeatures(string componentPath)
{
componentPath = NormalizePath(componentPath);
string[] lKind =
{
"Function", "Macro", "Field", "EnumMember", "Struct", "Method", "TypeAlias", "All"
}; // "All for all types
using (var db = new DataModels.Symbols.SYMBOLDB(_dbProvider, _connectionString))
{
try
{
var requiredItemsHelp = (
from x in
(from u in db.CodeItemUsages // u: usage of an item
join usageInFile in db.Files on u.FileId equals usageInFile.Id
join item in db.CodeItems on u.CodeItemId equals item.Id
join kind in db.CodeItemKinds on item.Kind equals kind.Id
join file in db.Files on item.FileId equals file.Id
where usageInFile.Name.StartsWith(componentPath)
where !file.Name.StartsWith(componentPath)
//where kind.name == "Function"
select new { ItemId = u.CodeItemId, UsageInFileName = usageInFile.Name, ItemName = item.Name, Kind = kind.Name, File = file.Name })
group x by new { UsageInFileName = x.UsageInFileName, ItemName = x.ItemName, Kind = x.Kind, File = x.File, ItemId = x.ItemId } into grp
orderby grp.Key.ItemName.ToLower() descending
select new {
RequiredItem = grp.Key.ItemName,
RequiredFile = grp.Key.UsageInFileName.Substring(_settings.SettingsItem.WorkspaceDirectory.Length),
Kind = grp.Key.Kind,
Count = grp.Count(),
File = grp.Key.File.Substring(_settings.SettingsItem.WorkspaceDirectory.Length),
Id = grp.Key.ItemId
}).ToArray();
//var requiredItemsHelp = (
// from reqItem in db.CodeItemUsages
// join reqFile in db.Files on reqItem.FileId equals reqFile.Id
// join item in db.CodeItems on reqItem.CodeItemId equals item.Id
// join kind in db.CodeItemKinds on item.Kind equals kind.Id
// join file in db.Files on item.FileId equals file.Id
// where ! file.Name.StartsWith(componentPath)
// where reqFile.Name.StartsWith(componentPath)
// where kind.Name != "Macro" || (kind.Name == "Macro" && ! (item.Name.EndsWith("_H") || item.Name.EndsWith("_C")))
// orderby item.Name.ToLower(), kind
// select new
// {
// RequiredItem = item.Name,
// RequiredFile = file.LeafName,
// Kind = kind.Name,
// CalleeFile = reqFile.LeafName,
// CalleePath = reqFile.Name,
// Id = item.Id
// }).Distinct().ToArray();
// Check for item kinds, it's possible to use "ALL"
var requiredItemsHelp2 = from item in requiredItemsHelp
join possibleKinds in lKind on item.Kind equals possibleKinds
select item;
if (lKind.Contains("All"))
{
requiredItemsHelp2 = from item in requiredItemsHelp
select item;
}
return(requiredItemsHelp2.ToDataTable());
}
catch (Exception e)
{
MessageBox.Show($"SQLite: '{_connectionString}'\r\nPath: '{componentPath}'\r\n\r\n{e}", "SQL errors find provided Features");
return(new DataTable());
}
}
return(new DataTable());
}
/// <summary>
/// Load usage for variables and functions in symbol database for workspace
/// </summary>
/// <param name="workspace"></param>
public async Task <int> LoadUsage(string workspace)
{
// create all usages
int countUsages = 0;
using (var db = new DataModels.Symbols.SYMBOLDB(_dbProvider, _connectionString))
{
// Get all items from symbol database
var items = (from item in db.CodeItems
join file in db.Files on item.FileId equals file.Id
join kind in db.CodeItemKinds on item.Kind equals kind.Id
select new
{
ItemId = item.Id,
ItemKind = kind.Name,
ItemName = item.Name,
FileName = file.Name,
NameStartLine = item.NameStartLine,
NameStartColumn = item.NameStartColumn
}).ToArray();
// write to Database
db.BeginTransaction();
foreach (var item in items)
{
// Item used as reference
if (IsCallable(item.ItemKind) ||
IsVars(item.ItemKind))
{
string method = IsCallable(item.ItemKind) ? @"$cquery/callers" : @"$cquery/vars";
var locations =
await _client.TextDocument.Cquery(method, item.FileName, item.NameStartLine, item.NameStartColumn);
foreach (var location in locations)
{
string path = location.Uri.LocalPath.Substring(1).ToLower();
// only consider files with path in workspace and which are C-Files
if (path.Contains(workspace.ToLower()) & IsCFile(path)) // || IsHFile(path)))
{
// ReSharper disable once UnusedVariable
// Check to use it in insert
if (_dictFile.TryGetValue(path, out int fileId) == false)
{
MessageBox.Show(
$"path='{path}'\r\n\r\nmethod='{method}'\r\nkind='{item.ItemKind}'\r\nitem='{item.ItemName}'",
"Cant find file id");
continue;
}
db.Insert <CodeItemUsages>(new CodeItemUsages
{
CodeItemId = item.ItemId,
FileId = _dictFile[path],
Signature = " ",
StartColumn = (int)location.Range.Start.Character,
StartLine = (int)location.Range.Start.Line,
EndColumn = (int)location.Range.End.Character,
EndLine = (int)location.Range.End.Line,
});
countUsages += 1;
}
else
{
}
}
}
}
db.CommitTransaction();
}
return(countUsages);
}
/// <summary>
/// Create Database
/// </summary>
/// <returns></returns>
public bool Create()
{
// Delete Symbol database
DeleteOldDatabase();
//// accessing with LINQ to SQL
using (var db = new DataModels.Symbols.SYMBOLDB(_dbProvider, _connectionString))
{
var sp = db.DataProvider.GetSchemaProvider();
var dbSchema = sp.GetSchema(db);
try
{
db.BeginTransaction();
}
catch (Exception e)
{
MessageBox.Show($"SQLite locked?\r\n\r\n{e}", "Can't begin transaction");
return(false);
}
if (dbSchema.Tables.All(t => t.TableName != "code_item_kinds"))
{
db.CreateTable <CodeItemKinds>();
}
if (dbSchema.Tables.All(t => t.TableName != "files"))
{
db.CreateTable <File>();
}
if (dbSchema.Tables.All(t => t.TableName != "code_items"))
{
db.CreateTable <CodeItems>();
}
if (dbSchema.Tables.All(t => t.TableName != "code_item_usages"))
{
db.CreateTable <CodeItemUsages>();
}
db.GetTable <CodeItemKinds>()
.Delete();
db.Insert(new CodeItemKinds {
Id = 1, Name = "File"
});
db.Insert(new CodeItemKinds {
Id = 2, Name = "Module"
});
db.Insert(new CodeItemKinds {
Id = 3, Name = "Namespace"
});
db.Insert(new CodeItemKinds {
Id = 4, Name = "Package"
});
db.Insert(new CodeItemKinds {
Id = 5, Name = "Class"
});
db.Insert(new CodeItemKinds {
Id = 6, Name = "Method"
});
db.Insert(new CodeItemKinds {
Id = 7, Name = "Property"
});
db.Insert(new CodeItemKinds {
Id = 8, Name = "Field"
});
db.Insert(new CodeItemKinds {
Id = 9, Name = "Constructor"
});
db.Insert(new CodeItemKinds {
Id = 10, Name = "Enum"
});
db.Insert(new CodeItemKinds {
Id = 11, Name = "Method"
});
db.Insert(new CodeItemKinds {
Id = 12, Name = "Function"
});
db.Insert(new CodeItemKinds {
Id = 13, Name = "Variable"
});
db.Insert(new CodeItemKinds {
Id = 14, Name = "Constant"
});
db.Insert(new CodeItemKinds {
Id = 15, Name = "String"
});
db.Insert(new CodeItemKinds {
Id = 16, Name = "Number"
});
db.Insert(new CodeItemKinds {
Id = 17, Name = "Boolean"
});
db.Insert(new CodeItemKinds {
Id = 18, Name = "Array"
});
db.Insert(new CodeItemKinds {
Id = 19, Name = "Object"
});
db.Insert(new CodeItemKinds {
Id = 20, Name = "Key"
});
db.Insert(new CodeItemKinds {
Id = 21, Name = "Null"
});
db.Insert(new CodeItemKinds {
Id = 22, Name = "EnumMember"
});
db.Insert(new CodeItemKinds {
Id = 23, Name = @"Struct"
});
db.Insert(new CodeItemKinds {
Id = 24, Name = "Event"
});
db.Insert(new CodeItemKinds {
Id = 25, Name = "Operator"
});
db.Insert(new CodeItemKinds {
Id = 26, Name = "TypeParameter"
});
db.Insert(new CodeItemKinds {
Id = 27, Name = "Type27"
});
db.Insert(new CodeItemKinds {
Id = 28, Name = "Type28"
});
db.Insert(new CodeItemKinds {
Id = 29, Name = "Type29"
});
db.Insert(new CodeItemKinds {
Id = 30, Name = "Type30"
});
db.Insert(new CodeItemKinds {
Id = 31, Name = "Type31"
});
db.Insert(new CodeItemKinds {
Id = 32, Name = "Type32"
});
db.Insert(new CodeItemKinds {
Id = 33, Name = "Type33"
});
db.Insert(new CodeItemKinds {
Id = 34, Name = "Type34"
});
db.Insert(new CodeItemKinds {
Id = 35, Name = "Type35"
});
db.Insert(new CodeItemKinds {
Id = 36, Name = "Type36"
});
db.Insert(new CodeItemKinds {
Id = 37, Name = "Type37"
});
db.Insert(new CodeItemKinds {
Id = 38, Name = "Type38"
});
db.Insert(new CodeItemKinds {
Id = 39, Name = "Type39"
});
db.Insert(new CodeItemKinds {
Id = 40, Name = "Type40"
});
db.Insert(new CodeItemKinds {
Id = 41, Name = "Type41"
});
db.Insert(new CodeItemKinds {
Id = 42, Name = "Type42"
});
db.Insert(new CodeItemKinds {
Id = 43, Name = "Type43"
});
db.Insert(new CodeItemKinds {
Id = 44, Name = "Type44"
});
db.Insert(new CodeItemKinds {
Id = 45, Name = "Type45"
});
db.Insert(new CodeItemKinds {
Id = 46, Name = "Type46"
});
db.Insert(new CodeItemKinds {
Id = 47, Name = "Type47"
});
db.Insert(new CodeItemKinds {
Id = 48, Name = "Type48"
});
db.Insert(new CodeItemKinds {
Id = 49, Name = "Type49"
});
db.Insert(new CodeItemKinds {
Id = 50, Name = "Type50"
});
db.Insert(new CodeItemKinds {
Id = 51, Name = "Type51"
});
db.Insert(new CodeItemKinds {
Id = 52, Name = "Type52"
});
db.Insert(new CodeItemKinds {
Id = 53, Name = "Type53"
});
db.Insert(new CodeItemKinds {
Id = 54, Name = "Type54"
});
db.Insert(new CodeItemKinds {
Id = 55, Name = "Type55"
});
db.Insert(new CodeItemKinds {
Id = 56, Name = "Type56"
});
db.Insert(new CodeItemKinds {
Id = 57, Name = "Type57"
});
db.Insert(new CodeItemKinds {
Id = 58, Name = "Type58"
});
db.Insert(new CodeItemKinds {
Id = 59, Name = "Type59"
});
db.Insert(new CodeItemKinds {
Id = 200, Name = "Type200"
});
db.Insert(new CodeItemKinds {
Id = 201, Name = "Type201"
});
db.Insert(new CodeItemKinds {
Id = 202, Name = "Type202"
});
db.Insert(new CodeItemKinds {
Id = 203, Name = "Type203"
});
db.Insert(new CodeItemKinds {
Id = 204, Name = "Type204"
});
db.Insert(new CodeItemKinds {
Id = 205, Name = "Type205"
});
db.Insert(new CodeItemKinds {
Id = 206, Name = "Type206"
});
db.Insert(new CodeItemKinds {
Id = 207, Name = "Type207"
});
db.Insert(new CodeItemKinds {
Id = 208, Name = "Type208"
});
db.Insert(new CodeItemKinds {
Id = 209, Name = "Type209"
});
db.Insert(new CodeItemKinds {
Id = 210, Name = "Type210"
});
db.Insert(new CodeItemKinds {
Id = 211, Name = "Type211"
});
db.Insert(new CodeItemKinds {
Id = 212, Name = "Type212"
});
db.Insert(new CodeItemKinds {
Id = 213, Name = "Type213"
});
db.Insert(new CodeItemKinds {
Id = 214, Name = "Type214"
});
db.Insert(new CodeItemKinds {
Id = 215, Name = "Type215"
});
db.Insert(new CodeItemKinds {
Id = 216, Name = "Type216"
});
db.Insert(new CodeItemKinds {
Id = 217, Name = "Type217"
});
db.Insert(new CodeItemKinds {
Id = 218, Name = "Type218"
});
db.Insert(new CodeItemKinds {
Id = 219, Name = "Type219"
});
db.Insert(new CodeItemKinds {
Id = 220, Name = "Type220"
});
db.Insert(new CodeItemKinds {
Id = 221, Name = "Type221"
});
db.Insert(new CodeItemKinds {
Id = 222, Name = "Type222"
});
db.Insert(new CodeItemKinds {
Id = 223, Name = "Type223"
});
db.Insert(new CodeItemKinds {
Id = 224, Name = "Type224"
});
db.Insert(new CodeItemKinds {
Id = 225, Name = "Type225"
});
db.Insert(new CodeItemKinds {
Id = 226, Name = "Type226"
});
db.Insert(new CodeItemKinds {
Id = 227, Name = "Type227"
});
db.Insert(new CodeItemKinds {
Id = 228, Name = "Type228"
});
db.Insert(new CodeItemKinds {
Id = 229, Name = "Type229"
});
db.Insert(new CodeItemKinds {
Id = 230, Name = "Type230"
});
db.Insert(new CodeItemKinds {
Id = 231, Name = "Type231"
});
db.Insert(new CodeItemKinds {
Id = 232, Name = "Type232"
});
db.Insert(new CodeItemKinds {
Id = 233, Name = "Type233"
});
db.Insert(new CodeItemKinds {
Id = 234, Name = "Type234"
});
db.Insert(new CodeItemKinds {
Id = 235, Name = "Type235"
});
db.Insert(new CodeItemKinds {
Id = 236, Name = "Type236"
});
db.Insert(new CodeItemKinds {
Id = 237, Name = "Type237"
});
db.Insert(new CodeItemKinds {
Id = 238, Name = "Type238"
});
db.Insert(new CodeItemKinds {
Id = 239, Name = "Type239"
});
db.Insert(new CodeItemKinds {
Id = 240, Name = "Type240"
});
db.Insert(new CodeItemKinds {
Id = 241, Name = "Type241"
});
db.Insert(new CodeItemKinds {
Id = 242, Name = "Type242"
});
db.Insert(new CodeItemKinds {
Id = 243, Name = "Type243"
});
db.Insert(new CodeItemKinds {
Id = 244, Name = "Type244"
});
db.Insert(new CodeItemKinds {
Id = 245, Name = "Type245"
});
db.Insert(new CodeItemKinds {
Id = 246, Name = "Type246"
});
db.Insert(new CodeItemKinds {
Id = 247, Name = "Type247"
});
db.Insert(new CodeItemKinds {
Id = 248, Name = "Type248"
});
db.Insert(new CodeItemKinds {
Id = 249, Name = "Type249"
});
db.Insert(new CodeItemKinds {
Id = 250, Name = "Type250"
});
db.Insert(new CodeItemKinds {
Id = 251, Name = "Type251"
});
db.Insert(new CodeItemKinds {
Id = 252, Name = "Type252"
});
db.Insert(new CodeItemKinds {
Id = 253, Name = "TypeAlias"
});
db.Insert(new CodeItemKinds {
Id = 254, Name = "StaticMethod"
});
db.Insert(new CodeItemKinds {
Id = 255, Name = "Macro"
});
MakeKindDictionary(db);
db.GetTable <CodeItems>()
.Delete();
db.GetTable <File>()
.Delete();
db.GetTable <CodeItemUsages>()
.Delete();
db.CommitTransaction();
}
return(true);
}
