{"action":"created","issue":{"url":"https://api.github.com/repos/pushtorefresh/storio/issues/737","repository_url":"https://api.github.com/repos/pushtorefresh/storio","labels_url":"https://api.github.com/repos/pushtorefresh/storio/issues/737/labels{/name}","comments_url":"https://api.github.com/repos/pushtorefresh/storio/issues/737/comments","events_url":"https://api.github.com/repos/pushtorefresh/storio/issues/737/events","html_url":"https://github.com/pushtorefresh/storio/issues/737","id":196066423,"number":737,"title":"How can i realize operation COUNT(..), MAX(..), etc?","user":{"login":"ValeriusGC","id":3320861,"avatar_url":"https://avatars.githubusercontent.com/u/3320861?v=3","gravatar_id":"","url":"https://api.github.com/users/ValeriusGC","html_url":"https://github.com/ValeriusGC","followers_url":"https://api.github.com/users/ValeriusGC/followers","following_url":"https://api.github.com/users/ValeriusGC/following{/other_user}","gists_url":"https://api.github.com/users/ValeriusGC/gists{/gist_id}","starred_url":"https://api.github.com/users/ValeriusGC/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ValeriusGC/subscriptions","organizations_url":"https://api.github.com/users/ValeriusGC/orgs","repos_url":"https://api.github.com/users/ValeriusGC/repos","events_url":"https://api.github.com/users/ValeriusGC/events{/privacy}","received_events_url":"https://api.github.com/users/ValeriusGC/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-12-16T14:04:33Z","updated_at":"2016-12-16T17:01:29Z","closed_at":null,"body":"What is elegant and effective way to do that with StorIO?"},"comment":{"url":"https://api.github.com/repos/pushtorefresh/storio/issues/comments/267641552","html_url":"https://github.com/pushtorefresh/storio/issues/737#issuecomment-267641552","issue_url":"https://api.github.com/repos/pushtorefresh/storio/issues/737","id":267641552,"user":{"login":"nikitin-da","id":7294857,"avatar_url":"https://avatars.githubusercontent.com/u/7294857?v=3","gravatar_id":"","url":"https://api.github.com/users/nikitin-da","html_url":"https://github.com/nikitin-da","followers_url":"https://api.github.com/users/nikitin-da/followers","following_url":"https://api.github.com/users/nikitin-da/following{/other_user}","gists_url":"https://api.github.com/users/nikitin-da/gists{/gist_id}","starred_url":"https://api.github.com/users/nikitin-da/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nikitin-da/subscriptions","organizations_url":"https://api.github.com/users/nikitin-da/orgs","repos_url":"https://api.github.com/users/nikitin-da/repos","events_url":"https://api.github.com/users/nikitin-da/events{/privacy}","received_events_url":"https://api.github.com/users/nikitin-da/received_events","type":"User","site_admin":false},"created_at":"2016-12-16T17:01:29Z","updated_at":"2016-12-16T17:01:29Z","body":"Can you please try something some like this?\r\n```java\r\ntry (Cursor cursor = storIOSqlite\r\n                .get()\r\n                .cursor()\r\n                .withQuery(RawQuery.builder()\r\n                                   .query(\"SELECT COUNT(*) FROM some_table WHERE some_field =?\")\r\n                                   .args(\"some_value\")\r\n                                   .build())\r\n                .prepare()\r\n                .executeAsBlocking()\r\n) {\r\n    cursor.moveToFirst();\r\n    Assertions.assertThat(count).isEqualTo(cursor.getInt(0));\r\n}```\r\nYou can't use `get().object` for objects without get resolver, so should use `get().cursor` or `get().numberOfResults()`"}}
{"actor":{"display_login":"nikitin-da"}}