package main

import (
	"database/sql"

	"gemma.intevation.de/gemma/pkg/octree"
)

type result struct {
	h     float64
	lines octree.MultiLineStringZ
}

const insertSQL = `
INSERT INTO waterway.contour_lines (height, geom)
VALUES ($1, ST_Transform(
	ST_SetSRID(ST_GeomFromWKB($2), $3), 4326)::geography)
`

func store(all []result, epsg uint32) error {

	return run(func(db *sql.DB) error {

		tx, err := db.Begin()
		if err != nil {
			return err
		}
		defer tx.Rollback()

		stmt, err := tx.Prepare(insertSQL)
		if err != nil {
			return err
		}

		for _, r := range all {
			if _, err := stmt.Exec(r.h, r.lines.AsWKB(), epsg); err != nil {
				return err
			}
		}

		return tx.Commit()
	})
}