今天手欠本来想 rm -rf _* 结果敲成了 rm -rf _[空格]* 小半天的代码没有了。。。

以后必须
sudo apt-get install trash-cli
alias rm=’trash’

啊啊啊啊啊啊

首先安装twisted 跟 thrift ，这个官方都有文档，注意先装依赖关系就行了

奇怪的是我的thrift-ruby 死活编译不通过，还好我不用ruby,直接–without-ruby就好了

报这个错，不懂ruby，也google不到，烦请大侠们指点迷津：

Making all in rb
make[3]: Entering directory `/home/zyanlu/soft/thrift-0.8.0/lib/rb'
/usr/local/bin/rake
rake aborted!
no such file to load -- spec/rake/spectask

装完以后还需要给语言装扩展，我这里是php做客户端 跟py.twisted通信，所以需要编译一下php扩展跟python扩展

php：

cd thrift-0.8.0/lib/php/src/ext/thrift_protocol
phpize
./configure --enable-thrift_protocol
make
make install

然后配置一下extension=thrift_protocol.so 就可以了
注意要使扩展起作用的话必须使用TBinaryProtocolAccelerated，这个官方tutorial例子里没有

python 装就比较简单了，直接就好使

cd thrift-0.8.0/lib/py
py setup.py build
py setup.py install

现在我们来跑一个demo来看看，python的官网tutorial里直接可以跑通

cd thrift-0.8.0/tutorial
thrift -r --gen py tutorial.thrift
thrift -r --gen py:twisted tutorial.thrift
thrift -r --gen php tutorial.thrift

turial里的PhpClient.php 不能直接运行成功，是include的路径不对(看一下源码跟生成的代码就行了)
把php-gen/* 拷贝到 thrift-0.8.0/lib/php/src/packages

帖一下我的PhpClient.php

$GLOBALS['THRIFT_ROOT'] = '../../lib/php/src';

require_once $GLOBALS['THRIFT_ROOT'].'/Thrift.php';
require_once $GLOBALS['THRIFT_ROOT'].'/protocol/TBinaryProtocol.php';
require_once $GLOBALS['THRIFT_ROOT'].'/transport/TSocket.php';
#require_once $GLOBALS['THRIFT_ROOT'].'/transport/THttpClient.php';
#require_once $GLOBALS['THRIFT_ROOT'].'/transport/TBufferedTransport.php';
require_once $GLOBALS['THRIFT_ROOT'].'/transport/TFramedTransport.php';

/**
 * Suppress errors in here, which happen because we have not installed into
 * $GLOBALS['THRIFT_ROOT'].'/packages/tutorial' like we are supposed to!
 *
 * Normally we would only have to include Calculator.php which would properly
 * include the other files from their packages/ folder locations, but we
 * include everything here due to the bogus path setup.
 */
// error_reporting(0);
$GEN_DIR = $GLOBALS['THRIFT_ROOT'].'/packages';
require_once $GEN_DIR.'/shared/SharedService.php';
require_once $GEN_DIR.'/shared/shared_types.php';
require_once $GEN_DIR.'/tutorial/Calculator.php';
require_once $GEN_DIR.'/tutorial/tutorial_types.php';
error_reporting(E_ALL);

//try {
  if (array_search('--http', $argv)) {
    $socket = new THttpClient('localhost', 8080, '/php/PhpServer.php');
  } else {
    $socket = new TSocket('localhost', 9090);
    $socket->setRecvTimeout(2000);
  }
  $transport = new TFramedTransport($socket);
  $protocol = new TBinaryProtocolAccelerated($transport);
  $client = new tutorial_CalculatorClient($protocol);

  $transport->open();

  $client->ping();
  print "ping()\n";

  $sum = $client->add(1,1);
  print "1+1=$sum\n";

  $work = new tutorial_Work();

  $work->op = Operation::DIVIDE;
  $work->num1 = 1;
  $work->num2 = 0;

  try {
    $client->calculate(1, $work);
    print "Whoa! We can divide by zero?\n";
  } catch (tutorial_InvalidOperation $io) {
    print "InvalidOperation: $io->why\n";
  }

  $work->op = Operation::SUBTRACT;
  $work->num1 = 15;
  $work->num2 = 10;
  $diff = $client->calculate(1, $work);
  print "15-10=$diff\n";

  $log = $client->getStruct(1);
  print "Log: $log->value\n";

  $transport->close();

大功告成，后续测试一下性能是不是有宣传的那么给力

ubuntu server的好处是体积小，很快就能下好装上，但是开发常用的包都木有。(我是os x里弄了个linux vm来开发⋯ air的硬盘太小了…)

以下列表，不断更新中⋯⋯

apt-get install zlib1g-dev
apt-get install gcc
apt-get install dpkg-dev
apt-get install libssl-dev
apt-get install libxml2-dev
apt-get install libxslt-dev
apt-get install ntp
apt-get install libpcre3 libpcre3-dev
apt-get install libreadline5-dev
apt-get install exuberant-ctags
apt-get install mysql-client libmysqlclient-dev
apt-get install libbz2-dev
apt-get install zlib1g-dev
apt-get install libjpeg62-dev
apt-get install libfreetype6-dev
apt-get install liblcms1-dev
apt-get install libcurl3-dev

下面这段小程序是否输出true呢？

public long countRectangles(int width, int height){
		long x = (width*(width+1)/2)
				* (height*(height+1)/2);
		long a1 = (width*(width+1)/2);
		long a2 = (height*(height+1)/2);
		System.out.println(x == (a1*a2));
}
public static void main(String[] args) {
		new RectangularGrid().countRectangles(592, 964);
	}

结果坑爹了，打印出来x只有38960016，一看就是溢出了⋯
问题就在于 long = int*int的效果等同于long = (long)(int*int)
int*int返回值仍旧是int，所以修改成为long = (long)int*(long)int 就可以了。
这个其实是个很基础的问题，但是有时候敲代码一不留神还是很容易写错。

先把mysql全都配成utf8,比较坑爹的是table charset貌似没法指定默认utf-8,必须create的时候指定

[client]
default-character-set=utf8
[mysqld]
collation-server = utf8_general_ci
character-set-server = utf8

验证一下:

SHOW VARIABLES LIKE ‘character_set_%’;
SHOW VARIABLES LIKE ‘collation_%’;

# -*- coding: utf-8 -*-
import sqlalchemy
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, BigInteger,String,Text
from sqlalchemy.orm import sessionmaker

Base = declarative_base()
class Node(Base):
    __tablename__ = 'node'
    __table_args__ = {'mysql_engine':'InnoDB','mysql_charset':'utf8'}
    id = Column(Integer, primary_key=True)
    path = Column(String(255), index=True)
    name = Column(String(255))
    data = Column(Text)
    datatype = Column(String(255))

if __name__ == '__main__':
    engine = sqlalchemy.create_engine('mysql+mysqldb://root:123456@127.0.0.1:3306/dbname?charset=utf8', echo=True)

    Base.metadata.drop_all(engine)
    Base.metadata.create_all(engine) 

    Session = sessionmaker()
    Session.configure(bind=engine)
    session = Session()
    session.commit()

    n = Node()
    n.path = "/"
    n.name = "汉字"

    session.add(n)
    session.commit()

__table_args__指定了表编码，这样就可以很好支持中文了⋯ 如果有能在mysql配置里指定编码的方法请留言⋯