go-sqlbuilder/insert_test.go at master · parkingwang/go-sqlbuilder · 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
package sqlbuilder

import "testing"

//
// Author: 陈永佳 chenyongjia@parkingwang.com, yoojiachen@gmail.com
//

func TestInsertInto(t *testing.T) {
	sb := NewContext()
	sql := sb.Insert("t_users").
		Columns("username", "password").
		SetValueOfColumn("password", 123).
		ToSQL()
	checkSQLMatches(sql, "INSERT INTO `t_users`(`username`, `password`) VALUES (?, 123);", t)
}

func TestInsertInto1(t *testing.T) {
	sb := NewContext()
	sql := sb.Insert("t_users").
		Columns("username", "password").
		Values("yoojia", "1234").
		ToSQL()
	checkSQLMatches(sql, "INSERT INTO `t_users`(`username`, `password`) VALUES ('yoojia', '1234');", t)
}

func TestInsertIntoValued(t *testing.T) {
	sb := NewContext()
	sql := sb.Insert("t_users").
		Columns("username", "password").
		Values("yoojia", "123456").
		ToSQL()
	checkSQLMatches(sql, "INSERT INTO `t_users`(`username`, `password`) VALUES ('yoojia', '123456');", t)
}