sys.exit(1)
else:
filename = sys.argv[1]
ph = PDMHandler.parse(filename)
for pkg in PDMHandler.getPkgNodes(ph):
pkg_attrs = PDMHandler.getPkgAttrs(pkg)
for tbl in PDMHandler.getTblNodesInPkg(pkg):
tbl_attrs = PDMHandler.getTblAttrs(tbl)
print "CREATE TABLE", tbl_attrs["Code"], "\n("
cols = PDMHandler.getColNodesInTbl(tbl)
for col in cols:
col_attrs = PDMHandler.getColAttrs(col)
print " ", "%-16s " % col_attrs["Code"], "%-16s" % col_attrs[
"DataType"],
if col_attrs["Column.Mandatory"] == "1": print "NOT NULL",
else: print " ",
if cols.index(col) != len(cols) - 1: print ","
else: print "\n);"
for idx in PDMHandler.getIdxNodesInTbl(tbl):
idx_attrs = PDMHandler.getIdxAttrs(idx)
if idx_attrs["Unique"] == "1":
print "CREATE UNIQUE INDEX %s \n(" % idx_attrs["Code"]
else:
print "CREATE INDEX %s\n(" % idx_attrs["Code"]
idxcols = PDMHandler.getIdxColNodesInIdx(idx)
for idxcol in idxcols:
idxcol_attrs = PDMHandler.getIdxColAttrs(idxcol)
print " ", "%-16s " % idxcol_attrs["RefColCode"], "ASC",
if idxcols.index(idxcol) != len(idxcols) - 1: print ","
else: print "\n);"
import sys
reload(sys)
sys.setdefaultencoding("utf-8")
if len(sys.argv) <= 1:
print("USAGE: ", sys.argv[0], "<filename>")
print("EXAMPLE: ", sys.argv[0], "data/Consol.pdm")
sys.exit(1)
else:
filename = sys.argv[1]
ph = PDMHandler.parse(filename)
for pkg in PDMHandler.getPkgNodes(ph):
pkg_attrs = PDMHandler.getPkgAttrs(pkg)
print "P:", pkg_attrs["Name"], pkg_attrs["Code"], pkg_attrs["Creator"]
for tbl in PDMHandler.getTblNodesInPkg(pkg):
tbl_attrs = PDMHandler.getTblAttrs(tbl)
print " T:", tbl_attrs["Name"], tbl_attrs["Code"], tbl_attrs[
"Creator"]
print " T-PATH:", PDMHandler.getNodePath(tbl)
for col in PDMHandler.getColNodesInTbl(tbl):
col_attrs = PDMHandler.getColAttrs(col)
print " C:", col_attrs["Name"], col_attrs["Code"], col_attrs[
"DataType"], col_attrs["Length"], col_attrs[
"Column.Mandatory"]
for idx in PDMHandler.getIdxNodesInTbl(tbl):
idx_attrs = PDMHandler.getIdxAttrs(idx)
print " I:", idx_attrs["Name"], idx_attrs["Code"], idx_attrs[
"Unique"]
for idxcol in PDMHandler.getIdxColNodesInIdx(idx):
idxcol_attrs = PDMHandler.getIdxColAttrs(idxcol)
print " IC:", idxcol_attrs["RefColCode"]
if len(sys.argv) != 2:
print "USAGE: ",sys.argv[0],"<filename>"
print "EXAMPLE: ",sys.argv[0],"testpdm/Consol.pdm"
sys.exit(1)
else:
filename = sys.argv[1]
ph = PDMHandler.parse(filename)
for pkg in PDMHandler.getPkgNodes(ph):
pkg_attrs = PDMHandler.getPkgAttrs(pkg)
for tbl in PDMHandler.getTblNodesInPkg(pkg) :
tbl_attrs = PDMHandler.getTblAttrs(tbl)
print "CREATE TABLE",tbl_attrs["Code"],"\n("
cols = PDMHandler.getColNodesInTbl(tbl)
for col in cols :
col_attrs = PDMHandler.getColAttrs(col)
print " ", "%-16s "%col_attrs["Code"], "%-16s"%col_attrs["DataType"],
if col_attrs["Column.Mandatory"] == "1" : print "NOT NULL",
else: print " ",
if cols.index(col) != len(cols) - 1 : print ","
else : print "\n);"
for idx in PDMHandler.getIdxNodesInTbl(tbl) :
idx_attrs = PDMHandler.getIdxAttrs(idx)
if idx_attrs["Unique"] == "1" : print "CREATE UNIQUE INDEX %s \n("%idx_attrs["Code"]
else : print "CREATE INDEX %s\n("%idx_attrs["Code"]
idxcols = PDMHandler.getIdxColNodesInIdx(idx)
for idxcol in idxcols :
idxcol_attrs = PDMHandler.getIdxColAttrs(idxcol)
print " ", "%-16s "%idxcol_attrs["RefColCode"],"ASC",
if idxcols.index(idxcol) != len(idxcols) - 1 : print ","
else : print "\n);"
