swift - Post rating system in iOS with parse.com - upvote / downvote -


simply: want rating system of post (or image) works same in yik yak or 9gag - user can upvote or downvote once post. dont want store these data on device on parse.com. count comments. ideally in 1 query parse.com

i using code dont think approach how because every image create new query. have 4 tables in parse.com user, image, comment, rating , connected pointers image or user. 

func loaddata(){     forpaginationstart = 0     numberofimagesperpage = 5     imagedata.removeallobjects()     var findimagedata: pfquery = pfquery(classname: "image")     findimagedata.wherekey("deleted", equalto: 0)     findimagedata.orderbydescending("createdat")     findimagedata.skip = forpaginationstart     findimagedata.limit = numberofimagesperpage     findimagedata.findobjectsinbackgroundwithblock{         (objects:[anyobject]?, error:nserror?)->void in          if error == nil{             object in objects! {                  let image:pfobject = object as! pfobject                 self.imagedata.addobject(image)                  //comment counts                 var countcomments = pfquery(classname:"comment_image")                 countcomments.wherekey("image_id", equalto: pfobject(withoutdatawithclassname: "image", objectid: "\(image.objectid!)"))                 countcomments.wherekey("deleted", equalto: 0)                 countcomments.countobjectsinbackgroundwithblock {                     (count: int32, error: nserror?) -> void in                     if error == nil {                         println("there \(count) comments image: \((object.objectid!)!)")                         self.commentcount.append(countcomments.countobjects())                     }                 }             }              self.tableview.reloaddata()          }      }      //count number of records in db pagination end     var totalnumofrows: pfquery = pfquery(classname: "image")     totalnumofrows.wherekey("deleted", equalto: 0)     totalnumofrows.countobjectsinbackgroundwithblock {         (count: int32, error: nserror?) -> void in         if (error == nil) {             self.totalnumrecords = int(count)             println("total records: \(self.totalnumrecords)")         }       } }

i had working php , sql parse same approach doesnt work me... asked db value user, if 1 user upvoted , if negative 1 downvoted, 0 neither 1 , set button according value sql query:

ifnull((select value rating image.id = rating.image_id , rating.user_id = (select id user uuid='$uuid')), 0) userrating 

- (instancetype)wherekey:(nsstring *)key matcheskey:(nsstring *)otherkey inquery:(pfquery *)query

you can use this method on pfquery, example:

var countcomments = pfquery(classname:"comment_image") var findimagedata: pfquery = pfquery(classname: "image") findimagedata.wherekey("deleted", equalto: 0) findimagedata.orderbydescending("createdat") findimagedata.skip = forpaginationstart findimagedata.limit = numberofimagesperpage countcomments.wherekey("image_id", matcheskey:"objectid", inquery: ) countcomments.wherekey("deleted", equalto: 0) countcomments.countobjectsinbackgroundwithblock {     (count: int32, error: nserror?) -> void in      if error == nil {          println("there \(count) comments images!")      } }

by setting count query this, don't have call count each image, don't know in background if parse optimizes make faster current query.


Comments

Post a Comment

Popular posts from this blog

How to connect android app to App engine -

i'm trying connect app in android server i've opened on appengine. my server's name : dddd-daniel-2345 , website server : http://dddd-daniel-2345.appspot.com/ this how connect android app server in app engine: app.yaml: application: dddd-daniel-2345 version: 1 runtime: python27 api_version: 1 threadsafe: yes handlers: - url: .* script: main.app libraries: - name: webapp2 version: "2.5.2" main.py: #!/usr/bin/env python # # copyright 2007 google inc. google.appengine.api import users import webapp2 class userhandler(webapp2.requesthandler): def get(self): user = users.get_current_user() if user: greeting = ('%s,%s,%s' % (user.email(),user.user_id(),user.nickname())) else: greeting = ('not logged in') self.response.out.write(greeting) app = webapp2.wsgiapplication([('/', userhandler),], debug=true) my applications code : add manifast main....
Read more

gcc - MinGW's ld cannot perform PE operations on non PE output file -

i know there other similar questions out there, stackoverflow or not. i've researched lot this, , still didn't find single solution. i'm doing operative system side project. i've been doing in assembly, wanna join c code. test, made assembly code file (called test.asm): [bits 32] global _a section .text _a: jmp $ then made c file (called main.c): extern void a(void); int main(void) { a(); } to link, used file (called make.bat): "c:\mingw\bin\gcc.exe" -ffreestanding -c -o c.o main.c nasm -f coff -o asm.o test.asm "c:\mingw\bin\ld.exe" -ttext 0x100000 --oformat binary -o out.bin c.o asm.o pause i've been researching ages, , i'm still struggling find answer. hope won't flagged duplicate. acknowledge existence of similar questions, have different answers, , none work me. question: what doing wrong? old mingw versions had problem "ld" not able create non-pe files @ all. maybe current versions...
Read more

php - display validation error message next to the textbox in codeigniter -

Image
i'm newbie codeigniter.i want display error message next text box.my view file create.php contains following code. <?php echo validation_errors(); //validation echo form_open('news/create'); //create form ?> <div class="boxes"> <div class="common"> <div class="lables"> <label for="name">name</label> </div> <div class="text_boxes"> <input type="text" name="uname" /><div id="infomessage"><?php echo $message;?></br> </div> </div>` and below controller model: public function create() { $this->load->helper('form'); $this->load->library('form_validation'); $data['title'] = 'insert items'; $this->form_validation->set_rules('uname','required|min_length[6]|m...
Read more