Project: Bagatela

Publisher: Stanley

Querying timetables

In order to provide users with detailed information about their journey As a developer I want to build applications which have easy access to timetables

Background:
- Given an empty database "kr"
- And design documents

Scenario: Find timetables by line

Given the following timetables:

_id	valid_since	stop	line	route	source
1	13.10.2010	Cmentarz Rakowicki	2	CMENTARZ RAKOWICKI - SALWATOR	/0002/0002t012.htm
2	13.10.2010	Cmentarz Rakowicki	2	CMENTARZ RAKOWICKI - SALWATOR	/0002/0002t013.htm
3	13.10.2010	Rakowiecka	2	CMENTARZ RAKOWICKI - SALWATOR	/0002/0002t014.htm
4	13.10.2010	Uniwersytet Ekonomiczny	2	CMENTARZ RAKOWICKI - SALWATOR	/0002/0002t015.htm
5	13.10.2010	Lubicz	2	CMENTARZ RAKOWICKI - SALWATOR	/0002/0002t016.htm
6	13.10.2010	Dworzec Główny	2	CMENTARZ RAKOWICKI - SALWATOR	/0002/0002t017.htm
7	13.10.2010	Basztowa LOT	2	CMENTARZ RAKOWICKI - SALWATOR	/0002/0002t018.htm
8	13.10.2010	Teatr Bagatela	2	CMENTARZ RAKOWICKI - SALWATOR	/0002/0002t019.htm
9	13.10.2010	Filharmonia	2	CMENTARZ RAKOWICKI - SALWATOR	/0002/0002t020.htm
10	13.10.2010	Jubilat	2	CMENTARZ RAKOWICKI - SALWATOR	/0002/0002t021.htm
11	13.10.2010	Komorowskiego	2	CMENTARZ RAKOWICKI - SALWATOR	/0002/0002t022.htm
12	13.10.2010	Flisacka	2	CMENTARZ RAKOWICKI - SALWATOR	/0002/0002t023.htm

When I send a GET request to http://api.bagate.la/kr/_design/Timetables/_view/by_line?startkey=["2","SALWATOR"]&endkey=["2","SALWATOR",{}]&reduce=false
Then the response status should be 200

And the response without rows' value._rev should be:

