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