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

海外就職 – オーストラリアでIT(Web)関係の就職活動その1 – 転職の流れ in 2013

Feb 28, 2013

AD:

今月から、本格的に転職活動をしているのですが、いろいろ学んだので、もし日本人でオーストラリアで就職活動をしている方の参考になればと思いまとめました。

ちなみに、今回でオーストラリアでは２度目の転職活動になります。

オーストラリアの就職活動について

会社の規模や文化によりますが、日本とすこし違って、大抵の会社がエージェント（日本でいうところのリクルート）を使ってスタッフを採用します。
流れ的には、こんな感じだと理解しています。

会社はエージェントに、希望のスタッフと条件を伝えます。
そのエージェントが、Seekなどの求人サイトに広告を出します。（こちらの有名どころの求人サイトは９割がエージェントだと思っております）
求人サイトなどから応募すると、エージェントから電話で連絡が入ります。（電話では職歴や、なぜ転職するのか、Visaは持っているのか、技術はどれくらい年数使用しているのかを聞いてきます。）
それでエージェントに気に入ってもらえると、今度はエージェントの会社に行ってエージェントが面接をします。（ここでも、質問は内容は電話とあまり変わりませんが、もう少し質問内容が細かくなります。）
大抵、エージェントまで面接にいくと、具体的な仕事のオファーの話をされます。（今、こんな案件があるけど、どう興味ある？的な感じです。これが実際に求人サイトから応募したものでないときは多々あります、つまり求人サイトの告知は転職、求職者を見つける餌のような役割を兼ねていることがあります）
その後、会社によりますが、技術テストがあります。（独自フレームワークを作ってとか）
その技術テストをエージェントに渡して、エージェントのクライアント（スタッフを探している会社）が気に入ればいよいよ面接です。
面接は会社によりますが、最低でも２回はあります。はじめは電話だけだったりします。
面接では、技術的な質問が多く、今までの経験なども聞かれます。最後には給料はどれくらい欲しいのか聞かれますので、低すぎ高過ぎない程度で答えます。
１回目のテストでは、面接の後にまた技術テストがあったりします。（１時間で、指定されたフレームワークを使ってギャラリーを作るなど）
２回目の面接では、大抵マネジャークラスの人と面接します、ここでも技術的な質問や、過去に何をやったなどの質問がされます。
上記をクリアーすると、ほぼ決まりですが、次はリファリー（推薦してくれる人？）が必要になってきます。
大抵、過去の働いた会社の上司や、現在働いている会社の同僚などにお願いします。転職先の会社が、リファリーに直接電話するか、文章を提出して、本当にこの人が問題ないか最終確認します。
ここまでのステップを全部終了すると、もうあとは社員の契約をまとめて、転職活動は終了です。

次のblogで実際の準備や、やり方などについてまとめたいと思います。

海外就職 – オーストラリアでIT(Web)関係の就職活動の続き

ZendFramework 1.12.* と Doctrine 2.3.*の連携

Feb 24, 2013

AD:

仕事でZendFramework1.*を使用することになったので、ORMにDoctrine2.3.*を使用してみました。
下記の記事は、ある程度ZendFrameworkを触ったことがある方が対象になると思います。

構築環境

composerを使ってやりたかったのですが、うまくいかなかったので、結局手動で、Fileをダウンロードして設定しました。

Ubuntu 12.04
PHP 5.3.10
memcache 2.2.7
ZendFramework 1.12.1
Doctrine 2.3.0

設定に入る前に

KDF Memoさんの記事を参考に導入しました。
おそらく、KDF Memoさんものより、Versionが上がっているので、File構成がだいぶ変わってきているので、地味に設定に時間がかかりました。

最終的に僕のFile構成はこうなりました。

設定

まず、必要なものをダウンロード
Doctrine ORMよりLatestをダウンロードして、./library/vendor/に入れる
zendframework1-doctrine2より、Bisnaをダウンロードして、./libraryに入れるbinフォルダをコピーして、./に移動

cacheの設定などは、KDF Memoさんの記事に詳しく書いてありますのでそちらを参照してください。

application.iniを書き換える

[production]

; --------------------------
; PHP Specific Configuration
; --------------------------
phpSettings.display_startup_errors = 0
phpSettings.display_errors = 0

includePaths.library = APPLICATION_PATH "/../library"


