FilesExpand file tree

 https

/

explore.js

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

44 lines (39 loc) · 1.07 KB

 https

/

explore.js

Copy path

Top

File metadata and controls

• Code
• Blame

44 lines (39 loc) · 1.07 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

'use strict';

/**

* Get images for explore page for a specific user

* URL: /explore

* Method: GET

* Auth Required: Yes

* @param {string} user_id This optional query param specifies an user id to query by

* @returns {array} Returns a 200 status code with an array of upload (aka explore) objects

*/

server.get('/explore', function(req, res, next) {

// extract query params

var params = req.params || {};

// build sql query

var sql = `

SELECT

uploads.*,

COUNT(likes.id) AS likeTotal

FROM uploads

LEFT JOIN likes

ON likes.upload_id = uploads.id

WHERE uploads.user_id != ?

GROUP BY uploads.id

ORDER BY COUNT(likes.id) ASC

LIMIT 15

`;

// execute query

db.query(sql, [params.user_id], function(err, result) {

// catch all errors

if (err) {

// use global logger to log to console

log.error(err);

// return error message to client

return next(new restify.InternalError(err.message));

}

// send response to client

res.send(200, result);

return next();

});

});