mil.nga.geopackage.db.DateConverter Java Exaples

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

5 votes

private static void createPropertiesExtension(GeoPackage geoPackage) {

        PropertiesExtension properties = new PropertiesExtension(geoPackage);

        String dateTime = DateConverter.dateTimeConverter().stringValue(
                new Date());

        properties.addValue(PropertyNames.TITLE, "GeoPackage Android Example");
        properties.addValue(PropertyNames.VERSION, "3.2.0");
        properties.addValue(PropertyNames.CREATOR, "NGA");
        properties.addValue(PropertyNames.PUBLISHER, "NGA");
        properties.addValue(PropertyNames.CONTRIBUTOR, "Brian Osborn");
        properties.addValue(PropertyNames.CONTRIBUTOR, "Dan Barela");
        properties.addValue(PropertyNames.CREATED, dateTime);
        properties.addValue(PropertyNames.DATE, dateTime);
        properties.addValue(PropertyNames.MODIFIED, dateTime);
        properties
                .addValue(
                        PropertyNames.DESCRIPTION,
                        "GeoPackage example created by https://github.com/ngageoint/geopackage-android/blob/master/geopackage-sdk/src/androidTest/java/mil/nga/geopackage/test/GeoPackageExample.java");
        properties.addValue(PropertyNames.IDENTIFIER, "geopackage-android");
        properties.addValue(PropertyNames.LICENSE, "MIT");
        properties
                .addValue(
                        PropertyNames.SOURCE,
                        "http://github.com/ngageoint/GeoPackage/blob/master/docs/examples/android/example.gpkg");
        properties.addValue(PropertyNames.SUBJECT, "Examples");
        properties.addValue(PropertyNames.TYPE, "Examples");
        properties.addValue(PropertyNames.URI,
                "http://github.com/ngageoint/geopackage-android");
        properties.addValue(PropertyNames.TAG, "NGA");
        properties.addValue(PropertyNames.TAG, "Example");
        properties.addValue(PropertyNames.TAG, "BIT Systems");

    }

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

5 votes

/**
 * {@inheritDoc}
 */
@Override
public Object parseDefaultString(FieldType fieldType, String defaultStr) {
	Object defaultValue = null;
	if (DateConverter.DATETIME_FORMAT.equals(defaultStr)) {
		defaultValue = javaToSqlArg(null, new Date());
	}
	return defaultValue;
}

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

5 votes

/**
 * Set the time
 * 
 * @param time
 *            time
 */
public void setTime(Date time) {
	if (time != null) {
		DateConverter dateConverter = DateConverter
				.dateConverter(DateConverter.DATETIME_FORMAT2);
		this.time = dateConverter.stringValue(time);
	} else {
		this.time = null;
	}
}

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

5 votes

/**
 * Set the time period
 * 
 * @param period
 *            period
 */
public void setPeriod(Date period) {
	if (period != null) {
		DateConverter dateConverter = DateConverter
				.dateConverter(DateConverter.DATETIME_FORMAT2);
		this.period = dateConverter.stringValue(period);
	} else {
		this.period = null;
	}
}

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

5 votes

private static void createPropertiesExtension(GeoPackage geoPackage) {

		PropertiesExtension properties = new PropertiesExtension(geoPackage);

		String dateTime = DateConverter.dateTimeConverter()
				.stringValue(new Date());

		properties.addValue(PropertyNames.TITLE, "GeoPackage Java Example");
		properties.addValue(PropertyNames.VERSION, "3.2.0");
		properties.addValue(PropertyNames.CREATOR, "NGA");
		properties.addValue(PropertyNames.PUBLISHER, "NGA");
		properties.addValue(PropertyNames.CONTRIBUTOR, "Brian Osborn");
		properties.addValue(PropertyNames.CONTRIBUTOR, "Dan Barela");
		properties.addValue(PropertyNames.CREATED, dateTime);
		properties.addValue(PropertyNames.DATE, dateTime);
		properties.addValue(PropertyNames.MODIFIED, dateTime);
		properties.addValue(PropertyNames.DESCRIPTION,
				"GeoPackage example created by http://github.com/ngageoint/geopackage-java/blob/master/src/test/java/mil/nga/geopackage/test/GeoPackageExample.java");
		properties.addValue(PropertyNames.IDENTIFIER, "geopackage-java");
		properties.addValue(PropertyNames.LICENSE, "MIT");
		properties.addValue(PropertyNames.SOURCE,
				"http://github.com/ngageoint/GeoPackage/blob/master/docs/examples/java/example.gpkg");
		properties.addValue(PropertyNames.SUBJECT, "Examples");
		properties.addValue(PropertyNames.TYPE, "Examples");
		properties.addValue(PropertyNames.URI,
				"http://github.com/ngageoint/geopackage-java");
		properties.addValue(PropertyNames.TAG, "NGA");
		properties.addValue(PropertyNames.TAG, "Example");
		properties.addValue(PropertyNames.TAG, "BIT Systems");

	}

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

