<script>
$(function() {
$('#start').datepicker({
beforeShowDay: function(dt) {
return [dt.getDay() == 0 ? true : false];
}
});
});
</script>
LANG=ja_JP.UTF-8エラーログが/etc/crontab で実行した際に表示されていなかったが、
"command > /dev/null 2>&1"
> str = "ABCDE"
=> "ABCDE"
# 最終文字
> str[-1, 1]
=> "E"
# 最後から3番目の、そこから2文字
> str[-3, 2]
=> "CD"
$ rails g mailer WeeklyMailer
create app/mailers/weekly_mailer.rb
invoke erb
create app/views/weekly_mailer
invoke rspec
create spec/mailers/weekly_mailer_spec.rb
# app/mailers/weekly_mailer.rb
class WeeklyMailer < ActionMailer::Base
default from: "abc@example.com"
def weekly_email
@date = Period.date_from
recipient = "xxx@example.com"
subject = "お知らせ @date"
mail(:to => recipient,
:subject => subject)do |format|
format.html # HTML形式
format.text # テキスト形式
end
end
end
# app/views/weekly_mailer/weekly_email.html.erb
<!DOCTYPE html>
<html>
<head>
<meta content='text/html; charset=UTF-8' http-equiv='Content-Type' />
</head>
<body>
<p>てすと</p>
</body>
</html>
class WeeklyMailController < ApplicationController
class << self
def exec
WeeklyMailer.weekly_email.deliver
end
end
end
rails r WeeklyMailController.exec
# config/initializers/action_mailer_log_subscriber.rb
require 'action_mailer/log_subscriber'
module ActionMailer
class LogSubscriber
def deliver_with_debug(event)
deliver_without_debug(event)
debug(Mail.new(event.payload[:mail]).subject)
debug(Mail.new(event.payload[:mail]).body)
end
alias_method_chain :deliver, :debug
end
end
config/environments/development.rb
config.action_mailer.raise_delivery_errors = true #デフォルトはfalse
config.action_mailer.delivery_method = :smtp
config.action_mailer.smtp_settings = {
:enable_starttls_auto => false, ## ないとエラー(※)がでる
:address => 'xxxxx.example.com',
:port => 250,
}
bundle/ruby/1.9.1/gems/railties-3.2.6/lib/rails/commands/runner.rb:53:in `eval': hostname does not match the server certificate (OpenSSL::SSL::SSLError)
from /home/xxx/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/net/smtp.rb:585:in `tlsconnect'
from /home/xxx/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/net/smtp.rb:560:in `do_start'
from /home/xxx/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/net/smtp.rb:519:in `start'
...
gem 'mail-iso-2022-jp'差出人を書く所は、こんな書き方になります。
default from: "なまえ<aaa@example.com>", :charset => 'iso-2022-jp'
$ rails g model latest_info
invoke active_record
create db/migrate/20121030042916_create_latest_infos.rb
create app/models/latest_info.rb
invoke rspec
create spec/models/latest_info_spec.rb
$ rails destroy model latest_info
invoke active_record
remove db/migrate/20121030042916_create_latest_infos.rb
remove app/models/latest_info.rb
invoke rspec
remove spec/models/latest_info_spec.rb
<%= h simple_format(text) %>http://railsdoc.com/references/simple_format
文字列を<p>で括る
改行は<br />を付与
連続した改行は、</p><p>を付与
<table border=1 width="100%" style="table-layout: fixed;">
<tr>
<th width="100px">Col ABC</td>
<th>Col ABCDE</td>
<th>Col3 ABCDE FGHIJ</td>
<th>Col4</td>
</tr>
</table>
<div id = "my_table" style="display: none">
<table>
...
</table>
<div>
<script type="text/javascript">
function toggleDiv(divId) {
$("#"+divId).toggle('fast');
}
</script>
<a href="javascript:toggleDiv('my_table');" style="text-decoration: none;">Click!</a>
# config/application.rb
config.autoload_paths += %W(#{config.root}/lib/validators)
# lib/validators/repo_presence_validator.rb
class RepoPresenceValidator < ActiveModel::EachValidator
def validate_each(object, attribute, value)
unless mail_groups(value)
object.errors[attribute] << (options[:message] || "は存在しません")
end
end
private
def mail_groups(value)
...
end
end
validates :name, :presence => true, :repo_presence => true<参考>
Project.includes(:client)
Team.includes(:project => [:client])さらにwhere句を付ける場合は、下記のようにテーブル名をつけてあげます。
Team.includes(:project => [:client]).where("clients.code = ? ", code)
login_ids = ["sato", "suzuki", "tanaka"]
@users = User.where(["login in (?)", login_ids])
SELECT `users`.* FROM `users` WHERE (login in ('sato','suzuki','tanaka'))
app/assets/javascripts/jquery-ui-1.8.23.custom.min.js
$ vi app/assets/javascripts/application.js//= require jquery //= require jquery-ui //= require jquery_ujs //= require_tree .
CSSファイルの配置
app/assets/stylesheets/jquery-ui/jquery-ui-1.8.23.custom.css
CSSファイルの読み込み
$ vi app/assets/stylesheets/application.css*= require_self *= require_tree . *= require_tree ./jquery-ui
画像ファイルの配置(ここ注意！ images/imagesになります)
app/assets/images/images/*.png
日本語化対応のファイル配置
app/assets/javascripts/jquery.ui.datepicker-ja.js
日本語化対応のファイル読み込み
下記からjaのファイルを取得します。
http://jquery-ui.googlecode.com/svn/trunk/ui/i18n/
$ vi app/assets/javascripts/application.js//= require jquery.ui.datepicker-ja
$ bundle exec rake assets:precompile RAILS_ENV=production
$ rails s -e production
<%= favicon_link_tag %>
activerecord:
attributes:
user:
name: "名前"
<% if @admin_client.errors.any? %>ちなみに、このエラーメッセージ表示部をpartialで切り出して、@adminのところを引数で渡すようにすると、変更が容易になりました。
<div id="error_explanation">
<h2><%= pluralize(@admin_client.errors.count, "error") %> prohibited this admin_client from being saved:</h2>
<ul>
<% @admin_client.errors.full_messages.each do |msg| %>
<li><%= msg %></li>
<% end %>
</ul>
</div>
<% end %>
config.action_view.field_error_proc = Proc.new {|html_error, instance| "#{html_error}".html_safe }
<%= number_with_delimiter(12345678, :delimiter => ",") %>こんなふうに表示されます。
12,345,678
content_tag(:img,"" ,:src=>image_path("test.png"))
<img src="/assets/test.png">
class AddIndex < ActiveRecord::Migration
def change
add_index :users, [:project_id, :login], :unique=>true, :name=>'users_project_login'
end
end
show index from index;
drop index index_name on tbl_name;
<tr class="<%= cycle('even', 'odd')%>">なお、cycleの引数は2つ以上取れます。例えば、red, yellow, blueにした場合は、3色が順になります。
.odd {background-color:#f6f7f8;}
.even {background-color: #fff;}
<% reset_cycle() %>
background-image: url(/images/sort_asc.png);
background-image: url(../images/sort_asc.png);Try3 (assetが必要？ でもダメだった…)
background-image: url(/assets/images/sort_asc.png);Try4 (もしや、ただ単に画像ファイル名だけ？Bingo!)
background-image: url(sort_asc.png);
<div id = "sidebar">
<%= yield :sidebar %>
</div>
<div id="content">
<%= yield %>
</div>
<% content_for :sidebar do %>
<%= render(:partial => 'menu') %>
<% end %>
1.9.3p194 :001 > 1/3
=> 0
1.9.3p194 :002 > 1/3.to_f
=> 0.3333333333333333
1.9.3p194 :003 > (1/3.to_f).round
=> 0
1.9.3p194 :004 > (1/3.to_f).round(2)
=> 0.33
1.9.3p194 :005 > 1/4
=> 0
1.9.3p194 :006 > 1.to_f/4
=> 0.25
1.9.3p194 :007 > (1.to_f/4).round
=> 0
1.9.3p194 :008 > (1.to_f/4).round(1)
=> 0.3
1.9.3p194 :009 > (1.to_f/4).round(2)
=> 0.25
sudo /etc/mysql/my.cnfこれを1行追加して
default-character-set=utf8MySQL再起動すればOK！
$ sudo /etc/init.d/mysql restart
$ rvm use listrvm を最新に更新する
rvm rubies
jruby-1.6.2 [ amd64 ]
ree-1.8.7-2011.03 [ x86_64 ]
ruby-1.8.6-p420 [ x86_64 ]
ruby-1.8.7-p352 [ x86_64 ]
ruby-1.9.2-p290 [ x86_64 ]
$ rvm get headアップデートしたrvmの再読み込み
$ rvm reload
RVM reloaded!
$ rvm list known
# MRI Rubies
[ruby-]1.8.6[-p420]
[ruby-]1.8.7[-p358]
[ruby-]1.8.7-head
[ruby-]1.9.1[-p431]
[ruby-]1.9.2-p180
[ruby-]1.9.2-p290
[ruby-]1.9.2-p318
[ruby-]1.9.2[-p320]
[ruby-]1.9.2-head
[ruby-]1.9.3-preview1
[ruby-]1.9.3-rc1
[ruby-]1.9.3-p0
[ruby-]1.9.3-p125
[ruby-]1.9.3-[p194]
[ruby-]1.9.3-head
ruby-head
…
$ rvm install 1.9.3"--head"をつけるとリポジトリの最新リビジョン。
Installing Ruby from source to: /home/tiffany/.rvm/rubies/ruby-1.9.3-p194, this may take a while depending on your cpu(s)...
$ rvm use 1.9.3
Using /home/tiffany/.rvm/gems/ruby-1.9.3-p194
$ rvm use 1.9.2あれ… どもう最新じゃないからインストールせよと…
ruby-1.9.2-p320 is not installed.
To install do: 'rvm install ruby-1.9.2-p320'
$ rvm install ruby-1.9.2-p320
$ rvm use 1.9.2
Using /home/tiffany/.rvm/gems/ruby-1.9.2-p320
$ rvm use ruby-1.9.2-p290
Using /home/tiffany/.rvm/gems/ruby-1.9.2-p290
> require 'digest/md5'
=> true
> Digest::MD5.hexdigest("aa")
=> "4124bc0a9335c27f086f24ba207a4912"
> Digest::MD5.hexdigest("AA")
=> "3b98e2dffc6cb06a89dcb0d5c60a0206"
$ gem install passenger
Fetching: fastthread-1.0.7.gem (100%)
Building native extensions. This could take a while...
Fetching: daemon_controller-1.0.0.gem (100%)
Fetching: passenger-3.0.12.gem (100%)
Successfully installed fastthread-1.0.7
Successfully installed daemon_controller-1.0.0
Successfully installed passenger-3.0.12
3 gems installed
Installing ri documentation for fastthread-1.0.7...
Installing ri documentation for daemon_controller-1.0.0...
Installing ri documentation for passenger-3.0.12...
Installing RDoc documentation for fastthread-1.0.7...
Installing RDoc documentation for daemon_controller-1.0.0...
Installing RDoc documentation for passenger-3.0.12...
$ passenger-install-apache2-moduleここではとりあえずEnter押下。
Welcome to the Phusion Passenger Apache 2 module installer, v3.0.12.
This installer will guide you through the entire installation process. It
shouldn't take more than 3 minutes in total.
Here's what you can expect from the installation process:
1. The Apache 2 module will be installed for you.
2. You'll learn how to configure Apache.
3. You'll learn how to deploy a Ruby on Rails application.
Don't worry if anything goes wrong. This installer will advise you on how to
solve any problems.
Press Enter to continue, or Ctrl-C to abort.
--------------------------------------------無事インストールされたようなのでEnter押下。
The Apache 2 module was successfully installed.
Please edit your Apache configuration file, and add these lines:
LoadModule passenger_module /home/tiffany/.rvm/gems/ruby-1.9.2-p290@rails3/gems/passenger-3.0.12/ext/apache2/mod_passenger.so
PassengerRoot /home/tiffany/.rvm/gems/ruby-1.9.2-p290@rails3/gems/passenger-3.0.12
PassengerRuby /home/tiffany/.rvm/wrappers/ruby-1.9.2-p290@rails3/ruby
After you restart Apache, you are ready to deploy any number of Ruby on Rails
applications on Apache, without any further Ruby on Rails-specific
configuration!
Press ENTER to continue.
--------------------------------------------
Deploying a Ruby on Rails application: an example
Suppose you have a Rails application in /somewhere. Add a virtual host to your
Apache configuration file and set its DocumentRoot to /somewhere/public:
<VirtualHost *:80>
ServerName www.yourhost.com
# !!! Be sure to point DocumentRoot to 'public'!
DocumentRoot /somewhere/public
<Directory /somewhere/public>
# This relaxes Apache security settings.
AllowOverride all
# MultiViews must be turned off.
Options -MultiViews
</Directory>
</VirtualHost>
And that's it! You may also want to check the Users Guide for security and
optimization tips, troubleshooting and other useful information:
/home/tiffany/.rvm/gems/ruby-1.9.2-p290@rails3/gems/passenger-3.0.12/doc/Users guide Apache.html
Enjoy Phusion Passenger, a product of Phusion (www.phusion.nl) :-)
http://www.modrails.com/
Phusion Passenger is a trademark of Hongli Lai & Ninh Bui.
$ sudo vi /etc/apache2/sites-available/xxxそのファイルに下記を追加します。
LoadModule passenger_module /home/tiffany/.rvm/gems/ruby-1.9.2-p290@rails3/gems/passenger-3.0.12/ext/apache2/mod_passenger.soモジュールのパス設定
PassengerRoot /home/tiffany/.rvm/gems/ruby-1.9.2-p290@rails3/gems/passenger-3.0.12
PassengerRuby /home/tiffany/.rvm/wrappers/ruby-1.9.2-p290@rails3/ruby
<VirtualHost *:80>
ServerName www.yourhost.com
DocumentRoot /home/tiffany/sinatra/public
<Directory /home/tiffany/sinatra/public>
AllowOverride all
Options -MultiViews
</Directory>
ErrorLog /var/log/apache2/error.log
CustomLog /var/log/apache2/access.log combined
</VirtualHost>
DocumentRoot /home/tiffany/sinatra/public
RackEnv development
# config.ru
require "./myapp.rb"
run Sinatra::Application
$ rackup config.ru
[2012-04-20 15:51:07] INFO WEBrick 1.3.1
[2012-04-20 15:51:07] INFO ruby 1.9.2 (2011-07-09) [x86_64-linux]
[2012-04-20 15:51:07] INFO WEBrick::HTTPServer#start: pid=27704 port=9292
RACK_ENV=production rackup config.ru
スラッシュなしスラッシュあり
get '/hello' do
"Hello"
end
get '/hello/' do
"Hello"
end
get '/hello/?' do
"Hello"
end
require "sinatra/config_file"例えば、こんなconfig.ymlがあったとします。
config_file 'path/to/config.yml
production:settings.server、settings.port でそれぞれのモードに応じた値が取得できます。
server: sinatra_production
port: 5555
development:
server: sinatra_dev
port: 5555
test:
server: sinatra_test
port: 5555
server:
production: sinatra_production
development: sinatra_dev
test: sinatra_test
port: 5555
$ gem install sinatra-reloader
Fetching: backports-2.5.1.gem (100%)
Fetching: rack-test-0.6.1.gem (100%)
Fetching: eventmachine-0.12.10.gem (100%)
Building native extensions. This could take a while...
Fetching: sinatra-contrib-1.3.1.gem (100%)
Fetching: sinatra-reloader-1.0.gem (100%)
Successfully installed backports-2.5.1
Successfully installed rack-test-0.6.1
Successfully installed eventmachine-0.12.10
Successfully installed sinatra-contrib-1.3.1
Successfully installed sinatra-reloader-1.0
5 gems installed
if development?この下にはいつも通りの configure… before… get…等が続く。
require "sinatra/reloader"
also_reload File.dirname(__FILE__) + "/Xxxx.rb" ## 一緒にリロードするファイルがあれば
end
get '/get' doviews/hello.erb
res_data = find(x,y)
erb hello, :locals => {:data => res_data}
end
Result:
<%= data %>
$ ruby api.rb -p 4568他にもいくつかの起動オプションあり。
[2012-04-10 18:05:45] INFO WEBrick 1.3.1
[2012-04-10 18:05:45] INFO ruby 1.9.2 (2011-07-09) [x86_64-linux]
== Sinatra/1.3.2 has taken the stage on 4568 for development with backup from WEBrick
[2012-04-10 18:05:45] INFO WEBrick::HTTPServer#start: pid=13966 port=4568
$ ruby api.rb -h
Usage: api [options]
-p port set the port (default is 4567)
-o addr set the host (default is 0.0.0.0)
-e env set the environment (default is development)
-s server specify rack server/handler (default is thin)
-x turn on the mutex lock (default is off)
conn = Mongo::Connection.new("localhost",27017)
conn = Mongo::Connection.new("localhost",27017, :slave_ok=>true)
conn = Mongo::ReplSetConnection.new(['10.20.30.40:27017','10.20.30.41:27017'], :read => :secondary)Secondaryが落ちてる場合は、Primaryに接続される。
conn.read_primary?
$ gem install sinatra-r18nロケールファイルの作成
Fetching: r18n-core-0.4.14.gem (100%)
Fetching: sinatra-r18n-0.4.14.gem (100%)
Successfully installed r18n-core-0.4.14
Successfully installed sinatra-r18n-0.4.14
2 gems installed
message:
error1: サーバーが停止しています
require 'sinatra/r18n'
…
t.message.error1
$ gem install sinatra
Fetching: rack-1.4.1.gem (100%)
Fetching: rack-protection-1.2.0.gem (100%)
Fetching: sinatra-1.3.2.gem (100%)
Successfully installed rack-1.4.1
Successfully installed rack-protection-1.2.0
Successfully installed sinatra-1.3.2
3 gems installed
Installing ri documentation for rack-1.4.1...
Installing ri documentation for rack-protection-1.2.0...
Installing ri documentation for sinatra-1.3.2...
Installing RDoc documentation for rack-1.4.1...
Installing RDoc documentation for rack-protection-1.2.0...
Installing RDoc documentation for sinatra-1.3.2...
# myapp.rb
require 'sinatra'
get '/' do
'Hello world!'
end
$ ruby -rubygems myapp.rb
[2012-04-02 16:37:45] INFO WEBrick 1.3.1
[2012-04-02 16:37:45] INFO ruby 1.9.2 (2011-07-09) [x86_64-linux]
== Sinatra/1.3.2 has taken the stage on 4567 for development with backup from WEBrick
[2012-04-02 16:37:45] INFO WEBrick::HTTPServer#start: pid=24126 port=4567
http://localhost:4567/
$ sudo vi /etc/mongodb.conf
## ReplicaSetsの名前をつける。のちの設定で使用。
==
replSet = log_rep
==
## 変更後サービスの再起動
$ sudo service mongodb restart
> rs.status()自分自身の定義
{
"startupStatus" : 3,
"info" : "run rs.initiate(...) if not yet done for the set",
"errmsg" : "can't get local.system.replset config from self or any seed (EMPTYCONFIG)",
"ok" : 0
}
> config = {_id: 'log_rep', members: [{_id: 0, host: '10.20.30.191:27017'}]} ★定義ファイルで指定した名前が_id部初期化
{
"_id" : "log_rep",
"members" : [
{
"_id" : 0,
"host" : "10.20.30.191:27017"
}
]
}
> rs.initiate(config)
{
"info" : "Config now saved locally. Should come online in about a minute.",
"ok" : 1
}
>
> rs.status()SECONDARYの定義追加
{
"set" : "log_rep",
"date" : ISODate("2012-03-23T09:49:38Z"),
"myState" : 1,
"members" : [
{
"_id" : 0,
"name" : "10.20.30.191:27017",
"health" : 1,
"state" : 1,
"stateStr" : "PRIMARY",
"optime" : {
"t" : 1332496142000,
"i" : 1
},
"optimeDate" : ISODate("2012-03-23T09:49:02Z"),
"self" : true
}
],
"ok" : 1
}
PRIMARY> rs.add("10.20.30.192")Secondaryのほうは何もしなくて良い
{ "ok" : 1 }
PRIMARY> rs.status()
{
"set" : "log_rep",
"date" : ISODate("2012-03-23T09:55:43Z"),
"myState" : 1,
"members" : [
{
"_id" : 0,
"name" : "10.20.30.191:27017",
"health" : 1,
"state" : 1,
"stateStr" : "PRIMARY",
"optime" : {
"t" : 1332496301000,
"i" : 1
},
"optimeDate" : ISODate("2012-03-23T09:51:41Z"),
"self" : true
},
{
"_id" : 1,
"name" : "10.20.30.192:27017",
"health" : 1,
"state" : 2,
"stateStr" : "SECONDARY", ★無事SECONDARYになった！
"uptime" : 242,
"optime" : {
"t" : 1332496301000,
"i" : 1
},
"optimeDate" : ISODate("2012-03-23T09:51:41Z"),
"lastHeartbeat" : ISODate("2012-03-23T09:55:41Z"),
"pingMs" : 0
}
],
"ok" : 1
}
SECONDARY> rs.status()Arbiterの設定
{
"set" : "log_rep",
"date" : ISODate("2012-03-23T10:01:54Z"),
"myState" : 2,
"syncingTo" : "10.20.30.191:27017",
"members" : [
{
"_id" : 0,
"name" : "10.20.30.191:27017",
"health" : 1,
"state" : 1,
"stateStr" : "PRIMARY",
"uptime" : 604,
"optime" : {
"t" : 1332496301000,
"i" : 1
},
"optimeDate" : ISODate("2012-03-23T09:51:41Z"),
"lastHeartbeat" : ISODate("2012-03-23T10:01:53Z"),
"pingMs" : 1
},
{
"_id" : 1,
"name" : "10.20.30.192:27017",
"health" : 1,
"state" : 2,
"stateStr" : "SECONDARY",
"optime" : {
"t" : 1332496301000,
"i" : 1
},
"optimeDate" : ISODate("2012-03-23T09:51:41Z"),
"self" : true
}
],
"ok" : 1
}
PRIMARY> rs.addArb("10.20.30.190:27017")
PRIMARY> rs.status()
{
"set" : "log_rep",
"date" : ISODate("2012-03-26T08:23:53Z"),
"myState" : 1,
"syncingTo" : "10.20.30.192:27017",
"members" : [
{
"_id" : 0,
"name" : "10.20.30.191:27017",
"health" : 1,
"state" : 1,
"stateStr" : "PRIMARY",
"optime" : {
"t" : 1332749742000,
"i" : 1
},
"optimeDate" : ISODate("2012-03-26T08:15:42Z"),
"self" : true
},
{
"_id" : 1,
"name" : "10.20.30.192:27017",
"health" : 1,
"state" : 2,
"stateStr" : "SECONDARY",
"uptime" : 514,
"optime" : {
"t" : 1332749742000,
"i" : 1
},
"optimeDate" : ISODate("2012-03-26T08:15:42Z"),
"lastHeartbeat" : ISODate("2012-03-26T08:23:53Z"),
"pingMs" : 1
},
{
"_id" : 2,
"name" : "10.20.30.190:27017",
"health" : 1,
"state" : 7,
"stateStr" : "ARBITER", ★ Arbiterが追加されたことを確認
"uptime" : 390,
"optime" : {
"t" : 0,
"i" : 0
},
"optimeDate" : ISODate("1970-01-01T00:00:00Z"),
"lastHeartbeat" : ISODate("2012-03-26T08:23:53Z"),
"pingMs" : 1
}
],
"ok" : 1
}
ARBITER>
$ mongo
MongoDB shell version: 2.0.3
connecting to: test
PRIMARY> exit
bye
$ sudo service mongodb stop ★ DB停止
* Stopping database mongodb
$ sudo apt-get install mongodb-10gen ★ update
… （省略）
mongodb-10gen (2.0.4) を設定しています ...
* Starting database mongodb ★ DB起動
$ mongo
MongoDB shell version: 2.0.4
connecting to: test
$ sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 7F0CEB10
Executing: gpg --ignore-time-conflict --no-options --no-default-keyring --secret-keyring /etc/apt/secring.gpg --trustdb-name /etc/apt/trustdb.gpg --keyring /etc/apt/trusted.gpg --primary-keyring /etc/apt/trusted.gpg --keyserver hkp://keyserver.ubuntu.com:80 --recv 7F0CEB10
gpg: 鍵7F0CEB10をhkpからサーバーkeyserver.ubuntu.comに要求
gpg: 鍵7F0CEB10: 公開鍵“Richard Kreuter <richard@10gen.com>”を読み込みました
gpg: 絶対的に信用する鍵が見つかりません
gpg: 処理数の合計: 1
gpg: 読込み: 1 (RSA: 1)
$ sudo vi /etc/apt/sources.listインストール
# 下記を追加
==
deb http://downloads-distro.mongodb.org/repo/debian-sysvinit dist 10gen
==
$ sudo apt-get update
$ sudo apt-get install mongodb-10gen
$ sudo service mongodb stop
他の場所に作る場合は、定義ファイルを変更する。
MongoDBの生成場所は、 /etc/mongodb.conf に記載されている。
#dbpath=/var/lib/mongodb ←DBの場所
#logpath=/var/log/mongodb/mongodb.log ←ログの場所
## サービスが書かれている場所
$ sudo vi /etc/init.d/mongodb
==
## 88-90行目あたりを変更する。
DAEMONUSER=${DAEMONUSER:-mongodb} # ログインユーザに変更してみる
DAEMON_OPTS=${DAEMON_OPTS:-"--dbpath $DATA --logpath $LOGFILE run"} # この行が呼ばれるからコメントアウト！
DAEMON_OPTS="$DAEMON_OPTS --config $CONF"
==
$ sudo service mongodb start
* Starting database mongodb
require 'mysql'
db = Mysql.connect("ホスト", "ログイン名", "パスワード", "DB名")
sql = "select login, firstname, lastname from users;"
rs = db.query(sql)
# 件数
puts rs.num_rows
# 結果の表示
rs.each do |row|
puts row[0] + " " + row[1] + " " + row[2]
end
db.close
> a = [1,4,2,5,7,3,6,8,9]文字列
=> [1, 4, 2, 5, 7, 3, 6, 8, 9]
> a.sort
=> [1, 2, 3, 4, 5, 6, 7, 8, 9]
> b = ["e","c","a","b","d"]
=> ["e", "c", "a", "b", "d"]
> b.sort
=> ["a", "b", "c", "d", "e"]
> c = [[2,"b"],[1,"a"],[3,"c"],[2,"a"]]多重ソート
=> [[2, "b"], [1, "a"], [3, "c"], [2, "a"]]
> c.sort_by{|item| item[0]}
=> [[1, "a"], [2, "b"], [2, "a"], [3, "c"]]
> c = [[2,"b"],[1,"a"],[3,"c"],[2,"a"]]c.sort でもできるけど、想定通りになるかは…？
=> [[2, "b"], [1, "a"], [3, "c"], [2, "a"]]
> c.sort_by{|item| [item[0],item[1]]}
=> [[1, "a"], [2, "a"], [2, "b"], [3, "c"]]
> c.sort
=> [[1, "a"], [2, "a"], [2, "b"], [3, "c"]]
> a.sort.reverse多重配列
=> [9, 8, 7, 6, 5, 4, 3, 2, 1]
> b.sort.reverse
=> ["e", "d", "c", "b", "a"]
> c.sort_by{|item| [-item[0], item[1]]}
=> [[3, "c"], [2, "a"], [2, "b"], [1, "a"]]
$ cd
$ vi .bash_profile
alias ll='ls -l'
alias la='ls -a'
export CLICOLOR=1
export LSCOLORS=DxGxcxdxCxegedabagacad
> x = [1,2,3,4,5,6,7,8,9]
=> [1, 2, 3, 4, 5, 6, 7, 8, 9]
> x[0] # 0番目
=> 1
> x[1] # 1番目
=> 2
> x[3..5] # 3-5番目
=> [4, 5, 6]
> x[3..-1] # 3番目から最後まで
=> [4, 5, 6, 7, 8, 9]
$ sudo adduser tester
ユーザ `tester' を追加しています...
新しいグループ `tester' (1001) を追加しています...
新しいユーザ `tester' (1001) をグループ `tester' に追加しています...
ホームディレクトリ `/home/tester' を作成しています...
`/etc/skel' からファイルをコピーしています...
新しいUNIXパスワードを入力してください:
新しいUNIX パスワードを再入力してください:
passwd: password updated successfully
Changing the user information for tester
Enter the new value, or press ENTER for the default
Full Name []:
Room Number []:
Work Phone []:
Home Phone []:
Other []:
Is the information correct? [Y/n] Y
$ useradd tester
$ rvm gemset list
gemsets for ruby-1.9.2-p290 (found in /home/tiffany/.rvm/gems/ruby-1.9.2-p290)
global
$ rvm gemset create test
'test' gemset created (/home/tiffany/.rvm/gems/ruby-1.9.2-p290@test).
$ rvm gemset list
gemsets for ruby-1.9.2-p290 (found in /home/tiffany/.rvm/gems/ruby-1.9.2-p290)
global
test
$ rvm gemset use test
$ rvm gemset list
gemsets for ruby-1.9.2-p290 (found in /home/tiffany/.rvm/gems/ruby-1.9.2-p290)
global
rails3
=> test
$ rvm gemset rename test test2
$ rvm gemset list
gemsets for ruby-1.9.2-p290 (found in /home/tiffany/.rvm/gems/ruby-1.9.2-p290)
global
test2
$ rvm gemset delete test2
WARN: Are you SURE you wish to remove the entire gemset directory 'test2' (/home/tiffany/.rvm/gems/ruby-1.9.2-p290@test2)?
(anything other than 'yes' will cancel) > yes
$ rvm gemset list
gemsets for ruby-1.9.2-p290 (found in /home/tiffany/.rvm/gems/ruby-1.9.2-p290)
global
$ rvm gem use 1.9.2いざ、実行してみると
$ rvm gemset use rails3
$ gem install mongo
Fetching: bson-1.5.2.gem (100%)
Fetching: mongo-1.5.2.gem (100%)
Successfully installed bson-1.5.2
Successfully installed mongo-1.5.2
2 gems installed
Installing ri documentation for bson-1.5.2...
Installing ri documentation for mongo-1.5.2...
Installing RDoc documentation for bson-1.5.2...
Installing RDoc documentation for mongo-1.5.2...
$ gem list --local
bson (1.5.2)
mongo (1.5.2)
require 'mongo'こんなエラー…。 gemが足りないようです。
db = Mongo::Connection.new.db("test")
$ ruby mongo_test.rb
**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.
$ gem install bson_ext
Fetching: bson_ext-1.5.2.gem (100%)
Building native extensions. This could take a while...
Successfully installed bson_ext-1.5.2
1 gem installed
Installing ri documentation for bson_ext-1.5.2...
Installing RDoc documentation for bson_ext-1.5.2...
$ gem list --local
bson (1.5.2)
bson_ext (1.5.2)
mongo (1.5.2)
$ wget http://fastdl.mongodb.org/linux/mongodb-linux-x86_64-2.0.2.tgzmongoコンソール画面からアクセス
$ tar -xvzf mongodb-linux-x86_64-2.0.2.tgz
$ mkdir ~/mongo_test
$ mv mongodb-linux-x86_64-2.0.2 mongodb
$ pwd
/home/tiffany/mongodb/bin
$ ./mongod --dbpath ~/mongo_test/
Tue Dec 27 14:58:02 [initandlisten] MongoDB starting : pid=382 port=27017 dbpath=/home/tiffany/mongo_test/ 64-bit host=redmine-rvm
Tue Dec 27 14:58:02 [initandlisten] db version v2.0.2, pdfile version 4.5
Tue Dec 27 14:58:02 [initandlisten] git version: 514b122d308928517f5841888ceaa4246a7f18e3
Tue Dec 27 14:58:02 [initandlisten] build info: Linux bs-linux64.10gen.cc 2.6.21.7-2.ec2.v1.2.fc8xen #1 SMP Fri Nov 20 17:48:28 EST 2009 x86_64 BOOST_LIB_VERSION=1_41
Tue Dec 27 14:58:02 [initandlisten] options: { dbpath: "/home/tiffany/mongo_test/" }
Tue Dec 27 14:58:02 [initandlisten] journal dir=/home/tiffany/mongo_test/journal
Tue Dec 27 14:58:02 [initandlisten] recover : no journal files present, no recovery needed
Tue Dec 27 14:58:04 [initandlisten] preallocateIsFaster=true 27.82
Tue Dec 27 14:58:05 [initandlisten] preallocateIsFaster=true 22.32
Tue Dec 27 14:58:08 [initandlisten] preallocateIsFaster=true 23.08
Tue Dec 27 14:58:08 [initandlisten] preallocateIsFaster check took 6.006 secs
Tue Dec 27 14:58:08 [initandlisten] preallocating a journal file /home/tiffany/mongo_test/journal/prealloc.0
115343360/1073741824 10%
136314880/1073741824 12%
(... 初回は長い）
1017118720/1073741824 94%
1059061760/1073741824 98%
Tue Dec 27 15:00:26 [initandlisten] preallocating a journal file /home/tiffany/mongo_test/journal/prealloc.1
62914560/1073741824 5%
94371840/1073741824 8%
(... 初回は長い）
996147200/1073741824 92%
1059061760/1073741824 98%
Tue Dec 27 15:02:20 [initandlisten] preallocating a journal file /home/tiffany/mongo_test/journal/prealloc.2
62914560/1073741824 5%
136314880/1073741824 12%
(... 初回は長い）
996147200/1073741824 92%
1038090240/1073741824 96%
Tue Dec 27 15:03:51 [websvr] admin web console waiting for connections on port 28017
Tue Dec 27 15:03:51 [initandlisten] waiting for connections on port 27017
Tue Dec 27 15:04:51 [clientcursormon] mem (MB) res:15 virt:100 mapped:0
~/mongodb/bin$ ./mongo
MongoDB shell version: 2.0.2
connecting to: test
> show dbs
local (empty)
> show collections
> db.users.save({name:"admin"})
> show dbs
local (empty)
test 0.203125GB
> show collections
system.indexes
users
> db.users.find()
{ "_id" : ObjectId("4f0be472f1c128e1d88d7fa7"), "name" : "admin" }
> show dbs
local 1.203125GB
test 0.203125GB
> use mydb
switched to db mydb
> show dbs
local 1.203125GB
test 0.203125GB
> show collections生成されました！
> show dbs
local 1.203125GB
mydb (empty)
test 0.203125GB
> show dbs削除されたことが確認できました。
local 1.203125GB
mydb (empty)
test 0.203125GB
> use mydb
switched to db mydb
> db.dropDatabase()
{ "dropped" : "mydb", "ok" : 1 }
> show dbs
local 1.203125GB
test 0.203125GB