; ----------------------------------------
; Zend Framework Application Configuration
; ----------------------------------------
bootstrap.path = APPLICATION_PATH "/Bootstrap.php"
bootstrap.class = "Bootstrap"

pluginPaths.BisnaApplicationResource = "Bisna/Application/Resource"

autoloaderNamespaces[] = Bisna
autoloaderNamespaces[] = ApplicationEntity

appnamespace = "Application"


; ------------------------------
; Front Controller Configuration
; ------------------------------

resources.frontController.controllerDirectory = APPLICATION_PATH "/controllers"
resources.frontController.params.displayExceptions = 0


; ------------------------------------------------------------------------------
; Doctrine Class Loader Configuration
; ------------------------------------------------------------------------------

resources.doctrine.classLoader.loaderClass = "DoctrineCommonClassLoader"
resources.doctrine.classLoader.loaderFile  = APPLICATION_PATH "/../library/vendor/Doctrine/Doctrine/Common/ClassLoader.php"

resources.doctrine.classLoader.loaders.doctrine_common.namespace   = "DoctrineCommon"
resources.doctrine.classLoader.loaders.doctrine_common.includePath = APPLICATION_PATH "/../library/vendor/Doctrine"

resources.doctrine.classLoader.loaders.doctrine_dbal.namespace   = "DoctrineDBAL"
resources.doctrine.classLoader.loaders.doctrine_dbal.includePath = APPLICATION_PATH "/../library/vendor/Doctrine"

resources.doctrine.classLoader.loaders.doctrine_orm.namespace   = "DoctrineORM"
resources.doctrine.classLoader.loaders.doctrine_orm.includePath = APPLICATION_PATH "/../library/vendor/Doctrine"

resources.doctrine.classLoader.loaders.symfony_console.namespace   = "SymfonyComponentConsole"
resources.doctrine.classLoader.loaders.symfony_console.includePath = APPLICATION_PATH "/../library/vendor/Doctrine/Doctrine"

resources.doctrine.classLoader.loaders.symfony_yaml.namespace   = "SymfonyComponentYaml"
resources.doctrine.classLoader.loaders.symfony_yaml.includePath = APPLICATION_PATH "/../library/vendor/Doctrine/Doctrine"

; ------------------------------------------------------------------------------
; Doctrine Cache Configuration
; ------------------------------------------------------------------------------

; Points to default cache instance to be used. Optional is only one cache is defined
resources.doctrine.cache.defaultCacheInstance = default

; Cache Instance configuration for "default" cache
;resources.doctrine.cache.instances.default.id = default
resources.doctrine.cache.instances.default.adapterClass = "DoctrineCommonCacheMemcacheCache"
resources.doctrine.cache.instances.default.namespace    = "Application_"
resources.doctrine.cache.instances.default.options.servers.0.host = localhost
resources.doctrine.cache.instances.default.options.servers.0.port = 11211
;resources.doctrine.cache.instances.default.options.servers.0.persistent    = true
;resources.doctrine.cache.instances.default.options.servers.0.weight        = 1
;resources.doctrine.cache.instances.default.options.servers.0.timeout       = 1
;resources.doctrine.cache.instances.default.options.servers.0.retryInterval = 15
;resources.doctrine.cache.instances.default.options.servers.0.status        = true

; ------------------------------------------------------------------------------
; Doctrine DBAL Configuration
; ------------------------------------------------------------------------------

; Points to default connection to be used. Optional if only one connection is defined
resources.doctrine.dbal.defaultConnection = default

; DBAL Connection configuration for "default" connection
;resources.doctrine.dbal.connections.default.id = default
;resources.doctrine.dbal.connections.default.eventManagerClass  = "DoctrineCommonEventManager"
;resources.doctrine.dbal.connections.default.eventSubscribers[] = "DoctrineExtensionsSluggableSluggableSubscriber"
;resources.doctrine.dbal.connections.default.configurationClass = "DoctrineDBALConfiguration"
;resources.doctrine.dbal.connections.default.sqlLoggerClass     = "DoctrineDBALLoggingEchoSQLLogger"
;resources.doctrine.dbal.connections.default.types.my_type      = "ApplicationDBALTypeMyType"