4 votes

/**
 * Map the column to the content values
 *
 * @param contentValues content values
 * @param column        column
 * @param value         value
 */
protected void columnToContentValue(ContentValues contentValues,
                                    TColumn column, Object value) {

    String columnName = column.getName();

    if (value instanceof Number) {
        if (value instanceof Byte) {
            validateValue(column, value, Byte.class, Short.class,
                    Integer.class, Long.class);
            contentValues.put(columnName, (Byte) value);
        } else if (value instanceof Short) {
            validateValue(column, value, Short.class, Integer.class,
                    Long.class);
            contentValues.put(columnName, (Short) value);
        } else if (value instanceof Integer) {
            validateValue(column, value, Integer.class, Long.class);
            contentValues.put(columnName, (Integer) value);
        } else if (value instanceof Long) {
            validateValue(column, value, Long.class, Double.class);
            contentValues.put(columnName, (Long) value);
        } else if (value instanceof Float) {
            validateValue(column, value, Float.class);
            contentValues.put(columnName, (Float) value);
        } else if (value instanceof Double) {
            validateValue(column, value, Double.class);
            contentValues.put(columnName, (Double) value);
        } else {
            throw new GeoPackageException("Unsupported Number type: "
                    + value.getClass().getSimpleName());
        }
    } else if (value instanceof String) {
        validateValue(column, value, String.class);
        String stringValue = (String) value;
        if (column.getMax() != null
                && stringValue.length() > column.getMax()) {
            throw new GeoPackageException(
                    "String is larger than the column max. Size: "
                            + stringValue.length() + ", Max: "
                            + column.getMax() + ", Column: " + columnName);
        }
        contentValues.put(columnName, stringValue);
    } else if (value instanceof byte[]) {
        validateValue(column, value, byte[].class);
        byte[] byteValue = (byte[]) value;
        if (column.getMax() != null && byteValue.length > column.getMax()) {
            throw new GeoPackageException(
                    "Byte array is larger than the column max. Size: "
                            + byteValue.length + ", Max: "
                            + column.getMax() + ", Column: " + columnName);
        }
        contentValues.put(columnName, byteValue);
    } else if (value instanceof Boolean) {
        validateValue(column, value, Boolean.class);
        Boolean booleanValue = (Boolean) value;
        short shortBoolean = booleanValue ? (short) 1 : (short) 0;
        contentValues.put(columnName, shortBoolean);
    } else if (value instanceof Date) {
        validateValue(column, value, Date.class, String.class);
        Date dateValue = (Date) value;
        DateConverter converter = DateConverter.converter(column
                .getDataType());
        String dateString = converter.stringValue(dateValue);
        contentValues.put(columnName, dateString);
    } else {
        throw new GeoPackageException(
                "Unsupported update column value. column: " + columnName
                        + ", value: " + value);
    }
}

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

4 votes

/**
 * Populate the user row additional column values
 *
 * @param userTable   user custom table
 * @param userRow     user custom row
 * @param skipColumns columns to skip populating
 */
public static void populateUserRow(UserCustomTable userTable,
                                   UserCustomRow userRow, List<String> skipColumns) {

    Set<String> skipColumnsSet = new HashSet<>(skipColumns);

    for (UserCustomColumn column : userTable.getColumns()) {
        if (!skipColumnsSet.contains(column.getName())) {

            // Leave nullable columns null 20% of the time
            if (!column.isNotNull()
                    && DublinCoreType.fromName(column.getName()) == null) {
                if (Math.random() < 0.2) {
                    continue;
                }
            }

            Object value = null;

            switch (column.getDataType()) {

                case TEXT:
                    String text = UUID.randomUUID().toString();
                    if (column.getMax() != null
                            && text.length() > column.getMax()) {
                        text = text.substring(0, column.getMax().intValue());
                    }
                    value = text;
                    break;
                case REAL:
                case DOUBLE:
                    value = Math.random() * 5000.0;
                    break;
                case BOOLEAN:
                    value = Math.random() < .5 ? false : true;
                    break;
                case INTEGER:
                case INT:
                    value = (int) (Math.random() * 500);
                    break;
                case BLOB:
                    byte[] blob = UUID.randomUUID().toString().getBytes();
                    if (column.getMax() != null
                            && blob.length > column.getMax()) {
                        byte[] blobLimited = new byte[column.getMax()
                                .intValue()];
                        ByteBuffer.wrap(blob, 0, column.getMax().intValue())
                                .get(blobLimited);
                        blob = blobLimited;
                    }
                    value = blob;
                    break;
                case DATE:
                case DATETIME:
                    DateConverter converter = DateConverter.converter(column
                            .getDataType());
                    Date date = new Date();
                    if (Math.random() < .5) {
                        value = date;
                    } else {
                        value = converter.stringValue(date);
                    }
                    break;
                default:
                    throw new UnsupportedOperationException(
                            "Not implemented for data type: "
                                    + column.getDataType());
            }

            userRow.setValue(column.getName(), value);

        }
    }
}

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

