ruby gem mysql on cygwin
1£® °²×°Cygwin
ÔËÐÐCygwinµÄ°²×°³ÌÐò¡£´ÓÎļû°üµÄµÄÁбíÖУ¬ÔÚDEVÀïÃæ£¬È·¶¨ÒªÑ¡Ôñ
• Ruby
• gcc
• subversion
ÄãÐèҪʹÓÃgccÀ´½¨Á¢Cygwin°æ±¾µÄMySQL.
2. ÔÚwindowsÉÏÃæ°²×°MYSQL£º
download MySQL 5.0 Windows Installer
3£® °²×°MySQL generic source package²¢ÇÒ½¨Á¢Ëü
°ÑtarballÊͷŵ½Ò»¸öÁÙʱÎļþ¡£
./configure
make install
4£® °²×°Ruby Gems
°´ÕÕÕý³£·½Ê½°²×°£¬ÏÂÔØDownload Gems ÊͷŲ¢°²×°¡£
5£® °²×°Rails:
ÏÖÔÚÄãÒѾÓÐGems£¬Äã¿ÉÒÔ°²×°Rails. Ö´ÐУº
gem insall rails –include-dependencies
6. °²×°mysql gem
ÔËÐÐgem°²×°mysql¡£ µ±³öÏÖÑ¡Ôñʱºò£¬²»Òª°²×°mswin32,
Òª°²×°×îеÄUnix °æ±¾¡£
À©Õ¹µÄ°²×°Ö¸ÁÕâÀïûÓÐÈ«²¿·Òë¶¼Êǰ²×°CygwinµÄÖ¸Á
µ«ÊÇÓÐÒ»¾ä»°ÒªÖصã˵£ºWindows isn’t the greatest environment for development.
Windows²¢²»ÊǺܺõĿª·¢»·¾³¡£
Thanks for http://wiki.rubyonrails.org/rails/pages/RailsonWindowsCygwin
Ïà¹ØÎĵµ£º
MySQLµÄÊý¾Ý±íÀàÐͺܶ࣬MySQLÒ»¹²ÏòÓû§ÌṩÁ˰üÀ¨DBD¡¢HEAP¡¢ISAM¡¢MERGE¡¢MyIAS¡¢InnoDBÒÔ¼°GemeniÕâ7ÖÖ±í¡£ÆäÖÐDBD¡¢InnoDBÊôÓÚÊÂÎñ°²È«Àà±í£¬¶øÆäËûÊôÓÚÊÂÎñ·Ç°²È«Àà±í¡£
DBD
Berkeley DB(DBD)±íÊÇÖ§³ÖÊÂÎñ´¦ÀíµÄ±í£¬ÓÉSleepycatÈí¼þ¹«Ë¾¿ª·¢¡£ËüÌṩMySQLÓû§ÆÚ´ýÒѾõŦÄÜ--ÊÂÎñ¿ØÖÆ¡£ÊÂÎñ¿ØÖÆÔÚÈκÎÊý¾Ý¿âϵͳÖÐ ......
ÔÚphpmyadminµÄ¸ùĿ¼Ï½¨Á¢config.inc.php
дÈëÈçÏ´úÂ룺
<?php
//phpmyadmin ÅäÖÃÎļþ
//±¾µØMySQLÊý¾Ý¿â
$i=1;
$cfg['Servers'][$i]['host'] =
'localhost';
$cfg['Servers'][$i]['user'] ......
FPDFÄÜÖ§³ÖPDFµÄÖÐÎÄ´òÓ¡£¬È»¶øÈ´´æÔÚ²»ÉٵIJ»ÈçÒâÖ®´¦£¬¾ÝÎÒĿǰµÄʹÓã¬×ܽá³ö¼¸µã£º
1£©FPDFÌṩµÄPdf_Chinese×ÖÌ壬½«GBÕâÖÖ×ÖÌåдÈëÁË´úÂëÖУ¬ÈôÎÒÃÇÏ£ÍûÒýÈëÆäËûµÄÖÐÎÄ×ÖÌ壬Ôò²»ÄÜ·½±ãµØÊ¹ÓÃ
2£©FPDFÊä³öµÄÊý×Ö²¢²»ÃÀ¹Û£¬²»ÈçRuport::Formatter::PDF×Ô´øµÄ×ÖÌå
3£©FPDFÌṩµÄ·½·¨²¢²»¶à£¬¶ÔÓÚÒ»°ãµÄ±¨±í´òÓ¡£¬Óõ ......
ÔÚZend FrameWorkÖе÷ÓÃmysqlµÄ´æ´¢¹ý³Ì·½·¨ÈçÏ£º
$db = Zend_Db::factory($sql_DbType,$sql_Config);
$connection=$db->getConnection();
Zend_Registry::set("db",$db);
Zend_Registry::set("connect",$connection);
µ÷Óô洢¹ý³ÌÈçÏ´úÂëËùʾ£º
$this->_db = Zend_Registry::get('db');
$connection=Zend_ ......
Ê×ÏȽ¨Ò»¸ö¹¤³Ì£¬×¼±¸ºÃlog4jµÄjar°üºÍMysqLµÄÇý¶¯°ü¡£
ÅäÖÃlog4j.propertiesÎļþ£º
#´Ë¾äΪ¶¨ÒåÃûΪstdoutµÄÊä³ö¶ËÊÇÄÄÖÖÀàÐÍ£¬¿ÉÒÔÊÇ
#org.apache.log4j.ConsoleAppender£¨¿ØÖÆÌ¨£©£¬
#org.apache.log4j.FileAppender£¨Îļþ£©£¬
#org.apache.log4j.DailyRollingFileAppender£¨Ã¿Ìì²úÉúÒ»¸öÈÕÖ¾ÎÄ ......