require 'dm-core'
require 'dm-migrations'
require 'dm-migrations/migration_runner'

#DataMapper.setup(:default, "sqlite3://#{Dir.pwd}/sample.db") #"sqlite3::memory")
#DataMapper.setup(:default, 'mysql://root:@localhost/datamapper_test')
DataMapper.setup(:default,{
  :adapter=>'mysql',
  :database=>'datamapper_test',
  :username=>'root',
  :password=>'',
  :host=>'127.0.0.1'
})

DataMapper::Logger.new(STDOUT, :debug)
DataMapper.logger.debug( "Starting Migration" )

class Person
  include DataMapper::Resource

  property :id, Serial
  property :name, Text
  property :age, Integer
end

task :default

task :migrate_up do
  migrate_up!
end

task :migrate_down do
  migrate_down!
end

task :populate do
  Person.create(:name=>"Justin", :age=>12)

  Person.all.each do |dude|
    puts dude.inspect
  end
end

migration 1, :create_person_table do
  up do
    create_table :people do
      column :id,   Integer, :serial => true
      column :name, String, :length=>2
      column :age,  Integer
    end
  end
  down do
    drop_table :people
  end
end

migration 2, :change_name_constraints do
  up do
    modify_table :people do
      change_column :name,   Text
    end
  end
  down do
    modify_table :people do
      change_column :name,   String, :length=>2
    end
  end
end