@Test public void testFindByField() throws Exception { mv.create(context); int fieldId = mv.getFieldId(); List<MetadataValue> found = MetadataValue.findByField(context, fieldId); assertThat("testFind 0",found, notNullValue()); assertTrue("testFind 1",found.size() >= 1); }
public static List<MetadataValue> findByField(Context context, int fieldId) throws IOException, SQLException, AuthorizeException { TableRowIterator tri = DatabaseManager.queryTable(context, "MetadataValue", "SELECT * FROM MetadataValue WHERE metadata_field_id= ? ", fieldId); TableRow row = null; List<MetadataValue> ret = new ArrayList<MetadataValue>(); try { while (tri.hasNext()) { row = tri.next(); ret.add(new MetadataValue(row)); } } finally { if (tri != null) { tri.close(); } } return ret; }
MetadataValue { public static List<MetadataValue> findByField(Context context, int fieldId) throws IOException, SQLException, AuthorizeException { TableRowIterator tri = DatabaseManager.queryTable(context, "MetadataValue", "SELECT * FROM MetadataValue WHERE metadata_field_id= ? ", fieldId); TableRow row = null; List<MetadataValue> ret = new ArrayList<MetadataValue>(); try { while (tri.hasNext()) { row = tri.next(); ret.add(new MetadataValue(row)); } } finally { if (tri != null) { tri.close(); } } return ret; } }
MetadataValue { public static List<MetadataValue> findByField(Context context, int fieldId) throws IOException, SQLException, AuthorizeException { TableRowIterator tri = DatabaseManager.queryTable(context, "MetadataValue", "SELECT * FROM MetadataValue WHERE metadata_field_id= ? ", fieldId); TableRow row = null; List<MetadataValue> ret = new ArrayList<MetadataValue>(); try { while (tri.hasNext()) { row = tri.next(); ret.add(new MetadataValue(row)); } } finally { if (tri != null) { tri.close(); } } return ret; } MetadataValue(TableRow row);  MetadataValue();  MetadataValue(MetadataField field); }
MetadataValue { public static List<MetadataValue> findByField(Context context, int fieldId) throws IOException, SQLException, AuthorizeException { TableRowIterator tri = DatabaseManager.queryTable(context, "MetadataValue", "SELECT * FROM MetadataValue WHERE metadata_field_id= ? ", fieldId); TableRow row = null; List<MetadataValue> ret = new ArrayList<MetadataValue>(); try { while (tri.hasNext()) { row = tri.next(); ret.add(new MetadataValue(row)); } } finally { if (tri != null) { tri.close(); } } return ret; } MetadataValue(TableRow row);  MetadataValue();  MetadataValue(MetadataField field); int getFieldId(); void setFieldId(int fieldId); int getItemId(); void setItemId(int itemId); String getLanguage(); void setLanguage(String language); int getPlace(); void setPlace(int place); int getValueId(); String getValue(); void setValue(String value); String getAuthority(); void setAuthority(String value); int getConfidence(); void setConfidence(int value); void create(Context context); static MetadataValue find(Context context, int valueId); static List<MetadataValue> findByField(Context context, int fieldId); void update(Context context); void delete(Context context); @Override boolean equals(Object obj); @Override int hashCode(); }
MetadataValue { public static List<MetadataValue> findByField(Context context, int fieldId) throws IOException, SQLException, AuthorizeException { TableRowIterator tri = DatabaseManager.queryTable(context, "MetadataValue", "SELECT * FROM MetadataValue WHERE metadata_field_id= ? ", fieldId); TableRow row = null; List<MetadataValue> ret = new ArrayList<MetadataValue>(); try { while (tri.hasNext()) { row = tri.next(); ret.add(new MetadataValue(row)); } } finally { if (tri != null) { tri.close(); } } return ret; } MetadataValue(TableRow row);  MetadataValue();  MetadataValue(MetadataField field); int getFieldId(); void setFieldId(int fieldId); int getItemId(); void setItemId(int itemId); String getLanguage(); void setLanguage(String language); int getPlace(); void setPlace(int place); int getValueId(); String getValue(); void setValue(String value); String getAuthority(); void setAuthority(String value); int getConfidence(); void setConfidence(int value); void create(Context context); static MetadataValue find(Context context, int valueId); static List<MetadataValue> findByField(Context context, int fieldId); void update(Context context); void delete(Context context); @Override boolean equals(Object obj); @Override int hashCode(); public String value; public String language; public int place; public String authority; public int confidence; }