Sensor Web Server DB model v2.0.1

Available in Maven Central.

Change Log

• Fix resultTime declared not-nullable in ObservationEntity (77b7122)

Dependency Updates

None

Breaking Changes

None

See here for the complete commit log.

Sensor Web Server DB model v2.0.0

Available in Maven Central.

Change Log

• Add staIdentifier to DescribableEntity and to mappings of:
  • datastream
  • feature
  • location
  • historicalLocation
  • phenomenon
  • platform
  • procedure
  • data/observation
• Fix equals and hasCode for non sta entites
• Update hibernate to 5.4.15.Final
• Implement ObservationEntity replacing StaDataEntity
• Remove not used service mappings
• Fix thing_location relation mapping by setting foreign key properties to not null
• Update documentation
• Remove obsolete methods, now in DescribableEntity
• Add setStaIdentifier in copy/as methods
• Add flag whether sta supports urls, default value is false
• Add check for time period as sampling times
• Create a TreeSet before returning values to sort by id
• Add order in composite values
• fix missing property name constant for OM_ObservationType
• Allow resultTime to be null to support STA feature of null resultTime
• Add method hasResultTime

Dependency Updates

• Update geotools from 22.3 to 23.0
• Bump version.junit from 5.6.1 to 5.6.2 (#67)
• Bump ojdbc8 from 19.3.0.0 to 19.6.0.0 (#68)
• Bump joda-time from 2.10.5 to 2.10.6 (#69)
• Bump mysql-connector-java from 8.0.19 to 8.0.20 (#70)
• Bump jaxb-impl from 2.3.2 to 2.3.3 (#71)
• Bump mysql-connector-java from 8.0.19 to 8.0.20 (#72 )
• Bump spring-boot-dependencies from 2.2.6.RELEASE to 2.2.7.RELEASE (#74 )
• Bump spring-boot-dependencies from 2.2.7.RELEASE to 2.3.0.RELEASE (#75 )
• update hibernate to 5.4.16.Final

Breaking Changes

• result_time column is nullable
• Added sta_identifier not null column to the tables:
  • datastream
  • feature
  • location
  • historicalLocation
  • phenomenon
  • platform
  • procedure
  • observation

A SQL update script for ProstgreSQL is avalable here:

https://github.com/52North/sensorweb-server-db-model/blob/develop/etc/db/postgresql/update_130_200.sql

See here for the complete commit log.

Sensor Web Server DB model v1.3.0

Available in Maven Central.

Change Log

• Fixes #66: DataEntity equals() and hashCode() solely based on id

Dependency Updates

• Bump version.junit from 5.6.0 to 5.6.1 (#62)
• Bump geolatte-geom from 1.5.0 to 1.5.1 (#63)
• Bump spring-boot-dependencies from 2.2.5.RELEASE to 2.2.6.RELEASE (#64)
• Bump postgis-jdbc from 2.4.0 to 2.5.0 (#65)

Breaking Changes

See here for the complete commit log.

Sensor Web Server DB model v1.2.0

Available in Maven Central.

Change Log

• Remove obsolete map definition
• Organie imports
• Update table metadata doc
• Fix incorrect return type in ObservablePropertyEntitiy
• Add missing constuctor in StaDataEntity
• Refactor settery in DatastreamEntity into functional style
• Add missing FeatureEntity wrapper
• Fix spotbugs warnings

Dependency Updates

• Bump spring-boot-dependencies from 2.2.4.RELEASE to 2.2.5.RELEASE (#59)
• Bump ojdbc8 from 12.2.0.1 to 19.3.0.0 (#60)
• Bump postgis-jdbc from 2.3.0 to 2.4.0 (#61)
• Update hibernate to 5.4.12.Final

Breaking Changes

See here for the complete commit log.