Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Generate Customized a Data Model or Data Dictionary

bhaskarc1289447
Level 2
Level 2

I am using this code to Generate a data model. But here you get the data model for the whole database. Is there any way to get a data model out of a selective tables from DB

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)

1 Accepted Solution
DimaKudryavtsev
Correct answer by
Level 4
Level 4

HI

You can use

var schema = application.getSchema("cus:myTable")

To generate a single table schema. Is this is what you are looking for?

View solution in original post

5 Replies
Milan_Vucetic
Community Advisor
Community Advisor

Hi,

the Generate() method does not receive any parameter.

Please, find the other methods which may be helpful for you on: sqlSchema

Regards,

Milan

bhaskarc1289447
Level 2
Level 2

Sorry, I used the wrong line as reference. i should have used this line

var sql = xtk.sqlSchema.create()

Here as we can see the whole of xtk.sqlSchema is used. Is there anyway that i can use my custom schemas to create the the object sql. I only need my custom schemas in that variable.Is it possible?

Is there any way I can pass the namespace in xtk.sqlSchema.create()?

DimaKudryavtsev
Correct answer by
Level 4
Level 4

HI

You can use

var schema = application.getSchema("cus:myTable")

To generate a single table schema. Is this is what you are looking for?

View solution in original post

bhaskarc1289447
Level 2
Level 2

Thank you for your help.

i want to generate for 3-4 schemas in a single pdd. How to include those? Can the schemas be separated by comma? Also xtk.sqlSchema.create() generates WPPobject. Is it possible to generate WPPobject the for 3-4 schemas?

ChristopheProtat
Employee
Employee

Hello,

You can try this tool. It makes it possible to select the schemas/tables you want and print in PDF part of your Data Model. 

https://github.com/ChrisRedfield126/ac-campaign-analyzer

Hope it will help