SDN-R Database for Instanbul

In Istanbul we will switch from Elasticsearch to MariaDB (min. 10.2.7). In fact that the ccsdk/sli project has already established mysql/mariadb-reader/writer we don't have to do it again, and just connect to the service provided by dblib-provider.

What we have to do is the complete object mapping, because we like to have our own yang-based implementation. So we have to create:

• CREATE TABLE statements

• INSERT INTO statements 

• SELECT FROM statements

based on yang-generated interface classes plus  adapted search filter functions from data-provider to mariadb (including pagination)

In fact we like to use it as a multi-domain(multi-site) database, there will be an additional porperty for all entries called 'odl-id'.

Table structure mapping

The table structure mapping will be based on the yang-generated interface class and its getters. The java types were mapped like this:

Tables