4 votes

/**
 * Validate a user row
 *
 * @param columns array of columns
 * @param userRow user custom row
 */
public static void validateUserRow(String[] columns, UserCustomRow userRow) {

    TestCase.assertEquals(columns.length, userRow.columnCount());

    for (int i = 0; i < userRow.columnCount(); i++) {
        UserCustomColumn column = userRow.getTable().getColumns().get(i);
        GeoPackageDataType dataType = column.getDataType();
        TestCase.assertEquals(i, column.getIndex());
        TestCase.assertEquals(columns[i], userRow.getColumnName(i));
        TestCase.assertEquals(i, userRow.getColumnIndex(columns[i]));
        int rowType = userRow.getRowColumnType(i);
        Object value = userRow.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;

        }
    }

}

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: TableInfo.java From geopackage-core-java with MIT License

4 votes

/**
 * Get the default object value for the string default value with the data
 * type
 * 
 * @param defaultValue
 *            default value
 * @param type
 *            data type
 * @return default value
 */
public static Object getDefaultValue(String defaultValue,
		GeoPackageDataType type) {
	Object value = defaultValue;

	if (defaultValue != null && type != null
			&& !defaultValue.equalsIgnoreCase(DEFAULT_NULL)) {

		switch (type) {
		case TEXT:
			break;
		case DATE:
		case DATETIME:
			if (!DateConverter.isFunction(defaultValue)) {
				DateConverter converter = DateConverter.converter(type);
				try {
					value = converter.dateValue(defaultValue);
				} catch (Exception e) {
					logger.log(
							Level.WARNING, "Invalid " + type + " format: "
									+ defaultValue + ", String value used",
							e);
				}
			}
			break;
		case BOOLEAN:
			value = Integer.parseInt(defaultValue) == 0 ? Boolean.FALSE
					: Boolean.TRUE;
			break;
		case TINYINT:
			value = Byte.parseByte(defaultValue);
			break;
		case SMALLINT:
			value = Short.parseShort(defaultValue);
			break;
		case MEDIUMINT:
			value = Integer.parseInt(defaultValue);
			break;
		case INT:
		case INTEGER:
			value = Long.parseLong(defaultValue);
			break;
		case FLOAT:
			value = Float.parseFloat(defaultValue);
			break;
		case DOUBLE:
		case REAL:
			value = Double.parseDouble(defaultValue);
			break;
		case BLOB:
			value = defaultValue.getBytes();
			break;
		default:
			throw new GeoPackageException("Unsupported Data Type " + type);
		}

	}

	return value;
}

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

4 votes

/**
 * Map the column to the content values
 * 
 * @param contentValues
 *            content values
 * @param column
 *            column
 * @param value
 *            value
 */
