From f4d71b4d9fb4191c07a9c200d32626175568b4fa Mon Sep 17 00:00:00 2001
From: Birte Kristina Friesel <derf@finalrewind.org>
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