温界岳庄厩艶姻艶界看姻糸-看姻温界鉛艶喝艶稼鞄温稼界艶糸-温糸温沿岳艶姻のご府初

?Download as KEY, PDF?

0 likes?744 views

Kevin Toyoda

activerecord-orale_enhanced-
adapterのご�B初
書小( 弥)賓繁(@elcondor)

徭失�B初
Ruby�s�Rails�s�3定磯くらい

JRuby�s�磯定ちょこっと

挫きなメソッドはModule#included,
Class#class_eval
JRubyで晩云�ZCucumberを�咾�茲Δ�
しました

云晩のまとめ

RailsでOracleを聞う��呂蓮�
activerecord-oracle_enhanced-adapterが
オススメ

OracleでRails�
オ�`プンレガシ�`な二�I秤�鵐轡好謄爐�
いえば、DBはOracleのことが謹い
★屡贋システムを試かしたままRailsを聞う
なら、RailsもOracleに岷俊つなぐのが�S

JRubyは、オ�`プンレガシ�`との�f�{、という猟
�}で�Qわれることが謹いので、OracleでRailsと
いうのも寔��に深えておいて�pはない(謹蛍)

What¨s oracle_enhaced?

Oracle Databaseと�げます(輝たり念)

MRIでもJRubyでも聞えます

剽いところに返が曙いてます

箭えばこんな��
class CreateUsers < ActiveRecord::Migration
def self.up
create_table :users do |t|
...
t.date :start_on, :null => false
t.date :end_on
t.datetime :last_logged_at
...
end
end

...
end
start_on/end_onは晩原、last_logged_atは晩�r

禽京協吶は...
Column Type Size
....
START_ON DATE 7
END_ON DATE 7
LAST_LOGGED_AT DATE 7
....
.

禽京協吶は...
Column Type Size
....
START_ON DATE 7
END_ON DATE 7
LAST_LOGGED_AT DATE 7
....
.
晩原も晩�rも、OracleならDATE侏

どう是る?
irb(main):001:0> User.create!(:name => 'さんぷる',
:login => 'sample', :password => 'password',
:start_on => Date.current)
=> #<User id: 10001, name: "さんぷる",
login: "sample", password: "password",
start_on: "2010-12-25 15:00:00", end_on: nil,
last_logged_at: nil, description: nil,
created_at: "2010-XX-XX XX:XX:XX",
updated_at: "2010-XX-XX XX:XX:XX">

まずはdatabase.yml
development:
adapter: oracle_enhanced
uri: jdbc:oracle:thin:@host:1521:xe
connection_alive_sql: ｀select 1 from dual¨

まずはdatabase.yml
development:
adapter: oracle_enhanced
uri: jdbc:oracle:thin:@host:1521:xe
connection_alive_sql: ｀select 1 from dual¨

adapterにoracle_enhancedを峺協

モデルクラスの�g廾

class User < ActiveRecord::Base
set_date_columns :start_on, :end_on
...
end

モデルクラスの�g廾

class User < ActiveRecord::Base
set_date_columns :start_on, :end_on
...
end

set_date_columnsで晩原�Qいするカラムを
峺協

それでどうなった?
irb(main):006:0> User.create!(
:name => 'さんぷる',:login => 'sample',
:password => 'password',
:start_on => Date.current)
=> #<User id: 10002, name: "さんぷる",
login: "sample", password: "password",
start_on: "2010-12-25", end_on: nil,
last_logged_at: nil, description: nil,
created_at: "2010-12-25 22:18:58",
updated_at: "2010-12-25 22:18:58">

それだけ?

麿にも

凋兆��tで晩原侏かどうかを�Qめたり

猟忖双カラムをフラグに聞えたりとか

�かく是りそうなところに返が曙く

というわけで壅まとめ

Oracleでハマりがちな�Fを指閲するのに、
activerecord-oracle_enhanced-adapterが叨羨
つので、ぜひ聞いましょう

% (sudo) jruby -S gem install activerecord-
oracle_enhanced-adapter

温界岳庄厩艶姻艶界看姻糸-看姻温界鉛艶喝艶稼鞄温稼界艶糸-温糸温沿岳艶姻のご府初

1. activerecord-orale_enhanced- adapterのご�B初書小( 弥)賓繁(@elcondor)

2. 徭失�B初 Ruby�s�Rails�s�3定磯くらい JRuby�s�磯定ちょこっと挫きなメソッドはModule#included, Class#class_eval JRubyで晩云�ZCucumberを�咾�茲Δ� しました

