Beispiel #1
0
  /**
   * Returns the total number of java files in the project by recursively visiting directories.
   *
   * @param resource The location to start counting from. This could be a project, folder or file
   * @return The total number of files with java-like extensions found.
   */
  private int countTotalJavaFiles(IResource resource) {
    if (resource == null) {
      return 0;
    }
    int size = 0;
    try {
      if (resource.getType() == IResource.FOLDER) {
        IFolder folder = (IFolder) resource;
        for (IResource file : folder.members()) {
          size += countTotalJavaFiles(file);
        }
      } else if (resource.getType() == IResource.PROJECT) {
        IProject proj = (IProject) resource;
        for (IResource file : proj.members()) {
          size += countTotalJavaFiles(file);
        }
      }
    } catch (CoreException e) {
      eLog.logException(e);
    }
    if (resource.getType() == IResource.FILE && JavaCore.isJavaLikeFileName(resource.getName()))
      size++;

    return size;
  }
Beispiel #2
0
 /**
  * Inserts a new mapping from method id to word id to the methods_words table of the database.
  * Each row represents one instance of a word existing in the method. Unlike the other inserts,
  * duplicate entries are allowed since each word can exist more than once in a method.
  *
  * @param methodId The method's database ID
  * @param wordId The word's ID
  */
 public void insertMethodToWordMapping(int methodId, int wordId) {
   try {
     sp_insertMethodToWordMapping.setInt(1, methodId);
     sp_insertMethodToWordMapping.setInt(2, wordId);
     sp_insertMethodToWordMapping.executeUpdate();
   } catch (SQLException e) {
     eLog.logException(e);
   }
 }
Beispiel #3
0
 /**
  * Returns all the word IDs and words that exist in the words table of the database. The caller is
  * responsible for closing the result set. This method is synchronized.
  *
  * @return
  *     <ul>
  *       <li>ResultSet with the following columns: id, word
  *       <li>null if the query fails
  *     </ul>
  */
 public synchronized ResultSet getAllWordIdsAndWords() {
   ResultSet rv = null;
   try {
     rv = sp_getAllWordIdsAndWords.executeQuery();
   } catch (SQLException e) {
     eLog.logException(e);
   }
   return rv;
 }
Beispiel #4
0
 /**
  * Returns all the word IDs, words and the number of each word's occurrence for a given method's
  * id. The caller is responsible for closing the result set. This method is synchronized.
  *
  * @param methodId The database id of the method key
  * @return
  *     <ul>
  *       <li>ResultSet with the following columns: id, word, wordCount
  *       <li>null if the query fails or the ID is not found
  *     </ul>
  */
 public synchronized ResultSet getWordsFromMethodId(int methodId) {
   ResultSet rv = null;
   try {
     sp_getWordsFromMethodId.setInt(1, methodId);
     rv = sp_getWordsFromMethodId.executeQuery();
   } catch (SQLException e) {
     eLog.logException(e);
   }
   return rv;
 }
Beispiel #5
0
 /**
  * Inserts a new word to the words table of the database. If a word already exists, no rows are
  * added or modified in the database.
  *
  * @param word The word to add
  */
 public void insertWord(String word) {
   try {
     sp_insertWord.setString(1, word.toLowerCase());
     sp_insertWord.executeUpdate();
   } catch (MySQLIntegrityConstraintViolationException e) {
     // Ignore, this is to handle duplicate entries
   } catch (SQLException e) {
     eLog.logException(e);
   }
 }
Beispiel #6
0
 /**
  * Updates an existing word and word count for a given method. This method should be only used if
  * the row already exists in the database. Existence can be verified using the
  * getWordCountFromMethodIdAndWordId(int, int) method. If the method does not exist,
  * insertWordCountForMethodIdAndWordId(int, int) should be used instead.
  *
  * @param methodId The method's database id
  * @param wordId The word's database id
  * @param wordCount The number of times the word occurs in the given method
  */
 public void updateWordCountForMethodIdAndWordId(int methodId, int wordId, int wordCount) {
   try {
     sp_updateWordCountForMethodIdAndWordId.setInt(1, methodId);
     sp_updateWordCountForMethodIdAndWordId.setInt(2, wordId);
     sp_updateWordCountForMethodIdAndWordId.setInt(3, wordCount);
     sp_updateWordCountForMethodIdAndWordId.executeUpdate();
   } catch (SQLException e) {
     eLog.logException(e);
   }
 }
