Mercurial > gemma
view pkg/imports/errors.go @ 3533:8e083b271fca
Improve error messages if no matching gauge version found
Avoid hitting the NOT NULL constraint of the referencing validity
column in order to hit the foreign key constraint instead and emit
an appropriate error message in all such cases.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 29 May 2019 18:14:20 +0200 |
parents | e0dabe7b2fcf |
children | 453f15ba8030 |
line wrap: on
line source
// This is Free Software under GNU Affero General Public License v >= 3.0 // without warranty, see README.md and license for details. // // SPDX-License-Identifier: AGPL-3.0-or-later // License-Filename: LICENSES/AGPL-3.0.txt // // Copyright (C) 2019 by via donau // – Österreichische Wasserstraßen-Gesellschaft mbH // Software engineering by Intevation GmbH // // Author(s): // * Tom Gottfried <tom.gottfried@intevation.de> package imports import ( "strings" "github.com/jackc/pgx" ) func handleError(err error) error { switch e := err.(type) { case pgx.PgError: return dbError(e) } return err } // Handle PostgreSQL error codes const ( notNullViolation = "23502" foreignKeyViolation = "23503" noDataFound = "P0002" ) type dbError pgx.PgError func (err dbError) Error() string { switch err.Code { case notNullViolation: switch err.SchemaName { case "waterway": switch err.TableName { case "gauges": switch err.ColumnName { case "objname": return "Missing objname" case "geom": return "Missing lat/lon" case "zero_point": return "Missing zeropoint" } } } case foreignKeyViolation: switch err.SchemaName { case "waterway": switch err.TableName { case "gauge_measurements", "gauge_predictions", "bottlenecks": switch err.ConstraintName { case "gauge_key": return "Referenced gauge with matching temporal validity not available" } } } case noDataFound: // Most recent line from stacktrace contains name of failed function recent := strings.SplitN(err.Where, "\n", 1)[0] switch { case strings.Contains(recent, "isrsrange_points"): return "No distance mark found for at least one given ISRS Location Code" case strings.Contains(recent, "isrsrange_axis"): return "No contiguous axis found between given ISRS Location Codes" } } return "Unexpected database error: " + err.Message }