view pkg/imports/track.go @ 4611:b5aa1eb83bb0 geoserver_sql_views

Add possibility to configure SRS for GeoServer SQL view Automatic detection of spatial reference system for SQL views in GeoServer does not always find the correct SRS.
author Tom Gottfried <tom@intevation.de>
date Fri, 06 Sep 2019 11:58:03 +0200
parents e45442db19b1
children
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) 2018 by via donau
//   – Österreichische Wasserstraßen-Gesellschaft mbH
// Software engineering by Intevation GmbH
//
// Author(s):
//  * Sascha L. Teichmann <sascha.teichmann@intevation.de>

package imports

import (
	"context"
	"database/sql"
)

const (
	trackImportSQL = `
    INSERT INTO import.track_imports (import_id, relation, key)
	VALUES ($1, $2::regclass, $3)`

	trackImportDeletionSQL = `
    INSERT INTO import.track_imports (import_id, deletion, relation, key)
	VALUES ($1, $4, $2::regclass, $3)`
)

func track(ctx context.Context, tx *sql.Tx, importID int64, relation string, key int64) error {
	_, err := tx.ExecContext(ctx, trackImportSQL, importID, relation, key)
	return err
}