Beispiel #7
0
 /**
  * Returns the total number of methods. This method is synchronized.
  *
  * @return
  *     <ul>
  *       <li>The count of methods in table methods_words
  *       <li>-1 if the query fails
  *     </ul>
  */
 public synchronized int getIdfNumerator() {
   int rv = -1;
   try {
     rs = sp_getIdfNumerator.executeQuery();
     while (rs.next()) rv = rs.getInt(1);
     rs.close();
   } catch (SQLException e) {
     eLog.logException(e);
   }
   return rv;
 }
Beispiel #8
0
 /**
  * Iterates through the list of open projects and fires a {@link ResourceVisitor} over each one.
  * The monitor is told that the job has started and the visitor starts the process that populates
  * the database.
  */
 private void loadOpenProjectsIntoDb() {
   for (IProject proj : openProjects) {
     try {
       proj.open(null);
       monitor.beginTask("Filling IFT database with project content.", countTotalJavaFiles(proj));
       proj.accept(new ResourceVisitor());
     } catch (CoreException e) {
       eLog.logException(e);
     }
   }
 }
Beispiel #9
0
 /**
  * Return the total number of words in the given method. This method is synchronized.
  *
  * @param methodId The database id of the method
  * @return
  *     <ul>
  *       <li>The number of words in the given method
  *       <li>-1 if the method's ID is not found
  *     </ul>
  */
 public synchronized int getTfDenominator(int methodId) {
   int rv = -1;
   try {
     sp_getTfDenominator.setInt(1, methodId);
     rs = sp_getTfDenominator.executeQuery();
     while (rs.next()) rv = rs.getInt(1);
     rs.close();
   } catch (SQLException e) {
     eLog.logException(e);
   }
   return rv;
 }
Beispiel #10
0
 /**
  * Returns a {@link MethodData} object given method's key. This method is synchronized.
  *
  * <p>The plugin now uses MethodDeclaration as its main data type. See {@link MethodManager} for
  * more details
  *
  * @param methodKey
  * @return
  *     <ul>
  *       <li>A new MethodData object for the given method key
  *       <li>null if the query fails or if the key was not found
  *     </ul>
  *
  * @deprecated
  */
 public synchronized MethodData getMethodDataFromMethodKey(String methodKey) {
   MethodData rv = null;
   try {
     sp_getMethodDataFromMethodKey.setString(1, methodKey);
     rs = sp_getMethodDataFromMethodKey.executeQuery();
     while (rs.next()) rv = new MethodData(rs.getString(1), rs.getString(2), rs.getString(3));
     rs.close();
   } catch (SQLException e) {
     eLog.logException(e);
   }
   return rv;
 }
Beispiel #11
0
 /**
  * Inserts a method's data to the methods table of the database. If the method's key already
  * exists in the database, the new information is ignored and no database rows are added or
  * modified.
  *
  * @param methodData The method to insert
  */
 public void insertMethod(MethodData methodData) {
   try {
     sp_insertMethod.setString(1, methodData.getKey());
     sp_insertMethod.setString(2, methodData.getName());
     sp_insertMethod.setString(3, methodData.getPath());
     sp_insertMethod.executeUpdate();
   } catch (MySQLIntegrityConstraintViolationException e) {
     // Ignore, this is to handle duplicate entries
   } catch (SQLException e) {
     eLog.logException(e);
   }
 }
Beispiel #12
0
 /**
  * Returns the method's ID given a method's key. Most of the calls on the database are based on
  * IDs since they are quicker, use this to determine an ID for those calls. This method is
  * synchronized.
  *
  * @param methodKey The method key to look for
  * @return
  *     <ul>
  *       <li>The method's database id for the given key
  *       <li>-1 if the query fails or the key was not found
  *     </ul>
  */
 public synchronized int getMethodIdFromMethodKey(String methodKey) {
   int rv = -1;
   try {
     sp_getMethodIdFromMethodKey.setString(1, methodKey);
     rs = sp_getMethodIdFromMethodKey.executeQuery();
     while (rs.next()) rv = rs.getInt(1);
     rs.close();
   } catch (SQLException e) {
     eLog.logException(e);
   }
   return rv;
 }
Beispiel #13
0
 /**
  * Return the database ID of the given word. This method is synchronized.
  *
  * @param word The word to look for
  * @return
  *     <ul>
  *       <li>The database ID of the given word
  *       <li>-1 if the query fails or the word is not found
  *     </ul>
  */
 public synchronized int getWordIdFromWord(String word) {
   int rv = -1;
   try {
     sp_getWordIdFromWord.setString(1, word);
     rs = sp_getWordIdFromWord.executeQuery();
     while (rs.next()) rv = rs.getInt(1);
     rs.close();
   } catch (SQLException e) {
     eLog.logException(e);
   }
   return rv;
 }
