在项目起始阶段，我频繁修改model的定义， 我找不到合适的方式能让django自动根据model修改数据库的表定义。

我只能将数据库删掉，然后让django重建，但是这样我辛辛苦苦加入的测试数据就需要重新搞一遍，有没有方便的方式？

我dump了数据中的数据，然后修改sql语句，重新加入到新生成的数据库中，我觉得这个方式实在太麻烦了。



-- 
蔡峰 Cai Feng

用 alter 语句啊，或者开个数据库的管理程序来对表结构进行修改也行。

On 5/5/07, ljpsfree <caifen1985 at gmail.com> wrote:
>
> 在项目起始阶段，我频繁修改model的定义， 我找不到合适的方式能让django自动根据model修改数据库的表定义。
>
> 我只能将数据库删掉，然后让django重建，但是这样我辛辛苦苦加入的测试数据就需要重新搞一遍，有没有方便的方式？
>
> 我dump了数据中的数据，然后修改sql语句，重新加入到新生成的数据库中，我觉得这个方式实在太麻烦了。
>
>
>
> --
> 蔡峰 Cai Feng
> _______________________________________________
> python-chinese
> Post: send python-chinese at lists.python.cn
> Subscribe: send subscribe to python-chinese-request at lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request at lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese




-- 
http://codeplayer.blogspot.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://python.cn/pipermail/python-chinese/attachments/20070506/dbdcea18/attachment.htm 

手动修改数据库结构？我想让django自动根据model修改数据库结构。
用alter我会的，呵呵，我嫌这个还是比较麻烦。
我想的是最好能有./manager updatedb这样的东西

-- 
明天是美好的。


On 5/6/07, 黄毅 <yi.codeplayer在gmail.com> wrote:
> 用 alter 语句啊，或者开个数据库的管理程序来对表结构进行修改也行。
>
>
> On 5/5/07, ljpsfree <caifen1985在gmail.com> wrote:
> >
> > 在项目起始阶段，我频繁修改model的定义，
> 我找不到合适的方式能让django自动根据model修改数据库的表定义。
> >
> > 我只能将数据库删掉，然后让django重建，但是这样我辛辛苦苦加入的测试数据就需要重新搞一遍，有没有方便的方式？
> >
> > 我dump了数据中的数据，然后修改sql语句，重新加入到新生成的数据库中，我觉得这个方式实在太麻烦了。
> >
> >
> >
> > --
> > 蔡峰 Cai Feng
> > _______________________________________________
> > python-chinese
> > Post: send python-chinese在lists.python.cn
> > Subscribe: send subscribe to
> python-chinese-request在lists.python.cn
> > Unsubscribe: send unsubscribe to
> python-chinese-request在lists.python.cn
> > Detail Info:
> http://python.cn/mailman/listinfo/python-chinese
>
>
>
> --
>  http://codeplayer.blogspot.com/
> _______________________________________________
> python-chinese
> Post: send python-chinese在lists.python.cn
> Subscribe: send subscribe to
> python-chinese-request在lists.python.cn
> Unsubscribe: send unsubscribe to
> python-chinese-request在lists.python.cn
> Detail Info:
> http://python.cn/mailman/listinfo/python-chinese
>

On 5/6/07, ljpsfree <caifen1985在gmail.com> wrote:
> 手动修改数据库结构？我想让django自动根据model修改数据库结构。
> 用alter我会的，呵呵，我嫌这个还是比较麻烦。
> 我想的是最好能有./manager updatedb这样的东西
>

可以使用我写的db_dump.py工具，它在openbookplatform中有，可以用一用。

-- 
I like python!
UliPad <>: http://wiki.woodpecker.org.cn/moin/UliPad
My Blog: http://www.donews.net/limodou

ÐÞ¸ÄÊý¾Ý¿â¶¨Òå¶ÔÉý¼¶À´ËµÊǺÜÂé·³µÄ£¬²»ÊǼòµ¥µÄupdatedb¾ÍÄܸ㶨µÄ£¬ÒòΪÓкܶà¿ÉÄÜÐÔ¡£¿ÉÄÜÒ²ÊÇÕâ¸öÎÊÌâ£Ä£Ê£Á£Î£Ç£Ï²ÅûÀí°É£¬£°.£¹£¶ÓÐdumpÁË£¬
£Ì£É£Í£Ï£Ä£Ï£Õ¿ª·¢Õâ¸ödb_dump.pyÒ²Êǵ±Ê±¿¼Âǵ½Õâ¸öÎÊÌâ¶ø×öµÄ£¬Äã¿ÉÒÔÊÔÊÔ
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070506/cfc24b67/attachment.html 

