Initiative

新建一个django工程

设置数据库为一个普通的MySQL

新建URL映射
from django.conf.urls.defaults import *

urlpatterns = patterns('',
(r'^(?P<sql>[^/]*)','views.show_sql'),
)

写一个简单的view：
from django.http import HttpResponse
from django.db import connection

cursor=connection.cursor()

def show_sql(request, sql):
print sql
global cursor
cursor.execute(sql)
r=cursor.fetchall()
print r
return HttpResponse(str(r))

测试页面 http://127.0.0.1:8000/select 1这个简单页面，得到的返回是 ((1L,),) ，完全正常

刷新一次，或则多次刷新，都要出错：
InterfaceError at /select 1/
(0, '')
Request Method: GET
Request URL: http://127.0.0.1:8000/select 1/
Exception Type: InterfaceError
Exception Value: (0, '')
Exception Location: C:\Python25\Lib\site-packages\MySQLdb\cursors.py
in execute, line 147
Python Executable: C:\Python25\python.exe
Python Version: 2.5.1

Traceback (most recent call last):
File "C:\Python25\Lib\site-packages\django\core\handlers\base.py" in
_real_get_response
81. response = callback(request, *callback_args, **callback_kwargs)
File "E:\Python\exercise\1\views.py" in show_sql
12. cursor.execute(sql)
File "C:\Python25\Lib\site-packages\django\db\backends\util.py" in
execute
19. return self.cursor.execute(sql, params)
File "C:\Python25\Lib\site-packages\MySQLdb\cursors.py" in execute
147. charset = db.character_set_name()

InterfaceError at /select 1/
(0, '')

折腾了几天，发现这样写view就不会出错了，而且中文也不会出错

from django.http import HttpResponse
from django.db import connection

def show_sql(request, sql):
print sql
cursor=connection.cursor()
cursor.execute(sql)
r=cursor.fetchall()
print r
return HttpResponse(str(r))

也就是说把cursor的获得放在view内部就不会出错了，很奇怪。

MySQLdb以前有不能正确中文等编码的bug，不过现在修复了