-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathuser.rb
More file actions
104 lines (90 loc) · 2.09 KB
/
user.rb
File metadata and controls
104 lines (90 loc) · 2.09 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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
class User
attr_accessor :id, :fname, :lname
def self.all
results = QuestionsDatabase.instance.execute( 'SELECT * FROM users')
results.map {|result| User.new(result) }
end
def initialize(options = {})
@id = options['id']
@fname = options['fname']
@lname = options['lname']
end
def create
raise 'already saved!' unless self.id.nil?
QuestionsDatabase.instance.execute(<<-SQL, ['fname' => 'charles', 'lname' => 'darwin'])
INSERT INTO
users
VALUES
(?)
SQL
end
def self.find_by_id(user_id)
user_hash = QuestionsDatabase.instance.execute(<<-SQL, user_id)
SELECT
*
FROM
users
WHERE id = (?)
SQL
User.new(user_hash.first)
end
def self.find_by_name(fname, lname)
name_hash = QuestionDatabase.instance.execute(<<-SQL, fname, lname)
SELECT
*
FROM
users
WHERE users.fname = (?) AND users.lname = (?)
SQL
User.new(name_hash.first)
end
def authored_questions
questions_hash = QuestionDatabase.instance.execute(<<-SQL, @id)
SELECT
*
FROM
questions
WHERE
author_id = (?)
SQL
questions_hash.map {|question| Question.new(question)}
end
def authored_replies
reply_hash = QuestionDatabase.instance.execute(<<-SQL, @id)
SELECT
*
FROM
replies
WHERE
user_id = (?)
SQL
reply_hash.map {|reply| Reply.new(reply)}
end
def followed_questions
QuestionFollower.followed_questions_for_user_id(@id)
end
def average_karma
karma_count = QuestionsDatabase.instance.execute(<<-SQL, @id)
SELECT AVG(count)
FROM
(SELECT
CASE WHEN
questions.id IS NULL
THEN 0
ELSE
COUNT(question_likes.question_id)
END AS count
FROM
questions
LEFT JOIN question_likes ON questions.id = question_likes.question_id
WHERE questions.author_id = (?)
GROUP BY questions.id)
SQL
p karma_count
if karma_count.first.values.first.nil?
return 0
else
karma_count.first.values.first
end
end
end