{ "total_rows": 12, "offset": 0, "rows": [
    { "id": "1",
      "key": [ "2", "SALWATOR", "/0002/0002t012.htm" ],
      "value": {
        "_id": "1",
        "valid_since": "13.10.2010",
        "stop": "Cmentarz Rakowicki",
        "line": "2",
        "route": "CMENTARZ RAKOWICKI - SALWATOR",
        "source": "/0002/0002t012.htm",
        "type": "Timetable"
      }
    },
    { "id": "2",
      "key": [ "2", "SALWATOR", "/0002/0002t013.htm" ],
      "value": {
        "_id": "2",
        "valid_since": "13.10.2010",
        "stop": "Cmentarz Rakowicki",
        "line": "2",
        "route": "CMENTARZ RAKOWICKI - SALWATOR",
        "source": "/0002/0002t013.htm",
        "type": "Timetable"
      }
    },
    { "id": "3",
      "key": [ "2", "SALWATOR", "/0002/0002t014.htm" ],
      "value": {
        "_id": "3",
        "valid_since": "13.10.2010",
        "stop": "Rakowiecka",
        "line": "2",
        "route": "CMENTARZ RAKOWICKI - SALWATOR",
        "source": "/0002/0002t014.htm",
        "type": "Timetable"
      }
    },
    { "id": "4",
      "key": [ "2", "SALWATOR", "/0002/0002t015.htm" ],
      "value": {
        "_id": "4",
        "valid_since": "13.10.2010",
        "stop": "Uniwersytet Ekonomiczny",
        "line": "2",
        "route": "CMENTARZ RAKOWICKI - SALWATOR",
        "source": "/0002/0002t015.htm",
        "type": "Timetable"
      }
    },
    { "id": "5",
      "key": [ "2", "SALWATOR", "/0002/0002t016.htm" ],
      "value": {
        "_id": "5",
        "valid_since": "13.10.2010",
        "stop": "Lubicz",
        "line": "2",
        "route": "CMENTARZ RAKOWICKI - SALWATOR",
        "source": "/0002/0002t016.htm",
        "type": "Timetable"
      }
    },
    { "id": "6",
      "key": [ "2", "SALWATOR", "/0002/0002t017.htm" ],
      "value": {
        "_id": "6",
        "valid_since": "13.10.2010",
        "stop": "Dworzec Główny",
        "line": "2",
        "route": "CMENTARZ RAKOWICKI - SALWATOR",
        "source": "/0002/0002t017.htm",
        "type": "Timetable"
      }
    },
    { "id": "7",
      "key": [ "2", "SALWATOR", "/0002/0002t018.htm" ],
      "value": {
        "_id": "7",
        "valid_since": "13.10.2010",
        "stop": "Basztowa LOT",
        "line": "2",
        "route": "CMENTARZ RAKOWICKI - SALWATOR",
        "source": "/0002/0002t018.htm",
        "type": "Timetable"
      }
    },
    { "id": "8",
      "key": [ "2", "SALWATOR", "/0002/0002t019.htm" ],
      "value": {
        "_id": "8",
        "valid_since": "13.10.2010",
        "stop": "Teatr Bagatela",
        "line": "2",
        "route": "CMENTARZ RAKOWICKI - SALWATOR",
        "source": "/0002/0002t019.htm",
        "type": "Timetable"
      }
    },
    { "id": "9",
      "key": [ "2", "SALWATOR", "/0002/0002t020.htm" ],
      "value": {
        "_id": "9",
        "valid_since": "13.10.2010",
        "stop": "Filharmonia",
        "line": "2",
        "route": "CMENTARZ RAKOWICKI - SALWATOR",
        "source": "/0002/0002t020.htm",
        "type": "Timetable"
      }
    },
    { "id": "10",
      "key": [ "2", "SALWATOR", "/0002/0002t021.htm" ],
      "value": {
        "_id": "10",
        "valid_since": "13.10.2010",
        "stop": "Jubilat",
        "line": "2",
        "route": "CMENTARZ RAKOWICKI - SALWATOR",
        "source": "/0002/0002t021.htm",
        "type": "Timetable"
      }
    },
    { "id": "11",
      "key": [ "2", "SALWATOR", "/0002/0002t022.htm" ],
      "value": {
        "_id": "11",
        "valid_since": "13.10.2010",
        "stop": "Komorowskiego",
        "line": "2",
        "route": "CMENTARZ RAKOWICKI - SALWATOR",
        "source": "/0002/0002t022.htm",
        "type": "Timetable"
      }
    },
    { "id": "12",
      "key": [ "2", "SALWATOR", "/0002/0002t023.htm" ],
      "value": {
        "_id": "12",
        "valid_since": "13.10.2010",
        "stop": "Flisacka",
        "line": "2",
        "route": "CMENTARZ RAKOWICKI - SALWATOR",
        "source": "/0002/0002t023.htm",
        "type": "Timetable"
      }
    }
  ]
}

Scenario: Lines' route(s)

Given the following timetables:

stop	line	route	source
Aleja Przyjaźni	110	ALEJA PRZYJAŹNI - WADÓW TUNEL	/0110/0110t001.htm
Aleja Róż	110	ALEJA PRZYJAŹNI - WADÓW TUNEL	/0110/0110t001.htm
Żeromskiego	110	ALEJA PRZYJAŹNI - WADÓW TUNEL	/0110/0110t001.htm
Teatr Ludowy	110	ALEJA PRZYJAŹNI - WADÓW TUNEL	/0110/0110t001.htm
Kocmyrzowska	110	ALEJA PRZYJAŹNI - WADÓW TUNEL	/0110/0110t001.htm
Bieńczyce Mleczarnia	110	ALEJA PRZYJAŹNI - WADÓW TUNEL	/0110/0110t001.htm
Wadów Działki (NŻ)	110	ALEJA PRZYJAŹNI - WĘGRZYNOWICE	/0110/0110t033.htm
Parowozownia (NŻ)	110	ALEJA PRZYJAŹNI - WĘGRZYNOWICE	/0110/0110t034.htm
Węgrzynowice I (NŻ)	110	ALEJA PRZYJAŹNI - WĘGRZYNOWICE	/0110/0110t035.htm
Węgrzynowice II (NŻ)	110	ALEJA PRZYJAŹNI - WĘGRZYNOWICE	/0110/0110t036.htm

