Error on join with base

[sirex]

d | r | b | m | property | type    | ref     | access
$DATASET                 |         |         |
  |   |   | Place        |         | id      |
  |   |   |   | id       | integer |         | open
  |   |   |   | name     | string  |         | open
  |   |   |   |          |         |         |
  |   | Place            |         | name    |
  |   |   |   |          |         |         |
  |   |   | Country      |         | id      |
  |   |   |   | id       | integer |         | open
  |   |   |   | name     |         |         | open
  |   |   |   |          |         |         |
  |   |   | City         |         | id      |
  |   |   |   | id       | integer |         | open
  |   |   |   | name     |         |         | open
  |   |   |   | country  | ref     | Country | open

LTU=d55e65c6-97c9-4cd3-99ff-ae34e268289b
VLN=2074d66e-0dfd-4233-b1ec-199abc994d0c

http POST "$SERVER/$DATASET/Place"   $AUTH _id=$LTU id:=1   name=Lithuania
http POST "$SERVER/$DATASET/Country" $AUTH _id=$LTU id:=10

http POST "$SERVER/$DATASET/Place"   $AUTH _id=$VLN id:=2   name=Vilnius
http POST "$SERVER/$DATASET/City"    $AUTH _id=$VLN id:=20  country[_id]=$LTU

http GET  "$SERVER/$DATASET/City?select(id,name,country.name)&format(ascii)"

HTTP/1.1 500 Internal Server Error

{
    "errors": [
        {
            "code": "KeyError",
            "message": "'name'"
        }
    ]
}

tail $BASEDIR/spinta.log

Traceback (most recent call last):
  File "spinta/api.py", line 94, in homepage
    return await create_http_response(context, params, request)
  File "spinta/utils/response.py", line 153, in create_http_response
    return await commands.getall(
  File "spinta/commands/read.py", line 121, in getall
    return render(context, request, model, params, rows, action=action)
  File "spinta/renderer.py", line 23, in render
    return commands.render(
  File "spinta/formats/ascii/commands.py", line 28, in render
    return _render(
  File "spinta/formats/ascii/commands.py", line 62, in _render
    aiter(peek_and_stream(fmt(
  File "spinta/utils/response.py", line 223, in peek_and_stream
    peek = list(itertools.islice(stream, 2))
  File "spinta/formats/ascii/components.py", line 41, in __call__
    peek = next(data, None)
  File "spinta/commands/read.py", line 106, in <genexpr>
    rows = (
  File "spinta/backends/postgresql/commands/read.py", line 51, in getall
    expr = env.resolve(query)
  File "spinta/backends/postgresql/commands/query.py", line 267, in select
    selected = env.call('select', arg)
  File "spinta/backends/postgresql/commands/query.py", line 385, in select
    column = table.c[fpr.right.place]
  File "sqlalchemy/sql/base.py", line 1192, in __getitem__
    return self._index[key]
KeyError: 'name'

Related

• Reading models with base #273