Skip to content

common execute

양석우 edited this page May 25, 2023 · 1 revision
 1. URL ( Method : POST )
http://{router_ip}:{router_port}/route/common/portal/api/common-execute
update table set column = column + 1의 동작을 원할경우 data 값에 prefix로 "`"(백틱)을 붙여 사용
예) ... {"data": {"idx": "`idx + 1"}}...

2. BODY
[
  {
    "method": "",		(a) INSERT | UPDATE | DELETE (Required)
    "table_nm": "",		(b) 테이블명 (Required)
    "data": {},			(c) INSERT, UPDATE, DELETE를 위한 json format의 데이터 (Required)
    "key": []			(d) UPDATE, DELETE 위한 컬럼명 (Optional)
  }
]

@@@ EXAMPLE @@@
1. INSERT
- body :
[
  {
    "method": "INSERT",
    "table_nm": "tb_data_visual_anals_data_set",
    "data": {"data_set_id":"set id 1", "conts_id":"conts id 1","del_yn":"Y","reg_user":"user 1","amd_user":"amd user 1"}
  }
]


2. UPDATE
- body : 
[
  {
    "method": "INSERT",
    "table_nm": "tb_data_visual_anals_data_set",
    "data": {"data_set_id":"set id 1", "conts_id":"conts id 1","del_yn":"Y","reg_user":"user 1","amd_user":"amd user 1"}
  },
  {
    "method": "UPDATE",
    "key": ["conts_id", "amd_user"],
    "table_nm": "tb_data_visual_anals_data_set",
    "data": {"data_set_id":"set id 2", "conts_id":"conts id 1","del_yn":"N","reg_user":"user 2","amd_user":"amd user 2"}
  }
]



3. DELETE
- body :
[
  {
    "method": "INSERT",
    "table_nm": "tb_data_visual_anals_data_set",
    "data": {"data_set_id":"set id 1", "conts_id":"conts id 1","del_yn":"Y","reg_user":"user 1","amd_user":"amd user 1"}
  },
  {
    "method": "DELETE",
    "key": ["conts_id", "amd_user"],
    "table_nm": "tb_data_visual_anals_data_set",
    "data": {"conts_id":"conts id 1","amd_user":"amd user 2"}
  }
]



4. INSERT + UPDATE + DELETE
- body :
[
  {
    "method": "INSERT",
    "table_nm": "tb_data_visual_anals_data_set",
    "data": {"data_set_id":"set id 1", "conts_id":"conts id 1","del_yn":"Y","reg_user":"user 1","amd_user":"amd user 1"}
  },
  {
    "method": "UPDATE",
    "key": ["conts_id"],
    "table_nm": "tb_data_visual_anals_data_set",
    "data": {"data_set_id":"set id 2", "conts_id":"conts id 1","del_yn":"N","reg_user":"user 2","amd_user":"amd user 2"}
  },
  {
    "method": "DELETE",
    "key": ["conts_id"],
    "table_nm": "tb_data_visual_anals_data_set",
    "data": {"conts_id":"conts id 1"}
  }
]

Clone this wiki locally