When I send a GET request to http://api.bagate.la/kr/_design/Timetables/_view/by_line?group_level=1&startkey=["110"]
Then the response status should be 200

And the response should be:

{"rows":  [
  {"key": ["110"], "value": 10}]}

When I send a GET request to http://api.bagate.la/kr/_design/Timetables/_view/by_line?group_level=2&startkey=["110","WĘGRZYNOWICE"]&endkey=["110","WĘGRZYNOWICE",{}]
Then the response status should be 200

And the response should be:

{"rows":  [
  {"key": ["110","WĘGRZYNOWICE"], "value": 4}
]}

Scenario: Find timetables by stop id

Given the following stops:

_id name address

1 Bagatela Karmelicka
And the following timetables:

_id stop stop_id table

2 Bagatela 1 {}

3 Bagatela 1 {}

4 Bagatela 1 {}
When I send a GET request to http://api.bagate.la/kr/_design/Timetables/_view/by_stop_id?startkey=["1"]&endkey=["1",{}]
Then the response status should be 200

And the response without rows' value._rev should be:

{ "total_rows": 4, "offset": 0, "rows":  [
  { "id": "1", 
    "key": ["1", 0],
    "value": {"_id": "1", "name": "Bagatela", "address": "Karmelicka", "type": "Stop"}},
  { "id": "2",
    "key": ["1", 1],
    "value": {"_id": "2", "stop": "Bagatela", "stop_id": "1", "table": {}, "type": "Timetable"}},
  { "id": "3",
    "key": ["1", 1],
    "value": {"_id": "3", "stop": "Bagatela", "stop_id": "1", "table": {}, "type": "Timetable"}},
  { "id": "4",
    "key": ["1", 1],
    "value": {"_id": "4", "stop": "Bagatela", "stop_id": "1", "table": {}, "type": "Timetable"}}
]}

When I send a GET request to http://api.bagate.la/kr/_design/Timetables/_view/by_stop_id?key=["1",1]
Then the response status should be 200

And the response without rows' value._rev should be:

{ "total_rows": 4, "offset": 1, "rows":  [
  { "id": "2",
    "key": ["1", 1],
    "value":  {"_id": "2", "stop": "Bagatela", "stop_id": "1", "table": {}, "type": "Timetable"}},
  { "id": "3",
    "key": ["1", 1],
    "value":  {"_id": "3", "stop": "Bagatela", "stop_id": "1", "table": {}, "type": "Timetable"}},
  { "id": "4",
    "key": ["1", 1],
    "value":  {"_id": "4", "stop": "Bagatela", "stop_id": "1", "table": {}, "type": "Timetable"}}
]}

Scenario: Find timetables by stop name

Given the following stops:

_id name address

1 Bagatela Dunajewskiego

2 Bagatela Karmelicka

3 Bagatela Podwale

And the following timetables:

_id	line	stop	stop_id	route	table
4	14	Bagatela	1	MISTRZEJOWICE - ks. Jancarza, Srebrnych Orłów, Mikołajczyka, Broniewskiego, Andersa, Bieńczycka, Al. Pokoju, Al. Powstania Warszawskiego, Lubicz, Basztowa, Dunajewskiego, Karmelicka, Królewska, Podchorążych, Bronowicka - BRONOWICE	{}
5	14	Bagatela	2	BRONOWICE - Bronowicka, Podchorążych, Królewska, Karmelicka, Basztowa, Lubicz, Al. Powstania Warszawskiego, Al. Pokoju, Bieńczycka, Andersa, Broniewskiego, Mikołajczyka, Srebrnych Orłów, ks. Jancarza - MISTRZEJOWICE	{}
6	15	Bagatela	3	CICHY KĄCIK - Al. 3 Maja, Podwale, Basztowa, Lubicz, Mogilska, Al. Jana Pawła II, Ptaszyckiego, Igołomska - PLESZÓW	{}
7	15	Bagatela	1	PLESZÓW - Igołomska, Ptaszyckiego, Al. Jana Pawła II, Mogilska, Lubicz, Basztowa, Dunajewskiego, Piłsudskiego, Al. 3 Maja - CICHY KĄCIK	{}

When I send a GET request to http://api.bagate.la/kr/_design/Timetables/_view/by_stop?startkey=["Bagatela"]&endkey=["Bagatela",{}]
Then the response status should be 200