我在运行db_dump.py的时候出错
脚本运行到这一行时报错
417  from django.core.management import setup_environ

错误信息：
Traceback (most recent call last):
  File "django_db_dump.py", line 435, in ?
    execute_from_command_line()
  File "django_db_dump.py", line 417, in execute_from_command_line
    from django.core.management import setup_environ
ImportError: cannot import name setup_environ

我检查了一下django/core/management.py文件，里面setup_environ是以方法的形式存在的。
我在python的 shell 中尝试了
        from django.core.management import  *
        from django.core import management
都无法调用setup_environ这个方法。

-- 
明天是美好的。


On 5/6/07, limodou <limodou在gmail.com> wrote:
> On 5/6/07, ljpsfree <caifen1985在gmail.com> wrote:
> > 手动修改数据库结构？我想让django自动根据model修改数据库结构。
> > 用alter我会的，呵呵，我嫌这个还是比较麻烦。
> > 我想的是最好能有./manager updatedb这样的东西
> >
>
> 可以使用我写的db_dump.py工具，它在openbookplatform中有，可以用一用。
>
> --
> I like python!
> UliPad <>: http://wiki.woodpecker.org.cn/moin/UliPad
> My Blog: http://www.donews.net/limodou
> _______________________________________________
> python-chinese
> Post: send python-chinese在lists.python.cn
> Subscribe: send subscribe to python-chinese-request在lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese

db_dump.py
ÎÒÔÚdjango 0.96·¢Ðаæ
mysql 5.0ÏÂÃæÒ»Ö±³öÏÖÎÊÌ⣬ÏÔʾsucceed¡£¡£µ«ÊÇÉú³ÉÎļþ¼ÐÏÂÃæ¿ÕÎÞÒ»Îï
ͬʱÎÒÒ²ÊÔÁËsqlite  ͬÑù²»ÐС£
ÎÒÒÔΪÊÇ×Ô¼ºµÄÏîÄ¿models½á¹¹Ì«±ä̬£¬¾ÍÄÃlimodouÐÖµÄblog³ÌÐòºÍbeykingÐÖµÄbbs³ÌÐò¶¼ÊÔÊÔ£¨Õâ´ÎÊÇmysql£©
Ò²ÊÇ¿ÕÎÞÒ»ÎÎÒÏë»ØÍ·×Ðϸ¿´¿´db_dump.py
Ñо¿ÏÂÔ­Òò
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070506/122f5a0d/attachment.html 

On 5/6/07, ljpsfree <caifen1985在gmail.com> wrote:
> 我在运行db_dump.py的时候出错
> 脚本运行到这一行时报错
> 417  from django.core.management import setup_environ
>
> 错误信息：
> Traceback (most recent call last):
>   File "django_db_dump.py", line 435, in ?
>     execute_from_command_line()
>   File "django_db_dump.py", line 417, in execute_from_command_line
>     from django.core.management import setup_environ
> ImportError: cannot import name setup_environ
>
> 我检查了一下django/core/management.py文件，里面setup_environ是以方法的形式存在的。
> 我在python的 shell 中尝试了
>         from django.core.management import  *
>         from django.core import management
> 都无法调用setup_environ这个方法。
>

不知道你的django是什么版本，要trunk或0.96才可以。

-- 
I like python!
UliPad <>: http://wiki.woodpecker.org.cn/moin/UliPad
My Blog: http://www.donews.net/limodou

Çë½Ì limodou ÄúдµÄ django expr ÔËËã,ºÃÏñÎÒûÓа취ʵÏÖÀÛ¼Ó
{%for p in ports%}
  {%expr p.price * p.quantity as sub_total %}
  {%expr subtotal + sutotal as total %}#ºÃÔËÎÞ·¨ÊµÏÖÕâÖÖͳ¼Æ.
{%endfor}

ÁíÍâ,django ×Ô´øµÄ  add ¹ýÂËÆ÷ÎÒ²»»áÓÃѽ!
±í´ïʽÔõôд¶¼²»Ò»ÕýÈ·.
ÕâÊÇËüµÄ˵Ã÷:
add
·µ»Ø²ÎÊýÓë±»´¦ÀíÊý¾ÝÏà¼ÓµÄ½á¹û.


    
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070506/229f5344/attachment.htm 

On 5/6/07, bbenyu <bbenyu在gmail.com> wrote:
>
>
> 请教 limodou 您写的 django expr 运算,好像我没有办法实现累加
> {%for p in ports%}
>   {%expr p.price * p.quantity as sub_total %}
>   {%expr subtotal + sutotal as total %}#好运无法实现这种统计.
> {%endfor}
>
expr处理的是python数据类型，不是象django对变量的处理那样，对于字典要使用python的语法，如：a['a']。我不知道ports是什么类型的数组，是字典还是对象？而且第二行的计算与上面的变量名不符啊：一个是sub_total，而另一个是subtotal，不知道是敲错了，还是故意？

