自从工作电脑切换到Ubuntu之后，被这个问题困扰了好久。
一直没有静下心来研究一下是什么问题。 今天恰好有时间，搜索了一下解决方案，幸好也解决了，记录下来方便有需要的人。
解决步骤：
参考: Issue 443424: Ubuntu goes black screen when viewing some webpages
Written with StackEdit.
1
2
3
4
5
6
7
>>> import sqlalchemy
>>> sqlalchemy.__version__
'1.0.9'
>>> from sqlalchemy import create_engine
>>> engine = create_engine("mysql://root:123456@127.0.0.1:32768/db?charset=utf8", echo=True)
>>> engine
Engine(mysql://root:***@localhost:32768/db)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
>>> from sqlalchemy import Table, Column, Integer, String, MetaData, ForeignKey
>>> metadata = MetaData()
>>> messages = Table('messages', metadata,
... Column('id', Integer, primary_key=True),
... Column('FromUser', String(32)),
... Column('ToUser', String(32)),
... Column('content', String(128)),
... )
>>> metadata.create_all(engine)
CREATE TABLE messages (
id INTEGER NOT NULL AUTO_INCREMENT,
`from` VARCHAR(32),
`to` VARCHAR(32),
content VARCHAR(128),
PRIMARY KEY (id)
)
>>> messages.drop(engine)
1
2
3
4
5
6
>>> ins = messages.insert()
>>> str(ins)
'INSERT INTO messages (id, "from", "to", content) VALUES (:id, :from, :to, :content)'
>>> ins1 = messages.insert().values(FromUser='fan', ToUser='elain', content='hello')
>>> ins.compile().params
{'content': 'hello', 'FromUser': 'fan', 'ToUser': 'elain'}
###Executing
1
2
3
4
5
6
7
8
9
10
>>> conn = engine.connect()
>>> result = conn.execute(ins1)
2015-12-08 18:20:06,653 INFO sqlalchemy.engine.base.Engine INSERT INTO messages (`FromUser`, `ToUser`, content) VALUES (%s, %s, %s)
2015-12-08 18:20:06,654 INFO sqlalchemy.engine.base.Engine ('fan', 'elain', 'hello')
2015-12-08 18:20:06,692 INFO sqlalchemy.engine.base.Engine COMMIT
>>>conn.execute(ins, id=2, FromUser='wendy', ToUser='Wendy', content='Williams')
>>>conn.execute(ins, [
... {'content': 'hehe', 'FromUser': 'yun', 'ToUser': 'ali'}
... ])
###Table Reflecting
1
2
>>> messages = Table('messages', meta, autoload=True, autoload_with=engine)
>>> customers = Table('customers', meta, autoload=True, autoload_with=engine)
###Selecting
1
2
3
4
5
6
7
8
9
10
11
>>> s = select([messages])
>>> result = conn.execute(s)
2015-12-08 18:51:05,805 INFO sqlalchemy.engine.base.Engine SELECT messages.id, messages.`FromUser`, messages.`ToUser`, messages.content
FROM messages
2015-12-08 18:51:05,805 INFO sqlalchemy.engine.base.Engine ()
>>> for row in result:
... print row
...
(1L, 'fan', 'elain', 'hello')
(2L, 'wendy', 'Wendy', 'Williams')
(4L, 'yun', 'ali', 'hehe')
多表联合查找
1
2
3
4
5
6
>>> s = select([ messages, customers]).where(messages.c.FromUser == customers.c.name)
2015-12-09 15:28:21,900 INFO sqlalchemy.engine.base.Engine SELECT messages.id, messages.`FromUser`, messages.`ToUser`, messages.content, customers.id, customers.name, customers.country, customers.postcode, customers.city, customers.street, customers.mobile, customers.email
FROM messages, customers
WHERE messages.`FromUser` = customers.name
2015-12-09 15:28:21,900 INFO sqlalchemy.engine.base.Engine ()
Written with StackEdit.
[OPTIONS]:
None
没有任何参数，打印该容器的所有日志
-f
最常用的指令，类似tail的f选项，显示日志以及更新
–since
显示从某个timestamp开始的日志
-t
同时显示timestamps
–tail=n
从日志末尾的第n行显示
下面是一些样例：
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
$ docker logs --help
Usage: docker logs [OPTIONS] CONTAINER
Fetch the logs of a container
-f, --follow=false Follow log output
--help=false Print usage
--since= Show logs since timestamp
-t, --timestamps=false Show timestamps
--tail=all Number of lines to show from the end of the logs
$ docker logs -f --tail=10 flask
2015-11-25 15:19:44 杭州市 海关放行
2015-11-25 15:19:45 杭州市 离开处理中心,发往台州市
2015-11-26 10:41:54 台州市 离开处理中心
2015-11-26 14:12:53 临海市分公司 安排投递
2015-11-26 17:25:06 临海市分公司 未妥投
2015-11-26 19:26:50 临海市分公司 到达处理中心
2015-11-27 08:43:25 临海市分公司 安排投递
2015-11-27 11:53:42 临海市分公司 投递并签收
--------------------------------------------------------------------------------
$ docker logs -t --since='2015-11-27' flask
2015-11-27T09:29:18.872591141Z 192.168.42.1 - - [27/Nov/2015 09:29:18] "GET / HTTP/1.1" 200 -
2015-11-27T09:29:32.059603285Z 82.217.156.213 - - [27/Nov/2015 09:29:32] "GET / HTTP/1.1" 200 -