Web-service that provides REST API to manage business rules and its integrity on different systems

Functions

Business Rule

• extract rules from the systems
• extract a rule by ID from the systems
• create a rule on the systems (process in queue)
• update a rule on the systems (process in queue)
• delete a rule from the systems (process in queue)

Integrity

• verify integrity
• restore integrity (process in queue)

Task Queue

• extract task queue and currently executing task from the queue
• extract task results
• delete task results by time

Database

SQLite database schema

Technologies and tools

• Java 8
• Spring framework (Boot, Web, Test, Actuator, slf4j/logback)
• SQLite
• JDBC
• Apache DBCP (connection pooling framework)
• Concurrency
• Message Queue
• Maven
• Git
• IntelliJ IDEA
• Insomnia REST Client
• Visual VM (Java profiler)
• SQLite Studio

TODO

• make task queue capacity, api key, connection pool parameters configurable
• add unit tests
• manage rule asynchronically (one thread per system) using thread pool
• take tasks from external message queue (ActiveMQ)