From 3f08f86ac2ac65d458b0cd378b366003812b32fb Mon Sep 17 00:00:00 2001 From: Daniel Friesel Date: Wed, 18 Jan 2023 18:36:11 +0100 Subject: migration: only select required fields --- lib/Travelynx/Command/database.pm | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/lib/Travelynx/Command/database.pm b/lib/Travelynx/Command/database.pm index d8b04d2..4b83208 100644 --- a/lib/Travelynx/Command/database.pm +++ b/lib/Travelynx/Command/database.pm @@ -1225,7 +1225,7 @@ my @migrations = ( say 'Adjusting route schema, this may take a while ...'; - my $res = $db->select( 'in_transit_str', '*' ); + my $res = $db->select( 'in_transit_str', [ 'route', 'user_id' ] ); while ( my $row = $res->expand->hash ) { my @new_route; for my $stop ( @{ $row->{route} } ) { @@ -1242,9 +1242,8 @@ my @migrations = ( = $db->select( 'journeys', 'count(*) as count' )->hash->{count}; my $count = 0; - $res = $db->select( 'journeys_str', '*' ); + $res = $db->select( 'journeys_str', [ 'route', 'journey_id' ] ); while ( my $row = $res->expand->hash ) { - my $id = $row->{journey_id}; my @new_route; for my $stop ( @{ $row->{route} } ) { -- cgit v1.2.3