And the response without rows' value._rev should be:

{ "total_rows": 4, "offset": 0, "rows": [
    { "id": "4",
      "key": [ "Bagatela", "14", "BRONOWICE" ],
      "value": {
        "_id": "4",
        "line": "14",
        "stop": "Bagatela",
        "stop_id": "1",
        "route": "MISTRZEJOWICE - ks. Jancarza, Srebrnych Orłów, Mikołajczyka, Broniewskiego, Andersa, Bieńczycka, Al. Pokoju, Al. Powstania Warszawskiego, Lubicz, Basztowa, Dunajewskiego, Karmelicka, Królewska, Podchorążych, Bronowicka - BRONOWICE",
        "table": { },
        "type": "Timetable"
      }
    },
    { "id": "5",
      "key": [ "Bagatela", "14", "MISTRZEJOWICE" ],
      "value": {
        "_id": "5",
        "line": "14",
        "stop": "Bagatela",
        "stop_id": "2",
        "route": "BRONOWICE - Bronowicka, Podchorążych, Królewska, Karmelicka, Basztowa, Lubicz, Al. Powstania Warszawskiego, Al. Pokoju, Bieńczycka, Andersa, Broniewskiego, Mikołajczyka, Srebrnych Orłów, ks. Jancarza - MISTRZEJOWICE",
        "table": { },
        "type": "Timetable"
      }
    },
    { "id": "7",
      "key": [ "Bagatela", "15", "CICHY KĄCIK" ],
      "value": {
        "_id": "7",
        "line": "15",
        "stop": "Bagatela",
        "stop_id": "1",
        "route": "PLESZÓW - Igołomska, Ptaszyckiego, Al. Jana Pawła II, Mogilska, Lubicz, Basztowa, Dunajewskiego, Piłsudskiego, Al. 3 Maja - CICHY KĄCIK",
        "table": { },
        "type": "Timetable"
      }
    },
    { "id": "6",
      "key": [ "Bagatela", "15", "PLESZÓW" ],
      "value": {
        "_id": "6",
        "line": "15",
        "stop": "Bagatela",
        "stop_id": "3",
        "route": "CICHY KĄCIK - Al. 3 Maja, Podwale, Basztowa, Lubicz, Mogilska, Al. Jana Pawła II, Ptaszyckiego, Igołomska - PLESZÓW",
        "table": { },
        "type": "Timetable"
      }
    }
  ]
}

When I send a GET request to http://api.bagate.la/kr/_design/Timetables/_view/by_stop?startkey=["Bagatela","14"]&endkey=["Bagatela","14",{}]
Then the response status should be 200

And the response without rows' value._rev should be:

{"total_rows": 4,
 "offset": 0,
 "rows": 
  [{"id": "4",
    "key": ["Bagatela", "14", "BRONOWICE"],
    "value": {
      "_id": "4",
      "line": "14",
      "stop": "Bagatela",
      "stop_id": "1",
      "route": 
       "MISTRZEJOWICE - ks. Jancarza, Srebrnych Orłów, Mikołajczyka, Broniewskiego, Andersa, Bieńczycka, Al. Pokoju, Al. Powstania Warszawskiego, Lubicz, Basztowa, Dunajewskiego, Karmelicka, Królewska, Podchorążych, Bronowicka - BRONOWICE",
      "table": {},
      "type": "Timetable"}},
   {"id": "5",
    "key": ["Bagatela", "14", "MISTRZEJOWICE"],
    "value": {
      "_id": "5",
      "line": "14",
      "stop": "Bagatela",
      "stop_id": "2",
      "route": 
       "BRONOWICE - Bronowicka, Podchorążych, Królewska, Karmelicka, Basztowa, Lubicz, Al. Powstania Warszawskiego, Al. Pokoju, Bieńczycka, Andersa, Broniewskiego, Mikołajczyka, Srebrnych Orłów, ks. Jancarza - MISTRZEJOWICE",
      "table": {},
      "type": "Timetable"}}]}

When I send a GET request to http://api.bagate.la/kr/_design/Timetables/_view/by_stop?key=["Bagatela","14","BRONOWICE"]
Then the response status should be 200

And the response without rows' value._rev should be:

