abstract class %SYS.PTools.FileCreation
This class is a place to create File Creation & Formatting methods used by
the PTools Application Package, which was designed to gather performance
statistics for any type of Routine, Code Block or SQL Statement.
The following methods are written to be used within Class Definitions, and the
equivalent methods within the %SYS.PTools.FileCreation.INC file are written to be
used within MAC Routines and are written as pure COS methods.
The file formatted that these methods support are driven by the 'format'
parameter and support the following formats:
format - The output format of the Export/Reporting file
This parameter has the following structure of constituent elements:
format=[:$LB(,,)]
Where the constituent elements have the following values:
- The format of the Export/Reporting file:
- P = Printable/Viewable report file (.txt file, no pagination)
- D = Comma-delimited data file (.csv file) which can be read into a spreadsheet
- X = Microsoft Excel XML markup file suitable for import into Excel (.xml file)
- H = HTML page file (.html file)
- Z = User-defined delimiter "P" formatted file (.dlm file)
NOTE: The element is required or defaulted to $C(9) (TAB)
Optional Elements:
- User-defined delimiter [DEFAULT: $C(9) (TAB)]
NOTE: This is generally used for ="Z"
- .csv file header for ="D":
- 0 = Don't add non-standard information header to file [DEFAULT]
- 1 = Add non-standard information header to file
- .csv file footer for ="D":
- 0 = Don't add non-standard information footer to file [DEFAULT]
- 1 = Add non-standard information footer to file
EXAMPLES:
Valid 'format' values:
- "H" // HTML file
- "D" // CSV file with No information header or footer
- "D:"_$LB(,1,1) // CSV file with information header & footer
- "Z:"_$LB("^") // User-defined delimiter file (delim="^")
This class is Super-Class, and is used as part of the EXTENDS directive for the
following classes:
- %SYS.PTools.SQLQuery
- %SYS.PTools.Stats
- %SYS.PTools.StatsSQL
- %SYS.PTools.SQLStats
|
Parameters
|
Properties
|
Methods
|
Queries
|
Indices
|
ForeignKeys
|
Triggers
|
|
|
|
23
|
|
|
|
|
• classmethod CSVtabHead(metadata, delim)
CSV Table Header
• classmethod CSVtabRow(metadata, delim)
CSV Table Data Row
• classmethod DLMtabHead(metadata, delim)
DLM Table Header
• classmethod DLMtabRow(metadata, delim)
DLM Table Data Row
• classmethod HTMLtabHead(aTag, title, metadata)
HTML Table Header
• classmethod HTMLtabRow(metadata)
HTML Table Row
• classmethod TXTtabHead(metadata, delim)
Text Table Header
• classmethod TXTtabRow(metadata, delim)
Text Table Data Row
• classmethod XMLcolAuto()
XML Column AutoFit Width Element
• classmethod XMLcolWidth(width)
XML Column Width Element
• classmethod XMLrowHeader(metadata)
XML Header Row Element
• classmethod XMLsheet(name)
XML Worksheet Element
• classmethod XMLsort(sortColList, sortOrderList)
XML Sorting Element
• classmethod XMLtabRow(metadata)
XML Table Data Row Element
• classmethod XMLtable(colCnt=0, rowCnt=0)
XML Table Element
• classmethod condsMatch(conds, d, condValExp="")
as %Status
Check Conditional Matches
• classmethod createAndOpenFile(file, timeout=$$$PTSOpenTimeout)
as %Status
Create & Open File
• classmethod createOrderByList(orderBy="", d)
as %String
Create a valid SQL
• classmethod fileBody(file, format, metadata)
File Body
• classmethod fileFooter(file, format, footerMsg, metadata, elapseTime, rowCnt)
as %Status
File Footer
• classmethod fileHeader(file, format, title="", class, method, version, metadata, bcFlag="")
as %Status
File Header
• classmethod getOutputFile(file="", className="", methodName="", format="", hDate="", tSC=$$$OK)
as %String
Get the 'outputFile'
• classmethod openFileForRead(file, timeout=$$$PTSOpenTimeout)
as %Status
Open File For Read
