mil.nga.geopackage.db.GeoPackageDataType Java Exaples

Source File: RTreeIndexCoreExtension.java From geopackage-core-java with MIT License

6 votes

/**
 * Get the RTree Table
 * 
 * @param featureTable
 *            feature table
 * @return RTree table
 */
protected UserCustomTable getRTreeTable(FeatureTable featureTable) {

	List<UserCustomColumn> columns = new ArrayList<>();
	columns.add(UserCustomColumn.createPrimaryKeyColumn(COLUMN_ID));
	columns.add(UserCustomColumn.createColumn(COLUMN_MIN_X,
			GeoPackageDataType.FLOAT));
	columns.add(UserCustomColumn.createColumn(COLUMN_MAX_X,
			GeoPackageDataType.FLOAT));
	columns.add(UserCustomColumn.createColumn(COLUMN_MIN_Y,
			GeoPackageDataType.FLOAT));
	columns.add(UserCustomColumn.createColumn(COLUMN_MAX_Y,
			GeoPackageDataType.FLOAT));

	String rTreeTableName = getRTreeTableName(featureTable.getTableName(),
			featureTable.getGeometryColumnName());

	UserCustomTable userCustomTable = new UserCustomTable(rTreeTableName,
			columns);

	return userCustomTable;
}

Source File: UserColumn.java From geopackage-core-java with MIT License

6 votes

/**
 * Validate that if max is set, the data type is text or blob
 */
private void validateMax() {

	if (max != null) {
		if (dataType == null) {
			throw new GeoPackageException(
					"Column max is only supported for data typed columns. column: "
							+ name + ", max: " + max);
		} else if (dataType != GeoPackageDataType.TEXT
				&& dataType != GeoPackageDataType.BLOB) {
			throw new GeoPackageException(
					"Column max is only supported for "
							+ GeoPackageDataType.TEXT.name() + " and "
							+ GeoPackageDataType.BLOB.name()
							+ " columns. column: " + name + ", max: " + max
							+ ", type: " + dataType.name());
		}
	}

}

Source File: UserCoreRow.java From geopackage-core-java with MIT License

6 votes

/**
 * Validate the value and its actual value types against the column data
 * type class
 * 
 * @param column
 *            column
 * @param value
 *            value
 * @param valueTypes
 *            value types
 */
protected void validateValue(TColumn column, Object value,
		Class<?>... valueTypes) {

	GeoPackageDataType dataType = column.getDataType();
	Class<?> dataTypeClass = dataType.getClassType();

	boolean valid = false;
	for (Class<?> valueType : valueTypes) {
		if (valueType.equals(dataTypeClass)) {
			valid = true;
			break;
		}
	}

	if (!valid) {
		throw new GeoPackageException("Illegal value. Column: "
				+ column.getName() + ", Value: " + value
				+ ", Expected Type: " + dataTypeClass.getSimpleName()
				+ ", Actual Type: " + valueTypes[0].getSimpleName());
	}

}

Source File: TestUtils.java From geopackage-java with MIT License

6 votes

/**
 * Validate the float value with the data type
 * 
 * @param value
 * @param dataType
 */
public static void validateFloatValue(Object value,
		GeoPackageDataType dataType) {

	switch (dataType) {

	case FLOAT:
		TestCase.assertTrue(value instanceof Float);
		break;
	case DOUBLE:
	case REAL:
		TestCase.assertTrue(value instanceof Double);
		break;
	default:
		throw new GeoPackageException(
				"Data Type " + dataType + " is not a float type");
	}
}

Source File: IconTable.java From geopackage-core-java with MIT License

6 votes

/**
 * Create the style columns
 * 
 * @return columns
 */
private static List<UserCustomColumn> createColumns() {

	List<UserCustomColumn> columns = new ArrayList<>();
	columns.addAll(createRequiredColumns());

	columns.add(UserCustomColumn.createColumn(COLUMN_NAME,
			GeoPackageDataType.TEXT));
	columns.add(UserCustomColumn.createColumn(COLUMN_DESCRIPTION,
			GeoPackageDataType.TEXT));
	columns.add(UserCustomColumn.createColumn(COLUMN_WIDTH,
			GeoPackageDataType.REAL));
	columns.add(UserCustomColumn.createColumn(COLUMN_HEIGHT,
			GeoPackageDataType.REAL));
	columns.add(UserCustomColumn.createColumn(COLUMN_ANCHOR_U,
			GeoPackageDataType.REAL));
	columns.add(UserCustomColumn.createColumn(COLUMN_ANCHOR_V,
			GeoPackageDataType.REAL));

	return columns;
}

Source File: TestUtils.java From geopackage-android with MIT License

