var
strXslt =
"nl:dbdToOdt.xsl"
var
strTemplate = installDirectory(
"datakit/nl/dbd-template.odt"
)
var
strOutputFile =
"database-description.odt"
var
sql = xtk.sqlSchema.create()
sql.Generate() //-----------> tables from whole database is taken. Can it be customized to take only a few tables
var
strDbXml = db = sql.toXML().toXMLString()
var
strOdt = applyXsl(strXslt, strDbXml)
strOdt = strOdt.replace(/^<\?xml .*\?>\r?\n/,
'\r\n'
)
var
mbContent =
new
MemoryBuffer
mbContent.fromString(strOdt,
"utf-8"
)
var
zip =
new
ZipFile(strTemplate)
zip.open()
zip.setEntry(
"content.xml"
, mbContent)
zip.save(strOutputFile)