summaryrefslogtreecommitdiff
path: root/lib/Travelynx/Command/database.pm
AgeCommit message (Collapse)AuthorLines
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
2019-08-31Fix wagon order and direction display1.8.9Daniel Friesel-0/+29
This was broken by a database migration introduced in commit f6d56d3134f6045726cb1d4ed8700382575bb686
2019-08-23Add proper journey comment supportDaniel Friesel-0/+75
2019-08-13Fix beeline distance calculation when start/stop has no geo-coordinates1.8.7Daniel Friesel-1/+17
2019-06-04checked in: Show QoS messages before departure and HIM messages at all timesDaniel Friesel-0/+30
2019-05-26Use JSON for messages and route storage, prepare for extended route dataDaniel Friesel-0/+113
2019-05-20show journey suggestions on departure board as well1.6.0Daniel Friesel-0/+11
2019-05-18Show arrival/departure platform in journey cardDaniel Friesel-0/+54
2019-05-05WiP webhook supportDaniel Friesel-0/+25
2019-04-30use a separate table for registration tokensDaniel Friesel-0/+32
2019-04-30Implement deletion of inactive accountsDaniel Friesel-0/+12
2019-04-30allow users to change their mail address0.19Daniel Friesel-1/+20
Closes #6
2019-04-29Add password reset functionalityDaniel Friesel-0/+17
Closes #5
2019-04-29add database table/column comments0.18Daniel Friesel-0/+33
2019-04-28Handle inconsistent data when calculating monthly/yearly statsDaniel Friesel-0/+13
Closes #11
2019-04-23Use one row per journey instead of split checkin/checkout entriesDaniel Friesel-1/+207
Whether a user is in transit or not is now determined by an entry in the in_transit table instead of a dangling checkin. All completed journeys are stored in the "journeys" table. This does most of the work needed for automatic checkout. However, note that the corresponding worker process is not implemented yet.
2019-04-22Use Mojo::Pg for migrationsDaniel Friesel-59/+62
2019-04-21database migrate: Use truncateDaniel Friesel-1/+1
2019-04-21Ignore stations without coordinates in distance calculationDaniel Friesel-0/+14
Reported by @marudor
2019-04-18Add a registration testDaniel Friesel-2/+0
2019-04-14Do not print error when encountering an empty databaseDaniel Friesel-6/+16
2019-04-13database setup: merge setup and migration code pathsMarkus Witt-40/+58
2019-04-13"database" sub-command: Provide an exit statusDaniel Friesel-0/+5
2019-04-13fix dbschema: add type for editedMarkus Witt-1/+1
2019-04-09Allow journey editing, keep track of edited journey attributes0.13Daniel Friesel-1/+15
Provides a workaround for #2
2019-04-07Cache journey statsDaniel Friesel-4/+25
2019-04-07Add a note about updating travelynxDaniel Friesel-1/+9
2019-04-06Add a database command for database setup and migrationsDaniel Friesel-0/+131