6 votes

/**
 * Validate the float value with the data type
 *
 * @param value
 * @param dataType
 * @return
 */
public static void validateFloatValue(Object value,
                                      GeoPackageDataType dataType) {

    switch (dataType) {

        case FLOAT:
            TestCase.assertTrue(value instanceof Float);
            break;
        case DOUBLE:
        case REAL:
            TestCase.assertTrue(value instanceof Double);
            break;
        default:
            throw new GeoPackageException("Data Type " + dataType
                    + " is not a float type");
    }
}

Source File: StyleTable.java From geopackage-core-java with MIT License

6 votes

/**
 * Create the style columns
 * 
 * @return columns
 */
private static List<AttributesColumn> createColumns() {

	List<AttributesColumn> columns = new ArrayList<>();

	columns.add(AttributesColumn.createPrimaryKeyColumn(COLUMN_ID));
	columns.add(AttributesColumn.createColumn(COLUMN_NAME,
			GeoPackageDataType.TEXT));
	columns.add(AttributesColumn.createColumn(COLUMN_DESCRIPTION,
			GeoPackageDataType.TEXT));
	columns.add(AttributesColumn.createColumn(COLUMN_COLOR,
			GeoPackageDataType.TEXT));
	columns.add(AttributesColumn.createColumn(COLUMN_OPACITY,
			GeoPackageDataType.REAL));
	columns.add(AttributesColumn.createColumn(COLUMN_WIDTH,
			GeoPackageDataType.REAL));
	columns.add(AttributesColumn.createColumn(COLUMN_FILL_COLOR,
			GeoPackageDataType.TEXT));
	columns.add(AttributesColumn.createColumn(COLUMN_FILL_OPACITY,
			GeoPackageDataType.REAL));

	return columns;
}

Source File: UserMappingDao.java From geopackage-java with MIT License

5 votes

/**
 * Get the unique base ids
 *
 * @return list of unique base ids
 * @since 3.2.0
 */
public List<Long> uniqueBaseIds() {
	return querySingleColumnTypedResults(
			"SELECT DISTINCT "
					+ CoreSQLUtils
							.quoteWrap(UserMappingTable.COLUMN_BASE_ID)
					+ " FROM " + CoreSQLUtils.quoteWrap(getTableName()),
			null, GeoPackageDataType.INTEGER);
}

Source File: GeoPackageTestUtils.java From geopackage-java with MIT License

5 votes

/**
 * Get additional feature columns to create
 * 
 * @return
 */
public static List<FeatureColumn> getFeatureColumns() {
	List<FeatureColumn> columns = new ArrayList<FeatureColumn>();

	columns.add(FeatureColumn.createColumn(7, "test_text_limited",
			GeoPackageDataType.TEXT, 5L));
	columns.add(FeatureColumn.createColumn(8, "test_blob_limited",
			GeoPackageDataType.BLOB, 7L));
	columns.add(FeatureColumn.createColumn(9, "test_date",
			GeoPackageDataType.DATE));
	columns.add(FeatureColumn.createColumn(10, "test_datetime",
			GeoPackageDataType.DATETIME));
	columns.add(FeatureColumn.createColumn(2, "test_text",
			GeoPackageDataType.TEXT, false, ""));
	columns.add(FeatureColumn.createColumn(3, "test_real",
			GeoPackageDataType.REAL));
	columns.add(FeatureColumn.createColumn(4, "test_boolean",
			GeoPackageDataType.BOOLEAN));

	FeatureColumn blobColumn = FeatureColumn.createColumn("test_blob",
			GeoPackageDataType.BLOB);
	columns.add(blobColumn);
	// Let the index for this column be automatically set to 5
	// blobColumn.setIndex(5);

	// Test setting an index after column creation but before table creation
	FeatureColumn integerColumn = FeatureColumn.createColumn("test_integer",
			GeoPackageDataType.INTEGER);
	columns.add(integerColumn);
	integerColumn.setIndex(6);

	return columns;
}

Source File: TestUtils.java From geopackage-java with MIT License

5 votes

/**
 * Build an example feature table
 * 
 * @param tableName
 * @param geometryColumn
 * @param geometryType
 * @return feature table
 */
