SiLeBAT/FSK-Lab

View on GitHub

Showing 14,752 of 14,752 total issues

Define a constant instead of duplicating this literal "Serial" 11 times.
Open

"ALTER TABLE " + DBKernel.delimitL("Station") + " ADD COLUMN " + DBKernel.delimitL("Serial") + " VARCHAR(16383) BEFORE " + DBKernel.delimitL("Kommentar"), false);

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

public static boolean doRestore(final MyDBTable myDB, final File scriptFile, final boolean silent, boolean doReconnect) {

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

else if (fieldTypes[j].equals("BOOLEAN")) manageBoolean(ps, psUpdate, lfdCol, row.getCell(j));

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

if (bibitem.getField("volume") != null) psmt.setString(6, bibitem.getField("volume"));

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

if (bibitem.getField("abstract") != null) psmt.setString(4, bibitem.getField("abstract"));

Use indentation to denote the code conditionally executed by this "if".
Open

if (transformFormat)

Define a constant instead of duplicating this literal "Lieferungen" 39 times.
Open

DBKernel.sendRequest("ALTER TABLE " + DBKernel.delimitL("Lieferungen") + " ALTER COLUMN " + DBKernel.delimitL("Explanation_EndChain") + " VARCHAR(16383)", false);

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

sql = "SELECT " + DBKernel.delimitL("ID") + "," + DBKernel.delimitL("Kommentar") + " FROM " + DBKernel.delimitL("Lieferungen");

Define a constant instead of duplicating this literal "log10(1)" 3 times.
Open

if (zero_ncs.equals("1/mL") && KE_ncs.equals("log10(1)")) {

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

|| tableName.equals("GueltigkeitsBereiche") || tableName.equals("Kostenkatalog") || tableName.equals("Kostenkatalogpreise")

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

MyTable(String tableName, String[] fieldNames, String[] fieldTypes, String[] fieldComments, MyTable[] foreignFields, String[][] uniqueFields,

Define a constant instead of duplicating this literal ") VALUES (" 3 times.
Open

String sql = "INSERT INTO " + DBKernel.delimitL(tableName) + " (" + sql1.substring(0, sql1.length() - 1) + ") VALUES ("

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

if (fieldTypes[j].startsWith("VARCHAR(") || fieldTypes[j].startsWith("CHAR(") || fieldTypes[j].startsWith("BLOB(")

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

private String manageString(PreparedStatement ps, PreparedStatement psUpdate, int lfdCol, HSSFCell cell, LinkedHashMap<Object, String> hashBL) throws SQLException {

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

else author += " and " + val;

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

psmt.setString(1, bibitem.getField("erstautor"));

Define a constant instead of duplicating this literal "Row: " 18 times.
Open

String msg = "Row: " + (i + 1) + "\tSerial '" + serial + "' already defined in file '" + serials.get(serial) + "' -> not importing this row!";

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

DBKernel.myDBi.getTable("Produktkatalog").doMNs();

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

private int[] doImportGaia(HSSFWorkbook wb, JProgressBar progress) {

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

private int[] doImportStandard(HSSFWorkbook wb, JProgressBar progress, String filename) {
Severity
Category
Status
Source
Language