#!/usr/bin/env jruby

require 'rubygems'
gem 'activerecord-jdbc-adapter'
require 'jdbc_adapter'
gem 'activerecord', '1.15.3'
require 'active_record'
require 'pp'
require '/opt/apps/jruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/fixtures'

ActiveRecord::Base.establish_connection(:adapter => 'oracle',
                                        :database => 'XE',
                                        :username => 'blog',
                                        :password => 'blog')

class AddTestTable < ActiveRecord::Migration
  def self.up
    create_table :people do |t|
      t.column :name, :string
      t.column :active, :boolean
      t.column :added_at, :datetime
    end
  end

  def self.down
    drop_table :people
  end
end

class Person < ActiveRecord::Base
  validates_presence_of :name
  validates_presence_of :active
end

begin
  AddTestTable.migrate(:up)

  yml = <<EOYML
id: 1
name: "Jane Doe"
added_at: #{Time.now.to_formatted_s(:db)}
EOYML

  hsh = YAML.load(yml)
  fixture = Fixture.new(hsh, "Person")
  Person.connection.execute "INSERT INTO people (#{fixture.key_list}) VALUES (#{fixture.value_list})", 'Fixture Insert'

rescue
  pp $!
  pp $!.backtrace
ensure
  AddTestTable.migrate(:down)
end

# aglasgall@bs183873:~> jruby ar-jdbc-testcase.rb
# == AddTestTable: migrating ====================================================
# -- create_table(:people)
#    -> 1.4562s
# == AddTestTable: migrated (1.4576s) ===========================================

# #<ActiveRecord::StatementInvalid: ActiveRecord::ActiveRecordError: ORA-01861: literal does not match format string
# : INSERT INTO people (added_at, id, name) VALUES ('2008-02-25 16:11:25', 1, 'Jane Doe')>
# ["/opt/apps/jruby-1.1RC2/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract_adapter.rb:128:in `log'",
#  "/opt/apps/jruby-1.1RC2/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.7.2/lib/active_record/connection_adapters/jdbc_adapter.rb:507:in `execute'",
#  "/opt/apps/jruby-1.1RC2/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.7.2/lib/active_record/connection_adapters/jdbc_adapter.rb:507"]
# == AddTestTable: reverting ====================================================
# -- drop_table(:people)
#    -> 0.0465s
# == AddTestTable: reverted (0.0471s) ===========================================