; Database configuration
;resources.doctrine.dbal.connections.default.parameters.wrapperClass = ""
resources.doctrine.dbal.connections.default.parameters.driver   = "pdo_mysql"
resources.doctrine.dbal.connections.default.parameters.dbname   = "databasename"
resources.doctrine.dbal.connections.default.parameters.host = "localhost"
resources.doctrine.dbal.connections.default.parameters.port = 3306
resources.doctrine.dbal.connections.default.parameters.user = "root"
resources.doctrine.dbal.connections.default.parameters.password = "password"
;resources.doctrine.dbal.connections.default.parameters.driverOptions.ATTR_USE_BUFFERED_QUERIES = true


; ------------------------------------------------------------------------------
; Doctrine ORM Configuration
; ------------------------------------------------------------------------------

; Points to default EntityManager to be used. Optional if only one EntityManager is defined
resources.doctrine.orm.defaultEntityManager = default

; EntityManager configuration for "default" manager
;resources.doctrine.orm.entityManagers.default.id = default
;resources.doctrine.orm.entityManagers.default.entityManagerClass   = "DoctrineORMEntityManager"
;resources.doctrine.orm.entityManagers.default.configurationClass   = "DoctrineORMConfiguration"
;resources.doctrine.orm.entityManagers.default.defaultRepositoryClass   = "DoctrineORMEntityRepository"
;resources.doctrine.orm.entityManagers.default.entityNamespaces.app = "ApplicationEntity"
;resources.doctrine.orm.entityManagers.default.connection     = default
;resources.doctrine.orm.entityManagers.default.proxy.autoGenerateClasses = true
;resources.doctrine.orm.entityManagers.default.proxy.namespace           = "ApplicationEntityProxy"
;resources.doctrine.orm.entityManagers.default.proxy.dir                 = APPLICATION_PATH "/../library/Application/Entity/Proxy"
;resources.doctrine.orm.entityManagers.default.metadataCache = default
;resources.doctrine.orm.entityManagers.default.queryCache    = default
;resources.doctrine.orm.entityManagers.default.resultCache   = default
;resources.doctrine.orm.entityManagers.default.DQLFunctions.numeric.PI = "DoctrineExtensionsORMQueryFunctionsNumericPiFunction"
resources.doctrine.orm.entityManagers.default.metadataDrivers.annotationRegistry.annotationFiles[]     = APPLICATION_PATH "/../library/vendor/Doctrine/Doctrine/ORM/Mapping/Driver/DoctrineAnnotations.php"
;resources.doctrine.orm.entityManagers.default.metadataDrivers.annotationRegistry.annotationNamespaces.0.namespace   = "Gedmo"
;resources.doctrine.orm.entityManagers.default.metadataDrivers.annotationRegistry.annotationNamespaces.0.includePath = APPLICATION_PATH "/../library/vendor"
resources.doctrine.orm.entityManagers.default.metadataDrivers.drivers.0.adapterClass          = "DoctrineORMMappingDriverAnnotationDriver"
resources.doctrine.orm.entityManagers.default.metadataDrivers.drivers.0.mappingNamespace      = "ApplicationEntity"
resources.doctrine.orm.entityManagers.default.metadataDrivers.drivers.0.mappingDirs[]         = APPLICATION_PATH "/../library/Application/Entity"
resources.doctrine.orm.entityManagers.default.metadataDrivers.drivers.0.annotationReaderClass = "DoctrineCommonAnnotationsAnnotationReader"
resources.doctrine.orm.entityManagers.default.metadataDrivers.drivers.0.annotationReaderCache = default
;resources.doctrine.orm.entityManagers.default.metadataDrivers.drivers.0.annotationReaderNamespaces.App = "ApplicationDoctrineExtensionsORMMapping"

