qeKaNhJJ

1require 'sqlite3'
2
3db = SQLite3::Database.open "test.db"
4db.execute "CREATE TABLE IF NOT EXISTS Players(name VARCHAR PRIMARY KEY, amount INTEGER)"
5db.execute "Create Table if not exists Pending(name_to VARCHAR, amount Integer)"
6
7players = ["Elizabeth", "Vlad", "Aangelo", "Sean", "Jacob", "Alex"]
8
9begin
10players.each do |name|
11	p name
12	db.execute "INSERT INTO Players Values('#{name}', 2000)"
13end
14rescue SQLite3::Exception => e 
15	puts "Exception ocurred"
16	puts e
17ensure
18	db.close if db
19end