CheckPoint1.ql

import java

// First find all the methods
// from Method m
// select m

// Find all the methods named getAverageRating
// from Method m
// where m.hasName("getAverageRating")
// select m

// Find all the methods named getAverageRating, accepts two parameters and where the first parameters is name fromSql
// from Method m
// where 
//     m.hasName("getAverageRating") and
//     m.getNumberOfParameters() = 2 and
//     m.getParameter(0).hasName("fromsql")
// select m, m.getFile().getAbsolutePath()

// Find all the methods named getAverageRatingFromQuery
// from Method m
// where m.hasName("getAverageRatingFromQuery")
// select m

// Find all the methods named getAverageRatingFromQuery with a definition
// from Method m
// where m.hasName("getAverageRatingFromQuery") and
//     exists(m.getBody())
// select m

// Find all methods calls, named method accesses, named search
// from MethodAccess ma
// where ma.getMethod().hasName("search")
// select ma, ma.getMethod().getQualifiedName()

// Find the fully qualified name of declaring type of the method search that is called in `getAverageRatingFromQuery`
// from MethodAccess ma, Method m
// where 
//     ma.getMethod() = m and 
//     m.hasName("search") and
//     ma.getEnclosingCallable().hasName("getAverageRatingFromQuery") 
// select ma, m.getQualifiedName()

// Filter out the results with the qualified name of the method search
from MethodAccess ma, Method m
where 
    ma.getMethod() = m and
    ma.getEnclosingCallable().hasName("getAverageRatingFromQuery")  and 
    m.hasQualifiedName("com.xpn.xwiki.store", "XWikiStoreInterface", "search")
select ma, m.getQualifiedName()