public static FeatureTable buildFeatureTable(String tableName,
		String geometryColumn, GeometryType geometryType) {

	List<FeatureColumn> columns = new ArrayList<FeatureColumn>();

	columns.add(FeatureColumn.createPrimaryKeyColumn(0, "id"));
	columns.add(FeatureColumn.createColumn(7, "test_text_limited",
			GeoPackageDataType.TEXT, 5L));
	columns.add(FeatureColumn.createColumn(8, "test_blob_limited",
			GeoPackageDataType.BLOB, 7L));
	columns.add(FeatureColumn.createColumn(9, "test_date",
			GeoPackageDataType.DATE));
	columns.add(FeatureColumn.createColumn(10, "test_datetime",
			GeoPackageDataType.DATETIME));
	columns.add(FeatureColumn.createGeometryColumn(1, geometryColumn,
			geometryType));
	columns.add(FeatureColumn.createColumn(2, "test_text",
			GeoPackageDataType.TEXT, false, ""));
	columns.add(FeatureColumn.createColumn(3, "test_real",
			GeoPackageDataType.REAL));
	columns.add(FeatureColumn.createColumn(4, "test_boolean",
			GeoPackageDataType.BOOLEAN));
	columns.add(FeatureColumn.createColumn(5, "test_blob",
			GeoPackageDataType.BLOB));
	columns.add(FeatureColumn.createColumn(6, TEST_INTEGER_COLUMN,
			GeoPackageDataType.INTEGER));

	FeatureTable table = new FeatureTable(tableName, geometryColumn,
			columns);

	return table;
}

Source File: FeatureColumn.java From geopackage-core-java with MIT License

5 votes

/**
 * Attempt to get the geometry type of the table column
 * 
 * @param tableColumn
 *            table column
 * @return geometry type
 */
private static GeometryType getGeometryType(TableColumn tableColumn) {
	GeometryType geometryType = null;
	if (tableColumn.isDataType(GeoPackageDataType.BLOB)) {
		geometryType = GeometryType.findName(tableColumn.getType());
	}
	return geometryType;
}

Source File: PropertiesCoreExtension.java From geopackage-core-java with MIT License

5 votes

/**
 * Get or create the extension
 * 
 * @return extension
 */
public Extensions getOrCreate() {

	// Create the attributes table
	if (!geoPackage.isTable(TABLE_NAME)) {

		AttributesColumn propertyColumn = AttributesColumn.createColumn(
				COLUMN_PROPERTY, GeoPackageDataType.TEXT, true, null);
		AttributesColumn valueColumn = AttributesColumn
				.createColumn(COLUMN_VALUE, GeoPackageDataType.TEXT);

		List<AttributesColumn> additionalColumns = new ArrayList<>();
		additionalColumns.add(propertyColumn);
		additionalColumns.add(valueColumn);

		List<Constraint> constraints = new ArrayList<>();
		constraints.add(new UniqueConstraint(propertyColumn, valueColumn));

		geoPackage.createAttributesTableWithId(TABLE_NAME,
				additionalColumns, constraints);
	}

	Extensions extension = getOrCreate(EXTENSION_NAME, TABLE_NAME, null,
			EXTENSION_DEFINITION, ExtensionScopeType.READ_WRITE);

	return extension;
}

Source File: FeatureCoreGenerator.java From geopackage-core-java with MIT License

5 votes

/**
 * Get the type for the object value
 * 
 * @param value
 *            value
 * @return data type
 */
public static GeoPackageDataType getType(Object value) {

	GeoPackageDataType type = null;

	if (value instanceof String) {
		type = GeoPackageDataType.TEXT;
	} else if (value instanceof Boolean) {
		type = GeoPackageDataType.BOOLEAN;
	} else if (value instanceof Byte) {
		type = GeoPackageDataType.TINYINT;
	} else if (value instanceof Short) {
		type = GeoPackageDataType.SMALLINT;
	} else if (value instanceof Integer) {
		type = GeoPackageDataType.MEDIUMINT;
	} else if (value instanceof Long) {
		type = GeoPackageDataType.INT;
	} else if (value instanceof Float) {
		type = GeoPackageDataType.FLOAT;
	} else if (value instanceof Double) {
		type = GeoPackageDataType.DOUBLE;
	} else if (value instanceof byte[]) {
		type = GeoPackageDataType.BLOB;
	}

	if (type == null) {
		type = GeoPackageDataType.TEXT;
	}

	return type;
}

Source File: TestUtils.java From geopackage-android with MIT License

5 votes

/**
 * Validate the integer value with the data type
 *
 * @param value
 * @param dataType
 * @return
 */
public static void validateIntegerValue(Object value,
                                        GeoPackageDataType dataType) {

    switch (dataType) {

        case BOOLEAN:
            TestCase.assertTrue(value instanceof Boolean);
            break;
        case TINYINT:
            TestCase.assertTrue(value instanceof Byte);
            break;
        case SMALLINT:
            TestCase.assertTrue(value instanceof Short);
            break;
        case MEDIUMINT:
            TestCase.assertTrue(value instanceof Integer);
            break;
        case INT:
        case INTEGER:
            TestCase.assertTrue(value instanceof Long);
            break;
        default:
            throw new GeoPackageException("Data Type " + dataType
                    + " is not an integer type");
    }
}

