Please i need support to added splash screen code to my package
/*
* T24_Transformer_FormView.java
*/
package t24_transformer_form;
import org.jdesktop.application.Action;
import org.jdesktop.application.ResourceMap;
import org.jdesktop.application.SingleFrameApplication;
import org.jdesktop.application.FrameView;
import org.jdesktop.application.TaskMonitor;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.filechooser.FileNameExtensionFilter;
import javax.swing.filechooser.FileFilter;
// old T24 Transformer imports
import java.io.File;
import java.io.FileWriter;
import java.io.StringWriter;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
//import java.util.Properties;
import java.util.StringTokenizer;
import javax.swing.;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.transform.Result;
import javax.xml.transform.Source;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;
import org.apache.log4j.Logger;
import org.apache.log4j.PropertyConfigurator;
import org.w3c.dom.Document;
import org.w3c.dom.DocumentFragment;
import org.w3c.dom.Element;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;
import com.ejada.alinma.edh.xsdtransform.util.ConfigKeys;
import com.ejada.alinma.edh.xsdtransform.util.XSDElement;
import com.sun.org.apache.xml.internal.serialize.OutputFormat;
import com.sun.org.apache.xml.internal.serialize.XMLSerializer;
/*
* The application's main frame.
*/
public class T24_Transformer_FormView extends FrameView {
/**}
* static holders for application-level utilities
* { */
//private static Properties appProps;
private static Logger appLogger;
/**
*
*/
private StringBuffer columnsCSV = null;
private ArrayList<String> singleValueTableColumns = null;
private HashMap<String, String> multiValueTablesSQL = null;
private HashMap<Object, HashMap<String, Object>> groupAttrs = null;
private ArrayList<XSDElement> xsdElementsList = null;
/**
* initialization */
private void init() /*throws Exception*/ {
// init the properties object
//FileReader in = new FileReader(appConfigPropsPath);
//appProps.load(in);
// log4j.properties constant
String PROP_LOG4J_CONFIG_FILE = "log4j.properties";
// init the logger
if ((PROP_LOG4J_CONFIG_FILE != null)
&& (!PROP_LOG4J_CONFIG_FILE.equals(""))) {
PropertyConfigurator.configure(PROP_LOG4J_CONFIG_FILE);
if (appLogger == null) {
appLogger = Logger.getLogger(T24_Transformer_FormView.class.getName());
}
appLogger.info("Application initialization successful.");
}
columnsCSV = new StringBuffer(ConfigKeys.FIELD_TAG + "," + ConfigKeys.FIELD_NUMBER + ","
+ ConfigKeys.FIELD_DATA_TYPE + "," + ConfigKeys.FIELD_FMT + "," + ConfigKeys.FIELD_LEN + ","
+ ConfigKeys.FIELD_INPUT_LEN + "," + ConfigKeys.FIELD_GROUP_NUMBER + "," + ConfigKeys.FIELD_MV_GROUP_NUMBER
+ "," + ConfigKeys.FIELD_SHORT_NAME + "," + ConfigKeys.FIELD_NAME + "," + ConfigKeys.FIELD_COLUMN_NAME + ","
+ ConfigKeys.FIELD_GROUP_NAME + "," + ConfigKeys.FIELD_MV_GROUP_NAME + "," + ConfigKeys.FIELD_JUSTIFICATION
+ "," + ConfigKeys.FIELD_TYPE + "," + ConfigKeys.FIELD_SINGLE_OR_MULTI + System.getProperty("line.separator"));
singleValueTableColumns = new ArrayList<String>();
singleValueTableColumns.add(ConfigKeys.COLUMN_XPK_ROW + ConfigKeys.DELIMITER_COLUMN_TYPE
+ ConfigKeys.DATA_TYPE_XSD_NUMERIC);
multiValueTablesSQL = new HashMap<String, String>();
groupAttrs = new HashMap<Object, HashMap<String, Object>>();
xsdElementsList = new ArrayList<XSDElement>();
}
/**
* initialize the <code>DocumentBuilder</code> and read the XSD file
*
* @param docPath
* @return the <code>Document</code> object representing the read XSD file
*/
private Document retrieveDoc(String docPath) {
Document xsdDoc = null;
File file = new File(docPath);
try {
DocumentBuilder builder = DocumentBuilderFactory.newInstance().newDocumentBuilder();
xsdDoc = builder.parse(file);
} catch (Exception e) {
appLogger.error(e.getMessage());
}
return xsdDoc;
}
/**
* perform the iteration/modification on the document
* iterate to the level which contains all the elements (Single-Value, and Groups) and start processing each
*
* @param xsdDoc
* @return
*/
private Document processDoc(Document xsdDoc) {
ArrayList<Object> newElementsList = new ArrayList<Object>();
HashMap<String, Object> docAttrMap = new HashMap<String, Object>();
Element sequenceElement = null;
Element schemaElement = null;
// get document's root element
NodeList nodes = xsdDoc.getChildNodes();
for (int i = 0; i < nodes.getLength(); i++) {
if (ConfigKeys.TAG_SCHEMA.equals(nodes.item(i).getNodeName())) {
schemaElement = (Element) nodes.item(i);
break;
}
}
// process the document (change single-value elements, collect list of new elements to be added)
for (int i1 = 0; i1 < schemaElement.getChildNodes().getLength(); i1++) {
Node childLevel1 = (Node) schemaElement.getChildNodes().item(i1);
// <ComplexType> element
if (childLevel1.getNodeName().equals(ConfigKeys.TAG_COMPLEX_TYPE)) {
// first, get the main attributes and put it in the csv file
for (int i6 = 0; i6 < childLevel1.getChildNodes().getLength(); i6++) {
Node child6 = childLevel1.getChildNodes().item(i6);
if (ConfigKeys.TAG_ATTRIBUTE.equals(child6.getNodeName())) {
if (child6.getAttributes().getNamedItem(ConfigKeys.ATTR_NAME) != null) {
String attrName = child6.getAttributes().getNamedItem(ConfigKeys.ATTR_NAME).getNodeValue();
if (((Element) child6).getElementsByTagName(ConfigKeys.TAG_SIMPLE_TYPE).getLength() != 0) {
Node simpleTypeElement = ((Element) child6).getElementsByTagName(ConfigKeys.TAG_SIMPLE_TYPE)
.item(0);
if (((Element) simpleTypeElement).getElementsByTagName(ConfigKeys.TAG_RESTRICTION).getLength() != 0) {
Node restrictionElement = ((Element) simpleTypeElement).getElementsByTagName(
ConfigKeys.TAG_RESTRICTION).item(0);
if (((Element) restrictionElement).getElementsByTagName(ConfigKeys.TAG_MAX_LENGTH).getLength() != 0) {
Node maxLengthElement = ((Element) restrictionElement).getElementsByTagName(
ConfigKeys.TAG_MAX_LENGTH).item(0);
HashMap<String, String> elementProperties = new HashMap<String, String>();
elementProperties.put(ConfigKeys.FIELD_TAG, attrName);
elementProperties.put(ConfigKeys.FIELD_NUMBER, "0");
elementProperties.put(ConfigKeys.FIELD_DATA_TYPE, ConfigKeys.DATA_TYPE_XSD_STRING);
elementProperties.put(ConfigKeys.FIELD_FMT, "");
elementProperties.put(ConfigKeys.FIELD_NAME, attrName);
elementProperties.put(ConfigKeys.FIELD_SHORT_NAME, attrName);
elementProperties.put(ConfigKeys.FIELD_COLUMN_NAME, attrName);
elementProperties.put(ConfigKeys.FIELD_SINGLE_OR_MULTI, "S");
elementProperties.put(ConfigKeys.FIELD_LEN, maxLengthElement.getAttributes().getNamedItem(
ConfigKeys.ATTR_VALUE).getNodeValue());
elementProperties.put(ConfigKeys.FIELD_INPUT_LEN, maxLengthElement.getAttributes()
.getNamedItem(ConfigKeys.ATTR_VALUE).getNodeValue());
constructElementRow(elementProperties);
// add the attribute as a column in the single-value table
singleValueTableColumns.add(attrName + ConfigKeys.DELIMITER_COLUMN_TYPE
+ ConfigKeys.DATA_TYPE_XSD_STRING + ConfigKeys.DELIMITER_COLUMN_TYPE
+ maxLengthElement.getAttributes().getNamedItem(ConfigKeys.ATTR_VALUE).getNodeValue());
// add the attribute as an element in the elements list
addToElementsList(attrName, attrName);
appLogger.debug("added attribute: " + attrName);
}
}
}
}
}
}
// now, loop on the elements and process them
for (int i2 = 0; i2 < childLevel1.getChildNodes().getLength(); i2++) {
Node childLevel2 = (Node) childLevel1.getChildNodes().item(i2);
// <Sequence> element
if (childLevel2.getNodeName().equals(ConfigKeys.TAG_SEQUENCE)) {
sequenceElement = (Element) childLevel2;
for (int i3 = 0; i3 < childLevel2.getChildNodes().getLength(); i3++) {
Node childLevel3 = (Node) childLevel2.getChildNodes().item(i3);
// <Element> element
if (childLevel3.getNodeName().equals(ConfigKeys.TAG_ELEMENT)) {
// check if single element or group
if (isGroup(childLevel3)) {
processGroup(childLevel3, true, null, null, docAttrMap, xsdDoc, newElementsList);
// insert a new comment node with the contents of the group tag
sequenceElement.insertBefore(xsdDoc.createComment(serialize(childLevel3)), childLevel3);
// remove the group tag
sequenceElement.removeChild(childLevel3);
} else {
processElement(childLevel3);
}
}
}
}
}
}
}
// add new elements
// this step should be after finishing processing the whole document. when you add new elements to the document
// while you are working on it, those new elements will be included in the processing. We don't need that!
for (int i = 0; i < newElementsList.size(); i++) {
sequenceElement.appendChild((Element) newElementsList.get(i));
}
// write the new required attributes to the schema element
Iterator<String> attrIter = docAttrMap.keySet().iterator();
while(attrIter.hasNext()) {
Element attr = (Element) docAttrMap.get(attrIter.next());
Element newAttrElement = xsdDoc.createElement(ConfigKeys.TAG_ATTRIBUTE);
appLogger.debug("appending attr. [" + attr.getAttribute(ConfigKeys.ATTR_NAME) + "]...");
newAttrElement.setAttribute(ConfigKeys.ATTR_NAME, attr.getAttribute(ConfigKeys.ATTR_NAME));
newAttrElement.setAttribute(ConfigKeys.ATTR_TYPE, attr.getAttribute(ConfigKeys.ATTR_TYPE));
schemaElement.appendChild(newAttrElement);
}
return xsdDoc;
}
/**
* add a new <code>XSDElement</code> with the given <code>name</code> and <code>businessName</code> to
* the elements list
*
* @param name
* @param businessName
*/
private void addToElementsList(String name, String businessName) {
xsdElementsList.add(new XSDElement(name, businessName));
}
/**
* add the given <code>XSDElement</code> to the elements list
*
* @param element
*/
private void addToElementsList(XSDElement element) {
xsdElementsList.add(element);
}
/**
* check if the <code>element</code> sent is single-value element or group
* element. the comparison depends on the children of the element. if found one of type
* <code>ComplexType</code> then it's a group element, and if of type
* <code>SimpleType</code> then it's a single-value element
*
* @param element
* @return <code>true</code> if the element is a group element,
* <code>false</code> otherwise
*/
private boolean isGroup(Node element) {
for (int i = 0; i < element.getChildNodes().getLength(); i++) {
Node child = (Node) element.getChildNodes().item(i);
if (child.getNodeName().equals(ConfigKeys.TAG_COMPLEX_TYPE)) { // found a ComplexType child (Group element)
return true;
} else if (child.getNodeName().equals(ConfigKeys.TAG_SIMPLE_TYPE)) { // found a SimpleType child (Single-Value element)
return false;
}
}
return false;
/*
String attrName = null;
if (element.getAttributes() != null) {
Node attribute = element.getAttributes().getNamedItem(XSDTransformer.ATTR_NAME);
if (attribute != null) {
attrName = attribute.getNodeValue();
}
}
if (attrName.startsWith("g")) { // group element
return true;
} else { // single element
return false;
}
*/
}
/**
* process a group element. recursively, process groups till no more group elements are found
*
* @param element
* @param isFirstLevelGroup
* @param attrMap
* @param docAttrMap
* @param xsdDoc
* @param newElementsList
*/
private void processGroup(Node element, boolean isFirstLevelGroup, Node parentGroup, XSDElement parentGroupElement, HashMap<String, Object> docAttrMap,
Document xsdDoc, ArrayList<Object> newElementsList) {
String elementName = null;
HashMap<String, Object> groupAttrMap = new HashMap<String, Object>();
HashMap<String, Object> parentGroupAttrMap = new HashMap<String, Object>();
XSDElement groupElement = null;
if (element.getAttributes().getNamedItem(ConfigKeys.ATTR_NAME) != null) {
elementName = element.getAttributes().getNamedItem(ConfigKeys.ATTR_NAME).getNodeValue();
}
appLogger.debug("processing group [" + elementName + "]...");
groupElement = new XSDElement(elementName, elementName);
// get the attributes if a non-first-level-group
// attributes are: groups's own attributes + parent group's attributes
if (!isFirstLevelGroup) {
// get the current element (group) attributes
for (int i1 = 0; i1 < element.getChildNodes().getLength(); i1++) {
if (ConfigKeys.TAG_COMPLEX_TYPE.equals(element.getChildNodes().item(i1).getNodeName())) {
Node complexTypeNode = element.getChildNodes().item(i1);
for (int i2 = 0; i2 < complexTypeNode.getChildNodes().getLength(); i2++) {
if (ConfigKeys.TAG_ATTRIBUTE.equals(complexTypeNode.getChildNodes().item(i2).getNodeName())) {
appLogger.debug("add group attr: "
+ ((Element) complexTypeNode.getChildNodes().item(i2)).getAttribute(ConfigKeys.ATTR_NAME));
groupAttrMap.put(((Element) complexTypeNode.getChildNodes().item(i2)).getAttribute(ConfigKeys.ATTR_NAME),
complexTypeNode.getChildNodes().item(i2));
docAttrMap.put(((Element) complexTypeNode.getChildNodes().item(i2)).getAttribute(ConfigKeys.ATTR_NAME),
complexTypeNode.getChildNodes().item(i2));
}
}
}
}
// now, get the parent's attributes
parentGroupAttrMap = groupAttrs.get(parentGroup);
if (parentGroupAttrMap != null) {
Iterator<String> iter = parentGroupAttrMap.keySet().iterator();
while (iter.hasNext()) {
String attrName = iter.next();
groupAttrMap.put(attrName, parentGroupAttrMap.get(attrName));
}
}
// add the attributes to the group element that will be added to the elements list
Iterator<String> itr = groupAttrMap.keySet().iterator();
while(itr.hasNext()) {
groupElement.addAttribute(itr.next());
}
// put the attributes in the attributes map
groupAttrs.put(element, groupAttrMap);
}
for (int i = 0; i < element.getChildNodes().getLength(); i++) {
Node childLevel1 = (Node) element.getChildNodes().item(i);
if (childLevel1.getNodeName().equals(ConfigKeys.TAG_COMPLEX_TYPE)) {
for (int j = 0; j < childLevel1.getChildNodes().getLength(); j++) {
Node childLevel2 = (Node) childLevel1.getChildNodes().item(j);
if (childLevel2.getNodeName().equals(ConfigKeys.TAG_SEQUENCE)) {
for (int k = 0; k < childLevel2.getChildNodes().getLength(); k++) {
Node childLevel3 = (Node) childLevel2.getChildNodes().item(k);
if (childLevel3.getNodeName().equals(ConfigKeys.TAG_ELEMENT)) {
// check if single element or group
if (isGroup(childLevel3)) { // another group element..
// unfortunately, a recursion is
// needed here!!! :-(
processGroup(childLevel3, false, element, groupElement, docAttrMap, xsdDoc, newElementsList);
} else { // reached a single-value element.. copy it under the
// main sequence and apply the name<>shorname replacement
processGroupElement(childLevel3, element, groupElement, isFirstLevelGroup, xsdDoc, newElementsList);
}
}
}
}
}
}
}
if (isFirstLevelGroup) {
addToElementsList(groupElement);
} else {
parentGroupElement.addChild(groupElement);
}
appLogger.debug("finished processing group [" + elementName + "].");
}
/**
* process the sent <code>element</code> to extract/modify required
* information:
* 1. replace the <code>name</code> attribute with the <code>shortname</code>.
*
* @param element
*/
private void processElement(Node element) {
String fieldShortName = null;
String fieldColumnName = null;
String fieldDataType = null;
String fieldFormat = null;
String fieldInputLength = null;
String elementName = null;
HashMap<String, String> elementProperties = new HashMap<String, String>();
if (element.getAttributes().getNamedItem(ConfigKeys.ATTR_NAME) != null) {
elementName = element.getAttributes().getNamedItem(ConfigKeys.ATTR_NAME).getNodeValue();
}
appLogger.debug("processing element [" + elementName + "]...");
for (int i = 0; i < element.getChildNodes().getLength(); i++) {
Node childLevel1 = (Node) element.getChildNodes().item(i);
if (childLevel1.getNodeName().equals(ConfigKeys.TAG_ANNOTATION)) {
for (int j = 0; j < childLevel1.getChildNodes().getLength(); j++) {
Node childLevel2 = (Node) childLevel1.getChildNodes().item(j);
if (childLevel2.getNodeName().equals(ConfigKeys.TAG_APP_INFO)) {
for (int k = 0; k < childLevel2.getChildNodes().getLength(); k++) {
Node childLevel3 = (Node) childLevel2.getChildNodes().item(k);
if (childLevel3.getNodeName().equals(ConfigKeys.TAG_HAS_PROPERTY)) {
if (childLevel3.getAttributes() != null) {
String attrName = null;
Node attribute = childLevel3.getAttributes().getNamedItem(ConfigKeys.ATTR_NAME);
if (attribute != null) {
attrName = attribute.getNodeValue();
elementProperties.put(attrName, childLevel3.getAttributes().getNamedItem(ConfigKeys.ATTR_VALUE)
.getNodeValue());
if (attrName.equals(ConfigKeys.FIELD_SHORT_NAME)) {
fieldShortName = childLevel3.getAttributes().getNamedItem(ConfigKeys.ATTR_VALUE)
.getNodeValue();
} else if (attrName.equals(ConfigKeys.FIELD_COLUMN_NAME)) {
fieldColumnName = childLevel3.getAttributes().getNamedItem(ConfigKeys.ATTR_VALUE)
.getNodeValue();
} else if (attrName.equals(ConfigKeys.FIELD_DATA_TYPE)) {
fieldDataType = childLevel3.getAttributes().getNamedItem(ConfigKeys.ATTR_VALUE)
.getNodeValue();
} else if (attrName.equals(ConfigKeys.FIELD_FMT)) {
fieldFormat = childLevel3.getAttributes().getNamedItem(ConfigKeys.ATTR_VALUE)
.getNodeValue();
} else if (attrName.equals(ConfigKeys.FIELD_INPUT_LEN)) {
fieldInputLength = childLevel3.getAttributes().getNamedItem(ConfigKeys.ATTR_VALUE)
.getNodeValue();
}
}
}
}
}
}
}
}
}
// replace the name attribute with the shortname
if (element.getAttributes().getNamedItem(ConfigKeys.ATTR_NAME) != null) {
element.getAttributes().getNamedItem(ConfigKeys.ATTR_NAME).setNodeValue(fieldShortName);
}
elementProperties.put(ConfigKeys.FIELD_SINGLE_OR_MULTI, "S");
constructElementRow(elementProperties);
singleValueTableColumns.add(fieldShortName + ConfigKeys.DELIMITER_COLUMN_TYPE + fieldDataType + fieldFormat
+ ConfigKeys.DELIMITER_COLUMN_TYPE + fieldInputLength);
// add the element to elements list
addToElementsList(fieldShortName, fieldColumnName);
appLogger.debug("finished processing element [" + elementName + "].");
}
/**
* process the sent <code>element</code> to extract/modify required
* information:
* 1. copy the element under the main sequence
* 2. replace the <code>name</code> attribute with the <code>shortname</code>.
* 3. add the attributes of the parent groups (if non-first-level-group)
*
* @param element
*/
private void processGroupElement(Node element, Node parentGroup, XSDElement parentGroupElement, boolean isFirstLevelGroup, Document xsdDoc, ArrayList<Object> newElementsList) {
String fieldShortName = null;
String fieldColumnName = null;
String fieldDataType = null;
String fieldFormat = null;
String fieldInputLength = null;
String elementName = null;
Element newElement = null;
HashMap<String, String> elementProperties = new HashMap<String, String>();
ArrayList<String> tableColumns = new ArrayList<String>();
HashMap<String, Object> groupAttrMap = null;
if (element.getAttributes().getNamedItem(ConfigKeys.ATTR_NAME) != null) {
elementName = element.getAttributes().getNamedItem(ConfigKeys.ATTR_NAME).getNodeValue();
}
appLogger.debug("processing element [" + elementName + "]...");
// 1. copy the element
newElement = (Element) element.cloneNode(true);
newElement.setAttribute(ConfigKeys.ATTR_MAX_OCCURS, "unbounded");
// 2. if non-first-level-group, replace the element's SimpleType tag with a ComplexType tag
if (!isFirstLevelGroup) {
if (((Element) newElement).getElementsByTagName(ConfigKeys.TAG_SIMPLE_TYPE).getLength() != 0) {
// there should be only one tag of SimpleType
Node simpleTypeNode = ((Element) newElement).getElementsByTagName(ConfigKeys.TAG_SIMPLE_TYPE).item(0);
// create the new ComplexType element
Element complexTypeNode = xsdDoc.createElement(ConfigKeys.TAG_COMPLEX_TYPE);
complexTypeNode.setAttribute(ConfigKeys.ATTR_MIXED, "true");
// get the list of attributes for the parent group
groupAttrMap = groupAttrs.get(parentGroup);
Iterator<String> attrIter = groupAttrMap.keySet().iterator();
while(attrIter.hasNext()) {
Element attr = (Element) groupAttrMap.get(attrIter.next());
Element newAttrElement = xsdDoc.createElement(ConfigKeys.TAG_ATTRIBUTE);
appLogger.debug("adding attr. [" + attr.getAttribute(ConfigKeys.ATTR_NAME) + "]...");
newAttrElement.setAttribute(ConfigKeys.ATTR_REF, attr.getAttribute(ConfigKeys.ATTR_NAME));
newAttrElement.setAttribute(ConfigKeys.ATTR_USE, "optional");
complexTypeNode.appendChild(newAttrElement);
}
// replace the old SimpleType node with the new ComplexType node
newElement.replaceChild(complexTypeNode, simpleTypeNode);
}
}
// 3. replace the name with the shortname in the new element
for (int i = 0; i < newElement.getChildNodes().getLength(); i++) {
Node childLevel1 = (Node) newElement.getChildNodes().item(i);
if (childLevel1.getNodeName().equals(ConfigKeys.TAG_ANNOTATION)) {
for (int j = 0; j < childLevel1.getChildNodes().getLength(); j++) {
Node childLevel2 = (Node) childLevel1.getChildNodes().item(j);
if (childLevel2.getNodeName().equals(ConfigKeys.TAG_APP_INFO)) {
for (int k = 0; k < childLevel2.getChildNodes().getLength(); k++) {
Node childLevel3 = (Node) childLevel2.getChildNodes().item(k);
if (childLevel3.getNodeName().equals(ConfigKeys.TAG_HAS_PROPERTY)) {
if (childLevel3.getAttributes() != null) {
String attrName = null;
Node attribute = childLevel3.getAttributes().getNamedItem(ConfigKeys.ATTR_NAME);
if (attribute != null) {
attrName = attribute.getNodeValue();
elementProperties.put(attrName, childLevel3.getAttributes().getNamedItem(ConfigKeys.ATTR_VALUE)
.getNodeValue());
if (attrName.equals(ConfigKeys.FIELD_SHORT_NAME)) {
fieldShortName = childLevel3.getAttributes().getNamedItem(ConfigKeys.ATTR_VALUE)
.getNodeValue();
} else if (attrName.equals(ConfigKeys.FIELD_COLUMN_NAME)) {
fieldColumnName = childLevel3.getAttributes().getNamedItem(ConfigKeys.ATTR_VALUE)
.getNodeValue();
} else if (attrName.equals(ConfigKeys.FIELD_DATA_TYPE)) {
fieldDataType = childLevel3.getAttributes().getNamedItem(ConfigKeys.ATTR_VALUE)
.getNodeValue();
} else if (attrName.equals(ConfigKeys.FIELD_FMT)) {
fieldFormat = childLevel3.getAttributes().getNamedItem(ConfigKeys.ATTR_VALUE)
.getNodeValue();
} else if (attrName.equals(ConfigKeys.FIELD_INPUT_LEN)) {
fieldInputLength = childLevel3.getAttributes().getNamedItem(ConfigKeys.ATTR_VALUE)
.getNodeValue();
}
}
}
}
}
}
}
}
}
if (newElement.getAttributes().getNamedItem(ConfigKeys.ATTR_NAME) != null) {
newElement.getAttributes().getNamedItem(ConfigKeys.ATTR_NAME).setNodeValue(fieldShortName);
}
// 4. save the new element to be added to the sequence list
newElementsList.add(newElement);
elementProperties.put(ConfigKeys.FIELD_SINGLE_OR_MULTI, "M");
constructElementRow(elementProperties);
// create the MULTI-VALUE table
// 0. Primary Key
tableColumns.add(ConfigKeys.COLUMN_XPK_ROW + ConfigKeys.DELIMITER_COLUMN_TYPE + ConfigKeys.DATA_TYPE_XSD_STRING
+ ConfigKeys.DELIMITER_COLUMN_TYPE + ConfigKeys.COLUMN_XPK_ROW_LENGTH);
// 1. foreign key
tableColumns.add(ConfigKeys.COLUMN_FK_ROW + ConfigKeys.DELIMITER_COLUMN_TYPE + ConfigKeys.DATA_TYPE_XSD_NUMERIC);
// 2. field value
tableColumns.add(fieldShortName + ConfigKeys.DELIMITER_COLUMN_TYPE + fieldDataType + fieldFormat
+ ConfigKeys.DELIMITER_COLUMN_TYPE + fieldInputLength);
// 3. attributes
if (groupAttrMap != null) {
Iterator<String> attrIter = groupAttrMap.keySet().iterator();
while (attrIter.hasNext()) {
Element attr = (Element) groupAttrMap.get(attrIter.next());
tableColumns.add(attr.getAttribute(ConfigKeys.ATTR_NAME) + ConfigKeys.DELIMITER_COLUMN_TYPE
+ ConfigKeys.DATA_TYPE_XSD_NUMERIC);
}
}
multiValueTablesSQL.put(sub_table_prefix.getText() + fieldShortName, constructMultiValueTableSQL(
sub_table_prefix.getText() + fieldShortName, tableColumns));
// add the element to it's parent group children
parentGroupElement.addChild(new XSDElement(fieldShortName, fieldColumnName));
appLogger.debug("finished processing element [" + elementName + "].");
}
/**
* write resulted files
*
* @param xsdDoc
* @param docPath
*/
private void writeResults(Document xsdDoc, String resultsDir, String newXSDFileName, String csvFileName) {
String rsDir = resultsDir + File.separator + new SimpleDateFormat("yyyyMMdd-HHmm").format(new Date());
try {
File resultsDirFile = new File(rsDir);
if (!resultsDirFile.exists()) {
resultsDirFile.mkdirs();
}
// write the XSD doc
appLogger.info("writing the transformed XSD...");
Source source = new DOMSource(xsdDoc);
Result result = new StreamResult(rsDir + File.separator + newXSDFileName);
Transformer xformer = TransformerFactory.newInstance().newTransformer();
// xformer.setOutputProperty("indent", "yes");
xformer.transform(source, result);
appLogger.info("finished writing the transformed XSD.");
// write the CSV columns file
appLogger.info("writing the CSV file...");
FileWriter csvWriter = new FileWriter(rsDir + File.separator + csvFileName);
csvWriter.write(columnsCSV.toString());
csvWriter.close();
appLogger.info("finished writing the CSV file.");
// write the master single-value table
appLogger.info("writing the creation script for master table (single-values)...");
FileWriter masterTableWriter = new FileWriter(rsDir + File.separator
+ main_edh_table_name.getText() + ".sql");
masterTableWriter.write(constructSingleValueTableSQL(main_edh_table_name.getText(),
singleValueTableColumns));
masterTableWriter.close();
appLogger.info("finished writing the creation script for master table (single-values).");
// write the multi-value tables sql
appLogger.info("writing the creation script for slave tables (multi-values)...");
Iterator<String> iter = multiValueTablesSQL.keySet().iterator();
while (iter.hasNext()) {
String tableName = iter.next();
String sql = multiValueTablesSQL.get(tableName);
FileWriter tableSQLWriter = new FileWriter(rsDir + File.separator + tableName + ".sql");
tableSQLWriter.write(sql);
tableSQLWriter.close();
}
appLogger.info("finished writing the creation script for slave tables (multi-values).");
// write the single-value view
appLogger.info("writing the creation script for single-value selection view...");
FileWriter singleValueViewWriter = new FileWriter(rsDir + File.separator
+ view_name_single.getText() + ".sql");
singleValueViewWriter.write(constructViewSQL(ConfigKeys.SQL_VIEW_SINGLE));
singleValueViewWriter.close();
appLogger.info("finished writing the creation script for single-value selection view.");
// debug
for (int i = 0; i < xsdElementsList.size(); i++) {
getMultiView(xsdElementsList.get(i));
/*// if (xsdElementsList.get(i).getAllDescendants() != null) {
// for (int j = 0; j < xsdElementsList.get(i).getAllDescendants().size(); j++) {
// appLogger.debug(main_edh_table_name.getText() + "." + ConfigKeys.COLUMN_XPK_ROW
// + "=" + xsdElementsList.get(i).getAllDescendants().get(j).getName() + "." + ConfigKeys.COLUMN_FK_ROW);
// }
// }
*/ }
} catch (Exception e) {
appLogger.error(e.getMessage());
}
}
private String getMultiView(XSDElement element)
