SiLeBAT/FSK-Lab

View on GitHub

Showing 14,752 of 14,752 total issues

Refactor this method to reduce its Cognitive Complexity from 19 to the 15 allowed.
Open

private void go4Tables(final Statement anfrage, MyTable[] myTs, Integer[] myFromIDs) {

Define a constant instead of duplicating this literal ".tar.gz" 3 times.
Open

fc.setSelectedFile(new File(DBKernel.getUsername() + "_" + DBKernel.softwareVersion + "_" + sdf.format(c1.getTime()) + ".tar.gz")); // "AP1-2-DB_" + System.currentTimeMillis() + ".tar.gz"

Define a constant instead of duplicating this literal "' AND " 5 times.
Open

String sql = "DELETE FROM " + delimitL("DateiSpeicher") + " WHERE " + delimitL("TabellenID") + "=" + id + " AND" + delimitL("Tabelle") + "='" + tableName + "' AND "

Refactor this method to reduce its Cognitive Complexity from 18 to the 15 allowed.
Open

private static Connection getInternalKNIMEDB_LoadGui(boolean autoUpdate) {

Don't try to be smarter than the JVM, remove this call to run the garbage collector.
Open

System.gc();

Refactor this method to reduce its Cognitive Complexity from 18 to the 15 allowed.
Open

private String getStrVal(HSSFCell cell, int maxChars) {

Refactor this method to reduce its Cognitive Complexity from 16 to the 15 allowed.
Open

private Integer handleForeignKey(Integer foreignID, MyTable foreignTable, final Statement anfrage, boolean forceNewEntry) {

Refactor this method to reduce its Cognitive Complexity from 111 to the 15 allowed.
Open

public String doImport(final String filename, final JProgressBar progress, final boolean showResults) {

Refactor this method to reduce its Cognitive Complexity from 63 to the 15 allowed.
Open

private static boolean doRestore(String path, final MyDBTable myDB, final File targzFile, final boolean silent, boolean doReconnect) {

Define a constant instead of duplicating this literal "SELECT " 14 times.
Open

String sql = "SELECT " + delimitL("TabellenID") + " FROM " + delimitL("ChangeLog") + " WHERE " + delimitL("Tabelle") + " = '" + tablename + "' AND " + delimitL("ID")

Define a constant instead of duplicating this literal "Table" 3 times.
Open

sql += DBKernel.delimitL("Table") + "=" + "'" + tablename + "' AND";

Don't try to be smarter than the JVM, remove this call to run the garbage collector.
Open

System.gc();

Define a constant instead of duplicating this literal "ChangeLog" 10 times.
Open

String sql = "SELECT " + delimitL("TabellenID") + " FROM " + delimitL("ChangeLog") + " WHERE " + delimitL("Tabelle") + " = '" + tablename + "' AND " + delimitL("ID")

Refactor this method to reduce its Cognitive Complexity from 48 to the 15 allowed.
Open

public static boolean closeDBConnections(final boolean kompakt) {

Use static access with "java.awt.Frame" for "NORMAL".
Open

DBKernel.mainFrame.setExtendedState(JFrame.NORMAL);

Define a constant instead of duplicating this literal "SELECT FKTABLE_NAME, FKCOLUMN_NAME FROM INFORMATION_SCHEMA.SYSTEM_CROSSREFERENCE " 3 times.
Open

String sql = "SELECT FKTABLE_NAME, FKCOLUMN_NAME FROM INFORMATION_SCHEMA.SYSTEM_CROSSREFERENCE " + " WHERE PKTABLE_NAME = '" + tableName + "'";

Define a constant instead of duplicating this literal "Parameter" 6 times.
Open

ResultSet rs = getResultSet(conn, "SELECT " + delimitL("Wert") + " FROM " + delimitL("Infotabelle") + " WHERE " + delimitL("Parameter") + " = 'lastCache_" + tablename

Define a constant instead of duplicating this literal "Zugehörige Normen, z.B. ISO, DIN, CEN, etc." 3 times.
Open

new String[]{"Name des Nachweisverfahrens","Beschreibung des Nachweisverfahrens","Verweis auf Literaturstelle","Zugehörige Normen, z.B. ISO, DIN, CEN, etc.","Methodenkatalog - Codes"}, // ,"Angabe, ob Testreagenzien auch inhouse produziert werden können"

Define a constant instead of duplicating this literal " WHERE PKTABLE_NAME = '" 3 times.
Open

String sql = "SELECT FKTABLE_NAME, FKCOLUMN_NAME FROM INFORMATION_SCHEMA.SYSTEM_CROSSREFERENCE " + " WHERE PKTABLE_NAME = '" + tableName + "'";

Define a constant instead of duplicating this literal "EAN-Nummer aus SA2-Datenbank - falls bekannt" 4 times.
Open

new String[]{"Verweis auf die zugehörige Literatur","Verweis auf den Erregerkatalog","Details zum Erreger, die durch den Katalog nicht abgebildet werden, z.B. Stamm, Serovar","Auswahl der Matrix","EAN-Nummer aus SA2-Datenbank - falls bekannt","Details zur Matrix, die durch den Katalog nicht abgebildet werden",
Severity
Category
Status
Source
Language