Beispiel #14
0
 /**
  * Returns the most common occurring words according to PFIS given a method's id. This method is
  * synchronized. This is an updated version of getMostCommonWordsPFIS(int).
  *
  * @param methodId The id of the current method
  * @return An ordered string array of size 5 that contains one of the following in each cell
  *     <ul>
  *       <li>a word shared between the methods
  *       <li>null for empty entries
  *     </ul>
  */
 public synchronized String[] getMostCommonWordsPFIS2(int methodId) {
   String[] rv = new String[8];
   int i = 0;
   try {
     sp_getMostCommonWordsPFIS2.setInt(1, methodId);
     rs = sp_getMostCommonWordsPFIS2.executeQuery();
     while (rs.next()) rv[i++] = rs.getString(2);
     rs.close();
   } catch (SQLException e) {
     eLog.logException(e);
   }
   return rv;
 }
Beispiel #15
0
 /**
  * Return the path of the source code file containing the method given a method key. This is
  * mainly used to bring a method into focus in the Eclipe's source code editor. This method is
  * synchronized.
  *
  * @param methodKey The method's key
  * @return
  *     <ul>
  *       <li>The path to the method's source code file
  *       <li>-1 if the query fails or the key is not found
  *     </ul>
  */
 public synchronized String getPathFromMethodKey(String methodKey) {
   // TODO: Check if using method id's is faster
   String rv = null;
   try {
     sp_getPathFromMethodKey.setString(1, methodKey);
     rs = sp_getPathFromMethodKey.executeQuery();
     while (rs.next()) rv = rs.getString(1);
     rs.close();
   } catch (SQLException e) {
     eLog.logException(e);
   }
   return rv;
 }
Beispiel #16
0
  /**
   * Returns the number of times a word occurs for the given method's ID and word's ID. This method
   * is synchronized.
   *
   * @param methodId The database id of the method
   * @param wordId The database's id of the word
   * @return The number of times a word occurs within the method
   */
  public synchronized int getWordCountFromMethodIdAndWordId(int methodId, int wordId) {
    int rv = 0;

    try {
      sp_getWordCountsFromMethodIdAndWordId.setInt(1, methodId);
      sp_getWordCountsFromMethodIdAndWordId.setInt(2, wordId);
      rs = sp_getWordCountsFromMethodIdAndWordId.executeQuery();
      while (rs.next()) rv = rs.getInt(1);
      rs.close();
    } catch (SQLException e) {
      eLog.logException(e);
    }
    return rv;
  }
Beispiel #17
0
 /**
  * Call this to open a connection to the plugin database and prepare the CallableStatements for
  * the stored procedures. If the connection is already open, this method does nothing.
  *
  * <p>Note that this must be called before any methods that act on the database are called.
  *
  * @throws SQLException when the MySQL/MariaDb JDBC driver is not found.
  */
 public void openConnectionAndInit(String connectionString) throws SQLException {
   try {
     closeConnection();
     if (conn == null) {
       Class.forName("com.mysql.jdbc.Driver");
       conn = DriverManager.getConnection(connectionString);
       System.out.println("Database connection open.");
       verifyConnection();
       prepareCallableStatements();
     }
   } catch (ClassNotFoundException e) {
     eLog.logException(e);
     throw new SQLException("Couldn't load MySQL JDBC driver");
   }
 }
Beispiel #18
0
 /**
  * Returns up to 5 common shared words between two methods from the TF-IDF calculation from most
  * occurring to least occurring. This method is synchronized. Use getMostCommonWordsTFIDF2(int,
  * int) instead.
  *
  * @param methodId1 The id of the current method
  * @param methodId2 The id of the method to compare to
  * @return An ordered string array of size 5 that contains one of the following in each cell
  *     <ul>
  *       <li>a word shared between the methods
  *       <li>null for empty entries
  *     </ul>
  */
 @Deprecated
 public synchronized String[] getMostCommonWordsTFIDF(int methodId1, int methodId2) {
   String[] rv = new String[8];
   int i = 0;
   try {
     sp_getMostCommonWords.setInt(1, methodId1);
     sp_getMostCommonWords.setInt(2, methodId2);
     rs = sp_getMostCommonWords.executeQuery();
     while (rs.next()) rv[i++] = rs.getString(1);
     rs.close();
   } catch (SQLException e) {
     eLog.logException(e);
   }
   return rv;
 }