Define raw query

Define raw query

Query definition is similar to view. In the query you can use @SqlQuery annotation to write raw sql.

Query will be called in content provider and you can use parameters in the body. to define parameters use '?' symbol and provide arguments in query request

@RawQuery(LastScoreQuery.QUERY_NAME)
public static interface LastScoreQuery{
	
	String QUERY_NAME = "last_score_query";
	
	@URI
	String CONTENT_PATH = "last_score_query";
	
	@SqlQuery
	String QUERY = "select * from " + ScoreView.VIEW_NAME + " where " + ScoreView.TABLE_SCORE + "_" + ScoreTable.IS_LAST_TOUR + " = 1";
}