# coding: utf-8 require 'sqlite3' # 接続 db = SQLite3::Database.new("test_ruby.sqlite") # テーブル作成 db.execute('create table test (name text, val real)'); db.execute('create index name_idx on test(name)'); # データ挿入 for n in 1..10000 s = sprintf("test%05d", n) db.execute('insert into test (name, val) values (?, ?)', s, rand) end # 切断 db.close print "OK\n"