ruby°²×°mysql
ruby on rails°²×°mysqlÊý¾Ý¿â
1. ÏÂÔØmysqlÈí¼þ
http://www.mysql.cn/
mysqlÖÐÎĹٷ½ÍøÕ¾ÏÂÔØ°²×°Èí¼þ£¬Ñ¡Ôñ5.0
2. °²×°mysql£¬ÉèÖÃĬÈÏ×Ö·û¼¯Îªutf-8
3. ÏÂÔØmysql for rubyµÄÇý¶¯²¢°²×°
http://rubyforge.org/ËÑË÷mysql£¬ÕÒµ½mysql -win
µã»÷ÏÂÔØ£¬½øÈëÒ³Ãæ
http://rubyforge.org/frs/?group_id=1598&release_id=38245
ÏÂÔØmysql-2.7.1-mswin32.gem
c:\ruby Ŀ¼ÏÂÖ´ÐÐgem install mysql-2.7.1-mswin32.gem
°²×°mysqlÁ¬½ÓrubyµÄÇý¶¯³ÌÐò
4. ÅäÖÃ
½«mysql°²×°Ä¿Â¼£¨Ä¬ÈÏC:\program files\mysql)Ö®binĿ¼ÏµÄlibmySQL.dll
¿½±´ÖÁC:\ruby\binĿ¼ÏÂ
½«C:\ruby\lib\ruby\gems\1.8\gems\mysql-2.7.1-mswin32\ext\Ŀ¼ÏÂmysql.soÎļþ
¿½±´ÖÁC:\ruby\lib\ruby\site_ruby\1.8\i386-msvcrt\Ŀ¼ÏÂ
5. ²âÊÔrubyÁ¬½Ómysql
test_mysql.rd:
require "mysql"
puts("hello,mysql")
ÃüÁîÐÐÖ´ÐÐruby test_mysql.rd
Êä³ö½á¹û£º
hello,mysql
6. mysqlÁ¬½Ó³É¹¦
Ïà¹ØÎĵµ£º
Ò» °²×°ruby
$sudo apt-get install ruby irb rdoc
¶þ °²×°gem
1.µ½ÕâÀïÏÂÔØ ,×îºÃÊÇ×îа汾£¬ÎÒµÄ1.3.5
½âѹ£¬Çл»µ½µ±Ç°Ä¿Â¼£¬Ö´ÐÐ$sudo ruby setup.rb
»òÕßÕâÑù£º
$ tar xzvf rubygems-1.3.5.tgz £¨½âѹ£©
$ cd rubygems-1.3.5 £¨Çл»µ½´ËĿ¼£©
$ sudo ruby setup ......
Ëɱ¾ÐкêÈçÔ¼ÓÚÊ¥µ®½Ú·¢²¼ÁËRuby 1.9¡£¸ù¾ÝRubyµÄ¹ßÀý£¬Ð¡ÊýµãºóÃæµÚһλÈç¹ûÊǵ¥Êý£¬ÄÇô¾Í±íÃ÷ÕâÊÇÒ»¸öʵÑé°æ±¾£¬²»ÍƼöÓÃÓÚ²úÆ·»·¾³¡£Ëùν“²úÆ·»·¾³”£¬¶ÔÓÚĿǰµÄRubyÀ´Ëµ£¬»ù±¾ÉϾÍÊÇRuby on Rails¡£´ÓĿǰRoRÉçȺµÄ·´Ó³À´¿´£¬È·ÊµÓÐÈËÕýÔÚ³¢ÊÔÓÃRuby 1.9ÅäºÏRoR£¬µ«ÊÇÉÐÊôÍæÆ±ÐÔÖÊ¡£ÎÒѯÎÊÁËһЩ´¦ÔÚÕæÊµÏ ......
Ruby 101£º·½·¨¶ÔÏó
Written by Allen Lee
´Ó·½·¨µ÷ÓÃ˵Æð
ÔÚÉÏһƪÎÄÕÂÀÎÒÃÇ¿´µ½µ÷ÓöÔÏóµÄ·½·¨ÊµÖÊÉÏÊÇÏò¶ÔÏó·¢ËÍÏûÏ¢£¬ÏÂÃæ£¬ÎÒÃÇÔÙÀ´¿´Ò»¸öÓÐȤµÄÓ¦Óá£ÔÚRubyÀ×Öµä¿ÉÒÔͨ¹ý {key => value} À´´´½¨£¬Èç¹ûÄãʹÓõİ汾ÊÇ1.9»òÒÔÉÏ£¬µ±keyµÄÀàÐÍÊÇSymbolʱ£¬´´½¨×ÖµäµÄÓ ......
±¾ÎĽéÉÜÁËRuby on RailsµÄÏêϸ°²×°²½Öè¡£ÎÄÖÐʹÓõÄRuby on Rails°æ±¾ÊÇ1.8.6-26¡£°²×°RubyÖ®ºó°²×°Rails£¬È»ºó¾Í¿ÉÒÔ´´½¨WebÓ¦Ó㬲¢ÔÚ±¾µØ²âÊÔÁË¡£
1¡¢°²×°ruby
²»ÓÃ˵ ÊÇÏÂÔØ°²×°°ü£ºhttp://rubyforge.org/frs/?group_id=167£¬×¢Òâ°æ±¾---º¦È˲»Ç³£¬ºóÃæ»á˵µ½£¬ÎÒϵÄÊÇ1.8.6-26
×°Íêºó£¬¿ÉÒÔÓÃruby -v ²âÊÔÊÇ·ñ° ......
¶©µ¥´¦Öã¬Ê×ÏÈÒªÓÐÒ»¸ö¶©µ¥µÄÏêϸÁÐ±í£¨°üÀ¨ÊýÁ¿£¬¼ÛǮɶµÄ£©ºÍÒ»¸ö¶ÔÓÚ¸öÈ˵ÄһЩÐÅÏ¢µÄÒ»¸ö±í¡£Òò¶øÎÒÃÇ´´ÔìÁ½¸öÄ£ÐÍ£¬line_item(ÁбíÏî),order(Áбí)£¬Æäºó±àÕßÈç´Î
/db/migrate xxx_create_order xxx_line_item
Ruby´úÂë
Ò».class CreateOrders < ActiveRecord::Migration
¶þ.def self.up
3. create_tabl ......