(t *testing.T)
| 19 | ) |
| 20 | |
| 21 | func TestExampleSQLIntOnly(t *testing.T) { |
| 22 | tests := map[string]struct { |
| 23 | setupMock func(t testing.TB, mocks *MockSQL) |
| 24 | tester func(t testing.TB, db *sql.DB) |
| 25 | }{ |
| 26 | "NonNullable select nil": { |
| 27 | setupMock: func(t testing.TB, mocks *MockSQL) { |
| 28 | gomock.InOrder( |
| 29 | // Select In Work |
| 30 | mocks.Conn.EXPECT().Prepare(imageTypeSelect).Return(mocks.Stmt, nil), |
| 31 | mocks.Stmt.EXPECT().NumInput().Return(1), |
| 32 | mocks.Stmt.EXPECT().Query(gomock.Any()).Return(mocks.Rows, nil), |
| 33 | mocks.Rows.EXPECT().Columns().Return([]string{`status`}), |
| 34 | mocks.Rows.EXPECT().Next(gomock.Any()).SetArg(0, []driver.Value{nil}).Return(nil), |
| 35 | mocks.Rows.EXPECT().Close().Return(nil), |
| 36 | mocks.Stmt.EXPECT().Close().Return(nil), |
| 37 | ) |
| 38 | }, |
| 39 | tester: func(t testing.TB, conn *sql.DB) { |
| 40 | // Get inWork status |
| 41 | status, err := getImageType(conn) |
| 42 | require.NoError(t, err, "failed getting project status") |
| 43 | require.Equal(t, ImageTypeJpeg, status) |
| 44 | }, |
| 45 | }, |
| 46 | "Nullable Select Null": { |
| 47 | setupMock: func(t testing.TB, mocks *MockSQL) { |
| 48 | gomock.InOrder( |
| 49 | // Select In Work |
| 50 | mocks.Conn.EXPECT().Prepare(imageTypeSelect).Return(mocks.Stmt, nil), |
| 51 | mocks.Stmt.EXPECT().NumInput().Return(1), |
| 52 | mocks.Stmt.EXPECT().Query(gomock.Any()).Return(mocks.Rows, nil), |
| 53 | mocks.Rows.EXPECT().Columns().Return([]string{`status`}), |
| 54 | mocks.Rows.EXPECT().Next(gomock.Any()).SetArg(0, []driver.Value{nil}).Return(nil), |
| 55 | mocks.Rows.EXPECT().Close().Return(nil), |
| 56 | mocks.Stmt.EXPECT().Close().Return(nil), |
| 57 | ) |
| 58 | }, |
| 59 | tester: func(t testing.TB, conn *sql.DB) { |
| 60 | // Get inWork status |
| 61 | status, err := getNullImageType(conn) |
| 62 | require.NoError(t, err, "failed getting project status") |
| 63 | require.False(t, status.Valid) |
| 64 | }, |
| 65 | }, |
| 66 | "Select a string": { |
| 67 | setupMock: func(t testing.TB, mocks *MockSQL) { |
| 68 | gomock.InOrder( |
| 69 | // Select In Work |
| 70 | mocks.Conn.EXPECT().Prepare(imageTypeSelect).Return(mocks.Stmt, nil), |
| 71 | mocks.Stmt.EXPECT().NumInput().Return(1), |
| 72 | mocks.Stmt.EXPECT().Query(gomock.Any()).Return(mocks.Rows, nil), |
| 73 | mocks.Rows.EXPECT().Columns().Return([]string{`status`}), |
| 74 | mocks.Rows.EXPECT().Next(gomock.Any()).SetArg(0, []driver.Value{ImageTypePng.String()}).Return(nil), |
| 75 | mocks.Rows.EXPECT().Close().Return(nil), |
| 76 | mocks.Stmt.EXPECT().Close().Return(nil), |
| 77 | ) |
| 78 | }, |
nothing calls this directly
no test coverage detected
searching dependent graphs…