> 另外,django 自带的  add 过滤器我不会用呀!
> 表达式怎么写都不一正确.
> 这是它的说明:
>
要看文档，我没有用过。感觉django的template的过滤器过多了，造成记忆复杂。

-- 
I like python!
UliPad <>: http://wiki.woodpecker.org.cn/moin/UliPad
My Blog: http://www.donews.net/limodou

ÊÇ´ò´í×ÖÁË,Òâ˼ÊǾÍÊÇ:Òª×ö¸öµü´úµÄͳ¼Æ,°ÑËùÓеÄsub_total µÄÖµ¼ÆËã³öÀ´.

> {%for p in ports%}
>   {%expr p.price * p.quantity as sub_total %}
>   {%expr subtotal + subtotal as total %}#ºÃÔËÎÞ·¨ÊµÏÖÕâÖÖͳ¼Æ.
> {%endfor}

{{total}} ÊÇ¿ÕµÄ.




bbenyu
2007-05-06



·¢¼þÈË£º limodou
·¢ËÍʱ¼ä£º 2007-05-06 16:50:29
ÊÕ¼þÈË£º python-chinese在lists.python.cn
³­ËÍ£º 
Ö÷Ì⣺ Re: [python-chinese]Çë½Ì limodou ÄúдµÄ djangoexprÔËËã!

On 5/6/07, bbenyu  <bbenyu在gmail.com > wrote:
>
>
> Çë½Ì limodou ÄúдµÄ django expr ÔËËã,ºÃÏñÎÒûÓа취ʵÏÖÀÛ¼Ó
> {%for p in ports%}
>   {%expr p.price * p.quantity as sub_total %}
>   {%expr subtotal + sutotal as total %}#ºÃÔËÎÞ·¨ÊµÏÖÕâÖÖͳ¼Æ.
> {%endfor}
>
expr´¦ÀíµÄÊÇpythonÊý¾ÝÀàÐÍ£¬²»ÊÇÏódjango¶Ô±äÁ¿µÄ´¦ÀíÄÇÑù£¬¶ÔÓÚ×ÖµäҪʹÓÃpythonµÄÓï·¨£¬È磺a['a']¡£ÎÒ²»ÖªµÀportsÊÇʲôÀàÐ͵ÄÊý×飬ÊÇ×ֵ仹ÊǶÔÏ󣿶øÇÒµÚ¶þÐеļÆËãÓëÉÏÃæµÄ±äÁ¿Ãû²»·û°¡£ºÒ»¸öÊÇsub_total£¬¶øÁíÒ»¸öÊÇsubtotal£¬²»ÖªµÀÊÇÇôíÁË£¬»¹ÊǹÊÒ⣿

> ÁíÍâ,django ×Ô´øµÄ  add ¹ýÂËÆ÷ÎÒ²»»áÓÃѽ!
> ±í´ïʽÔõôд¶¼²»Ò»ÕýÈ·.
> ÕâÊÇËüµÄ˵Ã÷:
>
Òª¿´Îĵµ£¬ÎÒûÓÐÓùý¡£¸Ð¾õdjangoµÄtemplateµÄ¹ýÂËÆ÷¹ý¶àÁË£¬Ôì³É¼ÇÒ临ÔÓ¡£

-- 
I like python!
UliPad  <  >: http://wiki.woodpecker.org.cn/moin/UliPad
My Blog: http://www.donews.net/limodou
_______________________________________________
python-chinese
Post: send python-chinese在lists.python.cn
Subscribe: send subscribe to python-chinese-request在lists.python.cn
Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
Detail Info: http://python.cn/mailman/listinfo/python-chinese
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070506/1d33eef5/attachment.html 

On 5/6/07, bbenyu <bbenyu在gmail.com> wrote:
>
>
> 是打错字了,意思是就是:要做个迭代的统计,把所有的sub_total 的值计算出来.
>
> > {%for p in ports%}
> >   {%expr p.price * p.quantity as sub_total %}
> >   {%expr subtotal + subtotal as total %}#好运无法实现这种统计.
> > {%endfor}
>
> {{total}} 是空的.
>
我认为是可以的，一是修改上面的sub_total，为什么第二次还是一个错的。另外求和也不是这么求的，一般不是：

s = 0
s = s + i

吗？

为什么没有初始化total，而且total没有参与累计的过程中。每一步的变量倒底是什么也看不出来。如果不方便，建议在view中做这个处理。

