docs: public Script[] getScripts(Integer type) {
          ArrayList<Script> returnData = new ArrayList<>();
          PreparedStatement statement = null;
          ResultSet results = null;
  
          try (Connection sqlConnection = SQLService.getInstance().getConnection()) {
  
              statement = sqlConnection.prepareStatement("SELECT * FROM " + Constants.DB_TABLE_SCRIPT +
                                                             " ORDER BY " + Constants.GENERIC_ID);
              if (type != null) {
                  statement = sqlConnection.prepareStatement("SELECT * FROM " + Constants.DB_TABLE_SCRIPT +
                                                                 " WHERE " + Constants.SCRIPT_TYPE + "= ?" +
                                                                 " ORDER BY " + Constants.GENERIC_ID);
                  statement.setInt(1, type);
              }
  
              logger.info("Query: {}", statement);
  
              results = statement.executeQuery();
              while (results.next()) {
                  returnData.add(scriptFromSQLResult(results));
              }
          } catch (Exception e) {
  
          } finally {
              try {
                  if (results != null) {
                      results.close();
                  }
              } catch (Exception e) {
              }
              try {
                  if (statement != null) {
                      statement.close();
                  }
              } catch (Exception e) {
              }
          }
  
          return returnData.toArray(new Script[0]);
      }