fix(db): only update fields when necessary for repo hot path writes #1594

	# name of the action
	name: integration-test

	# trigger on pull_request events that modify this file or any database files
	on:
	pull_request:
	paths:
	- ".github/workflows/integration-test.yml"
	- "database/**"

	permissions:
	contents: read

	# pipeline to execute
	jobs:
	database_postgres:
	runs-on: ubuntu-latest

	strategy:
	matrix:
	# support should be n-1 here
	postgres_version:
	- postgres:15-alpine
	- postgres:16-alpine

	services:
	postgres:
	image: ${{ matrix.postgres_version }}
	env:
	POSTGRES_DB: vela
	POSTGRES_PASSWORD: notARealPassword12345
	POSTGRES_USER: vela
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5
	ports:
	- 5432:5432

	env:
	POSTGRES_ADDR: postgres://vela:notARealPassword12345@localhost:5432/vela

	steps:
	- name: clone
	uses: actions/checkout@de0fac2e4500dabe0009e67214ff5f5447ce83dd # v6.0.2

	- name: install go
	uses: actions/setup-go@4b73464bb391d4059bd26b0524d20df3927bd417 # v6.3.0
	with:
	# use version from go.mod file
	go-version-file: "go.mod"
	cache: true
	check-latest: true

	- name: testing with ${{ matrix.postgres_version }}
	run: \|
	DB_DRIVER=postgres make integration-test

	database_sql:
	runs-on: ubuntu-latest

	env:
	SQLITE_ADDR: vela.db

	steps:
	- name: clone
	uses: actions/checkout@de0fac2e4500dabe0009e67214ff5f5447ce83dd # v6.0.2

	- name: install go
	uses: actions/setup-go@4b73464bb391d4059bd26b0524d20df3927bd417 # v6.3.0
	with:
	# use version from go.mod file
	go-version-file: "go.mod"
	cache: true
	check-latest: true

	- name: testing with sqlite
	run: \|
	DB_DRIVER=sqlite make integration-test

Provide feedback