Examples of Field


Examples of org.molgenis.model.elements.Field

  @Test
  public void export() throws IOException, TableException
  {
    TupleTable tupleTable = mock(TupleTable.class);
    Field field1 = when(mock(Field.class).getSqlName()).thenReturn("col1").getMock();
    Field field2 = when(mock(Field.class).getSqlName()).thenReturn("col2").getMock();
    when(tupleTable.getColumns()).thenReturn(Arrays.asList(field1, field2));
    Tuple row1 = mock(Tuple.class);
    when(row1.getNrCols()).thenReturn(2);
    when(row1.get("col1")).thenReturn("val1");
    when(row1.get("col2")).thenReturn("val2");
View Full Code Here

Examples of org.molgenis.model.jaxb.Field

        ResultSet fieldInfo = md.getColumns(SCHEMA_NAME, null, tableInfo.getString("TABLE_NAME"), null);
        while (fieldInfo.next())
        {
          logger.debug("COLUMN: " + fieldInfo);

          Field f = new Field();
          f.setName(fieldInfo.getString("COLUMN_NAME"));
          f.setType(Field.Type.getType(fieldInfo.getInt("DATA_TYPE")));
          f.setDefaultValue(fieldInfo.getString("COLUMN_DEF"));

          if (md.getDatabaseProductName().toLowerCase().contains("mysql"))
          {
            // accomodate mysql CURRENT_TIMESTAMP
            if ("CURRENT_TIMESTAMP".equals(f.getDefaultValue())
                && (f.getType().equals(Field.Type.DATETIME) || f.getType().equals(Field.Type.DATE)))
            {
              f.setDefaultValue(null);
              f.setAuto(true);
            }

            // accomodate mysql text/string fields +
            // nillable="false" -> mysql ignore not null and so
            // should we!
          }

          if (fieldInfo.getString("REMARKS") != null && !"".equals(fieldInfo.getString("REMARKS").trim())) f
              .setDescription(fieldInfo.getString("REMARKS"));
          if (fieldInfo.getBoolean("NULLABLE")) f.setNillable(true);

          // auto increment?
          if (f.getType().equals(Field.Type.INT))
          {
            if (fieldInfo.getObject("IS_AUTOINCREMENT") != null) f.setAuto(fieldInfo
                .getBoolean("IS_AUTOINCREMENT"));
          }

          if (f.getType().equals(Field.Type.STRING) || f.getType().equals(Field.Type.CHAR))
          {
            if (fieldInfo.getInt("COLUMN_SIZE") > 255)
            {
              f.setType(Field.Type.TEXT);
              f.setLength(fieldInfo.getInt("COLUMN_SIZE"));
            }
            else
            {
              if (fieldInfo.getInt("COLUMN_SIZE") != 255) f.setLength(fieldInfo.getInt("COLUMN_SIZE"));
              f.setType(null); // defaults to string
            }
          }

          ResultSet xrefInfo = md.getImportedKeys(SCHEMA_NAME, null, tableInfo.getString("TABLE_NAME"));
          while (xrefInfo.next())
          {
            if (xrefInfo.getString("FKCOLUMN_NAME").equals(fieldInfo.getString("COLUMN_NAME")))
            {
              f.setType(Field.Type.XREF_SINGLE);
              // problem: PKTABLE_NAME is lowercase, need to be
              // corrected later?
              f.setXrefField(xrefInfo.getString("PKTABLE_NAME") + "."
                  + xrefInfo.getString("PKCOLUMN_NAME"));
            }
          }

          e.getFields().add(f);
        }

        // GET AUTO INCREMENT

        // mysql workaround
        Statement stmt = null;
        try
        {
          String sql = "select * from " + e.getName() + " where 1=0";
          stmt = conn.createStatement();

          ResultSet autoincRs = stmt.executeQuery(sql);
          ResultSetMetaData rowMeta = autoincRs.getMetaData();
          for (int i = 1; i <= rowMeta.getColumnCount(); i++)
          {
            if (rowMeta.isAutoIncrement(i))
            {
              e.getFields().get(i - 1).setAuto(true);
            }
          }
        }
        catch (Exception exc)
        {
          logger.error("didn't retrieve autoinc/sequence: " + exc.getMessage());
          // e.printStackTrace();
        }
        finally
        {
          stmt.close();
        }

        // ADD UNIQUE CONTRAINTS
        ResultSet rsIndex = md.getIndexInfo(SCHEMA_NAME, null, tableInfo.getString("TABLE_NAME"), true, false);
        // indexed list of uniques
        Map<String, List<String>> uniques = new LinkedHashMap<String, List<String>>();
        while (rsIndex.next())
        {
          logger.debug("UNIQUE: " + rsIndex);

          // TABLE_CAT='molgenistest' TABLE_SCHEM='null'
          // TABLE_NAME='boolentity' NON_UNIQUE='false'
          // INDEX_QUALIFIER='' INDEX_NAME='PRIMARY' TYPE='3'
          // ORDINAL_POSITION='1' COLUMN_NAME='id' ASC_OR_DESC='A'
          // CARDINALITY='0' PAGES='0' FILTER_CONDITION='null'
          if (uniques.get(rsIndex.getString("INDEX_NAME")) == null) uniques.put(
              rsIndex.getString("INDEX_NAME"), new ArrayList<String>());
          uniques.get(rsIndex.getString("INDEX_NAME")).add(rsIndex.getString("COLUMN_NAME"));
        }
        for (List<String> index : uniques.values())
        {
          if (index.size() == 1)
          {
            e.getField(index.get(0)).setUnique(true);
          }
          else
          {
            StringBuilder fieldsBuilder = new StringBuilder();
            for (String field_name : index)
            {
              fieldsBuilder.append(',').append(field_name);
            }
            Unique u = new Unique();
            u.setFields(fieldsBuilder.substring(1));
            e.getUniques().add(u);
          }

        }

        // FIND type="autoid"
        for (Field f : e.getFields())
        {
          if (f.getAuto() != null && f.getAuto() && f.getType().equals(Type.INT) && f.getUnique() != null
              && f.getUnique())
          {
            f.setType(Field.Type.AUTOID);
            f.setAuto(null);
            f.setUnique(null);
          }
        }
      }

      // GUESS type="xref"
      // normally they should be defined as foreign key but sometimes
      // designers leave this out
      // rule: if the field name is the same and one is autoid,
      // then other fields having the same name are likely to be xref to
      // the autoid
      for (Entity e : m.getEntities())
      {
        for (Field f : e.getFields())
        {
          if (Field.Type.AUTOID.equals(f.getType()))
          {
            for (Entity otherE : m.getEntities())
            {
              for (Field otherF : otherE.getFields())
              {
                // assume xref if
                // name == name
                // otherF.type == int
                if (otherF.getName().equals(f.getName()) && otherF.getType().equals(Field.Type.INT))
                {
                  logger.debug("Guessed that " + otherE.getName() + "." + otherF.getName()
                      + " references " + e.getName() + "." + f.getName());
                  otherF.setType(Field.Type.XREF_SINGLE);
                  // otherF.setXrefEntity(;
                  otherF.setXrefField(e.getName() + "." + f.getName());
                }
              }
            }
          }

        }
      }

      // GUESS the xref labels
      // guess the xreflabel as being the non-autoid field that is unique
      // and not null
      // rule: if there is another unique field in the referenced table
      // then that probably is usable as label
      for (Entity e : m.getEntities())
      {
        for (Field f : e.getFields())
        {
          if (Field.Type.XREF_SINGLE.equals(f.getType()))
          {
            String xrefEntityName = f.getXrefField().substring(0, f.getXrefField().indexOf("."));
            String xrefFieldName = f.getXrefField().substring(f.getXrefField().indexOf(".") + 1);
            // reset the xref entity to the uppercase version
            f.setXrefField(m.getEntity(xrefEntityName).getName() + "." + xrefFieldName);

            for (Field labelField : m.getEntity(xrefEntityName).getFields())
            {
              // find the other unique, nillable="false" field, if
              // any
              if (!labelField.getName().equals(xrefFieldName)
                  && Boolean.TRUE.equals(labelField.getUnique())
                  && Boolean.FALSE.equals(labelField.getNillable()))
              {
                logger.debug("guessed label " + e.getName() + "." + labelField.getName());
                f.setXrefLabel(labelField.getName());
              }
            }
          }
        }
      }

      // GUESS the inheritance relationship
      // rule: if there is a foreign key that is unique itself it is
      // probably inheriting...
      // action: change to inheritance and remove the xref field
      for (Entity e : m.getEntities())
      {
        List<Field> toBeRemoved = new ArrayList<Field>();
        for (Field f : e.getFields())
        {
          if (Field.Type.XREF_SINGLE.equals(f.getType()) && Boolean.TRUE.equals(f.getUnique()))
          {
            String entityName = f.getXrefField().substring(0, f.getXrefField().indexOf("."));
            e.setExtends(entityName);
            toBeRemoved.add(f);
          }
        }
        for (Field f : toBeRemoved)
        {
          e.getFields().remove(f);
        }
      }

      // TODO GUESS the type="mref"
      // rule: any entity that is not a subclass and that has maximum two
      // xref fields and autoid field
      // should be a mref
      List<Entity> toBeRemoved = new ArrayList<Entity>();
      for (Entity e : m.getEntities())
        if ("".equals(e.getExtends()))
        {

          if (e.getFields().size() <= 3)
          {
            int xrefs = 0;
            String idField = null;
            // the column refering to 'localEntity'
            String localIdField = null;
            // the localEntiy
            String localEntity = null;
            // the column referring to 'remoteEntity'
            String localEntityField = null;
            // the column the localIdField is referning to
            String remoteIdField = null;
            // the column remoteEntity
            String remoteEntity = null;
            // the column the remoteIdField is referring to
            String remoteEntityField = null;

            for (Field f : e.getFields())
            {
              if (Field.Type.AUTOID.equals(f.getType()))
              {
                idField = f.getName();
              }
              else if (Field.Type.XREF_SINGLE.equals(f.getType()))
              {
                xrefs++;
                if (xrefs == 1)
                {
                  localIdField = f.getName();
                  // localEntityField is just the idField of
                  // the
                  // localEntity
                  localEntity = f.getXrefField().substring(0, f.getXrefField().indexOf("."));
                  localEntityField = f.getXrefField().substring(f.getXrefField().indexOf(".") + 1);
                }
                else
                {
                  remoteIdField = f.getName();
                  // should be the id field of the remote
                  // entity
                  remoteEntity = f.getXrefField().substring(0, f.getXrefField().indexOf("."));
                  remoteEntityField = f.getXrefField().substring(f.getXrefField().indexOf(".") + 1);
                }
              }
            }

            // if valid mref, drop this entity and add mref fields
            // to
            // the other entities.
            if (xrefs == 2 && (e.getFields().size() == 2 || idField != null))
            {
              // add mref on 'local' end
              Entity localContainer = m.getEntity(localEntity);
              Field localField = new Field();
              if (localContainer.getField(e.getName()) == null)
              {
                localField.setName(e.getName());
              }

              localField.setType(Field.Type.XREF_MULTIPLE);
              localField.setXrefField(remoteEntity + "." + remoteEntityField);
              localField.setMrefName(e.getName());
              localField.setMrefLocalid(localIdField);
              localField.setMrefRemoteid(remoteIdField);
              localContainer.getFields().add(localField);

              // add mref to remote end
              Entity remoteContainer = m.getEntity(remoteEntity);
              Field remoteField = new Field();
              remoteField.setType(Field.Type.XREF_MULTIPLE);
              remoteField.setXrefField(localEntity + "." + localEntityField);
              remoteField.setMrefName(e.getName());
              // don't need to add local id as it is refering back
              remoteField.setMrefLocalid(remoteIdField);
              remoteField.setMrefRemoteid(localIdField);

              if (remoteContainer.getField(e.getName()) == null)
              {
                remoteField.setName(e.getName());
              }
              else
              {
                throw new RuntimeException("MREF creation failed: there is already a field "
                    + remoteContainer.getName() + "." + e.getName());
View Full Code Here

Examples of org.mortbay.jetty.HttpFields.Field

                Iterator i = fields.getFields();

                while (i.hasNext())
                {
                    num_fields++;
                    Field f = (Field) i.next();

                    byte[] codes = (byte[]) __headerHash.get(f.getName());
                    if (codes != null)
                    {
                        _buffer.put(codes);
                    }
                    else
                    {
                        addString(f.getName());
                    }
                    addString(f.getValue());
                }
            }

            if (!has_server && _status > 100 && getSendServerVersion())
            {
View Full Code Here

Examples of org.mule.common.query.Field

        verify(port).catalogInventoryStockItemList(anyString(), eq(idsOrSkus));
    }
   
    @Test
    public void queryTranslator() throws Exception {
      FieldComparation name = new FieldComparation(new EqualsOperator(), new Field("name", "java.lang.String"), new org.mule.common.query.expression.StringValue("mariano"));
      FieldComparation age = new FieldComparation(new LessOperator(), new Field("age", "int"), new IntegerValue(30));
      And and = new And(name, age);
     
      Query query = mock(Query.class);
      when(query.getFilterExpression()).thenReturn(and);
     
View Full Code Here

Examples of org.mule.module.db.integration.model.Field

        assertThat(payload.size(), equalTo(1));
        int expectedUpdateCount = testDatabase instanceof DerbyTestDatabase ? 0 : 1;
        assertThat((Integer) payload.get("updateCount1"), equalTo(expectedUpdateCount));

        List<Map<String, String>> result = selectData("select * from PLANET where POSITION=4", getDefaultDataSource());
        assertRecords(result, new Record(new Field("NAME", "foo"), new Field("POSITION", 4)));
    }
View Full Code Here

Examples of org.mybatis.generator.api.dom.java.Field

    // add field, getter, setter for orderby clause
    // @Resource private UserMapper userMapper;
    type = new FullyQualifiedJavaType("javax.annotation.Resource");
    importedTypes.add(type);

    Field field = new Field();
    field.setVisibility(JavaVisibility.PRIVATE);
    String mapper = introspectedTable.getMyBatis3JavaMapperType();
    type = new FullyQualifiedJavaType(mapper);
    field.setType(type);
    idx = mapper.lastIndexOf(".");
    if (idx != -1)
    {
      mapper = mapper.substring(idx + 1);
    }
    mapper = mapper.substring(0, 1).toLowerCase() + mapper.substring(1);
    field.setName(mapper);
    field.addAnnotation("@Resource");
    topLevelClass.addField(field);
    importedTypes.add(type);
    topLevelClass.addImportedTypes(importedTypes);

    // add Method....
View Full Code Here

Examples of org.netbeans.lib.profiler.heap.Field

        }
        char[] text = null;
        int offset = 0;
        int len = -1;
        for(FieldValue f: obj.getFieldValues()) {
            Field ff = f.getField();
            if ("value".equals(ff.getName())) {
                PrimitiveArrayInstance chars = (PrimitiveArrayInstance) ((ObjectFieldValue)f).getInstance();
                text = new char[chars.getLength()];
                for(int i = 0; i != text.length; ++i) {
                    text[i] = ((String)chars.getValues().get(i)).charAt(0);
                }
            }
            // fields below were removed in Java 7
            else if ("offset".equals(ff.getName())) {
                offset = Integer.valueOf(f.getValue());
            }
            else if ("count".equals(ff.getName())) {
                len = Integer.valueOf(f.getValue());
            }
        }

        if (len < 0) {
View Full Code Here

Examples of org.objectweb.medor.api.Field

    /**
     * Add the prefetch field to the current query tree
     * @param qd is the definition of the query
     */
    private void addPrefetchField(JDOQueryDefinitionImpl qd) throws MedorException {
        Field f = ((PropagatedField) selectfields.get(0)).getOriginFields()[0];
        if (f instanceof PNameField) {
            PNameField pnf = (PNameField) f;
            if (pnf.isClassPName() && !pnf.isInGenClass()) {
                //Add prefeched fields
                ClassExtent ce = (ClassExtent) pnf.getQueryTree();
View Full Code Here

Examples of org.objectweb.speedo.generation.generator.lib.AbstractSpeedoGenerator.Field

        }
        cv.visit(version, access, name, superName, itfs, sourceFile);
        final List fields = (List) ctx.get("fields");
        final int nbfields = fields.size();
        for (Iterator iter = fields.iterator(); iter.hasNext();) {
            Field f = (Field) iter.next();
            final String ftd = f.jvmType;
            Type ft = Type.getType(ftd);
            generateStaticFieldGetter(f, ft);
            generateStaticFieldSetter(f, ft);
            generateFieldGetter(f, ft, ftd, nbfields);
            generateFieldSetter(f, ft, ftd, nbfields);
            if (f.getCoherentSetter() != null) {
                generateCoherenceFieldSetter(f, ft, ftd, nbfields);
            }
        }
        if (needSpeedoGenClassListener) {
            generateSpeedoElementAddedMethod();
View Full Code Here

Examples of org.odftoolkit.simple.common.field.Field

    Assert.assertNotNull(variableField);
    TextSpanElement newTextSpanElement = sourcedoc.newParagraph("Update Variable Field:").newTextSpanElement();
    variableField.updateField("simple variable content", newTextSpanElement);
    newTextSpanElement = sourcedoc.newParagraph("Show Variable Field:").newTextSpanElement();
    variableField.displayField(newTextSpanElement);
    Field orgField = sourcedoc.getVariableFieldByName("test_simple_variable");
    // 6 Simple, at the middle of original Paragraph, split original
    // Paragraph, insert before the second Paragraph.
    search = new TextNavigation("SIMPLE", doc);
    while (search.hasNext()) {
      TextSelection item = (TextSelection) search.nextSelection();
      try {
        Field newField = item.replaceWith(orgField);
      } catch (InvalidNavigationException e) {
        e.printStackTrace();
      }
    }
    try {
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.