[TIMOB-24636] ArrowDB - User's stats for Photos and Storage always 0

GitHub Issue	n/a
Type	Bug
Priority	Critical
Status	Reopened
Resolution	Unresolved
Affected Version/s	n/a
Fix Version/s	n/a
Components	n/a
Labels	api
Reporter	Joseph Sachs
Assignee	Unknown
Created	2017-04-26T13:01:19.000+0000
Updated	2019-08-27T17:25:38.000+0000

Description

A User uploads a Photo to ArrowDB; When I query the User, the *stats* property for that User shows:

"stats": {
      "photos": {
        "total_count": 0
      },
      "storage": {
        "used": 0
      }
    },

Regardless of the number of Photos uploaded (even processed:true), the stats always show 0 for Photos and Storage.

Attachments

File	Date	Size
Screen Shot 2019-08-27 at 11.22.02 AM.png	2019-08-27T17:25:38.000+0000	134244
Screen Shot 2019-08-27 at 11.22.02 AM.png	2019-08-27T17:25:17.000+0000	134244

Comments

Sharif AbuDarda 2017-04-26

Hello, I can verify the issue for stats in user query.
Eric Merriman 2017-04-27

[~sdarda] If the curl and the SDK return the same result then it isn't the SDK. You should move the ticket to CLOUDSRV
Joseph Sachs 2019-08-14

I am curious if the fix has been implemented?
Alan Hutton 2019-08-14

Moving to CLOUDSRV off of HOLD.
Alan Hutton 2019-08-14

[~underlabs] This issue was moved over to a non public facing Axway Jira. Comments/updates from that issue will be placed here.
Alan Hutton 2019-08-21

The original query method generated a large number of db queries. This resulted in bad DB performance, and was removed. However, for querying photo stats per user ID please see : https://docs.appcelerator.com/arrowdb/latest/#!/api/Photos-method-query

Joseph Sachs 2019-08-21

I've tried the API in question, and I've received this returned Obj: /photos/query.json {"page":1,"per_page":100,"user_id":"5ca24b6XXXX2dae94"}

   {
     "meta": {
       "code": 200,
       "status": "ok",
       "method_name": "queryPhoto",
       "count": 1224
     },
     "response": {
       "photos": [
         {
           "id": "5ca24b6XXXX2dae94",
           "filename": "0156yyy826.jpeg",
           "size": 146223,
           "md5": "b2caffb4c5b693ab58eb0d9bd9089026",
           "created_at": "2019-08-20T21:50:29+0000",
           "updated_at": "2019-08-20T21:50:29+0000",
           "processed": true,
           "urls": {
             "preview": "https://s3-us-west-1.amazonaws.com/storage-platform.cloud.appcelerator.com/.....jpeg",
             "original": "https://s3-us-west-1.amazonaws.com/storage-platform.cloud.appcel....6_original.jpeg"
           },
           "content_type": "image/jpeg",
           "user_id": "5ca24b6XXXX2dae94",
           "custom_fields": {
             "coordinates": [
               [
                 -xxx.04579162597656,
                 yy.10063934326172
               ]
             ]
           }
         }
       ]
     }
   }

Note: I've trimmed the other 9 photos from the JSON above for simplification. I do see the count of images uploaded from that specific user: *1224* However, I don't see a *Stats* object for the *+total size+* or Storage consumed by that particular user.

JSON Source