/** * Create a user mapping table with the minimum required columns * * @param tableName * table name * @return user mapping table */ public static UserMappingTable create(String tableName) { return create(tableName, null); }
/** * Create a default user mapping table and extension row if either does not * exist. When not created, there is no guarantee that an existing table has * the same schema as the provided tabled. * * @param mappingTableName * user mapping table name * @return true if table was created, false if the table already existed */ public boolean createUserMappingTable(String mappingTableName) { UserMappingTable userMappingTable = UserMappingTable .create(mappingTableName); return createUserMappingTable(userMappingTable); }
/** * Adds a relationship between the base and user related table. Creates a * default user mapping table and the related table if needed. * * @param baseTableName * base table name * @param relatedTable * user related table * @param mappingTableName * user mapping table name * @return The relationship that was added */ public ExtendedRelation addRelationship(String baseTableName, UserRelatedTable relatedTable, String mappingTableName) { UserMappingTable userMappingTable = UserMappingTable .create(mappingTableName); return addRelationship(baseTableName, relatedTable, userMappingTable); }
/** * Adds a relationship between the base and related table. Creates a default * user mapping table if needed. * * @param baseTableName * base table name * @param relatedTableName * related table name * @param mappingTableName * mapping table name * @param relationName * relation name * @return The relationship that was added */ public ExtendedRelation addRelationship(String baseTableName, String relatedTableName, String mappingTableName, String relationName) { UserMappingTable userMappingTable = UserMappingTable .create(mappingTableName); ExtendedRelation extendedRelation = addRelationship(baseTableName, relatedTableName, userMappingTable, relationName); return extendedRelation; }
private static void createRelatedTablesFeaturesExtension( GeoPackage geoPackage, String tableName1, String tableName2) { RelatedTablesExtension relatedTables = new RelatedTablesExtension( geoPackage); List<UserCustomColumn> additionalMappingColumns = RelatedTablesUtils .createAdditionalUserColumns(UserMappingTable .numRequiredColumns()); UserMappingTable userMappingTable = UserMappingTable.create(tableName1 + "_" + tableName2, additionalMappingColumns); ExtendedRelation relation = relatedTables.addFeaturesRelationship( tableName1, tableName2, userMappingTable); insertRelatedTablesFeaturesExtensionRows(geoPackage, relation); }
private static void createRelatedTablesMediaExtension(Activity activity, Context testContext, GeoPackage geoPackage) throws IOException { RelatedTablesExtension relatedTables = new RelatedTablesExtension( geoPackage); List<UserCustomColumn> additionalMediaColumns = RelatedTablesUtils .createAdditionalUserColumns(MediaTable.numRequiredColumns()); MediaTable mediaTable = MediaTable.create("media", additionalMediaColumns); List<UserCustomColumn> additionalMappingColumns = RelatedTablesUtils .createAdditionalUserColumns(UserMappingTable .numRequiredColumns()); String tableName1 = "geometry1"; UserMappingTable userMappingTable1 = UserMappingTable.create(tableName1 + "_" + mediaTable.getTableName(), additionalMappingColumns); ExtendedRelation relation1 = relatedTables.addMediaRelationship( tableName1, mediaTable, userMappingTable1); insertRelatedTablesMediaExtensionRows(activity, testContext, geoPackage, relation1, "BIT Systems%", "BIT Systems", "BITSystems_Logo.png", "image/png", "BIT Systems Logo", "http://www.bit-sys.com"); String tableName2 = "geometry2"; UserMappingTable userMappingTable2 = UserMappingTable.create(tableName2 + "_" + mediaTable.getTableName(), additionalMappingColumns); ExtendedRelation relation2 = relatedTables.addMediaRelationship( tableName2, mediaTable, userMappingTable2); insertRelatedTablesMediaExtensionRows(activity, testContext, geoPackage, relation2, "NGA%", "NGA", "NGA_Logo.png", "image/png", "NGA Logo", "http://www.nga.mil"); insertRelatedTablesMediaExtensionRows(activity, testContext, geoPackage, relation2, "NGA", "NGA", "NGA.jpg", "image/jpeg", "Aerial View of NGA East", "http://www.nga.mil"); }
.numRequiredColumns()); UserMappingTable userMappingTable = UserMappingTable.create( mappingTableName, additionalColumns); TestCase.assertFalse(rte.has(userMappingTable.getTableName()));
.numRequiredColumns()); final String mappingTableName = "attributes_simple_attributes"; UserMappingTable userMappingTable = UserMappingTable.create( mappingTableName, additionalMappingColumns); TestCase.assertFalse(rte.has(userMappingTable.getTableName()));
.numRequiredColumns()); final String mappingTableName = "features_media"; UserMappingTable userMappingTable = UserMappingTable.create( mappingTableName, additionalMappingColumns); TestCase.assertFalse(rte.has(userMappingTable.getTableName()));
.createAdditionalUserColumns(UserMappingTable .numRequiredColumns()); UserMappingTable userMappingTable = UserMappingTable.create(tableName + "_" + simpleTable.getTableName(), additionalMappingColumns); ExtendedRelation relation = relatedTables