summaryrefslogtreecommitdiff
path: root/lib/Travelynx/Command/database.pm
AgeCommit message (Collapse)AuthorLines
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
2020-10-06Stats: Fix handling of negative cumulative arrival/departure delays1.18.1Daniel Friesel-0/+14
2020-09-30Allow linking a Träwelling account, auto-sync Träwelling→travelynxDaniel Friesel-0/+26
travelynx→Träwelling is still work-in-progress Squashed commit of the following: commit 97faa6e2e6c8d20fba30f2d0f6e78187ceeb72e6 Author: Daniel Friesel <derf@finalrewind.org> Date: Wed Sep 30 18:50:05 2020 +0200 improve traewelling log and tx handling commit 487d7dd728b9d45b731bdc7098cf3358ea2e206e Author: Daniel Friesel <derf@finalrewind.org> Date: Wed Sep 30 18:02:41 2020 +0200 add missing traewelling template commit 0148da2f48d9a52dcddc0ab81f83d8f8ac3062ab Author: Daniel Friesel <derf@finalrewind.org> Date: Wed Sep 30 18:02:35 2020 +0200 improve traewelling pull sync commit 4861a9750f9f2d7621043361d0af6b0a8869a0df Author: Daniel Friesel <derf@finalrewind.org> Date: Tue Sep 29 22:14:24 2020 +0200 wip checkin from traewelling commit f6aeb6f06998a2a7a80f63a7b1b688b1a26b66bd Author: Daniel Friesel <derf@finalrewind.org> Date: Tue Sep 29 18:37:53 2020 +0200 refactor traewelling integration. login and logout are less of a hack now. checkin and checkout are not supported at the moment.
2020-04-14use polyline when computing monthly/yearly distance travelled1.15.10Daniel Friesel-0/+15
Closes #40
2020-01-27Store journey polylines in DBDaniel Friesel-0/+56
Squashed commit of the following: commit d60c7d3c98d88a8f5b0e3ced6c11b56053e1e44b Author: Daniel Friesel <derf@finalrewind.org> Date: Mon Jan 27 20:22:46 2020 +0100 fix bugs related to users without past journeys commit 707fcc937ac7f6bc3dc29024273f5e74963f7f15 Author: Daniel Friesel <derf@finalrewind.org> Date: Mon Jan 27 20:19:14 2020 +0100 work around Cache::file turning floats into strings commit 55831121eb30bc30ed20134bbb48e4bee9772feb Author: Daniel Friesel <derf@finalrewind.org> Date: Mon Jan 27 19:43:29 2020 +0100 store journey polylines for later use commit 1971d511037ff2b8fbc9699cb98e4f8fd51261e5 Author: Daniel Friesel <derf@finalrewind.org> Date: Sat Jan 25 16:49:48 2020 +0100 set preliminary database schema for polyline storage. deduplication will follow at a later stage
generated by cgit v1.2.3 (git 2.39.1) at 2024-11-07 21:40:51 +0000