gerrit.onap Code Review - music/mdbc.git/commit

author	Tschaen, Brendan <ctschaen@att.com>
	Thu, 18 Apr 2019 15:08:14 +0000 (11:08 -0400)
committer	Tschaen, Brendan <ctschaen@att.com>
	Thu, 18 Apr 2019 15:31:57 +0000 (11:31 -0400)
commit	601050a535e916c0ff52826fbe2c61b798c74530
tree	137402ea91c92dcc9b41d5b431ca797c50dc621b	tree \| snapshot
parent	eff522e4e38b11432f518d1b43fda01d8d387ca4	commit \| diff

Switch to calcite query parser

Handle SQL Joins
Return Schema/DB and table as range

Change-Id: I9455da1e9118bc547bf28e5f22cce2cf044ce75a
Issue-ID: MUSIC-380
Signed-off-by: Tschaen, Brendan <ctschaen@att.com>

mdbc-server/src/main/java/org/onap/music/mdbc/MDBCUtils.java		diff \| blob \| history
mdbc-server/src/main/java/org/onap/music/mdbc/MdbcConnection.java		diff \| blob \| history
mdbc-server/src/main/java/org/onap/music/mdbc/mixins/MySQLMixin.java		diff \| blob \| history
mdbc-server/src/main/java/org/onap/music/mdbc/query/Operation.java	[deleted file]	blob \| history
mdbc-server/src/main/java/org/onap/music/mdbc/query/QueryProcessor.java		diff \| blob \| history
mdbc-server/src/main/java/org/onap/music/mdbc/query/SQLOperation.java	[new file with mode: 0644]	blob
mdbc-server/src/main/java/org/onap/music/mdbc/query/SQLOperationType.java	[moved from mdbc-server/src/main/java/org/onap/music/mdbc/tables/OperationType.java with 91% similarity]	diff \| blob \| history
mdbc-server/src/main/java/org/onap/music/mdbc/tables/Operation.java		diff \| blob \| history
mdbc-server/src/main/java/org/onap/music/mdbc/tables/StagingTable.java		diff \| blob \| history
mdbc-server/src/test/java/org/onap/music/mdbc/MDBCUtilsTest.java		diff \| blob \| history
mdbc-server/src/test/java/org/onap/music/mdbc/query/QueryProcessorTest.java		diff \| blob \| history

The most crucial recipe is a multi-site database cache (mdbc) that enable ONAP components that maintain state in a SQL database to avail the benefits of MUSIC without compromising their need to use transactional SQL DBs. These ONAP components can rely on existing db clustering techniques like MariaDB for transactionality and complex querying within a site. mdbc will intercept each of these read/write calls to the db cluster and mirror this state to other geo-distributed sites through MUSIC either synchronously or asynchronously (configurable at a table-level). For example, components like the ONAP Service Orchestrator that use MariaDB to maintain state can directly use this recipe with no change to their SQL code.

RSS Atom