; DocumentManager configuration for "default" manager
resources.doctrine.odm.documentManagers.default.documentManagerClass 		= "DoctrineODMMongoDBDocumentManager"
resources.doctrine.odm.documentManagers.default.connectionString 			= "mongodb://localhost"
resources.doctrine.odm.documentManagers.default.type 						= "MongoDB"
resources.doctrine.odm.documentManagers.default.proxy.autoGenerateClasses 	= true
resources.doctrine.odm.documentManagers.default.proxy.namespace 			= "DocumentProxy"
resources.doctrine.odm.documentManagers.default.proxy.dir 					= APPLICATION_PATH "/data/doctrineDocumentProxies/Proxy"
resources.doctrine.odm.documentManagers.default.hydrator.dir 				= APPLICATION_PATH "/data/hydrator"
resources.doctrine.odm.documentManagers.default.hydrator.namespace 			= "Hydrators"
resources.doctrine.odm.documentManagers.default.metadataDrivers.annotationRegistry.annotationFiles[] = "Doctrine/ODM/MongoDB/Mapping/Annotations/DoctrineAnnotations.php"
resources.doctrine.odm.documentManagers.default.metadataDrivers.drivers.0.adapterClass 				 = "DoctrineODMMongoDBMappingDriverAnnotationDriver"
resources.doctrine.odm.documentManagers.default.metadataDrivers.drivers.0.mappingNamespace 			 = "ApplicationDocument"
resources.doctrine.odm.documentManagers.default.metadataDrivers.drivers.0.mappingDirs[] 			 = APPLICATION_PATH "/../library/Application/Entity"
resources.doctrine.odm.documentManagers.default.metadataDrivers.drivers.0.annotationReaderClass 	 = "DoctrineCommonAnnotationsAnnotationReader"
resources.doctrine.odm.documentManagers.default.metadataDrivers.drivers.0.annotationReaderCache 	 = "annotationCacheODM"

[staging : production]


[testing : production]
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1


[development : production]
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1
resources.frontController.params.displayExceptions = 1

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

[production]

; --------------------------

; PHP Specific Configuration

; --------------------------

phpSettings.display_startup_errors = 0

phpSettings.display_errors = 0

includePaths.library = APPLICATION_PATH "/../library"

; ----------------------------------------

; Zend Framework Application Configuration

; ----------------------------------------

bootstrap.path = APPLICATION_PATH "/Bootstrap.php"

bootstrap.class = "Bootstrap"

pluginPaths.BisnaApplicationResource = "Bisna/Application/Resource"

autoloaderNamespaces[] = Bisna

autoloaderNamespaces[] = ApplicationEntity

appnamespace = "Application"

; ------------------------------

; Front Controller Configuration

; ------------------------------

resources.frontController.controllerDirectory = APPLICATION_PATH "/controllers"

resources.frontController.params.displayExceptions = 0

; ------------------------------------------------------------------------------

; Doctrine Class Loader Configuration

; ------------------------------------------------------------------------------

resources.doctrine.classLoader.loaderClass = "DoctrineCommonClassLoader"

resources.doctrine.classLoader.loaderFile = APPLICATION_PATH "/../library/vendor/Doctrine/Doctrine/Common/ClassLoader.php"

resources.doctrine.classLoader.loaders.doctrine_common.namespace = "DoctrineCommon"

resources.doctrine.classLoader.loaders.doctrine_common.includePath = APPLICATION_PATH "/../library/vendor/Doctrine"

resources.doctrine.classLoader.loaders.doctrine_dbal.namespace = "DoctrineDBAL"

resources.doctrine.classLoader.loaders.doctrine_dbal.includePath = APPLICATION_PATH "/../library/vendor/Doctrine"

resources.doctrine.classLoader.loaders.doctrine_orm.namespace = "DoctrineORM"

resources.doctrine.classLoader.loaders.doctrine_orm.includePath = APPLICATION_PATH "/../library/vendor/Doctrine"

resources.doctrine.classLoader.loaders.symfony_console.namespace = "SymfonyComponentConsole"

resources.doctrine.classLoader.loaders.symfony_console.includePath = APPLICATION_PATH "/../library/vendor/Doctrine/Doctrine"

resources.doctrine.classLoader.loaders.symfony_yaml.namespace = "SymfonyComponentYaml"

resources.doctrine.classLoader.loaders.symfony_yaml.includePath = APPLICATION_PATH "/../library/vendor/Doctrine/Doctrine"

; ------------------------------------------------------------------------------

; Doctrine Cache Configuration

; ------------------------------------------------------------------------------

; Points to default cache instance to be used. Optional is only one cache is defined

resources.doctrine.cache.defaultCacheInstance = default

; Cache Instance configuration for "default" cache

;resources.doctrine.cache.instances.default.id = default

resources.doctrine.cache.instances.default.adapterClass = "DoctrineCommonCacheMemcacheCache"

resources.doctrine.cache.instances.default.namespace = "Application_"

resources.doctrine.cache.instances.default.options.servers.0.host = localhost

resources.doctrine.cache.instances.default.options.servers.0.port = 11211

;resources.doctrine.cache.instances.default.options.servers.0.persistent = true

