go-db-sql-query/main_test.go at main · PracticumGrade/go-db-sql-query · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
package main

import (
	"database/sql"
	"testing"

	"github.com/stretchr/testify/require"
)

func TestInsertUpdateDelete(t *testing.T) {
	// prepare
	db, err := sql.Open("sqlite", "demo.db")
	require.NoError(t, err)
	defer db.Close()

	newClient := Client{
		FIO:      "TEST",
		Login:    "TEST",
		Birthday: "TEST",
		Email:    "TEST",
	}

	// insert
	id, err := insertClient(db, newClient)

	require.NoError(t, err)
	require.NotEmpty(t, id)
	newClient.ID = int(id)

	got, err := selectClient(db, id)
	require.NoError(t, err)
	require.Equal(t, newClient, got)

	// update
	newLogin := "TEST_NEW"
	err = updateClientLogin(db, newLogin, id)
	require.NoError(t, err)

	got, err = selectClient(db, id)
	require.NoError(t, err)
	require.Equal(t, newLogin, got.Login)

	// delete
	err = deleteClient(db, id)
	require.NoError(t, err)

	got, err = selectClient(db, id)
	require.Equal(t, sql.ErrNoRows, err)
	require.Empty(t, got)
}