github.com/ecodeclub/eorm@v0.0.2-0.20231001112437-dae71da914d0/internal/integration/insert_test.go (about)

     1  // Copyright 2021 ecodeclub
     2  //
     3  // Licensed under the Apache License, Version 2.0 (the "License");
     4  // you may not use this file except in compliance with the License.
     5  // You may obtain a copy of the License at
     6  //
     7  // http://www.apache.org/licenses/LICENSE-2.0
     8  //
     9  // Unless required by applicable law or agreed to in writing, software
    10  // distributed under the License is distributed on an "AS IS" BASIS,
    11  // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    12  // See the License for the specific language governing permissions and
    13  // limitations under the License.
    14  
    15  //go:build e2e
    16  
    17  package integration
    18  
    19  import (
    20  	"context"
    21  	"testing"
    22  
    23  	"github.com/ecodeclub/eorm"
    24  	"github.com/ecodeclub/eorm/internal/test"
    25  	_ "github.com/go-sql-driver/mysql"
    26  	"github.com/stretchr/testify/assert"
    27  	"github.com/stretchr/testify/require"
    28  	"github.com/stretchr/testify/suite"
    29  )
    30  
    31  type InsertTestSuite struct {
    32  	Suite
    33  }
    34  
    35  func (i *InsertTestSuite) TearDownTest() {
    36  	res := eorm.RawQuery[any](i.orm, "DELETE FROM `simple_struct`").Exec(context.Background())
    37  	if res.Err() != nil {
    38  		i.T().Fatal(res.Err())
    39  	}
    40  }
    41  
    42  func (i *InsertTestSuite) TestInsert() {
    43  	testCases := []struct {
    44  		name         string
    45  		i            *eorm.Inserter[test.SimpleStruct]
    46  		rowsAffected int64
    47  		wantErr      error
    48  	}{
    49  		{
    50  			name:         "id only",
    51  			i:            eorm.NewInserter[test.SimpleStruct](i.orm).Values(&test.SimpleStruct{Id: 1}),
    52  			rowsAffected: 1,
    53  		},
    54  		{
    55  			name:         "all field",
    56  			i:            eorm.NewInserter[test.SimpleStruct](i.orm).Values(test.NewSimpleStruct(2)),
    57  			rowsAffected: 1,
    58  		},
    59  		{
    60  			name:         "ignore pk",
    61  			i:            eorm.NewInserter[test.SimpleStruct](i.orm).SkipPK().Values(test.NewSimpleStruct(3)),
    62  			rowsAffected: 1,
    63  		},
    64  		{
    65  			name: "ignore pk multi",
    66  			i: eorm.NewInserter[test.SimpleStruct](i.orm).
    67  				SkipPK().Values(test.NewSimpleStruct(4), test.NewSimpleStruct(5)),
    68  			rowsAffected: 2,
    69  		},
    70  	}
    71  	for _, tc := range testCases {
    72  		i.T().Run(tc.name, func(t *testing.T) {
    73  			res := tc.i.Exec(context.Background())
    74  			assert.Equal(t, tc.wantErr, res.Err())
    75  			if res.Err() != nil {
    76  				return
    77  			}
    78  			affected, err := res.RowsAffected()
    79  			require.NoError(t, err)
    80  			assert.Equal(t, tc.rowsAffected, affected)
    81  		})
    82  	}
    83  }
    84  
    85  func TestMySQL8Insert(t *testing.T) {
    86  	suite.Run(t, &InsertTestSuite{
    87  		Suite{
    88  			driver: "mysql",
    89  			dsn:    "root:root@tcp(localhost:13306)/integration_test",
    90  		},
    91  	})
    92  }