3. 云晩のまとめ RailsでOracleを聞う��呂蓮� activerecord-oracle_enhanced-adapterがオススメ

4. OracleでRails� オ�`プンレガシ�`な二�I秤�鵐轡好謄爐� いえば、DBはOracleのことが謹い ★屡贋システムを試かしたままRailsを聞うなら、RailsもOracleに岷俊つなぐのが�S JRubyは、オ�`プンレガシ�`との�f�{、という猟 �}で�Qわれることが謹いので、OracleでRailsというのも寔��に深えておいて�pはない(謹蛍)

5. What¨s oracle_enhaced? Oracle Databaseと�げます(輝たり念) MRIでもJRubyでも聞えます剽いところに返が曙いてます

6. 剽いところに返が曙く?

7. 箭えばこんな�� class CreateUsers < ActiveRecord::Migration def self.up create_table :users do |t| ... t.date :start_on, :null => false t.date :end_on t.datetime :last_logged_at ... end end ... end start_on/end_onは晩原、last_logged_atは晩�r

8. 禽京協吶は... Column Type Size .... START_ON DATE 7 END_ON DATE 7 LAST_LOGGED_AT DATE 7 .... .

9. 禽京協吶は... Column Type Size .... START_ON DATE 7 END_ON DATE 7 LAST_LOGGED_AT DATE 7 .... . 晩原も晩�rも、OracleならDATE侏

10. どう是る? irb(main):001:0> User.create!(:name => 'さんぷる', :login => 'sample', :password => 'password', :start_on => Date.current) => #<User id: 10001, name: "さんぷる", login: "sample", password: "password", start_on: "2010-12-25 15:00:00", end_on: nil, last_logged_at: nil, description: nil, created_at: "2010-XX-XX XX:XX:XX", updated_at: "2010-XX-XX XX:XX:XX">

11. どう是る? irb(main):001:0> User.create!(:name => 'さんぷる', :login => 'sample', :password => 'password', :start_on => Date.current) => #<User id: 10001, name: "さんぷる", login: "sample", password: "password", start_on: "2010-12-25 15:00:00", end_on: nil, last_logged_at: nil, description: nil, created_at: "2010-XX-XX XX:XX:XX", updated_at: "2010-XX-XX XX:XX:XX"> Dateで函り�QいたいカラムがTimeにマッピングされて是る

12. そこで oracle_enhanced-adapter ですよ

13. まずはdatabase.yml development: adapter: oracle_enhanced uri: jdbc:oracle:thin:@host:1521:xe connection_alive_sql: ｀select 1 from dual¨

14. まずはdatabase.yml development: adapter: oracle_enhanced uri: jdbc:oracle:thin:@host:1521:xe connection_alive_sql: ｀select 1 from dual¨ adapterにoracle_enhancedを峺協

15. モデルクラスの�g廾 class User < ActiveRecord::Base set_date_columns :start_on, :end_on ... end

16. モデルクラスの�g廾 class User < ActiveRecord::Base set_date_columns :start_on, :end_on ... end set_date_columnsで晩原�Qいするカラムを峺協

17. それでどうなった? irb(main):006:0> User.create!( :name => 'さんぷる',:login => 'sample', :password => 'password', :start_on => Date.current) => #<User id: 10002, name: "さんぷる", login: "sample", password: "password", start_on: "2010-12-25", end_on: nil, last_logged_at: nil, description: nil, created_at: "2010-12-25 22:18:58", updated_at: "2010-12-25 22:18:58">

18. それでどうなった? irb(main):006:0> User.create!( :name => 'さんぷる',:login => 'sample', :password => 'password', :start_on => Date.current) => #<User id: 10002, name: "さんぷる", login: "sample", password: "password", start_on: "2010-12-25", end_on: nil, last_logged_at: nil, description: nil, created_at: "2010-12-25 22:18:58", updated_at: "2010-12-25 22:18:58"> set_date_columnsメソッドによって、晩原侏としての函り�Qいを�崙できた

19. それだけ? 麿にも凋兆��tで晩原侏かどうかを�Qめたり猟忖双カラムをフラグに聞えたりとか �かく是りそうなところに返が曙く

20. というわけで壅まとめ Oracleでハマりがちな�Fを指閲するのに、 activerecord-oracle_enhanced-adapterが叨羨つので、ぜひ聞いましょう % (sudo) jruby -S gem install activerecord- oracle_enhanced-adapter

