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
|
# File 'lib/fun_facts.rb', line 3
def self.funfacts?
db = SQLite3::Database.new("trivia_facts.db")
create_table_cmd = <<-SQL
CREATE TABLE IF NOT EXISTS trivia_facts(
id INTEGER PRIMARY KEY,
name VARCHAR(255),
fact VARCHAR(500)
)
SQL
db.execute(create_table_cmd)
puts "What's your name?"
@name = gets.chomp.downcase
puts "What interesting fact do you know?"
@fact = gets.chomp.downcase
db.execute("INSERT INTO trivia_facts (name, fact) VALUES (?, ?)", @name, @fact)
@random = db.execute("SELECT trivia_facts.fact FROM trivia_facts ORDER BY RANDOM() LIMIT 1")
puts "Do you wanna know what is quite funny? Answer yes or no"
answer = gets.chomp
if answer == "yes"
puts "You will never believe...Did you know that #{@random[0][0]}?"
else
puts "Oh, ok. NEVERMIND!"
end
end
|