summaryrefslogtreecommitdiff
path: root/lib/Travelynx/Command/database.pm
AgeCommit message (Collapse)AuthorLines
2024-08-15truncate journey stats once more2.8.21Birte Kristina Friesel-0/+17
2024-08-12database: avoid needlessly incrementing backends.idBirte Kristina Friesel-8/+18
2024-08-07dumpstops: provide backend name and type rather than just opaque IDs2.8.10Birte Kristina Friesel-0/+22
2024-07-26fix v55 migration: we also need to sync hafas->iris in some cases2.8.1Birte Kristina Friesel-7/+66
2024-07-26Multi-backend supportBirte Kristina Friesel-4/+266
Squashed commit of the following: commit 92518024ba295456358618c0e8180bd8e996fdf1 Author: Birte Kristina Friesel <birte.friesel@uos.de> Date: Fri Jul 26 18:39:46 2024 +0200 add_or_update station: remove superfluos 'new backend id := old backend id' commit df21c20c6e4c86454f8a9ac69121404415217f2a Author: Birte Kristina Friesel <birte.friesel@uos.de> Date: Fri Jul 26 18:35:51 2024 +0200 revert connection targets min_count to 3 commit be335cef07d0b42874f5fc1de4a1d13396e8e807 Author: Birte Kristina Friesel <birte.friesel@uos.de> Date: Fri Jul 26 18:20:05 2024 +0200 mention backend selection in API documentation commit 9f41828fb4f18fd707e0087def3032e8d4c8d7d8 Author: Birte Kristina Friesel <derf@finalrewind.org> Date: Thu Jul 25 20:19:23 2024 +0200 use_history: not all backends provide route data in departure monitor commit 09714b4d89684b8331d0e96f564a4c7432318f70 Author: Birte Kristina Friesel <derf@finalrewind.org> Date: Thu Jul 25 20:11:44 2024 +0200 disambiguation: pass correct hafas parameter commit 8cdf1120fc32155dc6525be64601b7c10a9c7f52 Author: Birte Kristina Friesel <derf@finalrewind.org> Date: Thu Jul 25 20:11:28 2024 +0200 _checked_in: hide Zuglauf link for non-db checkins commit 7455653f541198e0e0a6d11aed421487ffdb6285 Author: Birte Kristina Friesel <derf@finalrewind.org> Date: Thu Jul 25 20:01:47 2024 +0200 debug output commit b9cda07f85601a58ea32dbdacdd5399f302db52b Author: Birte Kristina Friesel <derf@finalrewind.org> Date: Thu Jul 25 19:09:07 2024 +0200 fix remaining get_connection_targets / get_connecting_trains_p invocations commit 2759d7258c37c7498905cfe19f6b4c4f6d16bd21 Author: Birte Kristina Friesel <derf@finalrewind.org> Date: Wed Jul 24 20:50:12 2024 +0200 support non-DB HAFAS backends (WiP)
2024-07-21Add lat/lon to pre-2.7.8 journeys; add eva where missingBirte Kristina Friesel-1/+145
This speeds up the map significantly and makes coordinates_by_station obsolete
2024-06-09Increate train_id length to account for DB HAFAS update2.6.19Birte Kristina Friesel-1/+117
2024-06-08Store journey backend; do not rely on '|' in ID to distinguish IRIS/HAFASBirte Kristina Friesel-0/+104
This is in preparation for supporting multiple HAFAS backends, and possibly EFA and RIS::Journeys.
2023-10-01store related stations; respect them when looking up connectionsBirte Kristina Friesel-0/+17
2023-09-24add support for HAFAS connection suggestions; drop manual destination listBirte Kristina Friesel-0/+14
Still TODO: handle stations that have several EVAs
2023-08-22Database: create index on real_departure to speed up latest journey queriesBirte Kristina Friesel-2/+12
2023-08-09Store traewelling refresh token in database1.34.3Birte Kristina Friesel-0/+22
2023-08-08sort timeline (descending by checkin timestamp, so most recent checkins first)1.34.2Birte Kristina Friesel-0/+47
2023-08-07Traewelling: replace legacy password login with OAuth2Birte Kristina Friesel-0/+19
This is a breaking change insofar as that traewelling support is no longer provided automatically, but must be enabled by providing a traewelling.de application ID and secret in travelynx.conf. However, as traewelling.de password login is deprecated and wil soon be disabled, travelynx would break either way. So we might or might not see travelynx 2.0.0 in the next days. Automatic token refresh is still todo, but that was the case for password login as well. Closes #64
2023-07-22database: stations: make 'ds100' column optional.Birte Kristina Friesel-0/+12
HAFAS stations do not necessarily have ds100 codes
2023-07-18followee list: show if accounts are following back1.33.3Birte Kristina Friesel-0/+23
2023-07-16account: add a list of sent follow requestsBirte Kristina Friesel-0/+19
2023-07-15database: change maximum comment lengthBirte Kristina Friesel-8/+8
2023-07-15add view for followees in transitBirte Kristina Friesel-0/+44
2023-07-03update ALL the copyright notices!Derf Null-1/+1
2023-06-26compute effective visibility in database viewDerf Null-0/+74
2023-06-26use small stations database for some testsDerf Null-0/+8
2023-06-24fine-graned visibility selection of history / past checkinsDerf Null-0/+54
most notably, adds a 'history for followers only' mode
2023-06-24time to flush the name cacheDerf Null-1/+1
2023-06-04fix missing join condition in followers viewDerf Null-0/+23
2023-06-04do not accept follows / follow requests by defaultDerf Null-1/+1
2023-06-04expose follows / social interaction in frontendDerf Null-0/+21
2023-06-03Users: support notifications about pending follow requestsDerf Null-0/+29
2023-05-31prepare for follow relations and follow-only checkinsDerf Null-0/+48
2023-04-01Update HAFAS polylines prior to checkout1.30.11Derf Null-0/+42
In case of diversions, the polyline fetched at checkin time may no longer be accurate. Request a new polyline prior to checkout to address this. Closes #66
2023-03-03set default visibility to unlistedDaniel Friesel-1/+3
2023-02-27set visibility per journey (wip)Daniel Friesel-0/+114
some odds and ends left to polish, but ready for testing
2023-02-19update ze copyrightDaniel Friesel-1/+1
2023-02-04improve inconsistency list1.29.18Daniel Friesel-0/+12
2023-02-04inconsistent journeys: link to journeysDaniel Friesel-0/+13
2023-01-18migration: only select required fields1.29.13Daniel Friesel-3/+2
2023-01-15change route/stop layout to [name, eva, {data}]Daniel Friesel-0/+76
2022-12-12database migration: track previosu travelynx version; offer rollback hintsDaniel Friesel-13/+66
2022-12-12database IRIS sync: update ds100, name, lat, lon from IRIS DB1.28.4Daniel Friesel-1/+1
2022-12-12database: has-current-schema: check IRIS versionDaniel Friesel-1/+4
2022-12-11database: refactor schema/iris version checkDaniel Friesel-19/+5
2022-12-07get name/ds100 from db and lat/lon from dict1.28.1Daniel Friesel-0/+67
result: significant performance improvement for stats generation
2022-12-07switch to internal station database; add out-of-service stations for old ↵1.28.0Daniel Friesel-1/+238
journeys
2022-09-24optionally show local transit connections as wellDaniel Friesel-0/+23
2022-08-19use bahn.expert as new domain for marudor.demarudor-1/+1
2022-07-11optionally link to external departure boards where sensible (WiP)Daniel Friesel-0/+14
2022-07-11database: fix missing word in workflow exampleDaniel Friesel-1/+1
2022-02-14Send inactivity notification prior to account deletionDaniel Friesel-0/+14
2021-01-29Switch to AGPL3+Daniel Friesel-1/+1
2020-11-27Add a bunch of licensing dataDaniel Friesel-0/+3