view pkg/imports/track.go @ 5670:b75d0b303328

Various fixes and improvements of gauges import: - Allow update of erased data (and thereby set erased to false) - Fix source_organization to work with ERDMS2 - Give ISRS of new and updated gauges in summary - Fixed reference of null pointers if revlevels are missing - Fixed reference of null pointer on update errors - Added ISRS to reference_code warning
author Sascha Wilde <wilde@sha-bang.de>
date Fri, 08 Dec 2023 17:29:56 +0100
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
}