Sign upLogin

yoichiro/chrome_mysql_admin

View on GitHub
Star
app/scripts/window/services/mysql_query_service.js

Summary

Maintainability
F
4 days
Test Coverage

Similar blocks of code found in 2 locations. Consider refactoring.
Open

        showCharacterSet: function() {
            var deferred = $q.defer();
            mySQLClientService.query("SHOW CHARACTER SET").then(function(result) {
                if (result.hasResultsetRows) {
                    if (result.resultsetRows.length > 0) {
Severity: Major
Found in app/scripts/window/services/mysql_query_service.js and 1 other location - About 5 hrs to fix
app/scripts/window/services/mysql_query_service.js on lines 26..42

Duplicated Code

Duplicated code can lead to software that is hard to understand and difficult to change. The Don't Repeat Yourself (DRY) principle states:

Every piece of knowledge must have a single, unambiguous, authoritative representation within a system.

When you violate DRY, bugs and maintenance problems are sure to follow. Duplicated code has a tendency to both continue to replicate and also to diverge (leaving bugs as two similar implementations differ in subtle ways).

Tuning

This issue has a mass of 145.

We set useful threshold defaults for the languages we support but you may want to adjust these settings based on your project guidelines.

The threshold configuration represents the minimum mass a code block must have to be analyzed for duplication. The lower the threshold, the more fine-grained the comparison.

If the engine is too easily reporting duplication, try raising the threshold. If you suspect that the engine isn't catching enough duplication, try lowering the threshold. The best setting tends to differ from language to language.

See codeclimate-duplication's documentation for more information about tuning the mass threshold in your .codeclimate.yml.

Refactorings

Further Reading

Similar blocks of code found in 2 locations. Consider refactoring.
Open

        showCollations: function() {
            var deferred = $q.defer();
            mySQLClientService.query("SHOW COLLATION").then(function(result) {
                if (result.hasResultsetRows) {
                    if (result.resultsetRows.length > 0) {
Severity: Major
Found in app/scripts/window/services/mysql_query_service.js and 1 other location - About 5 hrs to fix
app/scripts/window/services/mysql_query_service.js on lines 9..25

Duplicated Code

Duplicated code can lead to software that is hard to understand and difficult to change. The Don't Repeat Yourself (DRY) principle states:

Every piece of knowledge must have a single, unambiguous, authoritative representation within a system.

When you violate DRY, bugs and maintenance problems are sure to follow. Duplicated code has a tendency to both continue to replicate and also to diverge (leaving bugs as two similar implementations differ in subtle ways).

Tuning

This issue has a mass of 145.

We set useful threshold defaults for the languages we support but you may want to adjust these settings based on your project guidelines.

The threshold configuration represents the minimum mass a code block must have to be analyzed for duplication. The lower the threshold, the more fine-grained the comparison.

If the engine is too easily reporting duplication, try raising the threshold. If you suspect that the engine isn't catching enough duplication, try lowering the threshold. The best setting tends to differ from language to language.

See codeclimate-duplication's documentation for more information about tuning the mass threshold in your .codeclimate.yml.

Refactorings

Further Reading

Similar blocks of code found in 4 locations. Consider refactoring.
Open

        showFullColumns: function(table) {
            var deferred = $q.defer();
            mySQLClientService.query("SHOW FULL COLUMNS FROM `" + table + "`").then(function(result) {
                if (result.hasResultsetRows) {
                    deferred.resolve(result);
Severity: Major
Found in app/scripts/window/services/mysql_query_service.js and 3 other locations - About 4 hrs to fix
app/scripts/window/services/mysql_query_service.js on lines 126..138
app/scripts/window/services/mysql_query_service.js on lines 139..151
app/scripts/window/services/mysql_query_service.js on lines 152..164

Duplicated Code

Duplicated code can lead to software that is hard to understand and difficult to change. The Don't Repeat Yourself (DRY) principle states:

Every piece of knowledge must have a single, unambiguous, authoritative representation within a system.

When you violate DRY, bugs and maintenance problems are sure to follow. Duplicated code has a tendency to both continue to replicate and also to diverge (leaving bugs as two similar implementations differ in subtle ways).

Tuning

This issue has a mass of 120.

We set useful threshold defaults for the languages we support but you may want to adjust these settings based on your project guidelines.

The threshold configuration represents the minimum mass a code block must have to be analyzed for duplication. The lower the threshold, the more fine-grained the comparison.

If the engine is too easily reporting duplication, try raising the threshold. If you suspect that the engine isn't catching enough duplication, try lowering the threshold. The best setting tends to differ from language to language.

See codeclimate-duplication's documentation for more information about tuning the mass threshold in your .codeclimate.yml.

Refactorings

Further Reading

Similar blocks of code found in 4 locations. Consider refactoring.
Open

        showIndex: function(table) {
            var deferred = $q.defer();
            mySQLClientService.query("SHOW INDEX FROM `" + table + "`").then(function(result) {
                if (result.hasResultsetRows) {
                    deferred.resolve(result);
Severity: Major
Found in app/scripts/window/services/mysql_query_service.js and 3 other locations - About 4 hrs to fix
app/scripts/window/services/mysql_query_service.js on lines 113..125
app/scripts/window/services/mysql_query_service.js on lines 139..151
app/scripts/window/services/mysql_query_service.js on lines 152..164

Duplicated Code

Duplicated code can lead to software that is hard to understand and difficult to change. The Don't Repeat Yourself (DRY) principle states:

Every piece of knowledge must have a single, unambiguous, authoritative representation within a system.

When you violate DRY, bugs and maintenance problems are sure to follow. Duplicated code has a tendency to both continue to replicate and also to diverge (leaving bugs as two similar implementations differ in subtle ways).

Tuning

This issue has a mass of 120.

We set useful threshold defaults for the languages we support but you may want to adjust these settings based on your project guidelines.

The threshold configuration represents the minimum mass a code block must have to be analyzed for duplication. The lower the threshold, the more fine-grained the comparison.

If the engine is too easily reporting duplication, try raising the threshold. If you suspect that the engine isn't catching enough duplication, try lowering the threshold. The best setting tends to differ from language to language.

See codeclimate-duplication's documentation for more information about tuning the mass threshold in your .codeclimate.yml.

Refactorings

Further Reading

Similar blocks of code found in 4 locations. Consider refactoring.
Open

        showFunctionStatus: function(database) {
            var deferred = $q.defer();
            mySQLClientService.query("SHOW FUNCTION STATUS WHERE db = '" + database + "'").then(function(result) {
                if (result.hasResultsetRows) {
                    deferred.resolve(result);
Severity: Major
Found in app/scripts/window/services/mysql_query_service.js and 3 other locations - About 4 hrs to fix
app/scripts/window/services/mysql_query_service.js on lines 113..125
app/scripts/window/services/mysql_query_service.js on lines 126..138
app/scripts/window/services/mysql_query_service.js on lines 139..151

Duplicated Code

Duplicated code can lead to software that is hard to understand and difficult to change. The Don't Repeat Yourself (DRY) principle states:

Every piece of knowledge must have a single, unambiguous, authoritative representation within a system.

When you violate DRY, bugs and maintenance problems are sure to follow. Duplicated code has a tendency to both continue to replicate and also to diverge (leaving bugs as two similar implementations differ in subtle ways).

Tuning

This issue has a mass of 120.

We set useful threshold defaults for the languages we support but you may want to adjust these settings based on your project guidelines.

The threshold configuration represents the minimum mass a code block must have to be analyzed for duplication. The lower the threshold, the more fine-grained the comparison.

If the engine is too easily reporting duplication, try raising the threshold. If you suspect that the engine isn't catching enough duplication, try lowering the threshold. The best setting tends to differ from language to language.

See codeclimate-duplication's documentation for more information about tuning the mass threshold in your .codeclimate.yml.

Refactorings

Further Reading

Similar blocks of code found in 4 locations. Consider refactoring.
Open

        showProcedureStatus: function(database) {
            var deferred = $q.defer();
            mySQLClientService.query("SHOW PROCEDURE STATUS WHERE db = '" + database + "'").then(function(result) {
                if (result.hasResultsetRows) {
                    deferred.resolve(result);
Severity: Major
Found in app/scripts/window/services/mysql_query_service.js and 3 other locations - About 4 hrs to fix
app/scripts/window/services/mysql_query_service.js on lines 113..125
app/scripts/window/services/mysql_query_service.js on lines 126..138
app/scripts/window/services/mysql_query_service.js on lines 152..164

Duplicated Code

Duplicated code can lead to software that is hard to understand and difficult to change. The Don't Repeat Yourself (DRY) principle states:

Every piece of knowledge must have a single, unambiguous, authoritative representation within a system.

When you violate DRY, bugs and maintenance problems are sure to follow. Duplicated code has a tendency to both continue to replicate and also to diverge (leaving bugs as two similar implementations differ in subtle ways).

Tuning

This issue has a mass of 120.

We set useful threshold defaults for the languages we support but you may want to adjust these settings based on your project guidelines.

The threshold configuration represents the minimum mass a code block must have to be analyzed for duplication. The lower the threshold, the more fine-grained the comparison.

If the engine is too easily reporting duplication, try raising the threshold. If you suspect that the engine isn't catching enough duplication, try lowering the threshold. The best setting tends to differ from language to language.

See codeclimate-duplication's documentation for more information about tuning the mass threshold in your .codeclimate.yml.

Refactorings

Further Reading

Similar blocks of code found in 3 locations. Consider refactoring.
Open

        showGlobalStatus: function() {
            var deferred = $q.defer();
            mySQLClientService.queryWithoutProgressBar("SHOW GLOBAL STATUS").then(function(result) {
                if (result.hasResultsetRows) {
                    deferred.resolve(result);
Severity: Major
Found in app/scripts/window/services/mysql_query_service.js and 2 other locations - About 3 hrs to fix
app/scripts/window/services/mysql_query_service.js on lines 56..69
app/scripts/window/services/mysql_query_service.js on lines 191..203

Duplicated Code

Duplicated code can lead to software that is hard to understand and difficult to change. The Don't Repeat Yourself (DRY) principle states:

Every piece of knowledge must have a single, unambiguous, authoritative representation within a system.

When you violate DRY, bugs and maintenance problems are sure to follow. Duplicated code has a tendency to both continue to replicate and also to diverge (leaving bugs as two similar implementations differ in subtle ways).

Tuning

This issue has a mass of 111.

We set useful threshold defaults for the languages we support but you may want to adjust these settings based on your project guidelines.

The threshold configuration represents the minimum mass a code block must have to be analyzed for duplication. The lower the threshold, the more fine-grained the comparison.

If the engine is too easily reporting duplication, try raising the threshold. If you suspect that the engine isn't catching enough duplication, try lowering the threshold. The best setting tends to differ from language to language.

See codeclimate-duplication's documentation for more information about tuning the mass threshold in your .codeclimate.yml.

Refactorings

Further Reading

Similar blocks of code found in 3 locations. Consider refactoring.
Open

        showTables: function() {
            var deferred = $q.defer();
            mySQLClientService.query("SHOW /*!50002 FULL*/ TABLES").then(function(result) {
                if (result.hasResultsetRows) {
                    deferred.resolve(result);
Severity: Major
Found in app/scripts/window/services/mysql_query_service.js and 2 other locations - About 3 hrs to fix
app/scripts/window/services/mysql_query_service.js on lines 178..190
app/scripts/window/services/mysql_query_service.js on lines 191..203

Duplicated Code

Duplicated code can lead to software that is hard to understand and difficult to change. The Don't Repeat Yourself (DRY) principle states:

Every piece of knowledge must have a single, unambiguous, authoritative representation within a system.

When you violate DRY, bugs and maintenance problems are sure to follow. Duplicated code has a tendency to both continue to replicate and also to diverge (leaving bugs as two similar implementations differ in subtle ways).

Tuning

This issue has a mass of 111.

We set useful threshold defaults for the languages we support but you may want to adjust these settings based on your project guidelines.

The threshold configuration represents the minimum mass a code block must have to be analyzed for duplication. The lower the threshold, the more fine-grained the comparison.

If the engine is too easily reporting duplication, try raising the threshold. If you suspect that the engine isn't catching enough duplication, try lowering the threshold. The best setting tends to differ from language to language.

See codeclimate-duplication's documentation for more information about tuning the mass threshold in your .codeclimate.yml.

Refactorings

Further Reading

Similar blocks of code found in 3 locations. Consider refactoring.
Open

        getConnectionId: function() {
            var deferred = $q.defer();
            mySQLClientService.queryWithoutProgressBar("SELECT CONNECTION_ID()").then(function(result) {
                if (result.hasResultsetRows) {
                    deferred.resolve(result);
Severity: Major
Found in app/scripts/window/services/mysql_query_service.js and 2 other locations - About 3 hrs to fix
app/scripts/window/services/mysql_query_service.js on lines 56..69
app/scripts/window/services/mysql_query_service.js on lines 178..190

Duplicated Code

Duplicated code can lead to software that is hard to understand and difficult to change. The Don't Repeat Yourself (DRY) principle states:

Every piece of knowledge must have a single, unambiguous, authoritative representation within a system.

When you violate DRY, bugs and maintenance problems are sure to follow. Duplicated code has a tendency to both continue to replicate and also to diverge (leaving bugs as two similar implementations differ in subtle ways).

Tuning

This issue has a mass of 111.

We set useful threshold defaults for the languages we support but you may want to adjust these settings based on your project guidelines.

The threshold configuration represents the minimum mass a code block must have to be analyzed for duplication. The lower the threshold, the more fine-grained the comparison.

If the engine is too easily reporting duplication, try raising the threshold. If you suspect that the engine isn't catching enough duplication, try lowering the threshold. The best setting tends to differ from language to language.

See codeclimate-duplication's documentation for more information about tuning the mass threshold in your .codeclimate.yml.

Refactorings

Further Reading

There are no issues that match your filters.

Category
Status