From f4d71b4d9fb4191c07a9c200d32626175568b4fa Mon Sep 17 00:00:00 2001 From: Birte Kristina Friesel Date: Sat, 26 Aug 2023 09:17:28 +0200 Subject: obtain autocompletion from database --- lib/Travelynx/Model/Stations.pm | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'lib/Travelynx/Model') diff --git a/lib/Travelynx/Model/Stations.pm b/lib/Travelynx/Model/Stations.pm index 75b4174..ecd8adb 100644 --- a/lib/Travelynx/Model/Stations.pm +++ b/lib/Travelynx/Model/Stations.pm @@ -50,6 +50,19 @@ sub add_or_update { ); } +sub get_for_autocomplete { + my ($self) = @_; + + my $res = $self->{pg}->db->select( 'stations', ['name'] ); + my %ret; + + while ( my $row = $res->hash ) { + $ret{ $row->{name} } = undef; + } + + return \%ret; +} + # Fast sub get_by_eva { my ( $self, $eva, %opt ) = @_; -- cgit v1.2.3