Skip to content

Git designed for AI agents.

1011 B
Raw Blame
package testdb

import (
	"testing"

	"github.com/feder-cr/git-ai/internal/testhelper"
	"github.com/stretchr/testify/require"
)

func TestDB_Truncate(t *testing.T) {
	t.Parallel()
	ctx := testhelper.Context(t)
	db := New(t)

	_, err := db.ExecContext(ctx, "CREATE TABLE truncate_tbl(id BIGSERIAL PRIMARY KEY)")
	require.NoError(t, err)

	res, err := db.ExecContext(ctx, "INSERT INTO truncate_tbl VALUES (DEFAULT), (DEFAULT)")
	require.NoError(t, err)
	affected, err := res.RowsAffected()
	require.NoError(t, err)
	require.Equal(t, int64(2), affected, "2 rows must be inserted into the table")

	db.Truncate(t, "truncate_tbl")

	var count int
	require.NoError(t, db.QueryRowContext(ctx, "SELECT COUNT(*) FROM truncate_tbl").Scan(&count))
	require.Equal(t, 0, count, "no rows must exist after TRUNCATE operation")

	var id int
	require.NoError(t, db.QueryRowContext(ctx, "INSERT INTO truncate_tbl VALUES (DEFAULT) RETURNING id").Scan(&id))
	require.Equal(t, 1, id, "sequence for primary key must be restarted")
}