21. 嶮

Editor's Notes

&#x4ECA;&#x4E95;(&#x3068;&#x3088;&#x3060;)&#x3068;&#x8A00;&#x3044;&#x307E;&#x3059;&#x3002;\nTwitter&#x3067;&#x306F;@elcondor&#x3067;&#x3064;&#x3076;&#x3084;&#x3044;&#x3066;&#x307E;&#x3059;&#x3002;\n&#x3088;&#x308D;&#x3057;&#x304F;&#x304A;&#x306D;&#x304C;&#x3044;&#x3057;&#x307E;&#x3059;&#x3002;\n\n
&#x521D;&#x767B;&#x5834;&#x306A;&#x306E;&#x3067;&#x3001;&#x300C;&#x304A;&#x524D;&#x306F;&#x4F55;&#x8005;&#x306A;&#x3093;&#x3060;&#x300D;&#x3068;&#x601D;&#x308F;&#x308C;&#x308B;&#x65B9;&#x304C;&#x591A;&#x3044;&#x304B;&#x3068;&#x601D;&#x3044;&#x307E;&#x3059;&#x306E;&#x3067;&#x3001;&#x81EA;&#x5DF1;&#x7D39;&#x4ECB;&#x3092;&#x7C21;&#x5358;&#x306B;&#x3057;&#x307E;&#x3059;&#x3002;\nRuby&#x6B74;&#x3068;&#x304B;JRuby&#x6B74;&#x306F;&#x3001;&#x3053;&#x3053;&#x306B;&#x66F8;&#x3044;&#x305F;&#x901A;&#x308A;&#x3067;&#x3059;&#x3002;\nJRuby&#x30B3;&#x30DF;&#x30E5;&#x30CB;&#x30C6;&#x30A3;&#x3078;&#x306E;&#x8CA2;&#x732E;&#x3068;&#x3057;&#x3066;&#x306F;&#x3001;&#x65E5;&#x672C;&#x8A9E;Cucumber&#x3092;&#x66F8;&#x3051;&#x308B;&#x3088;&#x3046;&#x306B;&#x3059;&#x308B;&#x3001;JRuby&#x672C;&#x4F53;&#x3078;&#x306E;&#x30D1;&#x30C3;&#x30C1;&#x3092;&#x66F8;&#x3044;&#x305F;&#x3001;&#x3068;&#x3044;&#x3046;&#x3068;&#x3053;&#x308D;&#x3067;&#x3059;&#x306D;&#x3002;\n
&#x3067;&#x3001;&#x3044;&#x304D;&#x306A;&#x308A;&#x4ECA;&#x65E5;&#x306E;&#x307E;&#x3068;&#x3081;&#x3067;&#x3059;&#x304C;&#x3001;\nRails&#x3067;oracle&#x3092;&#x4F7F;&#x3046;&#x5834;&#x5408;&#x306F;&#x3001;activerecord-oracle_enhanced-adapter&#x3092;&#x4F7F;&#x3044;&#x307E;&#x3057;&#x3087;&#x3046;&#x3001;&#x3068;&#x3044;&#x3046;&#x3053;&#x3068;&#x306B;&#x306A;&#x308A;&#x307E;&#x3059;&#x3002;\n
Oracle&#x3067;Rails?&#x3068;&#x3044;&#x3046;&#x5411;&#x304D;&#x3082;&#x3042;&#x308B;&#x304B;&#x3068;&#x601D;&#x3044;&#x307E;&#x3059;&#x304C;&#x3001;&#x306A;&#x3093;&#x3060;&#x304B;&#x3093;&#x3060;&#x3067;&#x4F7F;&#x3046;&#x5C40;&#x9762;&#x306F;&#x591A;&#x3044;&#x3088;&#x3046;&#x306B;&#x601D;&#x3046;&#x306E;&#x3067;&#x3059;&#x306D;&#x3002;\nJRuby&#x306F;&#x7279;&#x306B;&#x3001;&#x30AA;&#x30FC;&#x30D7;&#x30F3;&#x30EC;&#x30AC;&#x30B7;&#x30FC;&#x3001;&#x4F8B;&#x3048;&#x3070;EJB&#x30A2;&#x30D7;&#x30EA;&#x306A;&#x3093;&#x304B;&#x3068;&#x306E;&#x9023;&#x643A;&#x3001;&#x307F;&#x305F;&#x3044;&#x306A;&#x6587;&#x8108;&#x3067;&#x6271;&#x308F;&#x308C;&#x308B;&#x3053;&#x3068;&#x304C;&#x591A;&#x3044;&#x3088;&#x3046;&#x306B;&#x601D;&#x3046;&#x306E;&#x3067;&#x3001;\n
&#x3067;&#x3001;&#x3058;&#x3083;&#x3042;oracle_enanced&#x3063;&#x3066;&#x4F55;&#x306A;&#x306E;&#x304B;?&#x3063;&#x3066;&#x3053;&#x3068;&#x306B;&#x306A;&#x308B;&#x3093;&#x3067;&#x3059;&#x304C;&#x3001;Oracle&#x306B;&#x7E4B;&#x3052;&#x308B;&#x306E;&#x306F;&#x5F53;&#x7136;&#x3068;&#x3057;&#x3066;&#x3001;MRI&#x3067;&#x3082;JRuby&#x3067;&#x3082;&#x540C;&#x69D8;&#x306B;&#x4F7F;&#x3048;&#x307E;&#x3059;&#x3002;MRI&#x3067;&#x306F;ruby-oci8&#x306B;&#x3001;JRuby&#x3067;&#x306F;JDBC oracle driver&#x306B;&#x4F9D;&#x5B58;&#x3059;&#x308B;&#x8A33;&#x3067;&#x3059;&#x306D;&#x3002;\n&#x305D;&#x308C;&#x304B;&#x3089;&#x6700;&#x5927;&#x306E;&#x7279;&#x5FB4;&#x3067;&#x3059;&#x304C;&#x3001;&#x300C;&#x75D2;&#x3044;&#x3068;&#x3053;&#x308D;&#x306B;&#x624B;&#x304C;&#x5C4A;&#x3044;&#x3066;&#x308B;&#x300D;&#x3093;&#x3067;&#x3059;&#x3002;&#x3068;&#x3044;&#x3046;&#x308F;&#x3051;&#x3067;&#x3001;\n
&#x75D2;&#x3044;&#x3068;&#x3053;&#x308D;&#x306B;&#x624B;&#x304C;&#x5C4A;&#x304F;&#x3063;&#x3066;&#x3069;&#x3046;&#x3044;&#x3046;&#x3053;&#x3068;&#x3088;?&#x3068;&#x3044;&#x3046;&#x3053;&#x3068;&#x304C;&#x4ECA;&#x65E5;&#x306E;&#x672C;&#x984C;&#x3067;&#x3059;&#x3002;\n&#x524D;&#x7F6E;&#x304D;&#x9577;&#x3044;&#x3067;&#x3059;&#x306D;&#x3002;\n
&#x4F8B;&#x3048;&#x3070;&#x3001;&#x3053;&#x3093;&#x306A;&#x30B3;&#x30FC;&#x30C9;&#x3092;&#x8003;&#x3048;&#x3066;&#x307F;&#x307E;&#x3057;&#x3087;&#x3046;&#x3002;\nstart_on&#x3068;end_on&#x306F;&#x65E5;&#x4ED8;&#x578B;&#x3001;last_logged_at&#x306F;&#x65E5;&#x6642;&#x578B;&#x3067;&#x3059;&#x306D;&#x3002;\n
&#x3067;&#x3082;&#x3001;Oracle&#x3067;&#x306F;&#x3069;&#x3061;&#x3089;&#x3082;&#x3001;&#x533A;&#x5225;&#x305B;&#x305A;DATE&#x3068;&#x3057;&#x3066;&#x53D6;&#x308A;&#x6271;&#x3044;&#x307E;&#x3059;&#x3002;&#x3053;&#x308C;&#x304C;&#x3069;&#x3046;&#x3044;&#x3046;&#x3053;&#x3068;&#x3092;&#x5F15;&#x304D;&#x8D77;&#x3053;&#x3059;&#x304B;&#x3001;&#x3068;&#x3044;&#x3046;&#x3068;...\n
&#x7AEF;&#x7684;&#x306B;&#x8A00;&#x3048;&#x3070;&#x3001;Ruby&#x3067;&#x306F;Date&#x3068;&#x3057;&#x3066;&#x6271;&#x3044;&#x305F;&#x3044;&#x30AB;&#x30E9;&#x30E0;&#x304C;&#x3001;&#x52DD;&#x624B;&#x306B;Time&#x306B;&#x3055;&#x308C;&#x3066;&#x56F0;&#x3063;&#x305F;&#x308A;&#x3059;&#x308B;&#x8A33;&#x3067;&#x3059;&#x306D;&#x3002;\n
&#x3053;&#x3053;&#x3067;oracle_enhanced-adapter&#x306E;&#x767B;&#x5834;&#x3068;&#x306A;&#x308B;&#x308F;&#x3051;&#x3067;&#x3059;&#x306D;&#x3002;\n
&#x307E;&#x305A;&#x306F;&#x3001;database.yml&#x306E;&#x8A2D;&#x5B9A;&#x3092;&#x3057;&#x307E;&#x3059;&#x3002;\n&#x3068;&#x3044;&#x3063;&#x3066;&#x3082;&#x3001;adapter&#x3092;&#x5909;&#x3048;&#x308B;&#x4EE5;&#x5916;&#x306B;&#x306F;&#x4F55;&#x3082;&#x5909;&#x3048;&#x306A;&#x304F;&#x3066;OK&#x3067;&#x3059;&#x3002;\n
&#x3064;&#x3044;&#x3067;&#x3001;&#x30E2;&#x30C7;&#x30EB;&#x30AF;&#x30E9;&#x30B9;&#x306B;set_date_columns&#x3059;&#x308B;&#x3053;&#x3068;&#x3067;&#x3001;&#x65E5;&#x4ED8;&#x6271;&#x3044;&#x3059;&#x308B;&#x30AB;&#x30E9;&#x30E0;&#x3092;&#x6307;&#x5B9A;&#x3059;&#x308B;&#x3093;&#x3067;&#x3059;&#x306D;&#x3002;\n
&#x3068;&#x3059;&#x308B;&#x3068;&#x3001;&#x3053;&#x3046;&#x306A;&#x308A;&#x307E;&#x3059;&#x3002;&#x65E5;&#x4ED8;&#x578B;&#x3068;&#x3057;&#x3066;&#x8A2D;&#x5B9A;&#x3057;&#x305F;&#x5024;&#x304C;&#x3001;&#x65E5;&#x4ED8;&#x578B;&#x3068;&#x3057;&#x3066;&#x53D6;&#x308A;&#x51FA;&#x305B;&#x3066;&#x3044;&#x308B;&#x306E;&#x304C;&#x308F;&#x304B;&#x308A;&#x307E;&#x3059;&#x306D;&#x3002;\n
&#x4ED6;&#x306B;&#x3082;&#x3001;&#x547D;&#x540D;&#x898F;&#x5247;&#x4F9D;&#x5B58;&#x306E;&#x578B;&#x6307;&#x5B9A;&#x3068;&#x304B;&#x3001;&#x30D5;&#x30E9;&#x30B0;&#x30AB;&#x30E9;&#x30E0;&#x306B;&#x6587;&#x5B57;&#x5217;&#x30AB;&#x30E9;&#x30E0;&#x3092;&#x4F7F;&#x3048;&#x305F;&#x308A;&#x3001;&#x3068;&#x304B;&#x3001;\n&#x7D30;&#x304B;&#x304F;&#x56F0;&#x308A;&#x305D;&#x3046;&#x306A;&#x3068;&#x3053;&#x308D;&#x306B;&#x624B;&#x304C;&#x5C4A;&#x3044;&#x3066;&#x3044;&#x308B;&#x3093;&#x3067;&#x3059;&#x306D;&#x3002;\n
&#x3068;&#x3044;&#x3046;&#x308F;&#x3051;&#x3067;&#x307E;&#x3068;&#x3081;&#x3002;\nOracle&#x3067;&#x30CF;&#x30DE;&#x308A;&#x304C;&#x3061;&#x306A;&#x7F60;&#x3092;&#x56DE;&#x907F;&#x3059;&#x308B;&#x70BA;&#x3001;oracle_enhanced-adapter&#x3092;&#x4F7F;&#x3044;&#x307E;&#x3057;&#x3087;&#x3046;&#x3002;\n
\n

際際滷

温界岳庄厩艶姻艶界看姻糸-看姻温界鉛艶喝艶稼鞄温稼界艶糸-温糸温沿岳艶姻のご府初

More Related Content

温界岳庄厩艶姻艶界看姻糸-看姻温界鉛艶喝艶稼鞄温稼界艶糸-温糸温沿岳艶姻のご府初

Editor's Notes