;resources.doctrine.cache.instances.default.options.servers.0.weight = 1

;resources.doctrine.cache.instances.default.options.servers.0.timeout = 1

;resources.doctrine.cache.instances.default.options.servers.0.retryInterval = 15

;resources.doctrine.cache.instances.default.options.servers.0.status = true

; ------------------------------------------------------------------------------

; Doctrine DBAL Configuration

; ------------------------------------------------------------------------------

; Points to default connection to be used. Optional if only one connection is defined

resources.doctrine.dbal.defaultConnection = default

; DBAL Connection configuration for "default" connection

;resources.doctrine.dbal.connections.default.id = default

;resources.doctrine.dbal.connections.default.eventManagerClass = "DoctrineCommonEventManager"

;resources.doctrine.dbal.connections.default.eventSubscribers[] = "DoctrineExtensionsSluggableSluggableSubscriber"

;resources.doctrine.dbal.connections.default.configurationClass = "DoctrineDBALConfiguration"

;resources.doctrine.dbal.connections.default.sqlLoggerClass = "DoctrineDBALLoggingEchoSQLLogger"

;resources.doctrine.dbal.connections.default.types.my_type = "ApplicationDBALTypeMyType"

; Database configuration

;resources.doctrine.dbal.connections.default.parameters.wrapperClass = ""

resources.doctrine.dbal.connections.default.parameters.driver = "pdo_mysql"

resources.doctrine.dbal.connections.default.parameters.dbname = "databasename"

resources.doctrine.dbal.connections.default.parameters.host = "localhost"

resources.doctrine.dbal.connections.default.parameters.port = 3306

resources.doctrine.dbal.connections.default.parameters.user = "root"

resources.doctrine.dbal.connections.default.parameters.password = "password"

;resources.doctrine.dbal.connections.default.parameters.driverOptions.ATTR_USE_BUFFERED_QUERIES = true

; ------------------------------------------------------------------------------

; Doctrine ORM Configuration

; ------------------------------------------------------------------------------

; Points to default EntityManager to be used. Optional if only one EntityManager is defined

resources.doctrine.orm.defaultEntityManager = default

; EntityManager configuration for "default" manager

;resources.doctrine.orm.entityManagers.default.id = default

;resources.doctrine.orm.entityManagers.default.entityManagerClass = "DoctrineORMEntityManager"

;resources.doctrine.orm.entityManagers.default.configurationClass = "DoctrineORMConfiguration"

;resources.doctrine.orm.entityManagers.default.defaultRepositoryClass = "DoctrineORMEntityRepository"

;resources.doctrine.orm.entityManagers.default.entityNamespaces.app = "ApplicationEntity"

;resources.doctrine.orm.entityManagers.default.connection = default

;resources.doctrine.orm.entityManagers.default.proxy.autoGenerateClasses = true

;resources.doctrine.orm.entityManagers.default.proxy.namespace = "ApplicationEntityProxy"

;resources.doctrine.orm.entityManagers.default.proxy.dir = APPLICATION_PATH "/../library/Application/Entity/Proxy"

;resources.doctrine.orm.entityManagers.default.metadataCache = default

;resources.doctrine.orm.entityManagers.default.queryCache = default

;resources.doctrine.orm.entityManagers.default.resultCache = default

;resources.doctrine.orm.entityManagers.default.DQLFunctions.numeric.PI = "DoctrineExtensionsORMQueryFunctionsNumericPiFunction"

resources.doctrine.orm.entityManagers.default.metadataDrivers.annotationRegistry.annotationFiles[] = APPLICATION_PATH "/../library/vendor/Doctrine/Doctrine/ORM/Mapping/Driver/DoctrineAnnotations.php"

;resources.doctrine.orm.entityManagers.default.metadataDrivers.annotationRegistry.annotationNamespaces.0.namespace = "Gedmo"

;resources.doctrine.orm.entityManagers.default.metadataDrivers.annotationRegistry.annotationNamespaces.0.includePath = APPLICATION_PATH "/../library/vendor"

resources.doctrine.orm.entityManagers.default.metadataDrivers.drivers.0.adapterClass = "DoctrineORMMappingDriverAnnotationDriver"

resources.doctrine.orm.entityManagers.default.metadataDrivers.drivers.0.mappingNamespace = "ApplicationEntity"

