Code Review / music / mdbc.git / commit
? search:
summary | shortlog | log | commit | commitdiff | review | tree
(parent: 601050a) | patch
Fall back sql parsing option 78/86678/1
authorTschaen, Brendan <ctschaen@att.com>
Tue, 30 Apr 2019 20:17:27 +0000 (16:17 -0400)
committerTschaen, Brendan <ctschaen@att.com>
Tue, 30 Apr 2019 20:17:27 +0000 (16:17 -0400)
commit04ab8895cde445cb3895d6875e5040921f2a38ca
tree73795af3098a25302a73b14307e10e2822384803tree | snapshot
parent601050a535e916c0ff52826fbe2c61b798c74530commit | diff
Fall back sql parsing option

If we can't parse the sql query, use basic string analysis
to attempt to find the tables

Change-Id: Ibb81186e1fb768ee2c7c39b11922c99b79bf942d
Issue-ID: MUSIC-391
Signed-off-by: Tschaen, Brendan <ctschaen@att.com>
mdbc-server/src/main/java/org/onap/music/mdbc/MdbcConnection.java diff | blob | history
mdbc-server/src/main/java/org/onap/music/mdbc/query/QueryProcessor.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.