org.opengis.cite.gpkg12.extensions.relatedtables.SimpleAttributesTests Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of ets-gpkg12 Show documentation
This test suite checks GeoPackage 1.2 files for standards conformance.
The newest version!
package org.opengis.cite.gpkg12.extensions.relatedtables;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.opengis.cite.gpkg12.ErrorMessage;
import org.opengis.cite.gpkg12.ErrorMessageKeys;
import org.testng.Assert;
import org.testng.ITestContext;
import org.testng.annotations.BeforeClass;
import org.testng.annotations.Test;

/**
 * Defines test methods that apply to the "Simple Attributes" requirements class of the
 * Related Tables Extension.
 *
 * 
 * Sources
 * 
 * 
 *  GeoPackage Related Tables Extension, Simple Attributes Extension (OGC
 * 18-000)
 * 
 *
 * @author Jeff Yutzler
 */
public class SimpleAttributesTests extends RTEBase {

	/**
	 * A user-defined related data table or view SHALL be a user-defined simple attribute
	 * table or view if the row in gpkgext_relations with a corresponding
	 * related_table_name has a relation_name of "simple_attributes".
	 * @param testContext a test context
	 * @throws SQLException On any SQL query error or test failure
	 *
	 */
	@BeforeClass
	public void activeExtension(ITestContext testContext) throws SQLException {
		super.activeExtension(testContext);
		testRequirementsClassActive("simple_attributes", "Simple Attributes");
	}

	/**
	 * A user-defined simple attribute table or view SHALL contain the primary key column
	 * and at least one other column as defined in User-Defined Simple Attributes Table
	 * Definition. A user-defined simple attribute table SHALL only contain data belonging
	 * to the TEXT, INTEGER, or REAL storage classes and SHALL NOT contain NULL or BLOB
	 * storage classes (e.g., GEOMETRY).
	 * @throws SQLException On any SQL query error or test failure
	 *
	 * @see OGC 18-000 Requirement 15
	 */
	@Test(description = "See OGC 18-000: Requirement 15")
	public void attributesTableDefinition() throws SQLException {

		try (final Statement statement = this.databaseConnection.createStatement();

				final ResultSet resultSet = statement.executeQuery(
						"SELECT related_table_name FROM gpkgext_relations WHERE relation_name = 'simple_attributes';");) {

			while (resultSet.next()) {
				final String simpleAttributesTableName = resultSet.getString("related_table_name");
				getPrimaryKeyColumn(simpleAttributesTableName, true);
				try (final Statement statement2 = this.databaseConnection.createStatement();

						final ResultSet resultSet2 = statement2
							.executeQuery(String.format("PRAGMA table_info(%s)", simpleAttributesTableName));) {
					while (resultSet2.next()) {
						final String type = resultSet2.getString("type");
						final String name = resultSet2.getString("name");
						switch (type) {
							case "BLOB":
								Assert.fail(ErrorMessage.format(ErrorMessageKeys.INVALID_DATA_TYPE, type, name,
										simpleAttributesTableName));
								break;
							default:
								break;
						}
						final int notNull = resultSet2.getInt("notnull");
						Assert.assertEquals(notNull, 1, ErrorMessage.format(ErrorMessageKeys.INVALID_COLUMN_DEFINITION,
								name, simpleAttributesTableName, "notnull", 1, notNull));
					}
				}
			}
		}
	}

}