summaryrefslogtreecommitdiff
path: root/lib/Travelynx/Command/database.pm
AgeCommit message (Collapse)AuthorLines
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