Source File: TestUtils.java From geopackage-java with MIT License

5 votes

/**
 * Validate the integer value with the data type
 * 
 * @param value
 * @param dataType
 */
public static void validateIntegerValue(Object value,
		GeoPackageDataType dataType) {

	switch (dataType) {

	case BOOLEAN:
		TestCase.assertTrue(value instanceof Boolean);
		break;
	case TINYINT:
		TestCase.assertTrue(value instanceof Byte);
		break;
	case SMALLINT:
		TestCase.assertTrue(value instanceof Short);
		break;
	case MEDIUMINT:
		TestCase.assertTrue(value instanceof Integer);
		break;
	case INT:
	case INTEGER:
		TestCase.assertTrue(value instanceof Long);
		break;
	default:
		throw new GeoPackageException(
				"Data Type " + dataType + " is not an integer type");
	}
}

Source File: UserColumns.java From geopackage-core-java with MIT License

5 votes

/**
 * Check for the expected data type
 * 
 * @param expected
 *            expected data type
 * @param column
 *            user column
 */
protected void typeCheck(GeoPackageDataType expected, TColumn column) {

	GeoPackageDataType actual = column.getDataType();
	if (actual == null || !actual.equals(expected)) {
		throw new GeoPackageException("Unexpected " + column.getName()
				+ " column data type was found for table '" + tableName
				+ "', expected: " + expected.name() + ", actual: "
				+ (actual != null ? actual.name() : "null"));
	}
}

Source File: RelatedTablesUtils.java From geopackage-java with MIT License

4 votes

/**
 * Create additional user table columns
 * 
 * @param notNull
 *            columns not null value
 * @return additional user table columns
 */
public static List<UserCustomColumn> createAdditionalUserColumns(
		boolean notNull) {

	List<UserCustomColumn> columns = new ArrayList<>();

	// Add Dublin Core Metadata term columns
	columns.add(UserCustomColumn.createColumn(
			DublinCoreType.DATE.getName(), GeoPackageDataType.DATETIME,
			notNull));
	columns.add(UserCustomColumn.createColumn(
			DublinCoreType.DESCRIPTION.getName(), GeoPackageDataType.TEXT,
			notNull));
	columns.add(UserCustomColumn.createColumn(
			DublinCoreType.SOURCE.getName(), GeoPackageDataType.TEXT,
			notNull));
	columns.add(UserCustomColumn.createColumn(
			DublinCoreType.TITLE.getName(), GeoPackageDataType.TEXT,
			notNull));

	// Add test columns for common data types, some with limits
	columns.add(UserCustomColumn.createColumn("test_text",
			GeoPackageDataType.TEXT, notNull, ""));
	columns.add(UserCustomColumn.createColumn("test_real",
			GeoPackageDataType.REAL, notNull));
	columns.add(UserCustomColumn.createColumn("test_boolean",
			GeoPackageDataType.BOOLEAN, notNull));
	columns.add(UserCustomColumn.createColumn("test_blob",
			GeoPackageDataType.BLOB, notNull));
	columns.add(UserCustomColumn.createColumn("test_integer",
			GeoPackageDataType.INTEGER, notNull));
	columns.add(UserCustomColumn.createColumn("test_text_limited",
			GeoPackageDataType.TEXT, 5L, notNull, null));
	columns.add(UserCustomColumn.createColumn("test_blob_limited",
			GeoPackageDataType.BLOB, 7L, notNull, null));
	columns.add(UserCustomColumn.createColumn("test_date",
			GeoPackageDataType.DATE, notNull));
	columns.add(UserCustomColumn.createColumn("test_datetime",
			GeoPackageDataType.DATETIME, notNull));

	return columns;
}

Source File: FeatureUtils.java From geopackage-android with MIT License

4 votes

/**
 * Validate a feature row
 *
 * @param columns
 * @param featureRow
 */
