/** * Get the related id mappings for the base id * * @param extendedRelation extended relation * @param baseId base id * @return IDs representing the matching related IDs */ public List<Long> getMappingsForBase(ExtendedRelation extendedRelation, long baseId) { return getMappingsForBase(extendedRelation.getMappingTableName(), baseId); }
/** * Remove a specific relationship from the GeoPackage * * @param extendedRelation * extended relation */ public void removeRelationship(ExtendedRelation extendedRelation) { removeRelationship(extendedRelation.getBaseTableName(), extendedRelation.getRelatedTableName(), extendedRelation.getRelationName()); }
TestCase.assertEquals(1, featureExtendedRelations.size()); TestCase.assertEquals(1, featureExtendedRelations2.size()); TestCase.assertEquals(featureExtendedRelations.get(0).getId(), featureExtendedRelations2.get(0).getId()); TestCase.assertTrue(extendedRelationsDao.getRelatedTableRelations( featureDao.getTableName()).isEmpty()); TestCase.assertTrue(featureRelation.getId() >= 0); TestCase.assertEquals(featureDao.getTableName(), featureRelation.getBaseTableName()); TestCase.assertEquals( featureDao.getTable().getPkColumn().getName(), featureRelation.getBasePrimaryColumn()); TestCase.assertEquals(mediaDao.getTableName(), featureRelation.getRelatedTableName()); TestCase.assertEquals(mediaDao.getTable().getPkColumn().getName(), featureRelation.getRelatedPrimaryColumn()); TestCase.assertEquals(MediaTable.RELATION_TYPE.getName(), featureRelation.getRelationName()); TestCase.assertEquals(mappingTableName, featureRelation.getMappingTableName()); TestCase.assertEquals(1, mediaExtendedRelations.size()); TestCase.assertEquals(1, mediaExtendedRelations2.size()); TestCase.assertEquals(mediaExtendedRelations.get(0).getId(), mediaExtendedRelations2.get(0).getId()); TestCase.assertTrue(extendedRelationsDao.getBaseTableRelations( mediaTable.getTableName()).isEmpty());
/** * Get a related media table DAO * * @param extendedRelation * extended relation * @return media DAO */ public MediaDao getMediaDao(ExtendedRelation extendedRelation) { return getMediaDao(extendedRelation.getRelatedTableName()); }
.getBaseTableName()); FeatureColumn pkColumn = baseDao.getTable().getPkColumn(); FeatureCursor frs = baseDao.queryForAll(); .getAttributesDao(extendedRelation.getRelatedTableName()); AttributesColumn pkColumn2 = relatedDao.getTable().getPkColumn(); AttributesCursor ars = relatedDao.queryForAll();
ExtendedRelation extendedRelation = new ExtendedRelation(); extendedRelation.setBaseTableName(baseTableName); extendedRelation .setBasePrimaryColumn(getPrimaryKeyColumnName(baseTableName)); extendedRelation.setRelatedTableName(relatedTableName); extendedRelation .setRelatedPrimaryColumn(getPrimaryKeyColumnName(relatedTableName)); extendedRelation.setMappingTableName(userMappingTable.getTableName()); extendedRelation.setRelationName(relationName); try { extendedRelationsDao.create(extendedRelation);
/** * Get all the base table names * * @return base table names * @throws SQLException * upon failure */ public List<String> getBaseTables() throws SQLException { List<String> baseTables = new ArrayList<String>(); List<ExtendedRelation> extendedRelations = queryForAll(); for (ExtendedRelation extendedRelation : extendedRelations) { baseTables.add(extendedRelation.getBaseTableName()); } return baseTables; }
/** * Get the relation type for pre-known types * * @return relation type or null */ public RelationType getRelationType() { return RelationType.fromName(getRelationName()); }
TestCase.assertEquals(1, attributesExtendedRelations.size()); TestCase.assertEquals(1, attributesExtendedRelations2.size()); TestCase.assertEquals(attributesExtendedRelations.get(0).getId(), attributesExtendedRelations2.get(0).getId()); TestCase.assertTrue(extendedRelationsDao.getRelatedTableRelations( attributesDao.getTableName()).isEmpty()); TestCase.assertTrue(attributesRelation.getId() >= 0); TestCase.assertEquals(attributesDao.getTableName(), attributesRelation.getBaseTableName()); TestCase.assertEquals(attributesDao.getTable().getPkColumn() .getName(), attributesRelation.getBasePrimaryColumn()); TestCase.assertEquals(simpleDao.getTableName(), attributesRelation.getRelatedTableName()); TestCase.assertEquals(simpleDao.getTable().getPkColumn().getName(), attributesRelation.getRelatedPrimaryColumn()); TestCase.assertEquals( SimpleAttributesTable.RELATION_TYPE.getName(), attributesRelation.getRelationName()); TestCase.assertEquals(mappingTableName, attributesRelation.getMappingTableName()); TestCase.assertEquals(1, simpleExtendedRelations.size()); TestCase.assertEquals(1, simpleExtendedRelations2.size()); TestCase.assertEquals(simpleExtendedRelations.get(0).getId(), simpleExtendedRelations2.get(0).getId()); TestCase.assertTrue(extendedRelationsDao.getBaseTableRelations( simpleTable.getTableName()).isEmpty());
/** * Get a related simple attributes table DAO * * @param extendedRelation * extended relation * @return simple attributes DAO */ public SimpleAttributesDao getSimpleAttributesDao( ExtendedRelation extendedRelation) { return getSimpleAttributesDao(extendedRelation.getRelatedTableName()); }
.getBaseTableName()); FeatureDao featureDao2 = geoPackage.getFeatureDao(relation .getRelatedTableName());
.getBaseTableName()); MediaDao mediaDao = relatedTables.getMediaDao(relation); UserMappingDao userMappingDao = relatedTables.getMappingDao(relation);
/** * Get a User Mapping DAO from an extended relation * * @param extendedRelation * extended relation * @return user mapping dao */ public UserMappingDao getMappingDao(ExtendedRelation extendedRelation) { return getMappingDao(extendedRelation.getMappingTableName()); }
/** * Get a related simple attributes table DAO * * @param extendedRelation extended relation * @return simple attributes DAO */ public SimpleAttributesDao getSimpleAttributesDao( ExtendedRelation extendedRelation) { return getSimpleAttributesDao(extendedRelation.getRelatedTableName()); }
/** * Get a User Mapping DAO from an extended relation * * @param extendedRelation extended relation * @return user mapping dao */ public UserMappingDao getMappingDao(ExtendedRelation extendedRelation) { return getMappingDao(extendedRelation.getMappingTableName()); }
/** * Get a related media table DAO * * @param extendedRelation extended relation * @return media DAO */ public MediaDao getMediaDao(ExtendedRelation extendedRelation) { return getMediaDao(extendedRelation.getRelatedTableName()); }
/** * Get the base id mappings for the related id * * @param extendedRelation extended relation * @param relatedId related id * @return IDs representing the matching base IDs */ public List<Long> getMappingsForRelated(ExtendedRelation extendedRelation, long relatedId) { return getMappingsForRelated(extendedRelation.getMappingTableName(), relatedId); }
/** * Get all the related table names * * @return related table names * @throws SQLException * upon failure */ public List<String> getRelatedTables() throws SQLException { List<String> relatedTables = new ArrayList<String>(); List<ExtendedRelation> extendedRelations = queryForAll(); for (ExtendedRelation extendedRelation : extendedRelations) { relatedTables.add(extendedRelation.getRelatedTableName()); } return relatedTables; }
/** * Get the related id mappings for the base id * * @param extendedRelation * extended relation * @param baseId * base id * @return IDs representing the matching related IDs */ public List<Long> getMappingsForBase(ExtendedRelation extendedRelation, long baseId) { return getMappingsForBase(extendedRelation.getMappingTableName(), baseId); }
/** * Get the base id mappings for the related id * * @param extendedRelation * extended relation * @param relatedId * related id * @return IDs representing the matching base IDs */ public List<Long> getMappingsForRelated(ExtendedRelation extendedRelation, long relatedId) { return getMappingsForRelated(extendedRelation.getMappingTableName(), relatedId); }