resources.doctrine.orm.entityManagers.default.metadataDrivers.drivers.0.mappingDirs[] = APPLICATION_PATH "/../library/Application/Entity"

resources.doctrine.orm.entityManagers.default.metadataDrivers.drivers.0.annotationReaderClass = "DoctrineCommonAnnotationsAnnotationReader"

resources.doctrine.orm.entityManagers.default.metadataDrivers.drivers.0.annotationReaderCache = default

;resources.doctrine.orm.entityManagers.default.metadataDrivers.drivers.0.annotationReaderNamespaces.App = "ApplicationDoctrineExtensionsORMMapping"

; DocumentManager configuration for "default" manager

resources.doctrine.odm.documentManagers.default.documentManagerClass = "DoctrineODMMongoDBDocumentManager"

resources.doctrine.odm.documentManagers.default.connectionString = "mongodb://localhost"

resources.doctrine.odm.documentManagers.default.type = "MongoDB"

resources.doctrine.odm.documentManagers.default.proxy.autoGenerateClasses = true

resources.doctrine.odm.documentManagers.default.proxy.namespace = "DocumentProxy"

resources.doctrine.odm.documentManagers.default.proxy.dir = APPLICATION_PATH "/data/doctrineDocumentProxies/Proxy"

resources.doctrine.odm.documentManagers.default.hydrator.dir = APPLICATION_PATH "/data/hydrator"

resources.doctrine.odm.documentManagers.default.hydrator.namespace = "Hydrators"

resources.doctrine.odm.documentManagers.default.metadataDrivers.annotationRegistry.annotationFiles[] = "Doctrine/ODM/MongoDB/Mapping/Annotations/DoctrineAnnotations.php"

resources.doctrine.odm.documentManagers.default.metadataDrivers.drivers.0.adapterClass = "DoctrineODMMongoDBMappingDriverAnnotationDriver"

resources.doctrine.odm.documentManagers.default.metadataDrivers.drivers.0.mappingNamespace = "ApplicationDocument"

resources.doctrine.odm.documentManagers.default.metadataDrivers.drivers.0.mappingDirs[] = APPLICATION_PATH "/../library/Application/Entity"

resources.doctrine.odm.documentManagers.default.metadataDrivers.drivers.0.annotationReaderClass = "DoctrineCommonAnnotationsAnnotationReader"

resources.doctrine.odm.documentManagers.default.metadataDrivers.drivers.0.annotationReaderCache = "annotationCacheODM"

[staging : production]

[testing : production]

phpSettings.display_startup_errors = 1

phpSettings.display_errors = 1

[development : production]

phpSettings.display_startup_errors = 1

phpSettings.display_errors = 1

resources.frontController.params.displayExceptions = 1

doctrineの動作確認

$ php bin/doctrine.php
Doctrine Command Line Interface version 2.3.0

Usage:
  [options] command [arguments]

Options:
  --help           -h Display this help message.
  --quiet          -q Do not output any message.
  --verbose        -v Increase verbosity of messages.
  --version        -V Display this application version.
  --ansi              Force ANSI output.
  --no-ansi           Disable ANSI output.
  --no-interaction -n Do not ask any interactive question.

$ php bin/doctrine.php

Doctrine Command Line Interface version 2.3.0

Usage:

[options] command [arguments]

Options:

--help -h Display this help message.

--quiet -q Do not output any message.

--verbose -v Increase verbosity of messages.

--version -V Display this application version.

--ansi Force ANSI output.

--no-ansi Disable ANSI output.

--no-interaction -n Do not ask any interactive question.

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>

$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>

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

$ 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

その他

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

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

$ 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

$ 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 }

$ 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 }

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

Feb 22, 2013

AD:

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

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

$ gem install less

$ less --version

less 444

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>

$ 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

$ af tunnel

1: database_name

Which service to tunnel to?: 1

Getting tunnel connection info: OK

Done

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>

$ 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

$ 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"

$ 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

$ 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')"

$ 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.

海外就職 – オーストラリアでIT(Web)関係の就職活動その1 – 転職の流れ in 2013

オーストラリアの就職活動について

海外就職 – オーストラリアでIT(Web)関係の就職活動の続き

ZendFramework 1.12.* と Doctrine 2.3.*の連携

構築環境

設定に入る前に

設定

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

Search Keyword

Meta

FacebookPage

Popular Posts

My Tags

Status

Links

ARCHIVES