/path/to/dream
3.0 798 actionmailer Android apache apk array base64 beijing boundingbox capistrano Centos comet contentSlider cookie csrf ctime date_picker datetime debug DeepLearning DMZ dns dnspod dovecot drx exif feixin find fixtures gem gems git godaddy Google gui hanzi_to_pinyin helper Heroku httpclient IE iftop ImageMagick init.d IOS iou iso8601 Java javascript jQuery jstack Katz Linode linux lua mac mail_server Metaprogramming microsoft mini_magick mongodb monitor Mysql NBA netbeans Netposa nginx ngx_lua nodejs NoSQL OAuth2 omniauth oo open_relay openResty orientation pack passenger pdf PhoneGap php phpmyadmin postfix PostgreSQL prototype python QQ RAID1 rails rails3 rails3.0 rails3.0.3 rails3.1 rails3.x Rake rc.d rc.local regexp reset resty rm RMagick routes rspec ruby ruby1.9.2 rvm sed server session shell SNS software squirrelmail ssh String svn swfupload TestCase thin timestamp tomcat Twitter ubuntu unpack update visual_studio vmware VPS weibo windows wuxi XSS yaml 北京 北京世贸天阶 北京故宫 北京莎日娜蒙古风情生态农业观光园 北京通州 北京鹫峰 园博园 圣丰地产 宿迁 招聘 方正 旅游 旅行 正则 活动 盈利模式 目标检测 租房 索引 自动部署 路由器 骆马湖 黑中介
环境: Rails 3.0.3
Rails中判断表是否存在,表的某个字段是否存在都提供了API,但是如何判断数据库存在,没有提供api
可以使用下面的方法判断出来:
> ActiveRecord::Base.connection.execute("USE INFORMATION_SCHEMA") # 连接mysql INFORMATION_SCHEMA 数据库 >ActiveRecord::Base.connection.execute("SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'db'").to_a =>[["db"]] # 存在db >ActiveRecord::Base.connection.execute("SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'db1'").to_a =>[] # 不存在db1