-- 
I like python!
UliPad <>: http://wiki.woodpecker.org.cn/moin/UliPad
My Blog: http://www.donews.net/limodou

ÇëÎÊÒ»ÏÂ, simplejson ÈçºÎʹÓÃ?ÈçºÎ½âÎö·µ»ØµÄÊý¾Ýѽ?

ÎÒÓÃÒÔÏ´úÂë,ÔõôÌáʾis not JSON serializableµÄ´íÎó?

def test(request, p):
    result = ProductComment.objects.filter(p=p).values();
    return HttpResponse(simplejson.dumps(result));

ÕýÈ·µÄÊÇʲô?Ëû½ÓÊÜʲô²ÎÊýѽ?
ÎÒÓõÄÊÇ django 0.96 ×Ô´øµÄ simplejson.
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070506/724d252a/attachment.htm 

ÔÚÎÒµÄModelÖÐ,Ϊʲô ForeignKey²»ÄܼÓ×¢ÊÍÄØ?
Èç:

class Product(models.Model):
    name = models.CharField('²úÆ·Ãû³Æ', maxlength =32);

class ProductImages(mdoels.Model):
    product = mdoels.ForeginKey('²úÆ·', Product);

»áÌáʾÈçϵĴíÎó:
#'²úÆ·', make an error is "attributeError : str no attribute '_meta'
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070506/957946fe/attachment.html 

product = mdoels.ForeginKey(Product, verbose_name='产品')
看文档去！


On 5/6/07, bbenyu <bbenyu at gmail.com> wrote:
>
>  在我的Model中,为什么 ForeignKey不能加注释呢?
> 如:
>
> class Product(models.Model):
>     name = models.CharField('产品名称', maxlength =32);
>
> class ProductImages(mdoels.Model):
>     product = mdoels.ForeginKey('产品', Product);
>
> 会提示如下的错误:
> #'产品', make an error is "attributeError : str no attribute '_meta'
>
>
>
> _______________________________________________
> python-chinese
> Post: send python-chinese at lists.python.cn
> Subscribe: send subscribe to python-chinese-request at lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request at lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese
>



-- 
http://codeplayer.blogspot.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://python.cn/pipermail/python-chinese/attachments/20070506/69001899/attachment-0001.htm 

This is a multi-part message in MIME format.

--=====003_Dragon877516578200_=====
Content-Type: text/plain;
	charset="gb2312"
Content-Transfer-Encoding: base64

