tree e287f10e4c2ce53a7b980d38c972aa2515ad75b1
parent 030d6bd4c085ea8d1dc4e94ce4d5e69736df9114
author Jonathan Amsterdam <jba@google.com> 1616629329 -0400
committer Jonathan Amsterdam <jba@google.com> 1616670159 +0000

internal/database: add CopyUpsert

Add the CopyUpsert method, which uses an efficient
Postgres protocol to insert rows.

For this to work, we need the connection underlying a sql.Tx value.
Since sql.Tx doesn't expose its connection, we create one explicitly
in DB.transact.

Change-Id: Ie48ce7a4318f4531d4756f779943188a6f0fb6cd
Reviewed-on: https://go-review.googlesource.com/c/pkgsite/+/304631
Trust: Jonathan Amsterdam <jba@google.com>
Run-TryBot: Jonathan Amsterdam <jba@google.com>
TryBot-Result: kokoro <noreply+kokoro@google.com>
Reviewed-by: Julie Qiu <julie@golang.org>