View Javadoc
1   /*
2    *
3    * The DbUnit Database Testing Framework
4    * Copyright (C)2002-2004, DbUnit.org
5    *
6    * This library is free software; you can redistribute it and/or
7    * modify it under the terms of the GNU Lesser General Public
8    * License as published by the Free Software Foundation; either
9    * version 2.1 of the License, or (at your option) any later version.
10   *
11   * This library is distributed in the hope that it will be useful,
12   * but WITHOUT ANY WARRANTY; without even the implied warranty of
13   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
14   * Lesser General Public License for more details.
15   *
16   * You should have received a copy of the GNU Lesser General Public
17   * License along with this library; if not, write to the Free Software
18   * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
19   *
20   */
21  
22  package org.dbunit.database;
23  
24  import static org.assertj.core.api.Assertions.assertThat;
25  
26  import org.dbunit.AbstractDatabaseTesterIT;
27  import org.junit.jupiter.api.Test;
28  
29  /**
30   * @author Andres Almiray
31   */
32  public abstract class AbstractDatabaseTesterConnectionIT
33          extends AbstractDatabaseTesterIT
34  {
35  
36      @Test
37      final void testGetRowCount_withPopulatedTables_returnsCorrectCounts() throws Exception
38      {
39          assertThat(_connection.getRowCount("EMPTY_TABLE", null))
40                  .as("EMPTY_TABLE").isZero();
41          assertThat(_connection.getRowCount("EMPTY_TABLE")).as("EMPTY_TABLE")
42                  .isZero();
43  
44          assertThat(_connection.getRowCount("TEST_TABLE", null)).as("TEST_TABLE")
45                  .isEqualTo(6);
46          assertThat(_connection.getRowCount("TEST_TABLE")).as("TEST_TABLE")
47                  .isEqualTo(6);
48  
49          assertThat(_connection.getRowCount("PK_TABLE", "where PK0 = 0"))
50                  .as("PK_TABLE").isEqualTo(1);
51      }
52  }