This document describes how to link DB data using DB Storage and Storage blocks.
Index
Storage
1) Create DB Storage
No. | Function |
1 | Create DB Storage - Studio > Storage > DB Storage > + Create Storage |
2 | Select DB Type MySQL |
3 | Create Storage - Select the appropriate Group > Create Storage- Database Type : MySQL |
2) Register Query
No. | Function |
1 | Create Query - Studio > Storage > Query Manager > + Create Query |
2 | Enter relevant information in the Create Query window
- Mapping ID : Use to call Query on NBlock
- Query : Register query statements created by SQL grammar |
NBlock
1) Configure the data to be used as a Bind parameter in the Request Body
2) Connect DB Storage and Query Blocks on BizUnit
No. | Function |
1 | Getting data to be used as Bind parameter from Request Data {“a” : “1”} |
2 | DB Connector - Output DB Storage Information Connected by Apps |
3 | Register Query statement
- Pairing by entering the Query ID registered in Query Manager in Query ID
- Setting to get the a Value of request data with Bind parameter
SELECT * FROM study.data where id=:a; > SELECT * FROM study.data where id=1; |
3) Check DB Data call results
No. | Function |
1 | Checking DB Data Call results from Testbed as Results |
2 | Comparing it with the Value called with an external DB management tool (DBeaver) |