github.com/ecodeclub/eorm@v0.0.2-0.20231001112437-dae71da914d0/internal/integration/insert_masterslave_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/stretchr/testify/assert" 26 "github.com/stretchr/testify/require" 27 "github.com/stretchr/testify/suite" 28 ) 29 30 type InsertMasterSlaveTestSuite struct { 31 MasterSlaveSuite 32 } 33 34 func (i *InsertMasterSlaveTestSuite) TearDownTest() { 35 res := eorm.RawQuery[any](i.orm, "DELETE FROM `simple_struct`").Exec(context.Background()) 36 if res.Err() != nil { 37 i.T().Fatal(res.Err()) 38 } 39 } 40 41 func (i *InsertMasterSlaveTestSuite) TestInsert() { 42 testcases := []struct { 43 name string 44 i *eorm.Inserter[test.SimpleStruct] 45 slaveName string 46 rowsAffected int64 47 wantErr error 48 }{ 49 { 50 name: "", 51 i: eorm.NewInserter[test.SimpleStruct](i.orm).Values(&test.SimpleStruct{Id: 1}), 52 rowsAffected: 1, 53 }, 54 } 55 for _, tc := range testcases { 56 i.T().Run(tc.name, func(t *testing.T) { 57 res := tc.i.Exec(context.Background()) 58 assert.Equal(t, tc.wantErr, res.Err()) 59 if res.Err() != nil { 60 return 61 } 62 slaveName := "" 63 select { 64 case slaveName = <-i.testSlaves.ch: 65 default: 66 } 67 affected, err := res.RowsAffected() 68 require.NoError(t, err) 69 assert.Equal(t, tc.rowsAffected, affected) 70 assert.Equal(t, tc.slaveName, slaveName) 71 }) 72 } 73 } 74 func TestMasterSlaveInsert(t *testing.T) { 75 suite.Run(t, &InsertMasterSlaveTestSuite{ 76 MasterSlaveSuite: MasterSlaveSuite{ 77 driver: "mysql", 78 masterDsn: "root:root@tcp(localhost:13307)/integration_test", 79 slaveDsns: []string{"root:root@tcp(localhost:13308)/integration_test"}, 80 initSlaves: newRoundRobinSlaves, 81 }, 82 }) 83 }