From 8ffb773f43c8dc54801ca1d111854e7e881c93c9 Mon Sep 17 00:00:00 2001 From: Frédéric Guillot Date: Sun, 19 Nov 2017 21:10:04 -0800 Subject: First commit --- storage/timezone.go | 34 ++++++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100644 storage/timezone.go (limited to 'storage/timezone.go') diff --git a/storage/timezone.go b/storage/timezone.go new file mode 100644 index 0000000..8edfc1c --- /dev/null +++ b/storage/timezone.go @@ -0,0 +1,34 @@ +// Copyright 2017 Frédéric Guillot. All rights reserved. +// Use of this source code is governed by the Apache 2.0 +// license that can be found in the LICENSE file. + +package storage + +import ( + "fmt" + "github.com/miniflux/miniflux2/helper" + "time" +) + +func (s *Storage) GetTimezones() (map[string]string, error) { + defer helper.ExecutionTime(time.Now(), "[Storage:GetTimezones]") + + timezones := make(map[string]string) + query := `select name from pg_timezone_names() order by name asc` + rows, err := s.db.Query(query) + if err != nil { + return nil, fmt.Errorf("unable to fetch timezones: %v", err) + } + defer rows.Close() + + for rows.Next() { + var timezone string + if err := rows.Scan(&timezone); err != nil { + return nil, fmt.Errorf("unable to fetch timezones row: %v", err) + } + + timezones[timezone] = timezone + } + + return timezones, nil +} -- cgit v1.2.3