#!/usr/bin/env ruby # coding: utf-8 require 'sqlite3' require 'kconv' db = SQLite3::Database.new("fruits.sq3") sql = "insert into fruits values (?, ?, ?)" while true STDERR.print 'Fruit: ' fr = gets break if fr==nil # 入力終端でbreak STDERR.print 'unit of price: ' pr = gets.to_i STDERR.print 'memo: ' memo = gets.chomp db.execute(sql, fr.chomp.toutf8, pr, memo.toutf8) end STDERR.puts "Done"