activerecordからpostgresql使う
出力
== MessageInit: migrating ==================================================== -- create_table(:messages) NOTICE: CREATE TABLE will create implicit sequence "messages_id_seq" for serial column "messages.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "messages_pkey" for table "messages" -> 0.1686s == MessageInit: migrated (0.1690s) =========================================== user1@うふふ user2@あはは
ar-test.rb
#/usr/bin/ruby require 'rubygems' require 'active_record' ActiveRecord::Base.establish_connection( :adapter => 'postgresql', :host => 'localhost', :username => 'ar_user', :password => 'ar_pass', :database => 'ar-test' ) class MessageInit < ActiveRecord::Migration def self.up create_table(:messages){|t| t.string :name, :limit => 20, :null => false t.string :text,:limit => 30, :null => false } end def self.down drop_table :messages end end MessageInit.migrate(:up) #MessageInit.migrate(:down) # model class Message < ActiveRecord::Base def to_s return "#{name}@#{text}" end end Message.create( :name => 'user1', :text => 'うふふ' ) Message.create( :name => 'user2', :text => 'あはは' ) Message.find(:all).each{ |m| puts m.to_s }