contract-definition-store-sql

SQL Contract Definition

Provides SQL persistence for contract definitions.

Prerequisites

Please apply this schema to your SQL database.

Entity Diagram

Configuration

Key	Description	Mandatory
edc.datasource.contractdefinition.name	Datasource used by this extension	X

Create a flexible query API to accommodate QuerySpec

For the first version, only the limit and offset arguments from the QuerySpec will be used.

For subsequent versions it is recommended to re-use the Clause interface and its implementors, that were originally implemented for CosmosDB, and create an equivalent set of clauses for SQL. Thus, there would be a Limit-, Offset- , Order- and WhereClause for SQL.

That way, dialect-dependent variants can be implemented should the need arise, because the actual SQL statement is encoded in those clauses, offering a fluent Java API.