Fixes utPLSQL#55 - oddgen "Run test" view under "All Suites": Include suites without tests

PhilippSalvisberg · PhilippSalvisberg · commit d49a6c52539e · 2018-11-25T03:03:35.000+01:00
diff --git a/sqldev/src/main/java/org/utplsql/sqldev/dal/UtplsqlDao.xtend b/sqldev/src/main/java/org/utplsql/sqldev/dal/UtplsqlDao.xtend
@@ -416,7 +416,7 @@ class UtplsqlDao {
 				             'Yes' AS multiselectable,
 				             'Yes' AS relevant
 				        FROM test
-				       WHERE item_type = 'UT_TEST'
+				       WHERE item_type IN ('UT_TEST', 'UT_SUITE')
 				      UNION ALL
 				      SELECT object_owner || '.' || object_name AS parent_id,
 				             object_owner || '.' || object_name || '.' || item_name AS id,
diff --git a/sqldev/src/test/java/org/utplsql/sqldev/tests/DalTest.xtend b/sqldev/src/test/java/org/utplsql/sqldev/tests/DalTest.xtend
@@ -471,6 +471,21 @@ class DalTest extends AbstractJdbcTest {
 		Assert.assertEquals(expected, actual)
 		
 	}
+
+	@Test
+	def void issue55SuiteWithoutTests() {
+		setupAndTeardown
+		jdbcTemplate.execute('''
+			CREATE OR REPLACE PACKAGE junit_utplsql_test_pkg IS
+			   -- %suite
+
+			END junit_utplsql_test_pkg;
+		''')
+		val dao = new UtplsqlDao(dataSource.connection)
+		val actualNodes = dao.runnables()		
+		Assert.assertEquals(4, actualNodes.size)
+		jdbcTemplate.execute("DROP PACKAGE junit_utplsql_test_pkg")
+	}
 	
 	@Test
 	def void issue56SuiteWithoutTests() {
