シドニーで働くプログラマーのBlog(今はIT会社の経営者)

MongoDBコマンド＆検索クエリ

Feb 23, 2013

AD:

最近、仕事でMongoDBを使う機会があったので、MongoDBコマンド＆検索関係をまとめたいと思います。

検索クエリ

現時点で僕の理解しきれている範囲だとクエリの特徴は下記のような特徴があるようです。
– メソッドの引数にJSON形式のデータを渡す
– 変数が使える
– 制御構造が使える
– カーソルが使える

条件演算子

MongoDBは、JavascriptのエンジンであるSpiderMonkeyを拡張した、Javascriptシェル？です。
なので、JavaScriptの記述でデータのが取得が可能です。

$gt
greater than (i.e. &gt;)
$gte
greater than or equal (i.e. =&gt;)
$in 
field value equals any value in the specified array (e.g. <value1>, <value2>)
$lt
less than (i.e. 

&#12371;&#12385;&#12425;&#12398;<a href="http://gihyo.jp/dev/serial/01/mongodb/0003" targer="_blank">&#12506;&#12540;&#12472;</a>&#12289;<a href="http://docs.mongodb.org/manual/reference/operators/#AdvancedQueries-ConditionalOperators" targer="_blank">&#12506;&#12540;&#12472;</a>&#12434;&#21442;&#32771;&#12395;&#12375;&#12414;&#12375;&#12383;&#12290;

<h3>mongo &#12467;&#12510;&#12531;&#12489;</h3>
mongo&#12398;&#12467;&#12510;&#12531;&#12489;&#12398;&#12504;&#12523;&#12503;&#12398;&#19968;&#35239;&#12391;&#12377;&#12290;
<pre> mongo&#12288;
&gt; help
db.help()                    help on db methods
db.mycoll.help()             help on collection methods
sh.help()                    sharding helpers
rs.help()                    replica set helpers
help admin                   administrative help
help connect                 connecting to a db help
help keys                    key shortcuts
help misc                    misc things to know
help mr                      mapreduce
show dbs                     show database names
show collections             show collections in current database
show users                   show users in current database
show profile                 show most recent system.profile entries with time &gt;= 1ms
show logs                    show the accessible logger names
show log [name]              prints out the last segment of log in memory, 'global' is default
use <db_name>                set current database
db.foo.find()                list objects in collection foo
db.foo.find( { a : 1 } )     list objects in foo where a == 1
it                           result of the last line evaluated; use to further iterate
DBQuery.shellBatchSize = x   set default number of items to display on shell
exit                         quit the mongo shell
</db_name>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

$gt

greater than (i.e. >)

$gte

greater than or equal (i.e. =>)

$in

field value equals any value in the specified array (e.g. <value1>, <value2>)

$lt

less than (i.e.

こちらの<a href="http://gihyo.jp/dev/serial/01/mongodb/0003" targer="_blank">ページ</a>、<a href="http://docs.mongodb.org/manual/reference/operators/#AdvancedQueries-ConditionalOperators" targer="_blank">ページ</a>を参考にしました。

<h3>mongo コマンド</h3>

mongoのコマンドのヘルプの一覧です。

<pre> mongo　

> help

db.help() help on db methods

db.mycoll.help() help on collection methods

sh.help() sharding helpers

rs.help() replica set helpers

help admin administrative help

help connect connecting to a db help

help keys key shortcuts

help misc misc things to know

help mr mapreduce

show dbs show database names

show collections show collections in current database

show users show users in current database

show profile show most recent system.profile entries with time >= 1ms

show logs show the accessible logger names

show log [name] prints out the last segment of log in memory, 'global' is default

use <db_name> set current database

db.foo.find() list objects in collection foo

db.foo.find( { a : 1 } ) list objects in foo where a == 1

it result of the last line evaluated; use to further iterate

DBQuery.shellBatchSize = x set default number of items to display on shell

exit quit the mongo shell

</db_name>

Twitter:
Warning: Undefined array key "Twitter" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Facebook: 0 | Google Plus:
Warning: Undefined array key "Google+" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Hatena: 0 | Pocket: 1 | Total: 1 | Feedly: 0

MongoDBの状況確認

Feb 23, 2013

AD:

ブラウザから確認

MongoDBをインストールした場合は、下記のURLにアクセスすると、MongoDBの状況が確認できるようです。
http://localhost:28017

ちなみに、上記の機能は–norestオプションで無効化できるらしいです。

コマンドから確認

ちなみに、コマンドでMongoの状況確認は下記の要します。

$ mongostat
connected to: 127.0.0.1
insert  query update delete getmore command flushes mapped  vsize    res faults  locked db idx miss %     qr|qw   ar|aw  netIn netOut  conn       time 
     0      0      0      0       0       1       0     0m   102m    23m      0 local:0.0%          0       0|0     0|0    62b     1k     1   05:26:35 
     0      0      0      0       0       1       0     0m   102m    23m      0 local:0.0%          0       0|0     0|0    62b     1k     1   05:26:36

1

2

3

4

5

$ mongostat

connected to: 127.0.0.1

insert query update delete getmore command flushes mapped vsize res faults locked db idx miss % qr|qw ar|aw netIn netOut conn time

0 0 0 0 0 1 0 0m 102m 23m 0 local:0.0% 0 0|0 0|0 62b 1k 1 05:26:35

0 0 0 0 0 1 0 0m 102m 23m 0 local:0.0% 0 0|0 0|0 62b 1k 1 05:26:36

その他

他にもいろいろな管理ツールがあるようです。

Twitter:
Warning: Undefined array key "Twitter" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Facebook: 0 | Google Plus:
Warning: Undefined array key "Google+" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Hatena: 0 | Pocket: 0 | Total: 0 | Feedly: 0

Ubuntu12.04にMongoDBをインストール

Feb 23, 2013

AD:

このページを参考にUbuntuにMongoDBを入れようと思ったらうまくいかなかったのでメモしておきます。
やっていることは、GnuPGへキーを登録して、MongoDB用のパッケージ管理システムを登録して、インストールの流れです。

$ sudo apt-key adv --keyserver keyserver.ubuntu.com --recv 7F0CEB10
$ sudo sh -c 'echo "deb http://downloads-distro.mongodb.org/repo/ubuntu-upstart dist 10gen" | tee -a /etc/apt/sources.list.d/10gen.list'
deb http://downloads-distro.mongodb.org/repo/ubuntu-upstart dist 10gen
$ sudo apt-get -y update
$ sudo apt-get -y install mongodb-10gen

1

2

3

4

5

$ sudo apt-key adv --keyserver keyserver.ubuntu.com --recv 7F0CEB10

$ sudo sh -c 'echo "deb http://downloads-distro.mongodb.org/repo/ubuntu-upstart dist 10gen" | tee -a /etc/apt/sources.list.d/10gen.list'

deb http://downloads-distro.mongodb.org/repo/ubuntu-upstart dist 10gen

$ sudo apt-get -y update

$ sudo apt-get -y install mongodb-10gen

操作関係

$ sudo service mongodb start
mongodb start/running, process 19200

$ sudo service mongodb stop
mongodb stop/waiting

$ sudo service mongodb restart
mongodb stop/waiting
mongodb start/running, process 19224

1

2

3

4

5

6

7

8

9

$ sudo service mongodb start

mongodb start/running, process 19200

$ sudo service mongodb stop

mongodb stop/waiting

$ sudo service mongodb restart

mongodb stop/waiting

mongodb start/running, process 19224

データの登録、検索

MongoDBは、JavascriptのエンジンであるSpiderMonkeyを拡張した、Javascriptシェル？です。
なんで、JavaScriptの記述でデータのが取得が可能です。

$ mongo
MongoDB shell version: 2.2.3
connecting to: test
&gt; show dbs
local	(empty)
test	(empty)
&gt; use test
switched to db test
&gt; db.test.save( { a: 1 } )
&gt; db.test.find()
{ "_id" : ObjectId("51285b019fc2311ea475b159"), "a" : 1 }

1

2

3

4

5

6

7

8

9

10

11

$ mongo

MongoDB shell version: 2.2.3

connecting to: test

> show dbs

local (empty)

test (empty)

> use test

switched to db test

> db.test.save( { a: 1 } )

> db.test.find()

{ "_id" : ObjectId("51285b019fc2311ea475b159"), "a" : 1 }

Twitter:
Warning: Undefined array key "Twitter" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Facebook: 0 | Google Plus:
Warning: Undefined array key "Google+" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Hatena: 0 | Pocket: 0 | Total: 0 | Feedly: 0

Ubuntu(12.04) にlessをインストール

Feb 22, 2013

AD:

過去のサイトで、Lessを使用しているものがあったので、lessをインストール

$ gem install less
$ less --version
less 444
Copyright (C) 1984-2009 Mark Nudelman

1

2

3

4

$ gem install less

$ less --version

less 444

Twitter:
Warning: Undefined array key "Twitter" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Facebook: 0 | Google Plus:
Warning: Undefined array key "Google+" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Hatena: 0 | Pocket: 0 | Total: 0 | Feedly: 0

AppFog tunnel Error 600: Not enough memory capacity, you’re allowed: 2048

Feb 13, 2013

AD:

In AppFog, when you connect Database you will use tunnel but I could not access today.

$ af tunnel
1: database_name
Which service to tunnel to?: 1
Deploying tunnel application 'caldecott-ap-aws'.
<span style="color:red;">Error 600: Not enough memory capacity, you're allowed: 2048</span>

1

2

3

4

5

$ af tunnel

1: database_name

Which service to tunnel to?: 1

Deploying tunnel application 'caldecott-ap-aws'.

<span style="color:red;">Error 600: Not enough memory capacity, you're allowed: 2048</span>

So I searched why and then I found out the problem.

How I fix

When using af tunnel, it uses 64MB that why error was “Not enough memory capacity“.
I just went to Console Page in AppFog and then reduced memory from one of App.

$ af tunnel
1: database_name
Which service to tunnel to?: 1
Getting tunnel connection info: OK

1

2

3

4

$ af tunnel

1: database_name

Which service to tunnel to?: 1

Getting tunnel connection info: OK

Done

Twitter:
Warning: Undefined array key "Twitter" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Facebook: 0 | Google Plus:
Warning: Undefined array key "Google+" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Hatena: 0 | Pocket: 0 | Total: 0 | Feedly: 0

Ruby 1.9.3 rails console error by “completion.rb:9:in `require'”

Feb 7, 2013

AD:

I set up Rails Env with ruby 1.9.3p374 & Rails 3.2.11
I tried to use consolce and I got this massage…

Error

$ rails c
/home/vagrant/.rbenv/versions/1.9.3-p374/lib/ruby/1.9.1/irb/completion.rb:9:in `require': cannot load such file -- readline (LoadError)
	from /home/vagrant/.rbenv/versions/1.9.3-p374/lib/ruby/1.9.1/irb/completion.rb:9:in `<top>'
	from /home/vagrant/.rbenv/versions/1.9.3-p374/lib/ruby/gems/1.9.1/gems/railties-3.2.11/lib/rails/commands/console.rb:3:in `require'
	from /home/vagrant/.rbenv/versions/1.9.3-p374/lib/ruby/gems/1.9.1/gems/railties-3.2.11/lib/rails/commands/console.rb:3:in `<top>'
	from /home/vagrant/.rbenv/versions/1.9.3-p374/lib/ruby/gems/1.9.1/gems/railties-3.2.11/lib/rails/commands.rb:38:in `require'
	from /home/vagrant/.rbenv/versions/1.9.3-p374/lib/ruby/gems/1.9.1/gems/railties-3.2.11/lib/rails/commands.rb:38:in `<top>'
	from script/rails:6:in `require'
	from script/rails:6:in `<main>'
</main></top></top></top>

1

2

3

4

5

6

7

8

9

10

$ rails c

/home/vagrant/.rbenv/versions/1.9.3-p374/lib/ruby/1.9.1/irb/completion.rb:9:in `require': cannot load such file -- readline (LoadError)

from /home/vagrant/.rbenv/versions/1.9.3-p374/lib/ruby/1.9.1/irb/completion.rb:9:in `<top>'

from /home/vagrant/.rbenv/versions/1.9.3-p374/lib/ruby/gems/1.9.1/gems/railties-3.2.11/lib/rails/commands/console.rb:3:in `require'

from /home/vagrant/.rbenv/versions/1.9.3-p374/lib/ruby/gems/1.9.1/gems/railties-3.2.11/lib/rails/commands/console.rb:3:in `<top>'

from /home/vagrant/.rbenv/versions/1.9.3-p374/lib/ruby/gems/1.9.1/gems/railties-3.2.11/lib/rails/commands.rb:38:in `require'

from /home/vagrant/.rbenv/versions/1.9.3-p374/lib/ruby/gems/1.9.1/gems/railties-3.2.11/lib/rails/commands.rb:38:in `<top>'

from script/rails:6:in `require'

from script/rails:6:in `<main>'

</main></top></top></top>

Add re-readline

$ vi Gemfile
gem 'rb-readline'
$ bundle install

1

2

3

$ vi Gemfile

gem 'rb-readline'

$ bundle install

Done

Railsでサイト名などを設定する場合

Feb 6, 2013

AD:

設定方法

$ vi config/application.rb
module YourAppName
  class Application 

<h3>&#29872;&#22659;&#12372;&#12392;&#12395;&#22793;&#26356;&#12375;&#12383;&#12356;&#22580;&#21512;</h3>
<pre> vi config/environments/development.rb
config.site_name = "&#12469;&#12452;&#12488;&#21517;"
config.site_url = "localhost:3000"

1

2

3

4

5

6

7

8

$ vi config/application.rb

module YourAppName

class Application

<h3>環境ごとに変更したい場合</h3>

<pre> vi config/environments/development.rb

config.site_name = "サイト名"

config.site_url = "localhost:3000"

参照方法

&lt;h1&gt;&lt;/h1&gt;
@url = YourAppName::Application.config.site_url

1 2	<h1></h1> @url = YourAppName::Application.config.site_url

Done

Country Code for Rails with Migration

Feb 6, 2013

AD:

I want to setup contry code for my Rails app so I searched by google there are some Gem but I just want to make Tables & Model.
I used data from here

Make migratiton file

$ rails g model country name:string alpha_2:string alpha_3:string
invoke  active_record
create    db/migrate/20130206044924_create_countries.rb
create    app/models/country.rb
invoke    rspec
create      spec/models/country_spec.rb

1

2

3

4

5

6

$ rails g model country name:string alpha_2:string alpha_3:string

invoke active_record

create db/migrate/20130206044924_create_countries.rb

create app/models/country.rb

invoke rspec

create spec/models/country_spec.rb

Add SQL from here

$ vi db/migrate/20130206044924_create_countries.rb
#add data from http://stefangabos.ro/other-projects/list-of-world-countries-with-national-flags/
execute "
INSERT INTO `countries` (`name`, `alpha_2`, `alpha_3`) VALUES
('Afghanistan', 'af', 'afg'),
('Aland Islands', 'ax', 'ala'),
('Albania', 'al', 'alb'),
more...
('Zimbabwe', 'zw', 'zwe')"

1

2

3

4

5

6

7

8

9

$ vi db/migrate/20130206044924_create_countries.rb

#add data from http://stefangabos.ro/other-projects/list-of-world-countries-with-national-flags/

execute "

INSERT INTO `countries` (`name`, `alpha_2`, `alpha_3`) VALUES

('Afghanistan', 'af', 'afg'),

('Aland Islands', 'ax', 'ala'),

('Albania', 'al', 'alb'),

more...

('Zimbabwe', 'zw', 'zwe')"

and then

$ rake db:migrate

1	$ rake db:migrate

Done.

Twitter:
Warning: Undefined array key "Twitter" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Facebook: 0 | Google Plus:
Warning: Undefined array key "Google+" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Hatena: 0 | Pocket: 0 | Total: 0 | Feedly: 0

Appfog /tmp folder

Jan 29, 2013

AD:

Thanks Appfog /tmp folder

$_SERVER['DOCUMENT_ROOT'].'/../tmp'

1	$_SERVER['DOCUMENT_ROOT'].'/../tmp'

My wp-config.php for WordPress

/** Setup for AppFog **/
$services = getenv("VCAP_SERVICES");
if($services !== false){
$services_json = json_decode($services,true);
$mysql_config = $services_json["mysql-5.1"][0]["credentials"];
define('DB_NAME', $mysql_config["name"]);
define('DB_USER', $mysql_config["user"]);
define('DB_PASSWORD', $mysql_config["password"]);
define('DB_HOST', $mysql_config["hostname"]);
define('DB_PORT', $mysql_config["port"]);
define('TMP_FOLDER', realpath($_SERVER['DOCUMENT_ROOT'].'/../tmp'));
#local setting
}else{
define('DB_NAME', 'DatabaseName');
define('DB_USER', 'UserName');
define('DB_PASSWORD', 'Password!');
define('DB_HOST', 'localhost');
define('TMP_FOLDER', '/tmp');
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

/** Setup for AppFog **/

$services = getenv("VCAP_SERVICES");

if($services !== false){

$services_json = json_decode($services,true);

$mysql_config = $services_json["mysql-5.1"][0]["credentials"];

define('DB_NAME', $mysql_config["name"]);

define('DB_USER', $mysql_config["user"]);

define('DB_PASSWORD', $mysql_config["password"]);

define('DB_HOST', $mysql_config["hostname"]);

define('DB_PORT', $mysql_config["port"]);

define('TMP_FOLDER', realpath($_SERVER['DOCUMENT_ROOT'].'/../tmp'));

#local setting

}else{

define('DB_NAME', 'DatabaseName');

define('DB_USER', 'UserName');

define('DB_PASSWORD', 'Password!');

define('DB_HOST', 'localhost');

define('TMP_FOLDER', '/tmp');

}

Twitter:
Warning: Undefined array key "Twitter" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Facebook: 0 | Google Plus:
Warning: Undefined array key "Google+" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Hatena: 0 | Pocket: 0 | Total: 0 | Feedly: 0

Vagrant in Ubuntu(12.04) Desktop

Jan 23, 2013

AD:

Set up ruby first

Before install Vagrant needs set up ruby. I use rbenv for setting Ruby environment

$ sudo apt-get update
$ sudo apt-get install build-essential zlib1g-dev curl git-core sqlite3 libsqlite3-dev

$ git clone git://github.com/sstephenson/rbenv.git ~/.rbenv
$ echo 'export PATH="$HOME/.rbenv/bin:$PATH"' &gt;&gt; ~/.bash_profile
$ echo 'eval "$(rbenv init -)"' &gt;&gt; ~/.bash_profile
$ source .bash_profile
$ git clone git://github.com/sstephenson/ruby-build.git
$ cd ~/ruby-build/gr
$ sudo ./install.sh 
$ rbenv install 1.9.3-p374
$ rbenv global 1.9.3-p374
$ gem install bundler
$ rbenv rehash
$ ruby -v
ruby 1.9.3p374 (2013-01-15 revision 38858) [x86_64-linux]

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

$ sudo apt-get update

$ sudo apt-get install build-essential zlib1g-dev curl git-core sqlite3 libsqlite3-dev

$ git clone git://github.com/sstephenson/rbenv.git ~/.rbenv

$ echo 'export PATH="$HOME/.rbenv/bin:$PATH"' >> ~/.bash_profile

$ echo 'eval "$(rbenv init -)"' >> ~/.bash_profile

$ source .bash_profile

$ git clone git://github.com/sstephenson/ruby-build.git

$ cd ~/ruby-build/gr

$ sudo ./install.sh

$ rbenv install 1.9.3-p374

$ rbenv global 1.9.3-p374

$ gem install bundler

$ rbenv rehash

$ ruby -v

ruby 1.9.3p374 (2013-01-15 revision 38858) [x86_64-linux]

Install Vagrant

$ apt-get install virtualbox-ose
$ apt-get install rubygems
$ gem install vagrant
$ vagrant box add ubuntu12.10.64 https://s3-sa-east-1.amazonaws.com/willian-boxes/Ubuntu-Server-12.10-amd64-Minimal.box
$ vagrant up ubuntu12.10.64

1

2

3

4

5

$ apt-get install virtualbox-ose

$ apt-get install rubygems

$ gem install vagrant

$ vagrant box add ubuntu12.10.64 https://s3-sa-east-1.amazonaws.com/willian-boxes/Ubuntu-Server-12.10-amd64-Minimal.box

$ vagrant up ubuntu12.10.64

Twitter:
Warning: Undefined array key "Twitter" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Facebook: 0 | Google Plus:
Warning: Undefined array key "Google+" in /home/sazaeau/mizoshiri.com/public_html/blog.mizoshiri.com/wp-content/plugins/sns-count-cache/sns-count-cache.php on line 2897
0 | Hatena: 1 | Pocket: 0 | Total: 1 | Feedly: 0

MongoDBコマンド＆検索クエリ

検索クエリ

条件演算子

MongoDBの状況確認

ブラウザから確認

コマンドから確認

その他

Ubuntu12.04にMongoDBをインストール

操作関係

データの登録、検索

Ubuntu(12.04) にlessをインストール

AppFog tunnel Error 600: Not enough memory capacity, you’re allowed: 2048

How I fix

Ruby 1.9.3 rails console error by “completion.rb:9:in `require'”

Error

Add re-readline

Railsでサイト名などを設定する場合

設定方法

参照方法

Country Code for Rails with Migration

Make migratiton file

Add SQL from here

Appfog /tmp folder

My wp-config.php for WordPress

Vagrant in Ubuntu(12.04) Desktop

Set up ruby first

Install Vagrant

Search Keyword

Meta

FacebookPage

Popular Posts

My Tags

Status

Links

ARCHIVES