private static void validateFeatureRow(String[] columns,
                                       FeatureRow featureRow) {
    TestCase.assertEquals(columns.length, featureRow.columnCount());

    for (int i = 0; i < featureRow.columnCount(); i++) {
        FeatureColumn column = featureRow.getTable().getColumns().get(i);
        GeoPackageDataType dataType = column.getDataType();
        TestCase.assertEquals(i, column.getIndex());
        TestCase.assertEquals(columns[i], featureRow.getColumnName(i));
        TestCase.assertEquals(i, featureRow.getColumnIndex(columns[i]));
        int rowType = featureRow.getRowColumnType(i);
        Object value = featureRow.getValue(i);

        switch (rowType) {

            case Cursor.FIELD_TYPE_INTEGER:
                TestUtils.validateIntegerValue(value, column.getDataType());
                break;

            case Cursor.FIELD_TYPE_FLOAT:
                TestUtils.validateFloatValue(value, column.getDataType());
                break;

            case Cursor.FIELD_TYPE_STRING:
                if (dataType == GeoPackageDataType.DATE || dataType == GeoPackageDataType.DATETIME) {
                    TestCase.assertTrue(value instanceof Date);
                    Date date = (Date) value;
                    DateConverter converter = DateConverter.converter(dataType);
                    String dateString = converter.stringValue(date);
                    TestCase.assertEquals(date.getTime(), converter.dateValue(dateString).getTime());
                } else {
                    TestCase.assertTrue(value instanceof String);
                }
                break;

            case Cursor.FIELD_TYPE_BLOB:
                if (featureRow.getGeometryColumnIndex() == i) {
                    TestCase.assertTrue(value instanceof GeoPackageGeometryData);
                } else {
                    TestCase.assertTrue(value instanceof byte[]);
                }
                break;

            case Cursor.FIELD_TYPE_NULL:
                TestCase.assertNull(value);
                break;

        }
    }

    TestCase.assertTrue(featureRow.getId() >= 0);
}

Source File: AttributesUtils.java From geopackage-android with MIT License

4 votes

/**
 * Validate an attributes row
 *
 * @param columns
 * @param attributesRow
 */
private static void validateAttributesRow(String[] columns,
                                          AttributesRow attributesRow) {
    TestCase.assertEquals(columns.length, attributesRow.columnCount());

    for (int i = 0; i < attributesRow.columnCount(); i++) {
        AttributesColumn column = attributesRow.getTable().getColumns()
                .get(i);
        GeoPackageDataType dataType = column.getDataType();
        TestCase.assertEquals(i, column.getIndex());
        TestCase.assertEquals(columns[i], attributesRow.getColumnName(i));
        TestCase.assertEquals(i, attributesRow.getColumnIndex(columns[i]));
        int rowType = attributesRow.getRowColumnType(i);
        Object value = attributesRow.getValue(i);

        switch (rowType) {

            case ResultUtils.FIELD_TYPE_INTEGER:
                TestUtils.validateIntegerValue(value, column.getDataType());
                break;

            case ResultUtils.FIELD_TYPE_FLOAT:
                TestUtils.validateFloatValue(value, column.getDataType());
                break;

            case ResultUtils.FIELD_TYPE_STRING:
                if (dataType == GeoPackageDataType.DATE || dataType == GeoPackageDataType.DATETIME) {
                    TestCase.assertTrue(value instanceof Date);
                    Date date = (Date) value;
                    DateConverter converter = DateConverter.converter(dataType);
                    String dateString = converter.stringValue(date);
                    TestCase.assertEquals(date.getTime(), converter.dateValue(dateString).getTime());
                } else {
                    TestCase.assertTrue(value instanceof String);
                }
                break;

            case ResultUtils.FIELD_TYPE_BLOB:
                TestCase.assertTrue(value instanceof byte[]);
                break;

            case ResultUtils.FIELD_TYPE_NULL:
                TestCase.assertNull(value);
                break;

        }
    }

    TestCase.assertTrue(attributesRow.getId() >= 0);
}

Source File: RelatedTablesUtils.java From geopackage-android with MIT License

4 votes

/**
 * Create additional user table columns
 *
 * @param notNull columns not null value
 * @return additional user table columns
 */
public static List<UserCustomColumn> createAdditionalUserColumns(
        boolean notNull) {

    List<UserCustomColumn> columns = new ArrayList<>();

    // Add Dublin Core Metadata term columns
    columns.add(UserCustomColumn.createColumn(
            DublinCoreType.DATE.getName(), GeoPackageDataType.DATETIME,
            notNull));
    columns.add(UserCustomColumn.createColumn(
            DublinCoreType.DESCRIPTION.getName(), GeoPackageDataType.TEXT,
            notNull));
    columns.add(UserCustomColumn.createColumn(
            DublinCoreType.SOURCE.getName(), GeoPackageDataType.TEXT,
            notNull));
    columns.add(UserCustomColumn.createColumn(
            DublinCoreType.TITLE.getName(), GeoPackageDataType.TEXT,
            notNull));

    // Add test columns for common data types, some with limits
    columns.add(UserCustomColumn.createColumn("test_text",
            GeoPackageDataType.TEXT, notNull, ""));
    columns.add(UserCustomColumn.createColumn("test_real",
            GeoPackageDataType.REAL, notNull));
    columns.add(UserCustomColumn.createColumn("test_boolean",
            GeoPackageDataType.BOOLEAN, notNull));
    columns.add(UserCustomColumn.createColumn("test_blob",
            GeoPackageDataType.BLOB, notNull));
    columns.add(UserCustomColumn.createColumn("test_integer",
            GeoPackageDataType.INTEGER, notNull));
    columns.add(UserCustomColumn.createColumn("test_text_limited",
            GeoPackageDataType.TEXT, 5L, notNull, null));
    columns.add(UserCustomColumn.createColumn("test_blob_limited",
            GeoPackageDataType.BLOB, 7L, notNull, null));
    columns.add(UserCustomColumn.createColumn("test_date",
            GeoPackageDataType.DATE, notNull));
    columns.add(UserCustomColumn.createColumn("test_datetime",
            GeoPackageDataType.DATETIME, notNull));

    return columns;
}