protected void columnToContentValue(ContentValues contentValues,
		TColumn column, Object value) {

	String columnName = column.getName();

	if (value instanceof Number) {
		if (value instanceof Byte) {
			validateValue(column, value, Byte.class, Short.class,
					Integer.class, Long.class);
			contentValues.put(columnName, (Byte) value);
		} else if (value instanceof Short) {
			validateValue(column, value, Short.class, Integer.class,
					Long.class);
			contentValues.put(columnName, (Short) value);
		} else if (value instanceof Integer) {
			validateValue(column, value, Integer.class, Long.class);
			contentValues.put(columnName, (Integer) value);
		} else if (value instanceof Long) {
			validateValue(column, value, Long.class, Double.class);
			contentValues.put(columnName, (Long) value);
		} else if (value instanceof Float) {
			validateValue(column, value, Float.class);
			contentValues.put(columnName, (Float) value);
		} else if (value instanceof Double) {
			validateValue(column, value, Double.class);
			contentValues.put(columnName, (Double) value);
		} else {
			throw new GeoPackageException("Unsupported Number type: "
					+ value.getClass().getSimpleName());
		}
	} else if (value instanceof String) {
		validateValue(column, value, String.class);
		String stringValue = (String) value;
		if (column.getMax() != null
				&& stringValue.length() > column.getMax()) {
			throw new GeoPackageException(
					"String is larger than the column max. Size: "
							+ stringValue.length() + ", Max: "
							+ column.getMax() + ", Column: " + columnName);
		}
		contentValues.put(columnName, stringValue);
	} else if (value instanceof byte[]) {
		validateValue(column, value, byte[].class);
		byte[] byteValue = (byte[]) value;
		if (column.getMax() != null && byteValue.length > column.getMax()) {
			throw new GeoPackageException(
					"Byte array is larger than the column max. Size: "
							+ byteValue.length + ", Max: " + column.getMax()
							+ ", Column: " + columnName);
		}
		contentValues.put(columnName, byteValue);
	} else if (value instanceof Boolean) {
		validateValue(column, value, Boolean.class);
		Boolean booleanValue = (Boolean) value;
		short shortBoolean = booleanValue ? (short) 1 : (short) 0;
		contentValues.put(columnName, shortBoolean);
	} else if (value instanceof Date) {
		validateValue(column, value, Date.class, String.class);
		Date dateValue = (Date) value;
		DateConverter converter = DateConverter
				.converter(column.getDataType());
		String dateString = converter.stringValue(dateValue);
		contentValues.put(columnName, dateString);
	} else {
		throw new GeoPackageException(
				"Unsupported update column value. column: " + columnName
						+ ", value: " + value);
	}
}

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

4 votes

/**
 * Populate the user row additional column values
 * 
 * @param userTable
 *            user custom table
 * @param userRow
 *            user custom row
 * @param skipColumns
 *            columns to skip populating
 */
public static void populateUserRow(UserCustomTable userTable,
		UserCustomRow userRow, List<String> skipColumns) {

	Set<String> skipColumnsSet = new HashSet<>(skipColumns);

	for (UserCustomColumn column : userTable.getColumns()) {
		if (!skipColumnsSet.contains(column.getName())) {

			// Leave nullable columns null 20% of the time
			if (!column.isNotNull()
					&& DublinCoreType.fromName(column.getName()) == null) {
				if (Math.random() < 0.2) {
					continue;
				}
			}

			Object value = null;

			switch (column.getDataType()) {

			case TEXT:
				String text = UUID.randomUUID().toString();
				if (column.getMax() != null
						&& text.length() > column.getMax()) {
					text = text.substring(0, column.getMax().intValue());
				}
				value = text;
				break;
			case REAL:
			case DOUBLE:
				value = Math.random() * 5000.0;
				break;
			case BOOLEAN:
				value = Math.random() < .5 ? false : true;
				break;
			case INTEGER:
			case INT:
				value = (int) (Math.random() * 500);
				break;
			case BLOB:
				byte[] blob = UUID.randomUUID().toString().getBytes();
				if (column.getMax() != null
						&& blob.length > column.getMax()) {
					byte[] blobLimited = new byte[column.getMax()
							.intValue()];
					ByteBuffer.wrap(blob, 0, column.getMax().intValue())
							.get(blobLimited);
					blob = blobLimited;
				}
				value = blob;
				break;
			case DATE:
			case DATETIME:
				DateConverter converter = DateConverter.converter(column
						.getDataType());
				Date date = new Date();
				if (Math.random() < .5) {
					value = date;
				} else {
					value = converter.stringValue(date);
				}
				break;
			default:
				throw new UnsupportedOperationException(
						"Not implemented for data type: "
								+ column.getDataType());
			}

			userRow.setValue(column.getName(), value);

		}
	}
}

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

4 votes

/**
 * Validate a user row
 * 
 * @param columns
 *            array of columns
 * @param userRow
 *            user custom row
 */
public static void validateUserRow(String[] columns, UserCustomRow userRow) {

	TestCase.assertEquals(columns.length, userRow.columnCount());

	for (int i = 0; i < userRow.columnCount(); i++) {
		UserCustomColumn column = userRow.getTable().getColumns().get(i);
		GeoPackageDataType dataType = column.getDataType();
		TestCase.assertEquals(i, column.getIndex());
		TestCase.assertEquals(columns[i], userRow.getColumnName(i));
		TestCase.assertEquals(i, userRow.getColumnIndex(columns[i]));
		int rowType = userRow.getRowColumnType(i);
		Object value = userRow.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;

		}
	}

}

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: AttributesUtils.java From geopackage-java 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);
}

mil.nga.geopackage.db.DateConverter Java Examples