Exemple #1
0
  public Element generateXml() {
    Element element = null;
    if (this.portableType.equals(PortableType.IMPORTABLE)) {
      element = new Element(XMLElements.IMPORTABLE.toString());
      element.setAttribute(XMLElements.FILTERS.toString(), McUtils.listToStr(this.filterList, ","));
    } else {
      element = new Element(XMLElements.EXPORTABLE.toString());
      element.setAttribute(
          XMLElements.ATTRIBUTES.toString(), McUtils.listToStr(this.attributeList, ","));
      element.setAttribute(
          XMLElements.DEFAULT.toString(), this.getPropertyValue(XMLElements.DEFAULT));
    }
    element.setAttribute(XMLElements.NAME.toString(), this.getPropertyValue(XMLElements.NAME));
    element.setAttribute(XMLElements.INTERNALNAME.toString(), this.getInternalName());
    element.setAttribute(XMLElements.DISPLAYNAME.toString(), this.getDisplayName());
    element.setAttribute(XMLElements.DESCRIPTION.toString(), this.getDescription());

    element.setAttribute(
        XMLElements.VERSION.toString(), this.getPropertyValue(XMLElements.VERSION));
    element.setAttribute(
        XMLElements.ORDERBY.toString(), this.getPropertyValue(XMLElements.ORDERBY));
    element.setAttribute(
        XMLElements.LINKVERSION.toString(), this.getPropertyValue(XMLElements.LINKVERSION));
    element.setAttribute(XMLElements.TYPE.toString(), this.getPropertyValue(XMLElements.TYPE));
    element.setAttribute(XMLElements.LINKVERSIONS.toString(), this.MapToStr(this.linkVersionMap));
    return element;
  }
  public Map<String, List<String>> getMartTablesInfo(JdbcLinkObject conObj, String dsName)
      throws MartBuilderException {
    Map<String, List<String>> tblColMap =
        new TreeMap<String, List<String>>(McUtils.BETTER_STRING_COMPARATOR); // see DCCTEST-491
    List<String> colList = new ArrayList<String>();
    StringBuffer sb =
        new StringBuffer(
            "select table_name,column_name,column_key "
                + "from information_schema.columns where table_schema='"
                + conObj.getDatabaseName()
                + "' and "
                + "table_name like '"
                + dsName
                + "%' order by "
                + "table_name, ordinal_position");
    String lastTableName = "";
    List<Map<String, String>> resultSet = ConnectionPool.Instance.query(conObj, sb.toString());

    for (Map<String, String> mapItem : resultSet) {
      String tableName = (String) mapItem.get("table_name");
      if (!(tableName.endsWith("__main") || tableName.endsWith("__dm"))) {
        continue;
      }
      // finish all columns in one table and move to the next, if previous table doesn't have a PK,
      // create using keyguessing
      if (!lastTableName.equals(tableName)) {
        if (!lastTableName.equals("")) {
          tblColMap.put(lastTableName, colList);
          colList = new ArrayList<String>();
        }
        // move to next table
        // clean flags
        lastTableName = tableName;
      }
      colList.add((String) mapItem.get("column_name"));
    }

    // sort column list
    Collections.sort(colList, McUtils.BETTER_STRING_COMPARATOR); // see DCCTEST-491

    if (!McUtils.isStringEmpty(lastTableName)) tblColMap.put(lastTableName, colList);

    return tblColMap;
  }
 @Override
 public Object getTransferData(DataFlavor e) throws UnsupportedFlavorException, IOException {
   if (e == DataFlavor.stringFlavor) {
     Container container =
         SwingUtilities.getAncestorOfClass(
             org.biomart.configurator.view.idwViews.McViewSourceGroup.class, this);
     if (container != null) {
       McViewSourceGroup sgview = (McViewSourceGroup) container;
       List<Mart> martList = sgview.getSelectedMarts();
       List<String> marts = new ArrayList<String>();
       for (Mart mart : martList) {
         marts.add(mart.getName());
       }
       if (!marts.isEmpty()) {
         return McUtils.StrListToStr(marts, ",");
       }
     }
     return null;
   } else return null;
 }
 public void refreshIcon() {
   String iconPath = "images/source.gif";
   this.iconLabel.setIcon(McUtils.createImageIcon(iconPath));
   this.revalidate();
 }
Exemple #5
0
 public void initSourceSchema(List<SourceSchema> sourceSchemas) throws MartBuilderException {
   if (McUtils.isCollectionEmpty(sourceSchemas)) this.initSourceSchemaFromDB();
   else this.initSourceSchemaFromXML(sourceSchemas);
 }
Exemple #6
0
 public void addAttribute(Attribute attribute) {
   this.attributeList.add(attribute);
   this.setProperty(XMLElements.ATTRIBUTES, McUtils.listToStr(this.attributeList, ","));
 }
Exemple #7
0
 public void addFilter(Filter filter) {
   this.filterList.add(filter);
   this.setProperty(XMLElements.FILTERS, McUtils.listToStr(this.filterList, ","));
 }