{"total_rows": 4,
 "offset": 0,
 "rows": 
  [{"id": "4",
    "key": ["Bagatela", "14", "BRONOWICE"],
    "value": {
      "_id": "4",
      "line": "14",
      "stop": "Bagatela",
      "stop_id": "1",
      "route": 
       "MISTRZEJOWICE - ks. Jancarza, Srebrnych Orłów, Mikołajczyka, Broniewskiego, Andersa, Bieńczycka, Al. Pokoju, Al. Powstania Warszawskiego, Lubicz, Basztowa, Dunajewskiego, Karmelicka, Królewska, Podchorążych, Bronowicka - BRONOWICE",
      "table": {},
      "type": "Timetable"}}]}

Scenario: Find timetables by source

Given the following timetables:

_id	source	valid_from
1	http://rozklady.mpk.krakow.pl/aktualne/0099/0099t014.htm	17.04.2011
2	http://rozklady.mpk.krakow.pl/aktualne/0099/0099t014.htm	17.05.2011
3	http://rozklady.mpk.krakow.pl/aktualne/0099/0099t030.htm	17.05.2011

When I send a GET request to http://api.bagate.la/kr/_design/Timetables/_view/by_source?key=["http://rozklady.mpk.krakow.pl/aktualne/0099/0099t030.htm", "17.05.2011"]
Then the response status should be 200

And the response without rows' value._rev should be:

{"total_rows": 3, "offset": 2, "rows":  [
  {"id": "3",
  "key": ["http://rozklady.mpk.krakow.pl/aktualne/0099/0099t030.htm", "17.05.2011"],
  "value":  {"_id":"3", "source": "http://rozklady.mpk.krakow.pl/aktualne/0099/0099t030.htm", "valid_from": "17.05.2011", "type": "Timetable"}}]}

When I send a GET request to http://api.bagate.la/kr/_design/Timetables/_view/by_source?startkey=["http://rozklady.mpk.krakow.pl/aktualne/0099/0099t014.htm"]&endkey=["http://rozklady.mpk.krakow.pl/aktualne/0099/0099t014.htm", {}]
Then the response status should be 200

And the response without rows' value._rev should be:

{"total_rows": 3, "offset": 0, "rows":  [
  {"id": "1",
  "key": ["http://rozklady.mpk.krakow.pl/aktualne/0099/0099t014.htm", "17.04.2011"],
  "value":  {"_id": "1", "source": "http://rozklady.mpk.krakow.pl/aktualne/0099/0099t014.htm", "valid_from": "17.04.2011", "type": "Timetable"}},
  {"id": "2",
  "key": ["http://rozklady.mpk.krakow.pl/aktualne/0099/0099t014.htm", "17.05.2011"],
  "value":  {"_id": "2", "source": "http://rozklady.mpk.krakow.pl/aktualne/0099/0099t014.htm", "valid_from": "17.05.2011", "type": "Timetable"}}]}

Scenario: Attributes filtering

Given the following timetables:

_id	line	route	stop	table	valid_since
1	1	WZGÓRZA KRZESŁAWICKIE - Kocmyrzowska, Bieńczycka, Al. Pokoju, Grzegórzecka, Dietla, Starowiślna - POCZTA GŁÓWNA	Darwina	{"Soboty": {"5": ["15","35"]}}	14.10.2010

When I send a GET request to http://api.bagate.la/kr/_design/Timetables/_list/filter/by_stop?only=line,stop
Then the response status should be 200

And the response should be:

{"total_rows": 1, "offset": 0, "rows": [
  {"id": "1", "key": ["Darwina", "1", "POCZTA GŁÓWNA"], "value": {"stop": "Darwina", "line": "1"}}
]}

When I send a GET request to http://api.bagate.la/kr/_design/Timetables/_list/filter/by_stop?except=_id,_rev,route,table
Then the response status should be 200

And the response should be:

{"total_rows": 1, "offset": 0, "rows": [
  {"id": "1", "key": ["Darwina", "1", "POCZTA GŁÓWNA"], "value": {"line": "1", "stop": "Darwina", "valid_since": "14.10.2010", "type": "Timetable"}}
]}

Last published almost 11 years ago by stanley.

Querying timetables

Background:

Scenario: Find timetables by line

Scenario: Lines' route(s)

Scenario: Find timetables by stop id

Scenario: Find timetables by stop name

Scenario: Find timetables by source

Scenario: Attributes filtering

Bagatela settings