view pkg/imports/track.go @ 5560:f2204f91d286

Join the log lines of imports to the log exports to recover data from them. Used in SR export to extract information that where in the meta json but now are only found in the log.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 09 Feb 2022 18:34:40 +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
}