eyUgZXhwciAwIGFzIHRvdGFsJX0NCnslZm9yIHAgaW4gcG9ydHMlfQ0KICAgeyVleHByIHAucHJp
Y2UgKiBwLnF1YW50aXR5IGFzIHN1Yl90b3RhbCAlfQ0KICAgeyVleHByIHRvdGFsICsgc3ViX3Rv
dGFsIGFzIHRvdGFsICV9I7rD1MvO3reoyrXP1tXi1tbNs7zGLg0KIHslZW5kZm9yfQ0KDQq21CzS
u7Djx/O6zcrHOiBzICs9IHM7DQq1q8Tj0rLD97DXLNTaZGphbmdvtcTEo7Dl1tDO3reoyerD97rN
yrnTw7Hkwb/RvSHEv8ewysfTw8T60LS1xHRlbXBsYXRldGFntKbA7S4NCrK71qez1iArPSDA4MvG
1MvL47f70b0hDQrL+dLULM7SysfP67XDtb0gdG90YWwgKz0gc3ViX3RvdGFsILXEveG5+9G9IQ0K
dG90YWwgtcjT2iBzdWJfdG90YWwgtcTL+dPQus0uDQrI57n7t8W1vSB2aWV3IMDvLL71tcPC6bez
Lg0KDQoNCg0KYmJlbnl1DQoyMDA3LTA1LTA2DQoNCg0KDQq3orz+yMujuiBsaW1vZG91DQq3osvN
yrG85KO6IDIwMDctMDUtMDYgMTg6MTM6NTYNCsrVvP7Iy6O6IHB5dGhvbi1jaGluZXNlQGxpc3Rz
LnB5dGhvbi5jbg0Ks63LzaO6IA0K1vfM4qO6IFJlOiBbcHl0aG9uLWNoaW5lc2Vdx+u9zCBsaW1v
ZG91IMT60LS1xCBkamFuZ29leHBy1MvL4yENCg0KT24gNS82LzA3LCBiYmVueXUgIDxiYmVueXVA
Z21haWwuY29tID4gd3JvdGU6DQo+DQo+DQo+IMrHtPK07dfWwcss0uLLvMrHvs3KxzrSqtf2uPa1
/LT6tcTNs7zGLLDRy/nT0LXEc3ViX3RvdGFsILXE1rW8xsvjs/bAtC4NCj4NCj4gID4geyVmb3Ig
cCBpbiBwb3J0cyV9DQo+ICA+ICAgeyVleHByIHAucHJpY2UgKiBwLnF1YW50aXR5IGFzIHN1Yl90
b3RhbCAlfQ0KPiAgPiAgIHslZXhwciBzdWJ0b3RhbCArIHN1YnRvdGFsIGFzIHRvdGFsICV9I7rD
1MvO3reoyrXP1tXi1tbNs7zGLg0KPiAgPiB7JWVuZGZvcn0NCj4NCj4ge3t0b3RhbH19IMrHv9W1
xC4NCj4NCs7SyM/OqsrHv8nS1LXEo6zSu8rH0N64xMnPw+a1xHN1Yl90b3RhbKOszqrKssO0tdq2
/rTOu7nKx9K7uPa07bXEoaPB7c3ix/O6zdKysrvKx9Xiw7TH87XEo6zSu7DjsrvKx6O6DQoNCnMg
PSAwDQpzID0gcyArIGkNCg0KwvCjvw0KDQrOqsqyw7TDu9PQs/XKvLuvdG90YWyjrLb4x9J0b3Rh
bMO709CyztPrwNu8xrXEuf2zzNbQoaPDv9K7sr21xLHkwb+1ubXXysfKssO00rK/tLK7s/bAtKGj
yOe5+7K7t72x46OsvajS6dTadmlld9bQ1/bV4rj2tKbA7aGjDQoNCi0tIA0KSSBsaWtlIHB5dGhv
biENClVsaVBhZCAgPCA8VGhlIFB5dGhvbiBFZGl0b3IgPiA+OiBodHRwOi8vd2lraS53b29kcGVj
a2VyLm9yZy5jbi9tb2luL1VsaVBhZA0KTXkgQmxvZzogaHR0cDovL3d3dy5kb25ld3MubmV0L2xp
bW9kb3UNCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fDQpw
eXRob24tY2hpbmVzZQ0KUG9zdDogc2VuZCBweXRob24tY2hpbmVzZUBsaXN0cy5weXRob24uY24N
ClN1YnNjcmliZTogc2VuZCBzdWJzY3JpYmUgdG8gcHl0aG9uLWNoaW5lc2UtcmVxdWVzdEBsaXN0
cy5weXRob24uY24NClVuc3Vic2NyaWJlOiBzZW5kIHVuc3Vic2NyaWJlIHRvICBweXRob24tY2hp
bmVzZS1yZXF1ZXN0QGxpc3RzLnB5dGhvbi5jbg0KRGV0YWlsIEluZm86IGh0dHA6Ly9weXRob24u
Y24vbWFpbG1hbi9saXN0aW5mby9weXRob24tY2hpbmVzZQ0K

--=====003_Dragon877516578200_=====
Content-Type: text/html;
	charset="gb2312"
