Lines Matching refs:WHERE
113 @Query("SELECT * from User where uid = :x")
130 @Query("SELECT * from User where uid in (:ids)")
148 @Query("SELECT uid from User where uid = :id")
163 @Query("SELECT uid from User where uid = :id")
179 @Query("SELECT uid from User where uid = :id OR uid = :id")
197 @Query("SELECT uid from User where uid = :id OR uid = :uid")
218 @Query("SELECT uid from User where name = :bar AND uid = :id OR uid = :uid")
241 @Query("SELECT uid from User where name = :bar")
258 @Query("select * from User where uid = :_blah")
296 @Query("WITH RECURSIVE tempTable(n, fact) AS (SELECT 0, 1 UNION ALL SELECT n+1, (n+1)*fact FROM tempTable WHERE n < 9) SELECT fact FROM tempTable, User")
322 @Query("WITH RECURSIVE tempTable(n, fact) AS (SELECT 0, 1 UNION ALL SELECT n+1, (n+1)*fact FROM tempTable WHERE n < 9) SELECT fact FROM tempTable")
352 @Query("select COUNT(*) from User where :t")
369 @Query("DELETE from User where uid = :id")
381 @Query("DELETE from User where uid = :id")
394 @Query("DELETE from User where uid = :id")
422 @Query("select name from user where uid = :id")
438 @Query("delete from user where uid = :id")