前边有介绍mongodb的安装以及ror项目的搭建,现在进行一下整合。
1.创建项目
创建项目时不再使用rails active_record支持
rails new todo -o
2.我们将要使用mongomapper来驱动mongodb到rails
编辑gemfile,增加下面的内容
gem"mongo_mapper"
然后 执行 bundle install 安装gem
bundle install
3.添加数据库链接
在config/initializer下面新建一个mongo.rb文件,指定全局的数据库信息:
mongomapper.connection = mongo::connection.new('localhost', 27017) mongomapper.database ='todo'#通过指定rails运行环境参数,我们可以在不同的运行环境下创建互不干扰的数据,为了简单起见,没有为不同的环境指定不同的数据
if defined?(phusionpassenger) phusionpassenger.on_event(:starting_worker_process)do|forked| mongomapper.connection.connectifforked end end
完成以上步骤后,启动程序:
$ rails server
**notice: c extension not loaded. this is required for optimum mongodb ruby driver performance. you can install the extension as follows:
gem install bson_ext
if you continue to receive this message after installing, make sure that the bson_ext gem is in your load path and that the bson_ext and mongo gems are of the same version. => booting webrick => rails 3.0.10 application starting in development on http://0.0.0.0:3000 => call with -d to detach => ctrl-c to shutdown server [2011-10-19 23:36:14] info webrick 1.3.1 [2011-10-19 23:36:14] info ruby 1.9.2 (2011-07-09) [x86_64-linux] [2011-10-19 23:36:14] info webrick::httpserver#start: pid=19595 port=3000
从上面输出中可以看到bson_ext库没有加载。按照提示安装该库即可(别忘了在gemfile中添加gem):
再次启动程序,notice提示消息消失,启动正常。在浏览器输入:http://127.0.0.1:3000,就可以看到如下页面
4.添加页面和处理逻辑
通过rails的generate命令来生成页面、控制器和模型层文件(个人还是喜欢自己手动创建,这里为了演示方便)
rails generate scaffold project name:string --orm=mongo_mapper
由于我们使用mongo作为数据库。那么,我们需要把activerecord的model,改成mongomapper的类型,也就是把继承关系从activerecord::base变成mongomapper::document。我们使用key这个方法标明该mongomapper的字段属性。我们的属性是name,再加上这个字段的类型string,那么定义如下:
classproject include mongomapper::document key:name,string end
通过以上的修改,我们就已经拥有了所有添加,更新,删除和列表的操作
5.数据查看
可以通过命令mongo进入mongodb数据库进行数据的查询
mongo //进入数据库 use todo //切换库 db.projects.find() //执行查询
mongomapper和activerecord是完全相同的。甚至,mongomapper还是支持activerecord的验证方式如下
validates_presence_of:name
由于mongodb没有schema-less(数据版本记录)我们可以非常容易的添加和更改model的属性,而不需要执行任何migrations的操作。比如,我们需要添加一个priority的属性,我们仅仅需要的是修改project model如下:
classproject include mongomapper::document key:name,string,:required=>true key:priority,integer end
表之间的关联对于mongodb这里稍微有点区别,我们需要objectid类型来存储所有id。
至于,处理不同表之前的关联,我们可以像activerecord一样定义belongs_to,当然,稍微有点不同,在project中我们需要定义has_many :tasks,在mongomapper中需要用many代替。
我目前也就做到这里。有时间再去深入研究其他的功能。
ps:ruby编写mongodb备份脚本(fsync & lock)
#!/usr/local/bin/ruby # date: 06-12-2014 # auther: lucifer # use fsync and lock to the file-system before backup the file-system # mongo-ruby-driver version > 1.10.0 require 'mongo' require 'fileutils' require 'date' include mongo include bson # the members of replcation-set # test mongodb server version 2.6.0 # host = "192.168.11.51" # the port of members # if the port is 27017 by default then otherport don't need to assignment # otherport = "" # port = otherport.length != 0 ? otherport : mongoclient::default_port # opts = {:pool_size => 5, :pool_timeout => 10} # create a new connection # client = mongoclient.new(host, port, opts) uri_string = "mongodb://caoqing:xxxxxxxx@x.x.x.x:27017/admin" client = mongoclient.from_uri(uri = "#{uri_string}") db = client['admin'] # fsync and lock the database cmd = orderedhash.new cmd[:fsync] = 1 cmd[:lock] = true # p cmd db.command(cmd) # datafile path d = "/var/lib/mongo" # dir = dir.new("#{d}") # entries = dir.entries # entries.delete_if { |entry| entry =~ /^\./} # convert the relative path to the full path # entries.map! { |entry| file.join(dir.path, entry) } # maintain only the type of file # entries.delete_if { |entry| !file.file?(entry) } # p entries start = date.today.to_s prev = (date.today - 7).to_s dest = "/backup/#{start}" sour = "/backup/#{prev}" fileutils.rm_rf("#{sour}") if file::exist?("#{sour}") dir.mkdir("#{dest}", 0755) unless file::exist?("#{dest}") fileutils.cp_r dir.glob("#{d}/**"), dest if client.locked? puts "*" * 20 puts "\tbackup complete" puts "*" * 20 # db::system_command_collection # unlock the database db["$cmd.sys.unlock"].find_one client.close
发表评论