photo / frontend

The official @github repository of the Trovebox frontend software. A photo sharing and photo management web interface for data stored "in the cloud" (i.e. Amazon S3, Rackspace CloudFiles, Google Storage).
https://trovebox.com
Apache License 2.0
1.38k stars 244 forks source link

Permission based tag counts are not correct #330

Closed jmathai closed 11 years ago

jmathai commented 12 years ago

There's a bug in the tag list API. When calling /tags/list.json sometimes the count does not correlate with /photos/tags-foobar/list.json.

Two tags for November.

jmathai@[~/Y/openphoto-php]: ./openphoto -h ec2-184-72-129-199.compute-1.amazonaws.com -e /tags/list.json -p -v
==========
Method: get
Host: ec2-184-72-129-199.compute-1.amazonaws.com
Endpoint: /tags/list.json
==========

{
  "message" : "Tags for the user",
  "code" : 200,
  "result" : [
    {
      "id" : "November",
      "count" : "2"
    }
  ]
}

One photo tagged with November.

jmathai@[~/Y/openphoto-php]: ./openphoto -h ec2-184-72-129-199.compute-1.amazonaws.com -e /photos/tags-November/list.json -p -v
==========
Method: get
Host: ec2-184-72-129-199.compute-1.amazonaws.com
Endpoint: /photos/tags-November/list.json
==========

{
  "message" : "Successfully retrieved user's photos",
  "code" : 200,
  "result" : [
    {
      "tags" : [
        "2011",
        "hello",
        "November",
        "test"
      ],
      "id" : "3",
      "appId" : "openphoto-frontend",
      "pathBase" : "\/base\/201111\/1321493686-cover-7-starry-night-van-gogh-may-2011.jpg",
      "dateUploadedMonth" : "11",
      "dateTakenMonth" : "11",
      "exifExposureTime" : "",
      "exifFocalLength" : "",
      "exifCameraMake" : "",
      "dateTaken" : "1321493686",
      "title" : "",
      "height" : "1061",
      "description" : "",
      "dateTakenYear" : "2011",
      "dateUploadedDay" : "16",
      "longitude" : "",
      "exifISOSpeed" : "",
      "license" : "",
      "exifFNumber" : "",
      "host" : "cultivatr.openphoto.s3.amazonaws.com",
      "status" : "1",
      "hash" : "bcbe8d3a7b7c00a979d21cc6dba20cf75b25f27d",
      "width" : "1500",
      "dateTakenDay" : "16",
      "permission" : "1",
      "pathOriginal" : "\/original\/201111\/1321493686-cover-7-starry-night-van-gogh-may-2011.jpg",
      "size" : "252",
      "Name" : "3",
      "views" : "0",
      "dateUploadedYear" : "2011",
      "latitude" : "",
      "dateUploaded" : "1321493687",
      "exifCameraModel" : "",
      "totalRows" : 1,
      "pageSize" : "16",
      "currentPage" : 1,
      "totalPages" : 1
    }
  ]
}
jmathai commented 11 years ago

Closed in the fabrizio1.0 branch with commit 280c96d34c874d636e7e4e17fe710a5eca78def4

jmathai commented 11 years ago

Fixed with triggers.