-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathquestion_like.rb
More file actions
67 lines (57 loc) · 1.53 KB
/
question_like.rb
File metadata and controls
67 lines (57 loc) · 1.53 KB
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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
class QuestionLike
attr_accessor :id, :question_id, :user_id
def self.likers_for_question_id(question_id)
users_hash = QuestionsDatabase.instance.execute(<<-SQL, question_id)
SELECT
u.*
FROM
users u JOIN question_likes q ON q.user_id = u.id
WHERE
q.question_id = (?)
GROUP BY q.question_id
SQL
users_hash.map {|user| User.new(user)}
end
def self.num_likes_for_question_id(question_id)
count_hash = QuestionsDatabase.instance.execute(<<-SQL, question_id)
SELECT
COUNT(q.user_id)
FROM
users u JOIN question_likes q ON q.user_id = u.id
WHERE
q.question_id = (?)
GROUP BY q.question_id
SQL
if count_hash.empty?
return 0
else
count_hash.first.values.first
end
end
def self.most_liked_questions(n)
questions_hash = QuestionsDatabase.instance.execute(<<-SQL)
SELECT
*
FROM
question_likes
LEFT JOIN questions ON questions.id = question_likes.question_id
GROUP BY questions.id
ORDER BY COUNT(question_likes.question_id) DESC
SQL
questions_hash.take(n).map {|question| Question.new(question)}
end
def initialize(options ={})
@id = options['id']
@user_id = options['user_id']
@question_id = options['question_id']
end
def create
raise 'already saved!' unless self.id.nil?
QuestionsDatabase.instance.execute(<<-SQL, user_id, question_id)
INSERT INTO
question_likes (user_id, question_id)
VALUES
(?, ?)
SQL
end
end