pull.yml

# Copyright (C) 2021 CGI France
#
# This file is part of LINO.
#
# LINO is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# LINO is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with LINO.  If not, see <http:#www.gnu.org/licenses/>.

name: http pull
testcases:
  - name: prepare test
    steps:
      # Clean working directory
      - script: rm -f *
      - script: sudo docker compose -p lino stop source dest && sudo docker compose -p lino rm -f source dest && sudo docker compose -p lino up -d source dest && sudo docker compose -p lino up -d --build lino
      # .devcontainer and lino http share same test workdir
      # edit yaml here is the same as in lino-http's container
      - script: lino dataconnector add --password-from-env PASSWORD source postgresql://postgres:sakila@source:5432/postgres?sslmode=disable
      - script: count=0; while ! lino dc ping source; do echo wait $count; ((count++)) && ((count>=10)) && break; sleep 1; done
        assertions:
          - result.code ShouldEqual 0
      - script: lino relation extract source
      - script: lino table extract source --only-tables
      - script: lino id create store
      - script: sed -i "s/true/false/g" ingress-descriptor.yaml
      - script: lino id set-child-lookup staff_store_id_fkey true
      - script: cp * /workspace/tests/workspace

  - name: pull bad source
    steps:
      - type: http
        method: GET
        url: http://lino:8000/api/v1/data/badsource
        assertions:
          - result.statuscode ShouldEqual 404
          - |
            result.body ShouldContainSubstring '{"error": "Data Connector badsource not found"}'

  - name: pull no query
    steps:
      - type: http
        method: GET
        url: http://lino:8000/api/v1/data/source
        assertions:
          - result.statuscode ShouldEqual 200
          - result.body ShouldContainSubstring {"address_id":1,"last_update":"2006-02-15T09:57:12Z","manager_staff_id":1,"store_id":1,"staff_store_id_fkey":[{"active":true,"address_id":3,"email":"Mike.Hillyer@sakilastaff.com","first_name":"Mike","last_name":"Hillyer","last_update":"2006-05-16T16:13:11.79328Z","password":"8cb2237d0679ca88db6464eac60da96345513964","picture":"iVBORw0KWgo=","staff_id":1,"store_id":1,"username":"Mike"}]}
          - result.body ShouldContainSubstring {"address_id":2,"last_update":"2006-02-15T09:57:12Z","manager_staff_id":2,"store_id":2,"staff_store_id_fkey":[{"active":true,"address_id":4,"email":"Jon.Stephens@sakilastaff.com","first_name":"Jon","last_name":"Stephens","last_update":"2006-05-16T16:13:11.79328Z","password":"8cb2237d0679ca88db6464eac60da96345513964","picture":null,"staff_id":2,"store_id":2,"username":"Jon"}]}

  - name: pull limit
    steps:
      - type: http
        method: GET
        url: http://lino:8000/api/v1/data/source?limit=1
        assertions:
          - result.statuscode ShouldEqual 200
          - result.bodyjson.address_id ShouldEqual 1

  - name: pull filter
    steps:
      - type: http
        method: GET
        url: http://lino:8000/api/v1/data/source?filter=address_id:2
        assertions:
          - result.statuscode ShouldEqual 200
          - result.bodyjson.address_id ShouldEqual 2

  - name: pull filter empty
    steps:
      - type: http
        method: GET
        url: http://lino:8000/api/v1/data/source?filter=address_id:99
        assertions:
          - result.statuscode ShouldEqual 200
          - result.body ShouldBeEmpty

  - name: pull filter multi values
    steps:
      - type: http
        method: GET
        url: http://lino:8000/api/v1/data/source?filter=address_id:1,store_id:1
        assertions:
          - result.statuscode ShouldEqual 200
          - result.bodyjson.address_id ShouldEqual 1

  - name: pull filter without values
    steps:
      - type: http
        method: GET
        url: http://lino:8000/api/v1/data/source?filter=address_id
        assertions:
          - result.statuscode ShouldEqual 400
          - |
            result.body ShouldContainSubstring '{"error": "param filter must be a string map (key1:value1,key2:value2)"}'

  - name: pull table content
    steps:
      - type: http
        method: GET
        url: http://lino:8000/api/v1/data/source?table=customer&limit=1
        assertions:
          - result.statuscode ShouldEqual 200
          - result.body ShouldContainSubstring '{"active":1,"activebool":true,"address_id":5,"create_date":"2006-02-14T00:00:00Z","customer_id":1,"email":"MARY.SMITH@sakilacustomer.org","first_name":"MARY","last_name":"SMITH","last_update":"2006-02-15T09:57:20Z","store_id":1}'

  - name: pull where
    steps:
      - type: http
        method: GET
        url: http://lino:8000/api/v1/data/source?table=customer&where=address_id%3E14&limit=1
        assertions:
          - result.statuscode ShouldEqual 200
          - result.bodyjson.address_id ShouldEqual 15

  - name: pull whith good Origin header
    steps:
      - type: http
        method: GET
        url: http://lino:8000/api/v1/data/source?limit=1
        headers:
          Origin: http://localhost:3000

        assertions:
          - result.statuscode ShouldEqual 200
          - result.headers.Access-Control-Allow-Origin ShouldEqual http://localhost:3000

  - name: pull with bad Origin header
    steps:
      - type: http
        method: GET
        url: http://lino:8000/api/v1/data/source?limit=1
        headers:
          Origin: http://foo.com

        assertions:
          - result.statuscode ShouldEqual 200
          - result.headers.Access-Control-Allow-Origin ShouldBeNil

  - name: pull with bad method
    steps:
      - type: http
        method: POST
        url: http://lino:8000/api/v1/
        headers:
          Origin: http://localhost:3000

        assertions:
          - result.statuscode ShouldEqual 404
          - result.headers.Access-Control-Allow-Origin ShouldBeNil