# vi:filetype=

use t::OpenResty;

plan tests => 3 * blocks();

run_tests;

__DATA__

=== TEST 1: Clear the environment
--- request
DELETE /=/model?_user=$TestAccount&_password=$TestPass&_use_cookie=1
--- response
{"success":1}



=== TEST 2: Create a model
--- request
POST /=/model/Foo
{
    "description":"foo",
    "columns":
        [ {"name":"name", "type":"text","label":"姓名"},
          {"name":"age", "label": "年龄", "type":"integer"}
        ]
}
--- response
{"success":1}



=== TEST 3: Insert some data
--- request
POST /=/model/Foo/~/~
[
  { "name":"Marry", "age":21 },
  { "name":"Bob", "age":32 },
  { "name":"Bob", "age": 15 },
  { "name":"Henry", "age": 19 },
  { "name":"Henry", "age": 23 },
  { "name":"Larry", "age": 59 },
  { "name":"Audrey", "age": 17 }
]
--- response
{"success":1,"rows_affected":7,"last_row":"/=/model/Foo/id/7"}



=== TEST 4: no order by
--- request
GET /=/model/Foo/~/~
--- response
[
    {"name":"Marry","id":"1","age":"21"},
    {"name":"Bob","id":"2","age":"32"},
    {"name":"Bob","id":"3","age":"15"},
    {"name":"Henry","id":"4","age":"19"},
    {"name":"Henry","id":"5","age":"23"},
    {"name":"Larry","id":"6","age":"59"},
    {"name":"Audrey","id":"7","age":"17"}
]



=== TEST 5: Order by name (asc by default)
--- request
GET /=/model/Foo/~/~?_order_by=name
--- response
[
    {"name":"Audrey","id":"7","age":"17"},
    {"name":"Bob","id":"2","age":"32"},
    {"name":"Bob","id":"3","age":"15"},
    {"name":"Henry","id":"4","age":"19"},
    {"name":"Henry","id":"5","age":"23"},
    {"name":"Larry","id":"6","age":"59"},
    {"name":"Marry","id":"1","age":"21"}
]



=== TEST 6: Order by name (asc by default)
--- request
GET /=/model/Foo/~/~?_order_by=name:desc
--- response
[
    {"name":"Marry","id":"1","age":"21"},
    {"name":"Larry","id":"6","age":"59"},
    {"name":"Henry","id":"4","age":"19"},
    {"name":"Henry","id":"5","age":"23"},
    {"name":"Bob","id":"2","age":"32"},
    {"name":"Bob","id":"3","age":"15"},
    {"name":"Audrey","id":"7","age":"17"}
]



=== TEST 7: Order by age (asc by default)
--- request
GET /=/model/Foo/~/~?_order_by=age
--- response
[
    {"name":"Bob","id":"3","age":"15"},
    {"name":"Audrey","id":"7","age":"17"},
    {"name":"Henry","id":"4","age":"19"},
    {"name":"Marry","id":"1","age":"21"},
    {"name":"Henry","id":"5","age":"23"},
    {"name":"Bob","id":"2","age":"32"},
    {"name":"Larry","id":"6","age":"59"}
]



=== TEST 8: Order by age desc
--- request
GET /=/model/Foo/~/~?_order_by=age:desc
--- response
[
    {"name":"Larry","id":"6","age":"59"},
    {"name":"Bob","id":"2","age":"32"},
    {"name":"Henry","id":"5","age":"23"},
    {"name":"Marry","id":"1","age":"21"},
    {"name":"Henry","id":"4","age":"19"},
    {"name":"Audrey","id":"7","age":"17"},
    {"name":"Bob","id":"3","age":"15"}
]



=== TEST 9: Order by name asc, age desc
--- request
GET /=/model/Foo/~/~?_order_by=name:asc,age:desc
--- response
[
    {"name":"Audrey","id":"7","age":"17"},
    {"name":"Bob","id":"2","age":"32"},
    {"name":"Bob","id":"3","age":"15"},
    {"name":"Henry","id":"5","age":"23"},
    {"name":"Henry","id":"4","age":"19"},
    {"name":"Larry","id":"6","age":"59"},
    {"name":"Marry","id":"1","age":"21"}
]



=== TEST 10: Order by name, age desc
--- request
GET /=/model/Foo/~/~?_order_by=name,age:desc
--- response
[
    {"name":"Audrey","id":"7","age":"17"},
    {"name":"Bob","id":"2","age":"32"},
    {"name":"Bob","id":"3","age":"15"},
    {"name":"Henry","id":"5","age":"23"},
    {"name":"Henry","id":"4","age":"19"},
    {"name":"Larry","id":"6","age":"59"},
    {"name":"Marry","id":"1","age":"21"}
]



=== TEST 11: Order by name, age desc
--- request
GET /=/model/Foo/~/~?_order_by=name,age:desc,id
--- response
[
    {"name":"Audrey","id":"7","age":"17"},
    {"name":"Bob","id":"2","age":"32"},
    {"name":"Bob","id":"3","age":"15"},
    {"name":"Henry","id":"5","age":"23"},
    {"name":"Henry","id":"4","age":"19"},
    {"name":"Larry","id":"6","age":"59"},
    {"name":"Marry","id":"1","age":"21"}
]



=== TEST 12: where name='Bob' order by age
--- request
GET /=/model/Foo/name/Bob?_order_by=age
--- response
[
    {"name":"Bob","id":"3","age":"15"},
    {"name":"Bob","id":"2","age":"32"}
]



=== TEST 13: where name='Bob' order by age desc
--- request
GET /=/model/Foo/name/Bob?_order_by=age:desc
--- response
[
    {"name":"Bob","id":"2","age":"32"},
    {"name":"Bob","id":"3","age":"15"}
]



=== TEST 14: order by an invalid column
--- request
GET /=/model/Foo/name/Bob?_order_by=null
--- response
{"error":"non-integer constant in ORDER BY","success":0}



=== TEST 15: order by no columns
--- request
GET /=/model/Foo/name/Bob?_order_by=
--- response
{"success":0,"error":"No column found in order_by."}



=== TEST 16: order by no columns
--- request
GET /=/model/Foo/name/Bob?_order_by=,
--- response
{"success":0,"error":"Invalid order_by value: ,"}



=== TEST 17: order by no columns
--- request
GET /=/model/Foo/name/Bob?_order_by=name:blah
--- response
{"success":0,"error":"Invalid order_by direction: blah"}



=== TEST 18: order by no columns
--- request
GET /=/model/Foo/name/Bob?_order_by=name:blah:foo
--- response
{"success":0,"error":"Invalid order_by direction: blah:foo"}



=== TEST 19: order by no columns
--- request
GET /=/model/Foo/~/~?_order_by=name:blah:foo
--- response
{"success":0,"error":"Invalid order_by direction: blah:foo"}



=== TEST 20: bad column name
--- request
GET /=/model/Foo/~/~?_order_by=foo--
--- response
{"success":0,"error":"Bad model column name: foo--"}



=== TEST 21: logout
--- request
GET /=/logout
--- response
{"success":1}