Source File: UserColumn.java From geopackage-core-java with MIT License

4 votes

/**
 * Constructor
 * 
 * @param index
 *            column index
 * @param name
 *            column name
 * @param type
 *            string type
 * @param dataType
 *            data type
 * @param max
 *            max value
 * @param notNull
 *            not null flag
 * @param defaultValue
 *            default value
 * @param primaryKey
 *            primary key flag
 * @since 3.3.0
 */
protected UserColumn(int index, String name, String type,
		GeoPackageDataType dataType, Long max, boolean notNull,
		Object defaultValue, boolean primaryKey) {
	this.index = index;
	this.name = name;
	this.max = max;
	this.notNull = notNull;
	this.defaultValue = defaultValue;
	this.primaryKey = primaryKey;
	this.type = type;
	this.dataType = dataType;

	validateDataType(name, dataType);
	validateMax();

	addDefaultConstraints();
}

Source File: GeoPackageExample.java From geopackage-android with MIT License

4 votes

private static void createAttributes(GeoPackage geoPackage) {

        List<AttributesColumn> columns = new ArrayList<AttributesColumn>();

        columns.add(AttributesColumn.createColumn(TEXT_COLUMN,
                GeoPackageDataType.TEXT, false, ""));
        columns.add(AttributesColumn.createColumn(REAL_COLUMN,
                GeoPackageDataType.REAL));
        columns.add(AttributesColumn.createColumn(BOOLEAN_COLUMN,
                GeoPackageDataType.BOOLEAN));
        columns.add(AttributesColumn.createColumn(BLOB_COLUMN,
                GeoPackageDataType.BLOB));
        columns.add(AttributesColumn.createColumn(INTEGER_COLUMN,
                GeoPackageDataType.INTEGER));
        columns.add(AttributesColumn.createColumn(TEXT_LIMITED_COLUMN,
                GeoPackageDataType.TEXT, (long) UUID.randomUUID().toString()
                        .length()));
        columns.add(AttributesColumn.createColumn(BLOB_LIMITED_COLUMN,
                GeoPackageDataType.BLOB, (long) UUID.randomUUID().toString()
                        .getBytes().length));
        columns.add(AttributesColumn.createColumn(DATE_COLUMN,
                GeoPackageDataType.DATE));
        columns.add(AttributesColumn.createColumn(DATETIME_COLUMN,
                GeoPackageDataType.DATETIME));

        AttributesTable attributesTable = geoPackage
                .createAttributesTableWithId("attributes", columns);

        AttributesDao attributesDao = geoPackage
                .getAttributesDao(attributesTable.getTableName());

        for (int i = 0; i < 10; i++) {

            AttributesRow newRow = attributesDao.newRow();

            newRow.setValue(TEXT_COLUMN, UUID.randomUUID().toString());
            newRow.setValue(REAL_COLUMN, Math.random() * 5000.0);
            newRow.setValue(BOOLEAN_COLUMN, Math.random() < .5 ? false : true);
            newRow.setValue(BLOB_COLUMN, UUID.randomUUID().toString()
                    .getBytes());
            newRow.setValue(INTEGER_COLUMN, (int) (Math.random() * 500));
            newRow.setValue(TEXT_LIMITED_COLUMN, UUID.randomUUID().toString());
            newRow.setValue(BLOB_LIMITED_COLUMN, UUID.randomUUID().toString()
                    .getBytes());
            newRow.setValue(DATE_COLUMN, new Date());
            newRow.setValue(DATETIME_COLUMN, new Date());

            attributesDao.create(newRow);

        }
    }

Source File: UserInvalidCursor.java From geopackage-android with MIT License

4 votes

