# vi:filetype=
#某一列的 unique 约束不会影响到其他没有 unique 约束的列
#先创建1列有unique = true属性的,再创建一列unique=true 属性的
use t::OpenResty;
plan tests => 3 * blocks();
run_tests;
__DATA__
=== TEST 1: Delete existing models
--- request
DELETE /=/model?_user=$TestAccount&_password=$TestPass&_use_cookie=1
--- response
{"success":1}
=== TEST 2: create a model(column without unique attribute)
--- request
POST /=/model/testunique
{ "description": "test unique path17","columns": [{ "name":"jx1701","type":"text","label":"jx1701","unique":true}]}
--- response
{"success":1}
=== TEST 3: check the model
--- request
GET /=/model/
--- response
[{"description": "test unique path17","name": "testunique","src":"/=/model/testunique"}]
=== TEST 4: check the column
--- request
GET /=/model/testunique/jx1701
--- response
{"name":"jx1701","default":null,"label":"jx1701","type":"text","unique":true,"not_null":false}
=== TEST 5: Insert one record
--- request
POST /=/model/testunique/~/~
{ "jx1701": "A1701"}
--- response
{"success":1,"rows_affected":1,"last_row":"/=/model/testunique/id/1"}
=== TEST 6: Get record(1 record)
--- request
GET /=/model/testunique/~/~
--- response
[{"id":"1","jx1701":"A1701"}]
=== TEST 7: Insert the same record
--- request
POST /=/model/testunique/~/~
{ "jx1701": "A1701"}
--- response
{"error":"duplicate key value violates unique constraint \"testunique_jx1701_key\"","success":0}
=== TEST 8: Get record(1 record)
--- request
GET /=/model/testunique/~/~
--- response
[{"id":"1","jx1701":"A1701"}]
=== TEST 9: Insert different record
--- request
POST /=/model/testunique/~/~
{ "jx1701": "A1701-1"}
--- response
{"success":1,"rows_affected":1,"last_row":"/=/model/testunique/id/3"}
=== TEST 10: Get record(2 record)
--- request
GET /=/model/testunique/~/~
--- response
[{"id":"1","jx1701":"A1701"},{"id":"3","jx1701":"A1701-1"}]
=== TEST 11: create a column(with unique attribute is true)
--- request
POST /=/model/testunique/jx1702
{"type":"text","label":"jx1702","unique":true}
--- response
{"success":1,"src":"/=/model/testunique/jx1702"}
=== TEST 12: check the column
--- request
GET /=/model/testunique/jx1702
--- response
{"name":"jx1702","default":null,"label":"jx1702","type":"text","unique":true,"not_null":false}
=== TEST 13: Insert one record
--- request
POST /=/model/testunique/~/~
{ "jx1701": "A1701","jx1702":"A1702"}
--- response
{"error":"duplicate key value violates unique constraint \"testunique_jx1701_key\"","success":0}
=== TEST 14: Get record(2 record)
--- request
GET /=/model/testunique/~/~
--- response
[{"id":"1","jx1701":"A1701","jx1702":null},{"id":"3","jx1701":"A1701-1","jx1702":null}]
=== TEST 15: Insert different record
--- request
POST /=/model/testunique/~/~
{ "jx1701": "A1701-2","jx1702":"A1702"}
--- response
{"success":1,"rows_affected":1,"last_row":"/=/model/testunique/id/5"}
=== TEST 16: Get record(3 record)
--- request
GET /=/model/testunique/~/~
--- response
[{"id":"1","jx1701":"A1701","jx1702":null},{"id":"3","jx1701":"A1701-1","jx1702":null},{"id":"5","jx1701":"A1701-2","jx1702":"A1702"}]
=== TEST 17: Insert the same record
--- request
POST /=/model/testunique/~/~
{ "jx1701": "A1701-3","jx1702":"A1702"}
--- response
{"error":"duplicate key value violates unique constraint \"testunique_jx1702_key\"","success":0}
=== TEST 18: Get record(3 record)
--- request
GET /=/model/testunique/~/~
--- response
[{"id":"1","jx1701":"A1701","jx1702":null},{"id":"3","jx1701":"A1701-1","jx1702":null},{"id":"5","jx1701":"A1701-2","jx1702":"A1702"}]
=== TEST 19: Insert different record
--- request
POST /=/model/testunique/~/~
{ "jx1701": "A1701-4","jx1702":"A1702-1"}
--- response
{"success":1,"rows_affected":1,"last_row":"/=/model/testunique/id/7"}
=== TEST 20: Get record(4 record)
--- request
GET /=/model/testunique/~/~
--- response
[{"id":"1","jx1701":"A1701","jx1702":null},{"id":"3","jx1701":"A1701-1","jx1702":null},{"id":"5","jx1701":"A1701-2","jx1702":"A1702"},{"id":"7","jx1701":"A1701-4","jx1702":"A1702-1"}]