-
Notifications
You must be signed in to change notification settings - Fork 137
/
SwisMetaDataProvider.cs
132 lines (108 loc) · 4.9 KB
/
SwisMetaDataProvider.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
namespace SwqlStudio.Metadata
{
class SwisMetaDataProvider : IMetadataProvider
{
private readonly ConnectionInfo info;
private Dictionary<string, Entity> entities = new Dictionary<string, Entity>();
public SwisMetaDataProvider(ConnectionInfo info)
{
this.info = info;
Name = info.Title;
_capabilities = new Lazy<Capability>(GetCapabilities);
}
private readonly Lazy<Capability> _capabilities;
private Capability Capabilities => _capabilities.Value;
private readonly IEnumerable<string> _metadataDefaultAttributes = new[]
{
"Entity.FullName", "Entity.Namespace", "Entity.BaseType",
"(Entity.Type ISA 'System.Indication') AS IsIndication",
"Entity.Properties.Name", "Entity.Properties.Type", "Entity.Properties.IsNavigable",
"Entity.Properties.IsInherited", "Entity.Properties.IsKey", "Entity.Verbs.EntityName", "Entity.Verbs.Name",
"Entity.IsAbstract"
};
private IEnumerable<string> AccessControlMetadataAttributes => Capabilities.HasFlag(Capability.AccessControl)
? new[] {"Entity.CanCreate", "Entity.CanDelete", "Entity.CanInvoke", "Entity.CanRead", "Entity.CanUpdate"}
: new string[0];
private IEnumerable<string> DocumentationMetadataAttributes => Capabilities.HasFlag(Capability.Documentation)
? new[] { "Entity.Summary", "Entity.Properties.Summary", "Entity.Verbs.Summary" }
: new string[0];
private IEnumerable<string> ObsoleteMetadataAttributes => Capabilities.HasFlag(Capability.Obsolete)
? new[] { "Entity.IsObsolete", "Entity.ObsolescenceReason", "Entity.Properties.IsObsolete", "Entity.Properties.ObsolescenceReason",
"Entity.Verbs.IsObsolete", "Entity.Verbs.ObsolescenceReason" }
: new string[0];
private IEnumerable<string> MetadataAttributes => _metadataDefaultAttributes
.Concat(AccessControlMetadataAttributes).Concat(DocumentationMetadataAttributes).Concat(ObsoleteMetadataAttributes);
public void Refresh()
{
string query = $"SELECT {string.Join(",", MetadataAttributes)} FROM Metadata.Entity";
entities = info.Query<Entity>(query).ToDictionary(entity => entity.FullName);
foreach (var entity in entities.Values)
{
if (entity.BaseType != null && entities.TryGetValue(entity.BaseType, out var baseEntity))
entity.BaseEntity = baseEntity;
}
EntitiesRefreshed?.Invoke(this, new EventArgs());
}
[Flags]
public enum Capability
{
None = 0,
AccessControl = 1,
Documentation = 2,
Obsolete = 4,
}
public Capability GetCapabilities()
{
const string query = @"SELECT Name
FROM Metadata.Property
WHERE EntityName='Metadata.Entity' AND Name IN ('CanCreate', 'Summary', 'IsObsolete')";
Capability cap = Capability.None;
DataTable dt = info.Query(query);
foreach (DataRow row in dt.Rows)
{
if ((string) row["Name"] == "CanCreate")
cap |= Capability.AccessControl;
else if ((string) row["Name"] == "Summary")
cap |= Capability.Documentation;
else if ((string) row["Name"] == "IsObsolete")
cap |= Capability.Obsolete;
}
return cap;
}
public IEnumerable<VerbArgument> GetVerbArguments(Verb verb)
{
return info.Query<VerbArgument>(
string.Format(
"SELECT VerbArgument.Name, VerbArgument.Type, VerbArgument.Position " +
(XmlTemplateSupported ? ", VerbArgument.XmlTemplate " : "") +
(_capabilities.Value.HasFlag(Capability.Documentation) ? ", VerbArgument.Summary " : "") +
"FROM Metadata.VerbArgument WHERE VerbArgument.EntityName='{0}' AND VerbArgument.VerbName='{1}' " +
"ORDER BY VerbArgument.Position",
verb.EntityName, verb.Name));
}
protected bool XmlTemplateSupported
{
get { return entities["Metadata.VerbArgument"].Properties.Any(p => p.Name == "XmlTemplate"); }
}
public ConnectionInfo ConnectionInfo
{
get { return info; }
}
public string Name { get; private set; }
public IEnumerable<Entity> Tables
{
get
{
if (entities == null)
Refresh();
return entities.Values.OrderBy(t => t.FullName);
}
}
/// <inheritdoc />
public event EventHandler EntitiesRefreshed;
}
}