sqlitecloud-go/test/select_test.go at 65a0809450fc12bbd5e8c55b981bf804221ed840 · sqlitecloud/sqlitecloud-go · 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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
package test

import (
	"os"
	"testing"

	"github.com/sqlitecloud/sqlitecloud-go"
)

func TestSelectWithLeadingChars(t *testing.T) {
	// Server API test
	connectionString, _ := os.LookupEnv("SQLITE_CONNECTION_STRING")
	apikey, _ := os.LookupEnv("SQLITE_API_KEY")
	connectionString += "/" + os.Getenv("SQLITE_DB") + "?apikey=" + apikey

	config, err1 := sqlitecloud.ParseConnectionString(connectionString)
	if err1 != nil {
		t.Fatal(err1.Error())
	}

	db := sqlitecloud.New(*config)
	err := db.Connect()

	if err != nil {
		t.Fatalf(err.Error())
	}

	defer db.Close()

	// test select with leading spaces
	result, err := db.Select("     SELECT 1 AS value;")
	if err != nil {
		t.Fatal(err.Error())
	}
	if result.GetNumberOfRows() != 1 {
		t.Fatalf("Expected 1 row, got %d rows", result.GetNumberOfRows())
	}

	// test select with leading tabs
	result, err = db.Select("\t\t\tSELECT 1 AS value;")
	if err != nil {
		t.Fatal(err.Error())
	}
	if result.GetNumberOfRows() != 1 {
		t.Fatalf("Expected 1 row, got %d rows", result.GetNumberOfRows())
	}

	// test select with leading new lines
	result, err = db.Select("\n\n\nSELECT 1 AS value;")
	if err != nil {
		t.Fatal(err.Error())
	}
	if result.GetNumberOfRows() != 1 {
		t.Fatalf("Expected 1 row, got %d rows", result.GetNumberOfRows())
	}

	// test with leading carriage returns
	result, err = db.Select("\r\r\rSELECT 1 AS value;")
	if err != nil {
		t.Fatal(err.Error())
	}
	if result.GetNumberOfRows() != 1 {
		t.Fatalf("Expected 1 row, got %d rows", result.GetNumberOfRows())
	}

	// test select with mixed leading characters
	result, err = db.Select(`
		SELECT 1 AS value;
	`)
	if err != nil {
		t.Fatal(err.Error())
	}
	if result.GetNumberOfRows() != 1 {
		t.Fatalf("Expected 1 row, got %d rows", result.GetNumberOfRows())
	}
}