github.com/yongjacky/phoenix-go-orm-builder@v0.3.5/builder_insert_test.go (about)

     1  // Copyright 2018 The Xorm Authors. All rights reserved.
     2  // Use of this source code is governed by a BSD-style
     3  // license that can be found in the LICENSE file.
     4  
     5  package builder
     6  
     7  import (
     8  	"testing"
     9  
    10  	"github.com/stretchr/testify/assert"
    11  )
    12  
    13  func TestBuilderInsert(t *testing.T) {
    14  	sql, err := Insert(Eq{"c": 1, "d": 2}).Into("table1").ToBoundSQL()
    15  	assert.NoError(t, err)
    16  	assert.EqualValues(t, "INSERT INTO table1 (c,d) Values (1,2)", sql)
    17  
    18  	sql, err = Insert(Eq{"e": 3}, Eq{"c": 1}, Eq{"d": 2}).Into("table1").ToBoundSQL()
    19  	assert.NoError(t, err)
    20  	assert.EqualValues(t, "INSERT INTO table1 (c,d,e) Values (1,2,3)", sql)
    21  
    22  	sql, err = Insert(Eq{"c": 1, "d": Expr("SELECT b FROM t WHERE d=? LIMIT 1", 2)}).Into("table1").ToBoundSQL()
    23  	assert.NoError(t, err)
    24  	assert.EqualValues(t, "INSERT INTO table1 (c,d) Values (1,(SELECT b FROM t WHERE d=2 LIMIT 1))", sql)
    25  
    26  	sql, err = Insert(Eq{"c": 1, "d": 2}).ToBoundSQL()
    27  	assert.Error(t, err)
    28  	assert.EqualValues(t, ErrNoTableName, err)
    29  	assert.EqualValues(t, "", sql)
    30  
    31  	sql, err = Insert(Eq{}).Into("table1").ToBoundSQL()
    32  	assert.Error(t, err)
    33  	assert.EqualValues(t, ErrNoColumnToInsert, err)
    34  	assert.EqualValues(t, "", sql)
    35  
    36  	sql, err = Insert(Eq{`a`: nil}).Into(`table1`).ToBoundSQL()
    37  	assert.NoError(t, err)
    38  	assert.EqualValues(t, `INSERT INTO table1 (a) Values (null)`, sql)
    39  
    40  	sql, args, err := Insert(Eq{`a`: nil, `b`: `str`}).Into(`table1`).ToSQL()
    41  	assert.NoError(t, err)
    42  	assert.EqualValues(t, `INSERT INTO table1 (a,b) Values (null,?)`, sql)
    43  	assert.EqualValues(t, []interface{}{`str`}, args)
    44  }
    45  
    46  func TestBuidlerInsert_Select(t *testing.T) {
    47  	sql, err := Insert().Into("table1").Select().From("table2").ToBoundSQL()
    48  	assert.NoError(t, err)
    49  	assert.EqualValues(t, "INSERT INTO table1 SELECT * FROM table2", sql)
    50  
    51  	sql, err = Insert("a, b").Into("table1").Select("b, c").From("table2").ToBoundSQL()
    52  	assert.NoError(t, err)
    53  	assert.EqualValues(t, "INSERT INTO table1 (a, b) SELECT b, c FROM table2", sql)
    54  }