Contents

#!/usr/bin/env ruby

require 'rubygems'
require_relative '../lib/ppcurses.rb'

begin
  require 'sqlite3'
rescue LoadError => e
  abort "Missing dependency! Run: gem install sqlite3"
end

stringAction = PPCurses::GetStringAction.new("What is your name? ");
intAction = PPCurses::GetIntegerAction.new("Input an integer? ");

def doAction(action)
  action.show()
  action.execute()
end


db = SQLite3::Database.open "test.db"
db.execute <<-SQL
  create table testTable (name varchar(30), val int);
SQL


sqlAction = PPCurses::InsertSQLDataAction.new( [stringAction, intAction],
                  "Insert into testTable(name, val) values ('%s', %s)", db)

screen = PPCurses::Screen.new()
screen.run { doAction(sqlAction) }

db.close
File.delete("test.db")

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
ppcurses-0.0.18	test/insertSQLAction.rb
ppcurses-0.0.17	test/insertSQLAction.rb