92 lines
4.5 KiB
Plaintext
92 lines
4.5 KiB
Plaintext
Option Explicit
|
|
Dim db, initResult, sheet, obj, cons, fso, output, total, seen, column, definition
|
|
Set fso = CreateObject("Scripting.FileSystemObject")
|
|
Set output = fso.CreateTextFile(WScript.Arguments(1), True, True)
|
|
Set db = CreateObject("CMS.CeObjectDefsICDB")
|
|
initResult = db.InitFromProjectFile(WScript.Arguments(2), "r", WScript.Arguments(0), WScript.Arguments(3), WScript.Arguments(4), "DxDesigner")
|
|
output.WriteLine "{""kind"":""initialization"",""result"":" & V(initResult) & ",""read_only"":" & V(db.ReadOnly) & ",""project"":" & Q(db.PrjFile) & "}"
|
|
If Not initResult Or LCase(db.PrjFile) <> LCase(WScript.Arguments(0)) Then
|
|
output.Close
|
|
WScript.Quit 3
|
|
End If
|
|
total = 0
|
|
Set seen = CreateObject("Scripting.Dictionary")
|
|
db.LoadAllDeferredPages
|
|
For Each sheet In db.Sheets
|
|
output.WriteLine "{""kind"":""sheet"",""name"":" & Q(sheet.Name) & "}"
|
|
For Each column In sheet.Columns
|
|
Set definition = column.ConstraintDef
|
|
output.WriteLine "{""kind"":""definition"",""sheet"":" & Q(sheet.Name) & ",""name"":" & Q(definition.Name) & ",""title"":" & Q(definition.Title) & ",""description"":" & Q(definition.Description) & ",""data_type"":" & V(definition.DataType) & ",""unit_type"":" & V(definition.UnitType) & ",""unit"":" & V(definition.Unit) & ",""display_unit"":" & V(definition.DisplayUnit) & ",""default"":" & V(definition.Default) & "}"
|
|
Next
|
|
For Each obj In sheet.Objects
|
|
DumpObject sheet.Name, obj
|
|
Next
|
|
Next
|
|
output.WriteLine "{""kind"":""complete"",""count"":" & CStr(total) & ",""objects"":" & CStr(seen.Count) & "}"
|
|
output.Close
|
|
Set db = Nothing
|
|
WScript.Echo "Constraints read: " & CStr(total)
|
|
|
|
Sub DumpObject(sheetName, current)
|
|
Dim key, constraint, child, children, actual, defaultValue, overridden, resolvedDefault, errorText, unitValue, def
|
|
key = sheetName & vbTab & current.Level & vbTab & CStr(current.AthenaId) & vbTab & current.Name
|
|
If seen.Exists(key) Then Exit Sub
|
|
seen.Add key, True
|
|
If seen.Count > 100000 Then WScript.Quit 4
|
|
For Each constraint In current.Constraints
|
|
actual = "" : defaultValue = "" : overridden = "" : resolvedDefault = "" : errorText = ""
|
|
unitValue = ""
|
|
On Error Resume Next
|
|
actual = constraint.Value
|
|
If Err.Number <> 0 Then errorText = errorText & "Value: " & Err.Description & "; " : Err.Clear
|
|
defaultValue = constraint.DefaultValue
|
|
If Err.Number <> 0 Then errorText = errorText & "DefaultValue: " & Err.Description & "; " : Err.Clear
|
|
overridden = constraint.IsOverridden
|
|
If Err.Number <> 0 Then errorText = errorText & "IsOverridden: " & Err.Description & "; " : Err.Clear
|
|
resolvedDefault = current.IsResolvedDefaultValue(constraint.Name, CStr(actual))
|
|
If Err.Number <> 0 Then errorText = errorText & "IsResolvedDefaultValue: " & Err.Description & "; " : Err.Clear
|
|
Set def = constraint.ConstraintDef
|
|
unitValue = constraint.GetStringValue(def.Unit)
|
|
If Err.Number <> 0 Then errorText = errorText & "GetStringValue: " & Err.Description & "; " : Err.Clear
|
|
On Error GoTo 0
|
|
output.WriteLine "{""kind"":""constraint"",""sheet"":" & Q(sheetName) & ",""object"":" & Q(current.Name) & ",""level"":" & Q(current.Level) & ",""athena_id"":" & Q(current.AthenaId) & ",""name"":" & Q(constraint.Name) & ",""value"":" & V(actual) & ",""default_value"":" & V(defaultValue) & ",""is_overridden"":" & V(overridden) & ",""equals_resolved_default"":" & V(resolvedDefault) & ",""value_in_definition_unit"":" & Q(unitValue) & ",""unit"":" & V(def.Unit) & ",""unit_type"":" & V(def.UnitType) & ",""error"":" & Q(errorText) & "}"
|
|
total = total + 1
|
|
Next
|
|
Set children = current.GetChildObjects
|
|
If Not children Is Nothing Then
|
|
For Each child In children
|
|
DumpObject sheetName, child
|
|
Next
|
|
End If
|
|
Set child = Nothing
|
|
Set children = Nothing
|
|
End Sub
|
|
|
|
Function Q(value)
|
|
Dim s
|
|
If IsNull(value) Or IsEmpty(value) Then
|
|
s = ""
|
|
Else
|
|
s = CStr(value)
|
|
End If
|
|
s = Replace(s, "\", "\\")
|
|
s = Replace(s, Chr(34), "\" & Chr(34))
|
|
s = Replace(s, vbCr, "\r")
|
|
s = Replace(s, vbLf, "\n")
|
|
s = Replace(s, vbTab, "\t")
|
|
Q = Chr(34) & s & Chr(34)
|
|
End Function
|
|
|
|
Function V(value)
|
|
Select Case VarType(value)
|
|
Case 0, 1
|
|
V = "null"
|
|
Case 11
|
|
V = LCase(CStr(value))
|
|
Case 2, 3, 4, 5, 6, 14, 17
|
|
V = Replace(CStr(value), ",", ".")
|
|
Case Else
|
|
V = Q(value)
|
|
End Select
|
|
End Function
|