如何使用MySQL和Ruby实现一个简单的投票系统

CREATE TABLE votes (
  id INT PRIMARY KEY AUTO_INCREMENT,
  question TEXT,
  option1 TEXT,
  option2 TEXT,
  option1_votes INT DEFAULT 0,
  option2_votes INT DEFAULT 0
);

gem install mysql2

require 'mysql2'

# 创建数据库连接
client = Mysql2::Client.new(:host => "localhost", :username => "root", :password => "your-password", :database => "voting_system")

# 添加投票
def add_vote(question, option1, option2)
  query = "INSERT INTO votes (question, option1, option2) VALUES ('#{question}', '#{option1}', '#{option2}')"
  client.query(query)
  puts "投票问题：#{question}，选项1：#{option1}，选项2：#{option2}，已添加"
end

# 获取投票信息
def get_votes
  query = "SELECT * FROM votes"
  result = client.query(query)
  result.each do |row|
    puts "投票ID: #{row['id']}"
    puts "问题: #{row['question']}"
    puts "选项1: #{row['option1']}"
    puts "选项1票数: #{row['option1_votes']}"
    puts "选项2: #{row['option2']}"
    puts "选项2票数: #{row['option2_votes']}"
    puts "
"
  end
end

# 投票
def vote(vote_id, option)
  query = "UPDATE votes SET #{option}_votes = #{option}_votes + 1 WHERE id = #{vote_id}"
  client.query(query)
  puts "投票ID：#{vote_id}，选项：#{option}，已记录"
end

# 示例代码
add_vote("你喜欢吃水果吗？", "喜欢", "不喜欢")
get_votes
vote(1, "option1")
get_votes