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"]
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) if tablename == "" or tablename.lower() == tbl_attrs["Name"].lower(): genTableName = tbl_attrs["Name"] tmpObjTableName = genTableName.replace("cs_", "") #tmpRe = re.compile('^mcc_') #tmpObjTableName = tmpRe.sub('',genTableName) objTableName = Convert2ClassStyle(tmpObjTableName,'_') print "" print "entity",objTableName,"{" colList = PDMHandler.getColNodesInTbl(tbl) colLen = len(colList) index = 0 for col in colList : col_attrs = PDMHandler.getColAttrs(col) dbType = GetJavaType(col_attrs["DataType"]) objColName = Convert2FieldStyle(col_attrs["Name"],"_") objClassName = Convert2ClassStyle(col_attrs["Name"],"_") length = col_attrs["Length"] hasLen = "" if dbType == "String" : hasLen = "" if (length<=0 or length=="") else ("maxlength("+length+")") isNullable = ("required" if col_attrs["Column.Mandatory"] else "")
import sys reload(sys) sys.setdefaultencoding("utf-8") 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)
import sys reload(sys) sys.setdefaultencoding("utf-8") 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",