Examples with DataColumnConstraints mil.nga.geopackage.extension.schema.constraints.DataColumnConstraints used on opensource projects

Example 1 with DataColumnConstraints

use of mil.nga.geopackage.extension.schema.constraints.DataColumnConstraints in project geopackage-android-map by ngageoint.

the class TestUtils method createConstraints.

/**
 * Create Data Column Constraints
 *
 * @param geoPackage
 * @throws SQLException
 */
public static void createConstraints(GeoPackage geoPackage) throws SQLException {
    SchemaExtension schemaExtension = new SchemaExtension(geoPackage);
    schemaExtension.createDataColumnConstraintsTable();
    DataColumnConstraintsDao dao = schemaExtension.getDataColumnConstraintsDao();
    DataColumnConstraints sampleRange = new DataColumnConstraints();
    sampleRange.setConstraintName(SAMPLE_RANGE_CONSTRAINT);
    sampleRange.setConstraintType(DataColumnConstraintType.RANGE);
    sampleRange.setMin(BigDecimal.ONE);
    sampleRange.setMinIsInclusive(true);
    sampleRange.setMax(BigDecimal.TEN);
    sampleRange.setMaxIsInclusive(true);
    dao.create(sampleRange);
    DataColumnConstraints sampleEnum1 = new DataColumnConstraints();
    sampleEnum1.setConstraintName(SAMPLE_ENUM_CONSTRAINT);
    sampleEnum1.setConstraintType(DataColumnConstraintType.ENUM);
    sampleEnum1.setValue("1");
    dao.create(sampleEnum1);
    DataColumnConstraints sampleEnum3 = new DataColumnConstraints();
    sampleEnum3.setConstraintName(SAMPLE_ENUM_CONSTRAINT);
    sampleEnum3.setConstraintType(DataColumnConstraintType.ENUM);
    sampleEnum3.setValue("3");
    dao.create(sampleEnum3);
    DataColumnConstraints sampleEnum5 = new DataColumnConstraints();
    sampleEnum5.setConstraintName(SAMPLE_ENUM_CONSTRAINT);
    sampleEnum5.setConstraintType(DataColumnConstraintType.ENUM);
    sampleEnum5.setValue("5");
    dao.create(sampleEnum5);
    DataColumnConstraints sampleEnum7 = new DataColumnConstraints();
    sampleEnum7.setConstraintName(SAMPLE_ENUM_CONSTRAINT);
    sampleEnum7.setConstraintType(DataColumnConstraintType.ENUM);
    sampleEnum7.setValue("7");
    dao.create(sampleEnum7);
    DataColumnConstraints sampleEnum9 = new DataColumnConstraints();
    sampleEnum9.setConstraintName(SAMPLE_ENUM_CONSTRAINT);
    sampleEnum9.setConstraintType(DataColumnConstraintType.ENUM);
    sampleEnum9.setValue("9");
    dao.create(sampleEnum9);
    DataColumnConstraints sampleGlob = new DataColumnConstraints();
    sampleGlob.setConstraintName(SAMPLE_GLOB_CONSTRAINT);
    sampleGlob.setConstraintType(DataColumnConstraintType.GLOB);
    sampleGlob.setValue("[1-2][0-9][0-9][0-9]");
    dao.create(sampleGlob);
}