summaryrefslogtreecommitdiff
path: root/lib/Travelynx/Command/database.pm
AgeCommit message (Collapse)AuthorLines
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
2019-12-23Use EVA IDs instead of travelynx-internal station IDs. Not 100% tested yet.Daniel Friesel-0/+132