gem install sinatra --no-ri --no-rdoc -V
require 'sinatra'
get '/hoge' do
http_headers = request.env.select { |k, v| k.start_with?('HTTP_') }
p "#{http_headers}"
ruby -rubygems ./echo.rb -o 127.0.0.1 -p 10000 &
http://127.0.0.1:10000/hogeにGETでアクセス
sudo port install php53 apache2
sudo port install php53-apache2handler
cd /opt/local/apache2/modules
sudo /opt/local/apache2/bin/apxs -a -e -n php5 mod_php53.so
#phpのtypeを追加
AddType application/x-httpd-php .php
Include conf/extra/httpd-vhosts.conf
Include conf/extra/mod_php53.conf
DirectoryIndex index.html index.php
<VirtualHost *:80>
DocumentRoot "/opt/local/apache2/htdocs"
ServerName localhost
</VirtualHost>
sudo ln /opt/local/bin/php53 /opt/local/bin/php
sudo cp /opt/local/etc/php53/php.ini-development /opt/local/etc/php53/php.ini
sudo vim /opt/local/etc/php53/php.ini
適当に
sudo /opt/local/apache2/bin/apachectl start
sudo vim /opt/local/apache2/htdocs/info.php
$ cat /opt/local/apache2/htdocs/info.php
<?php
phpinfo();
?>
ブラウザで、 http://localhost/info.php
// pipがなかったのでいれる $ sudo easy_install pip // swiftのclient入れる $ sudo pip install python-swiftclient // 怒られる $ swift Traceback (most recent call last): File "/usr/local/bin/swift", line 7, infrom swiftclient.shell import main File "/Library/Python/2.7/site-packages/swiftclient/__init__.py", line 20, in from .client import * File "/Library/Python/2.7/site-packages/swiftclient/client.py", line 34, in from swiftclient import version as swiftclient_version File "/Library/Python/2.7/site-packages/swiftclient/version.py", line 27, in import pbr.version ImportError: No module named pbr.version // 足りなそうなもの入れる $ sudo pip install pbr // 違う理由で怒られる $ swift --version Traceback (most recent call last): File "/usr/local/bin/swift", line 7, in from swiftclient.shell import main File "/Library/Python/2.7/site-packages/swiftclient/__init__.py", line 20, in from .client import * File "/Library/Python/2.7/site-packages/swiftclient/client.py", line 34, in from swiftclient import version as swiftclient_version File "/Library/Python/2.7/site-packages/swiftclient/version.py", line 28, in version_string = str(pbr.version.VersionInfo('python-swiftclient')) File "/Library/Python/2.7/site-packages/pbr/version.py", line 39, in __str__ return self.version_string() File "/Library/Python/2.7/site-packages/pbr/version.py", line 78, in version_string for part in self.release_string().split('.'): File "/Library/Python/2.7/site-packages/pbr/version.py", line 70, in release_string self.release = self._get_version_from_pkg_resources() File "/Library/Python/2.7/site-packages/pbr/version.py", line 62, in _get_version_from_pkg_resources return packaging.get_version(self.package) File "/Library/Python/2.7/site-packages/pbr/packaging.py", line 870, in get_version raise Exception("Versioning for this project requires either an sdist" Exception: Versioning for this project requires either an sdist tarball, or access to an upstream git repository. Are you sure that git is installed? // このwaringあやしい $ pip list （略） Warning: cannot find svn location for setuptools==0.6c12dev-r85381 // upgradeしてみる $ sudo pip install --upgrade setuptools // ちゃんと動いた $ swift --version swift 2.3.1
BLOB または TEXT カラムにインデックスを張る場合、インデックスに対して接頭辞長を指定しなければなりません。
例 : CREATE TABLE test (blob_col BLOB, INDEX(blob_col(10)));
接頭辞は、最大 1000 バイト長 (InnoDB テーブルに対しては 767 バイト) まで可能です。接頭辞の最大長はバイトで評価されます。
一方、CREATE TABLE ステートメント内の接頭辞長は文字数として解釈されます。マルチバイトキャラクタセットを使用するカラムに対して接頭辞長を指定するとき、このことを考慮に入れなければいけません。
4.4.2. カラムインデックス
update hoge set code = 0 where id IN (select id from hoge as tmp where id = 1 group by id order by id) ;
ERROR 1093 (HY000): You can't specify target table 'hoge' for update in FROM clausemysqlって同じテーブルに対するサブクエリからの操作ができないんですよね。
サブクエリは、SELECT ステートメント同様 UPDATE と DELETE ステートメント内で正当なので、UPDATE ステートメント内で、割り当ての為にサブクエリを利用する事ができます。しかし、同じテーブルを(この場合、テーブル t1)サブクエリの FROM 条項と更新ターゲットの両方に対して利用する事はできません。
update hoge set code = 0 where id IN ( select id from (select id from hoge where id = 1 group by id order by id) as tmp ) ;
$ sudo yum install ImageMagickidentifyコマンドでチェック
$ identify -verbose newwindow.png
Image: newwindow.png
Format: PNG (Portable Network Graphics)
Class: DirectClass
Geometry: 11x9+0+0
Resolution: 72x72
Print size: 0.152778x0.125
Units: Undefined
Type: PaletteMatte
Endianess: Undefined
Colorspace: RGB
Depth: 8-bit
Channel depth:
red: 8-bit
green: 8-bit
blue: 8-bit
alpha: 1-bit
Channel statistics:
red:
min: 117 (0.458824)
max: 255 (1)
mean: 207.97 (0.815567)
standard deviation: 58.2078 (0.228266)
kurtosis: -1.58905
skewness: -0.506753
green:
min: 0 (0)
max: 255 (1)
mean: 170.879 (0.670113)
standard deviation: 108.467 (0.425361)
kurtosis: -1.28129
skewness: -0.68968
blue:
min: 0 (0)
max: 255 (1)
mean: 170.879 (0.670113)
standard deviation: 108.467 (0.425361)
kurtosis: -1.28129
skewness: -0.68968
alpha:
min: 0 (0)
max: 255 (1)
mean: 167.424 (0.656566)
standard deviation: 121.088 (0.474855)
kurtosis: -1.56516
skewness: 0.659425
Image statistics:
Overall:
min: 0 (0)
max: 255 (1)
mean: 159.326 (0.624807)
standard deviation: 111.088 (0.435638)
kurtosis: -1.49685
skewness: -0.508195
Alpha: rgba(255,255,255,0) #FFFFFF00
Histogram:
16: (117,117,117,255) #757575 grey46
24: (153, 0, 0,255) #990000 rgba(153,0,0,1)
34: (255,255,255, 0) #FFFFFF00 rgba(255,255,255,0)
25: (255,255,255,255) #FFFFFF white
Rendering intent: Undefined
Gamma: 0.45
Interlace: None
Background color: white
Border color: rgba(223,223,223,1)
Matte color: grey74
Transparent color: none
Page geometry: 11x9+0+0
Dispose: Undefined
Iterations: 0
Compression: Zip
Orientation: Undefined
Properties:
date:create: 2014-06-30T19:11:35+09:00
date:modify: 2014-06-30T19:11:35+09:00
signature: 2c79c5cc4298064485707a3e8c1e0ceba9f7241dd7366ff9a9dcb505a8b14936
Software: Adobe ImageReady
Artifacts:
verbose: true
Tainted: False
Filesize: 220b
Number pixels: 99b
Version: ImageMagick 6.5.4-7 2014-02-10 Q16 OpenMP http://www.imagemagick.org
ずらーっとでてくる
例えば色空間（RGBとかCMYKとか）だったら
identify -verbose newwindow.png |grep Colorspace Colorspace: RGBColorspaceを見ればよいね。