=== RUN   CREATE book
Loading ./tests/fixtures/library-fixture.yaml
Populating ref dummy_add_library as {"$extend":"dummy_library","name":"First library"} from template
Loading ./tests/fixtures/empty_books_db.yaml
Issuing SQL: TRUNCATE TABLE "preferences"."libraries","preferences"."books" CASCADE
Issuing SQL: INSERT INTO "preferences"."libraries" AS row ("name") VALUES ('First library') RETURNING row_to_json(row)
Issuing SQL: 
DO $$
DECLARE
    r record;
BEGIN
    FOR r IN (
        SELECT 'SELECT SETVAL(' || quote_literal(quote_ident(seq_ns.nspname) || '.' || quote_ident(seq.relname))
            || ', COALESCE(MAX(' || quote_ident(col.attname) || '), 1) ) FROM '
            || quote_ident(tbl_ns.nspname) || '.' || quote_ident(tbl.relname) AS q
        FROM pg_class seq
            JOIN pg_namespace seq_ns ON (seq.relnamespace = seq_ns.oid)
            JOIN pg_depend dep ON (dep.objid = seq.oid)
            JOIN pg_class tbl ON (dep.refobjid = tbl.oid)
            JOIN pg_namespace tbl_ns ON (tbl.relnamespace = tbl_ns.oid)
            JOIN pg_attribute col ON (col.attrelid = tbl.oid AND dep.refobjsubid = col.attnum)
        WHERE
            seq.relkind = 'S'
        ORDER BY seq.relname
    ) LOOP
        EXECUTE r.q;
    END LOOP;
END$$


Name: CREATE book
Description: No description
File: ./tests/cases/10_books.gonkey.yaml

Request:
     Method: POST
       Path: /api/v1/library/1/book
      Query: 
       Body:
        {
          "name": "Test book name"
        }

Response:
     Status: 200 OK
       Body:
{"id":2, "library_id":1, "name": "Test book name"}

Result: ERRORS!

Errors:

1) at path $.id values do not match:
     expected: 1
       actual: 2


    --- FAIL: CREATE book (0.16s)

Issuing SQL: 
DO $$
DECLARE
    r record;
BEGIN
    FOR r IN (
        SELECT 'SELECT SETVAL(' || quote_literal(quote_ident(seq_ns.nspname) || '.' || quote_ident(seq.relname))
            || ', COALESCE(MAX(' || quote_ident(col.attname) || '), 1) ) FROM '
            || quote_ident(tbl_ns.nspname) || '.' || quote_ident(tbl.relname) AS q
        FROM pg_class seq
            JOIN pg_namespace seq_ns ON (seq.relnamespace = seq_ns.oid)
            JOIN pg_depend dep ON (dep.objid = seq.oid)
            JOIN pg_class tbl ON (dep.refobjid = tbl.oid)
            JOIN pg_namespace tbl_ns ON (tbl.relnamespace = tbl_ns.oid)
            JOIN pg_attribute col ON (col.attrelid = tbl.oid AND dep.refobjsubid = col.attnum)
        WHERE
            seq.relkind = 'S'
        ORDER BY seq.relname
    ) LOOP
        EXECUTE r.q;
    END LOOP;
END$$