| 87 | } |
| 88 | |
| 89 | func TestInsertBuilderSelect(t *testing.T) { |
| 90 | sb := Select("field1").From("table1").Where(Eq{"field1": 1}) |
| 91 | ib := Insert("table2").Columns("field1").Select(sb) |
| 92 | |
| 93 | sql, args, err := ib.ToSql() |
| 94 | assert.NoError(t, err) |
| 95 | |
| 96 | expectedSQL := "INSERT INTO table2 (field1) SELECT field1 FROM table1 WHERE field1 = ?" |
| 97 | assert.Equal(t, expectedSQL, sql) |
| 98 | |
| 99 | expectedArgs := []interface{}{1} |
| 100 | assert.Equal(t, expectedArgs, args) |
| 101 | } |
| 102 | |
| 103 | func TestInsertBuilderReplace(t *testing.T) { |
| 104 | b := Replace("table").Values(1) |