/**
 * {@inheritDoc}
 */
@Override
public Object getValue(int index, GeoPackageDataType dataType) {
    return cursor.getValue(index, dataType);
}

Source File: UserCursor.java From geopackage-android with MIT License

4 votes

/**
 * {@inheritDoc}
 */
@Override
public Object getValue(int index, GeoPackageDataType dataType) {
    return ResultUtils.getValue(invalidCursor == null ? this : invalidCursor, index, dataType);
}

Source File: GeoPackageExample.java From geopackage-java with MIT License

4 votes

private static void createAttributes(GeoPackage geoPackage) {

		List<AttributesColumn> columns = new ArrayList<AttributesColumn>();

		columns.add(AttributesColumn.createColumn(TEXT_COLUMN,
				GeoPackageDataType.TEXT, false, ""));
		columns.add(AttributesColumn.createColumn(REAL_COLUMN,
				GeoPackageDataType.REAL));
		columns.add(AttributesColumn.createColumn(BOOLEAN_COLUMN,
				GeoPackageDataType.BOOLEAN));
		columns.add(AttributesColumn.createColumn(BLOB_COLUMN,
				GeoPackageDataType.BLOB));
		columns.add(AttributesColumn.createColumn(INTEGER_COLUMN,
				GeoPackageDataType.INTEGER));
		columns.add(AttributesColumn.createColumn(TEXT_LIMITED_COLUMN,
				GeoPackageDataType.TEXT,
				(long) UUID.randomUUID().toString().length()));
		columns.add(AttributesColumn.createColumn(BLOB_LIMITED_COLUMN,
				GeoPackageDataType.BLOB,
				(long) UUID.randomUUID().toString().getBytes().length));
		columns.add(AttributesColumn.createColumn(DATE_COLUMN,
				GeoPackageDataType.DATE));
		columns.add(AttributesColumn.createColumn(DATETIME_COLUMN,
				GeoPackageDataType.DATETIME));

		AttributesTable attributesTable = geoPackage
				.createAttributesTableWithId("attributes", columns);

		AttributesDao attributesDao = geoPackage
				.getAttributesDao(attributesTable.getTableName());

		for (int i = 0; i < 10; i++) {

			AttributesRow newRow = attributesDao.newRow();

			newRow.setValue(TEXT_COLUMN, UUID.randomUUID().toString());
			newRow.setValue(REAL_COLUMN, Math.random() * 5000.0);
			newRow.setValue(BOOLEAN_COLUMN, Math.random() < .5 ? false : true);
			newRow.setValue(BLOB_COLUMN,
					UUID.randomUUID().toString().getBytes());
			newRow.setValue(INTEGER_COLUMN, (int) (Math.random() * 500));
			newRow.setValue(TEXT_LIMITED_COLUMN, UUID.randomUUID().toString());
			newRow.setValue(BLOB_LIMITED_COLUMN,
					UUID.randomUUID().toString().getBytes());
			newRow.setValue(DATE_COLUMN, new Date());
			newRow.setValue(DATETIME_COLUMN, new Date());

			attributesDao.create(newRow);

		}
	}

Source File: TileColumns.java From geopackage-core-java with MIT License

4 votes

/**
 * {@inheritDoc}
 */
@Override
protected void updateColumns() {
	super.updateColumns();

	// Find the required columns

	Integer zoomLevel = getColumnIndex(ZOOM_LEVEL, false);
	if (!isCustom()) {
		missingCheck(zoomLevel, ZOOM_LEVEL);
	}
	if (zoomLevel != null) {
		typeCheck(GeoPackageDataType.INTEGER, getColumn(zoomLevel));
		zoomLevelIndex = zoomLevel;
	}

	Integer tileColumn = getColumnIndex(TILE_COLUMN, false);
	if (!isCustom()) {
		missingCheck(tileColumn, TILE_COLUMN);
	}
	if (tileColumn != null) {
		typeCheck(GeoPackageDataType.INTEGER, getColumn(tileColumn));
		tileColumnIndex = tileColumn;
	}

	Integer tileRow = getColumnIndex(TILE_ROW, false);
	if (!isCustom()) {
		missingCheck(tileRow, TILE_ROW);
	}
	if (tileRow != null) {
		typeCheck(GeoPackageDataType.INTEGER, getColumn(tileRow));
		tileRowIndex = tileRow;
	}

	Integer tileData = getColumnIndex(TILE_DATA, false);
	if (!isCustom()) {
		missingCheck(tileData, TILE_DATA);
	}
	if (tileData != null) {
		typeCheck(GeoPackageDataType.BLOB, getColumn(tileData));
		tileDataIndex = tileData;
	}

}

