Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

#76 - Optmize check "Run utPLSQL test" menu option#77

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.

Already on GitHub?Sign in to your account

Merged
PhilippSalvisberg merged 2 commits intoutPLSQL:masterfromPhilippSalvisberg:feature/76_optmize_check_menu_option
Jul 16, 2019
Merged
Show file tree
Hide file tree
Changes fromall commits
Commits
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
17 changes: 7 additions & 10 deletionssqldev/src/main/java/org/utplsql/sqldev/dal/UtplsqlDao.xtend
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -37,7 +37,7 @@ class UtplsqlDao {
public static val FIRST_VERSION_WITH_INTERNAL_ANNOTATION_API = 3000004
public static val FIRST_VERSION_WITH_ANNOTATION_API = 3001003
public static val FIRST_VERSION_WITHOUT_INTERNAL_API = 3001008
public static valNOT_YET_AVAILABLE =9009009
public static valFIRST_VERSION_WITH_HAS_SUITES_API =3001008
var Connection conn
var JdbcTemplate jdbcTemplate
// cache fields
Expand DownExpand Up@@ -183,9 +183,8 @@ class UtplsqlDao {
*/
def boolean containsUtplsqlTest(String owner, String objectName, String subobjectName) {
try {
if (normalizedUtPlsqlVersionNumber >= NOT_YET_AVAILABLE && objectName !== null && subobjectName !== null) {
// use faster check function available since v3.1.3 (FIRST_VERSION_WITH_ANNOTATION_API)
// disabled (NOT_YET_AVAILABLE) due to wrong results in v3.1.7
if (normalizedUtPlsqlVersionNumber >= org.utplsql.sqldev.dal.UtplsqlDao.FIRST_VERSION_WITH_HAS_SUITES_API && objectName !== null && subobjectName !== null) {
// use faster check function available since v3.1.3 (reliable in v3.1.8)
val sql = '''
DECLARE
l_return VARCHAR2(1) := '0';
Expand DownExpand Up@@ -253,9 +252,8 @@ class UtplsqlDao {
}

def boolean containsUtplsqlTest(String owner) {
if (normalizedUtPlsqlVersionNumber >= NOT_YET_AVAILABLE) {
// use faster check function available since v3.1.3 (FIRST_VERSION_WITH_ANNOTATION_API)
// disabled (NOT_YET_AVAILABLE) due to wrong results in v3.1.7
if (normalizedUtPlsqlVersionNumber >= org.utplsql.sqldev.dal.UtplsqlDao.FIRST_VERSION_WITH_HAS_SUITES_API) {
// use faster check function available since v3.1.3 (reliable in v3.1.8)
val sql = '''
DECLARE
l_return VARCHAR2(1) := '0';
Expand All@@ -282,9 +280,8 @@ class UtplsqlDao {
}

def boolean containsUtplsqlTest(String owner, String objectName) {
if (normalizedUtPlsqlVersionNumber >= NOT_YET_AVAILABLE) {
// use faster check function available since v3.1.3 (FIRST_VERSION_WITH_ANNOTATION_API)
// disabled (NOT_YET_AVAILABLE) due to wrong results in v3.1.7
if (normalizedUtPlsqlVersionNumber >= org.utplsql.sqldev.dal.UtplsqlDao.FIRST_VERSION_WITH_HAS_SUITES_API) {
// use faster check function available since v3.1.3 (reliable in v3.1.8)
val sql = '''
DECLARE
l_return VARCHAR2(1) := '0';
Expand Down
30 changes: 14 additions & 16 deletionssqldev/src/test/java/org/utplsql/sqldev/test/dal/DalTest.xtend
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -25,7 +25,6 @@ import org.springframework.jdbc.BadSqlGrammarException
import org.utplsql.sqldev.dal.UtplsqlDao
import org.utplsql.sqldev.model.ut.Annotation
import org.utplsql.sqldev.test.AbstractJdbcTest
import org.junit.Ignore

class DalTest extends AbstractJdbcTest {

Expand DownExpand Up@@ -147,9 +146,8 @@ class DalTest extends AbstractJdbcTest {
}

@Test
@Ignore
def void containsUtplsqlTest999() {
containsUtplsqlTest("9.9.9")
def void containsUtplsqlTest318() {
containsUtplsqlTest("3.1.8")
}

def void annotations(String utPlsqlVersion) {
Expand DownExpand Up@@ -206,8 +204,8 @@ class DalTest extends AbstractJdbcTest {
}

@Test
def voidannotations999() {
annotations("9.9.9")
def voidannotations318() {
annotations("3.1.8")
}

def void testablesPackages(String utPlsqlVersion) {
Expand DownExpand Up@@ -252,8 +250,8 @@ class DalTest extends AbstractJdbcTest {
}

@Test
def voidtestablesPackages999() {
testablesPackages("9.9.9")
def voidtestablesPackages318() {
testablesPackages("3.1.8")
}

def void testablesTypes(String utPlsqlVersion) {
Expand DownExpand Up@@ -291,8 +289,8 @@ class DalTest extends AbstractJdbcTest {
}

@Test
def voidtestablesTypes999() {
testablesTypes("9.9.9")
def voidtestablesTypes318() {
testablesTypes("3.1.8")
}

def void testablesFunctions(String utPlsqlVersion) {
Expand DownExpand Up@@ -323,8 +321,8 @@ class DalTest extends AbstractJdbcTest {
}

@Test
def voidtestablesFunctions999() {
testablesFunctions("9.9.9")
def voidtestablesFunctions318() {
testablesFunctions("3.1.8")
}

def void testablesProcedures(String utPlsqlVersion) {
Expand DownExpand Up@@ -355,8 +353,8 @@ class DalTest extends AbstractJdbcTest {
}

@Test
def voidtestablesProcedures999() {
testablesProcedures("9.9.9")
def voidtestablesProcedures318() {
testablesProcedures("3.1.8")
}

def void runnables(String utPlsqlVersion) {
Expand DownExpand Up@@ -422,8 +420,8 @@ class DalTest extends AbstractJdbcTest {
}

@Test
def voidrunnables999() {
runnables("9.9.9")
def voidrunnables318() {
runnables("3.1.8")
}

@Test
Expand Down
[8]ページ先頭
©2009-2025 Movatter.jp