effort 努力人灼,盡量;一批數(shù)據(jù)中有一個(gè)失敗围段,不影響其他的處理;
transaction 事務(wù)投放;一批數(shù)據(jù)中有一個(gè)失敗奈泪,全部失敗跪呈;
batch 批量處理;處理多個(gè)
physical 物理處理取逾;用于刪除
logic 邏輯處理耗绿;用于新增
id 根據(jù)主鍵進(jìn)行刪改查
condition 根據(jù)字段條件進(jìn)行刪改查
data 實(shí)例Bean
新增:
新增不考慮有ID的情況,有ID的情況交給全量更新處理砾隅;
新增要考慮邏輯刪除的數(shù)據(jù)误阻,如果出現(xiàn)內(nèi)容和新增相同(除了ID,gmt_create,gmt_modified,且刪除標(biāo)志為1),且數(shù)量部位1就取第一個(gè),就復(fù)用這個(gè)數(shù)據(jù)究反,并且把創(chuàng)建時(shí)間修改時(shí)間更新寻定,刪除標(biāo)志設(shè)為0; ==》邏輯新增
單個(gè)新增/批量新增;物理新增/邏輯新增精耐;批量事務(wù)/批量盡量狼速;
post "" data
post /batchTransaction datas
post /batchEffort datas
post /logic data
post /logic/batchTransaction datas
post /logic/batchEffort datas
刪除:
ID刪除不需要傳實(shí)體數(shù)據(jù);邏輯刪除把刪除標(biāo)志設(shè)為1卦停;
Condition可以進(jìn)行非空復(fù)雜(等于向胡,大于等于,小于等于惊完,集合僵芹,字符串模糊查詢)條件的AND操作;
Example只對非空條件進(jìn)行等于操作小槐,然后AND拇派;
如果遇到OR的條件,沒有現(xiàn)成的接口可用凿跳,需要自己手動實(shí)現(xiàn)件豌;
單個(gè)刪除/批量刪除;物理刪除/邏輯刪除拄显;批量事務(wù)/批量盡量苟径;ID刪除/條件刪除;Condition條件/Example條件躬审;
delete /{id} id
delete /batchTransaction ids
delete /batchEffort ids
delete /conditionTransaction condition
delete /conditionEffort condition
delete /exampleTransaction example
delete /exampleEffort example
delete /physical/{id} id
delete /physical/batchTransaction ids
delete /physical/batchEffort ids
delete /physical/conditionTransaction condition
delete /physical/conditionEffort condition
delete /physical/exampleTransaction example
delete /physical/exampleEffort example
全量更新:
如果傳入的實(shí)體中存在null的字段棘街,則把數(shù)據(jù)庫中的對應(yīng)字段也設(shè)為null;
單個(gè)更新/批量更新;ID更新/條件更新承边;批量事務(wù)/批量盡量遭殉;Condition條件/Example條件;
put /{id} id,data
put /batchTransaction datas
put /batchEffort datas
put /conditionTransaction dataCondition
put /conditionEffort dataCondition
put /exampleTransaction dataExample
put /exampleEffort dataExample
非空更新:
只有字段為非空時(shí)才進(jìn)行更新博助;
patch /{id} id,data
patch /batchTransaction datas
patch /batchEffort datas
patch /conditionTransaction dataCondition
patch /conditionEffort dataCondition
patch /exampleTransaction dataExample
patch /exampleEffort dataExample
查詢:
條件查詢返回值為分頁险污;
ID查詢/條件查詢;Condition條件/Example條件富岳;單個(gè)查詢/批量查詢蛔糯;
get /{id} id
get "" 查詢?nèi)?br>
get /ids ids 逗號分隔的ID串
post /queryIds ids ID列表
post /queryCondition condition
post /queryExample example