Source File: FeatureUtils.java From geopackage-java with MIT License

4 votes

/**
 * Validate a feature row
 * 
 * @param columns
 * @param featureRow
 */
private static void validateFeatureRow(String[] columns,
		FeatureRow featureRow) {
	TestCase.assertEquals(columns.length, featureRow.columnCount());

	for (int i = 0; i < featureRow.columnCount(); i++) {
		FeatureColumn column = featureRow.getTable().getColumns().get(i);
		GeoPackageDataType dataType = column.getDataType();
		TestCase.assertEquals(i, column.getIndex());
		TestCase.assertEquals(columns[i], featureRow.getColumnName(i));
		TestCase.assertEquals(i, featureRow.getColumnIndex(columns[i]));
		int rowType = featureRow.getRowColumnType(i);
		Object value = featureRow.getValue(i);

		switch (rowType) {

		case ResultUtils.FIELD_TYPE_INTEGER:
			TestUtils.validateIntegerValue(value, column.getDataType());
			break;

		case ResultUtils.FIELD_TYPE_FLOAT:
			TestUtils.validateFloatValue(value, column.getDataType());
			break;

		case ResultUtils.FIELD_TYPE_STRING:
			if (dataType == GeoPackageDataType.DATE
					|| dataType == GeoPackageDataType.DATETIME) {
				TestCase.assertTrue(value instanceof Date);
				Date date = (Date) value;
				DateConverter converter = DateConverter.converter(dataType);
				String dateString = converter.stringValue(date);
				TestCase.assertEquals(date.getTime(),
						converter.dateValue(dateString).getTime());
			} else {
				TestCase.assertTrue(value instanceof String);
			}
			break;

		case ResultUtils.FIELD_TYPE_BLOB:
			if (featureRow.getGeometryColumnIndex() == i) {
				TestCase.assertTrue(value instanceof GeoPackageGeometryData);
			} else {
				TestCase.assertTrue(value instanceof byte[]);
			}
			break;

		case ResultUtils.FIELD_TYPE_NULL:
			TestCase.assertNull(value);
			break;

		}
	}

	TestCase.assertTrue(featureRow.getId() >= 0);
}

Source File: FeatureCoreGenerator.java From geopackage-core-java with MIT License

4 votes

/**
 * Get the value for the object value with the data type
 * 
 * @param value
 *            value
 * @param type
 *            data type
 * @return default value
 */
public static Object getValue(Object value, GeoPackageDataType type) {

	if (value != null && type != null) {

		switch (type) {
		case TEXT:
		case DATE:
		case DATETIME:
			value = value.toString();
			break;
		case BOOLEAN:
			value = (Boolean) value;
			break;
		case TINYINT:
			value = (Byte) value;
			break;
		case SMALLINT:
			value = (Short) value;
			break;
		case MEDIUMINT:
			value = (Integer) value;
			break;
		case INT:
		case INTEGER:
			value = (Long) value;
			break;
		case FLOAT:
			value = (Float) value;
			break;
		case DOUBLE:
		case REAL:
			value = (Double) value;
			break;
		case BLOB:
			value = (byte[]) value;
			break;
		default:
			throw new GeoPackageException("Unsupported Data Type " + type);
		}

	}

	return value;
}

Source File: FeatureColumn.java From geopackage-core-java with MIT License

3 votes

/**
 * Constructor
 * 
 * @param index
 *            index
 * @param name
 *            name
 * @param dataType
 *            data type
 * @param max
 *            max value
 * @param notNull
 *            not null flag
 * @param defaultValue
 *            default value
 * @param primaryKey
 *            primary key flag
 * @param geometryType
 *            geometry type
 */
private FeatureColumn(int index, String name, GeoPackageDataType dataType,
		Long max, boolean notNull, Object defaultValue, boolean primaryKey,
		GeometryType geometryType) {
	super(index, name, getTypeName(name, dataType, geometryType), dataType,
			max, notNull, defaultValue, primaryKey);
	this.geometryType = geometryType;
}

Source File: FeatureColumn.java From geopackage-core-java with MIT License

3 votes

/**
 * Create a new column
 * 
 * @param index
 *            index
 * @param name
 *            name
 * @param type
 *            data type
 * @param max
 *            max value
 * @param notNull
 *            not null flag
 * @param defaultValue
 *            default value
 * @return feature column
 */
public static FeatureColumn createColumn(int index, String name,
		GeoPackageDataType type, Long max, boolean notNull,
		Object defaultValue) {
	return new FeatureColumn(index, name, type, max, notNull, defaultValue,
			false, null);
}

mil.nga.geopackage.db.GeoPackageDataType Java Examples