sqlindo/sqlindo_test.go at master · nunesvn/sqlindo · 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
77
78
79
80
81
82
83
84
85
86
87
88
89
package sqlindo

import (
	"fmt"
	"testing"
)

// func TestGetConfigs(t *testing.T) {

// 	var db DB
// 	db.Driver = "postgres"
// 	//db.Host = "cfg.rede.tri.com.br"
// 	db.Host = "127.0.0.1"
// 	db.SSLMode = "disable"
// 	db.Port = "5432"
// 	db.Name = "pet3"
// 	db.User = "postgres"
// 	db.Password = ""

// 	db.Connect()

// 	opa := db.GetConfigs("cadin_configuracoes_gerais_pet")
// 	fmt.Println(opa)
// 	db.Conn.Close()
// 	//fmt.Println(opa["parks_config_seis"].(bool))
// }

func TestSelectRow(t *testing.T) {

	var db DB
	db.Driver = "postgres"
	db.Host = "cfg.rede.tri.com.br"
	//db.Host = "127.0.0.1"
	db.SSLMode = "disable"
	db.Port = "5432"
	db.Name = "pet3"
	db.User = "postgres"
	db.Password = ""

	db.Connect()

	opa := db.SelectRow("select * from cadin_configuracoes_gerais_pet")
	fmt.Println(opa)
	fmt.Println(opa["id"].(int64) + 1)
	db.Conn.Close()

}

func TestSelect(t *testing.T) {

	var db DB
	db.Driver = "postgres"
	//db.Host = "cfg.rede.tri.com.br"
	db.Host = "127.0.0.1"
	db.SSLMode = "disable"
	db.Port = "5432"
	db.Name = "pet3"
	db.User = "postgres"
	db.Password = ""

	db.Connect(1)

	opa := db.Select("select * from operations")
	fmt.Println(opa)
	//fmt.Println(opa[0]["id"].(int64) + 1)
	db.Conn.Close()

}

func TestSelectString(t *testing.T) {

	var db DB
	db.Driver = "postgres"
	//db.Host = "cfg.rede.tri.com.br"
	db.Host = "127.0.0.1"
	db.SSLMode = "disable"
	db.Port = "5432"
	db.Name = "pet3"
	db.User = "postgres"
	db.Password = ""

	db.Connect()

	opa := db.SelectString("select * from operations")
	fmt.Println(opa)
	fmt.Println(opa[0]["param"])
	db.Conn.Close()

}