Content-Transfer-Encoding: base64

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv
L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgaHR0cC1lcXVpdj1Db250ZW50LVR5cGUgY29udGVu
dD0idGV4dC9odG1sOyBjaGFyc2V0PWdiMjMxMiI+DQo8TUVUQSBjb250ZW50PSJNU0hUTUwgNi4w
MC4yOTAwLjI4NzMiIG5hbWU9R0VORVJBVE9SPg0KPFNUWUxFPg0KPCEtLQ0KIC8qIEZvbnQgRGVm
aW5pdGlvbnMgKi8NCiBAZm9udC1mYWNlDQoJe2ZvbnQtZmFtaWx5OsvOzOU7DQoJcGFub3NlLTE6
MiAxIDYgMCAzIDEgMSAxIDEgMTt9DQpAZm9udC1mYWNlDQoJe2ZvbnQtZmFtaWx5OlZlcmRhbmE7
DQoJcGFub3NlLTE6MiAxMSA2IDQgMyA1IDQgNCAyIDQ7fQ0KQGZvbnQtZmFjZQ0KCXtmb250LWZh
bWlseToiXEDLzszlIjsNCglwYW5vc2UtMToyIDEgNiAwIDMgMSAxIDEgMSAxO30NCiAvKiBTdHls
ZSBEZWZpbml0aW9ucyAqLw0KIHAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWwsIGRpdi5Nc29Ob3Jt
YWwNCgl7bWFyZ2luOjBjbTsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJdGV4dC1hbGlnbjpq
dXN0aWZ5Ow0KCXRleHQtanVzdGlmeTppbnRlci1pZGVvZ3JhcGg7DQoJZm9udC1zaXplOjEwLjVw
dDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIjt9DQphOmxpbmssIHNwYW4uTXNvSHlw
ZXJsaW5rDQoJe2NvbG9yOmJsdWU7DQoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQphOnZp
c2l0ZWQsIHNwYW4uTXNvSHlwZXJsaW5rRm9sbG93ZWQNCgl7Y29sb3I6cHVycGxlOw0KCXRleHQt
ZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0Kc3Bhbi5FbWFpbFN0eWxlMTcNCgl7bXNvLXN0eWxlLXR5
cGU6cGVyc29uYWwtY29tcG9zZTsNCglmb250LWZhbWlseTpWZXJkYW5hOw0KCWNvbG9yOndpbmRv
d3RleHQ7DQoJZm9udC13ZWlnaHQ6bm9ybWFsOw0KCWZvbnQtc3R5bGU6bm9ybWFsOw0KCXRleHQt
ZGVjb3JhdGlvbjpub25lIG5vbmU7fQ0KIC8qIFBhZ2UgRGVmaW5pdGlvbnMgKi8NCiBAcGFnZSBT
ZWN0aW9uMQ0KCXtzaXplOjU5NS4zcHQgODQxLjlwdDsNCgltYXJnaW46NzIuMHB0IDkwLjBwdCA3
Mi4wcHQgOTAuMHB0Ow0KCWxheW91dC1ncmlkOjE1LjZwdDt9DQpkaXYuU2VjdGlvbjENCgl7cGFn
ZTpTZWN0aW9uMTt9DQotLT4NCjwvU1RZTEU+DQo8L0hFQUQ+DQo8Qk9EWT4NCjxESVY+eyUgZXhw
ciAwIGFzIHRvdGFsJX08L0RJVj4NCjxESVY+eyVmb3ImbmJzcDtwJm5ic3A7aW4mbmJzcDtwb3J0
cyV9PC9ESVY+DQo8RElWPiZuYnNwOyZuYnNwOyZuYnNwO3slZXhwciZuYnNwO3AucHJpY2UmbmJz
cDsqJm5ic3A7cC5xdWFudGl0eSZuYnNwO2FzJm5ic3A7c3ViX3RvdGFsJm5ic3A7JX08L0RJVj4N
CjxESVY+Jm5ic3A7Jm5ic3A7Jm5ic3A7eyVleHByJm5ic3A7dG90YWwmbmJzcDsrJm5ic3A7c3Vi
X3RvdGFsJm5ic3A7YXMmbmJzcDt0b3RhbCZuYnNwOyV9I7rD1MvO3reoyrXP1tXi1tbNs7zGLjwv
RElWPg0KPERJVj4mbmJzcDt7JWVuZGZvcn08L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1WZXJkYW5h
IGNvbG9yPSMwMDAwZmYgc2l6ZT0yPjwvRk9OVD4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgZmFj
ZT1WZXJkYW5hIHNpemU9Mj621CzSu7Djx/O6zcrHOiBzICs9IHM7PC9GT05UPjwvRElWPg0KPERJ
Vj48Rk9OVCBmYWNlPVZlcmRhbmEgDQpzaXplPTI+tavE49Kyw/ew1yzU2mRqYW5nb7XExKOw5dbQ
zt63qMnqw/e6zcq508Ox5MG/0b0hxL/HsMrH08PE+tC0tcR0ZW1wbGF0ZXRhZ7SmwO0uPC9GT05U
PjwvRElWPg0KPERJVj48Rk9OVCBmYWNlPVZlcmRhbmEgc2l6ZT0yPrK71qez1iArPSDA4MvG1MvL
47f70b0hPC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBmYWNlPVZlcmRhbmEgc2l6ZT0yPsv50tQs
ztLKx8/rtcO1vSB0b3RhbCArPSBzdWJfdG90YWwgtcS94bn70b0hPC9GT05UPjwvRElWPg0KPERJ
Vj48Rk9OVCBmYWNlPVZlcmRhbmEgc2l6ZT0yPnRvdGFsILXI09ogc3ViX3RvdGFsILXEy/nT0LrN
LjwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1WZXJkYW5hIHNpemU9Mj7I57n7t8W1vSB2
aWV3IMDvLL71tcPC6bezLjwvRk9OVD48L0RJVj4NCjxESVYgYWxpZ249bGVmdD4NCjxESVYgYWxp
Z249bGVmdD48Rk9OVCBmYWNlPVZlcmRhbmEgc2l6ZT0yPg0KPEhSIHN0eWxlPSJXSURUSDogMTIy
cHg7IEhFSUdIVDogMnB4IiBTSVpFPTI+DQo8L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIGNvbG9y
PSNjMGMwYzA+PEZPTlQgZmFjZT1WZXJkYW5hIHNpemU9Mj5iYmVueXU8L0ZPTlQ+PC9ESVY+DQo8
RElWPjxGT05UIGZhY2U9VmVyZGFuYSBzaXplPTI+MjAwNy0wNS0wNjwvRk9OVD48L0ZPTlQ+PC9E
SVY+PC9ESVY+DQo8RElWPjxGT05UIGZhY2U9VmVyZGFuYSBzaXplPTI+DQo8SFI+DQo8L0ZPTlQ+
PC9ESVY+DQo8RElWPjxGT05UIGZhY2U9VmVyZGFuYT48Rk9OVCBzaXplPTI+PFNUUk9ORz63orz+
yMujujwvU1RST05HPiANCmxpbW9kb3U8L0ZPTlQ+PC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBm
YWNlPVZlcmRhbmE+PEZPTlQgc2l6ZT0yPjxTVFJPTkc+t6LLzcqxvOSjujwvU1RST05HPiANCjIw
MDctMDUtMDYmbmJzcDsxODoxMzo1NjwvRk9OVD48L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIGZh
Y2U9VmVyZGFuYT48Rk9OVCBzaXplPTI+PFNUUk9ORz7K1bz+yMujujwvU1RST05HPiANCnB5dGhv
bi1jaGluZXNlQGxpc3RzLnB5dGhvbi5jbjwvRk9OVD48L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05U
IGZhY2U9VmVyZGFuYT48Rk9OVCBzaXplPTI+PFNUUk9ORz6zrcvNo7o8L1NUUk9ORz4gPC9GT05U
PjwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1WZXJkYW5hPjxGT05UIHNpemU9Mj48U1RS
T05HPtb3zOKjujwvU1RST05HPiBSZTogW3B5dGhvbi1jaGluZXNlXcfrvcwgDQpsaW1vZG91IMT6
0LS1xCBkamFuZ29leHBy1MvL4yE8L0ZPTlQ+PC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBmYWNl
PVZlcmRhbmEgc2l6ZT0yPjwvRk9OVD4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1WZXJk
YW5hIHNpemU9Mj4NCjxESVY+T24mbmJzcDs1LzYvMDcsJm5ic3A7YmJlbnl1Jm5ic3A7ICZsdDti
YmVueXVAZ21haWwuY29tIA0KJmd0OyZuYnNwO3dyb3RlOjwvRElWPg0KPERJVj4mZ3Q7PC9ESVY+
DQo8RElWPiZndDs8L0RJVj4NCjxESVY+Jmd0OyZuYnNwO8rHtPK07dfWwcss0uLLvMrHvs3KxzrS
qtf2uPa1/LT6tcTNs7zGLLDRy/nT0LXEc3ViX3RvdGFsJm5ic3A7tcTWtbzGy+Oz9sC0LjwvRElW
Pg0KPERJVj4mZ3Q7PC9ESVY+DQo8RElWPiZndDsmbmJzcDsgJmd0OyZuYnNwO3slZm9yJm5ic3A7
cCZuYnNwO2luJm5ic3A7cG9ydHMlfTwvRElWPg0KPERJVj4mZ3Q7Jm5ic3A7IA0KJmd0OyZuYnNw
OyZuYnNwOyZuYnNwO3slZXhwciZuYnNwO3AucHJpY2UmbmJzcDsqJm5ic3A7cC5xdWFudGl0eSZu
YnNwO2FzJm5ic3A7c3ViX3RvdGFsJm5ic3A7JX08L0RJVj4NCjxESVY+Jmd0OyZuYnNwOyANCiZn
dDsmbmJzcDsmbmJzcDsmbmJzcDt7JWV4cHImbmJzcDtzdWJ0b3RhbCZuYnNwOysmbmJzcDtzdWJ0
b3RhbCZuYnNwO2FzJm5ic3A7dG90YWwmbmJzcDslfSO6w9TLzt63qMq1z9bV4tbWzbO8xi48L0RJ
Vj4NCjxESVY+Jmd0OyZuYnNwOyAmZ3Q7Jm5ic3A7eyVlbmRmb3J9PC9ESVY+DQo8RElWPiZndDs8
L0RJVj4NCjxESVY+Jmd0OyZuYnNwO3t7dG90YWx9fSZuYnNwO8rHv9W1xC48L0RJVj4NCjxESVY+
Jmd0OzwvRElWPg0KPERJVj7O0sjPzqrKx7/J0tS1xKOs0rvKx9DeuMTJz8PmtcRzdWJfdG90YWyj
rM6qyrLDtLXatv60zru5ysfSu7j2tO21xKGjwe3N4sfzus3SsrK7ysfV4sO0x/O1xKOs0ruw47K7
ysejujwvRElWPg0KPERJVj4mbmJzcDs8L0RJVj4NCjxESVY+cyZuYnNwOz0mbmJzcDswPC9ESVY+
DQo8RElWPnMmbmJzcDs9Jm5ic3A7cyZuYnNwOysmbmJzcDtpPC9ESVY+DQo8RElWPiZuYnNwOzwv
RElWPg0KPERJVj7C8KO/PC9ESVY+DQo8RElWPiZuYnNwOzwvRElWPg0KPERJVj7Oqsqyw7TDu9PQ
s/XKvLuvdG90YWyjrLb4x9J0b3RhbMO709CyztPrwNu8xrXEuf2zzNbQoaPDv9K7sr21xLHkwb+1
ubXXysfKssO00rK/tLK7s/bAtKGjyOe5+7K7t72x46OsvajS6dTadmlld9bQ1/bV4rj2tKbA7aGj
PC9ESVY+DQo8RElWPiZuYnNwOzwvRElWPg0KPERJVj4tLSZuYnNwOzwvRElWPg0KPERJVj5JJm5i
c3A7bGlrZSZuYnNwO3B5dGhvbiE8L0RJVj4NCjxESVY+VWxpUGFkJm5ic3A7ICZsdDsgJmx0O1Ro
ZSZuYnNwO1B5dGhvbiZuYnNwO0VkaXRvciAmZ3Q7ICZndDs6Jm5ic3A7PEEgDQpocmVmPSJodHRw
Oi8vd2lraS53b29kcGVja2VyLm9yZy5jbi9tb2luL1VsaVBhZCI+aHR0cDovL3dpa2kud29vZHBl
Y2tlci5vcmcuY24vbW9pbi9VbGlQYWQ8L0E+PC9ESVY+DQo8RElWPk15Jm5ic3A7QmxvZzombmJz
cDs8QSANCmhyZWY9Imh0dHA6Ly93d3cuZG9uZXdzLm5ldC9saW1vZG91Ij5odHRwOi8vd3d3LmRv
bmV3cy5uZXQvbGltb2RvdTwvQT48L0RJVj4NCjxESVY+X19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX188L0RJVj4NCjxESVY+cHl0aG9uLWNoaW5lc2U8L0RJVj4N
CjxESVY+UG9zdDombmJzcDtzZW5kJm5ic3A7cHl0aG9uLWNoaW5lc2VAbGlzdHMucHl0aG9uLmNu
PC9ESVY+DQo8RElWPlN1YnNjcmliZTombmJzcDtzZW5kJm5ic3A7c3Vic2NyaWJlJm5ic3A7dG8m
bmJzcDtweXRob24tY2hpbmVzZS1yZXF1ZXN0QGxpc3RzLnB5dGhvbi5jbjwvRElWPg0KPERJVj5V
bnN1YnNjcmliZTombmJzcDtzZW5kJm5ic3A7dW5zdWJzY3JpYmUmbmJzcDt0byZuYnNwOyZuYnNw
O3B5dGhvbi1jaGluZXNlLXJlcXVlc3RAbGlzdHMucHl0aG9uLmNuPC9ESVY+DQo8RElWPkRldGFp
bCZuYnNwO0luZm86Jm5ic3A7PEEgDQpocmVmPSJodHRwOi8vcHl0aG9uLmNuL21haWxtYW4vbGlz
dGluZm8vcHl0aG9uLWNoaW5lc2UiPmh0dHA6Ly9weXRob24uY24vbWFpbG1hbi9saXN0aW5mby9w
eXRob24tY2hpbmVzZTwvQT48L0RJVj48L0ZPTlQ+PC9ESVY+PC9CT0RZPjwvSFRNTD4NCg==

--=====003_Dragon877516578200_=====--

On 5/6/07, bbenyu <bbenyu在gmail.com> wrote:
>
>
> 请问一下, simplejson 如何使用?如何解析返回的数据呀?
>
> 我用以下代码,怎么提示is not JSON serializable的错误?
>
> def test(request, p):
>     result = ProductComment.objects.filter(p=p).values();
>     return HttpResponse(simplejson.dumps(result));
>
> 正确的是什么?他接受什么参数呀?
> 我用的是 django 0.96 自带的 simplejson.

应该看文档啊。它不能是一个字典类型，而values()正好返回一个字典，所以不行。

-- 
I like python!
UliPad <>: http://wiki.woodpecker.org.cn/moin/UliPad
My Blog: http://www.donews.net/limodou