求助全能的CU大侠们，web.py的自定义验证解决了，可是又出现sqlite数据库提交错误

hlsd665

官网上给的代码如下：

1.     vpass = web.form.regexp(r".{3,20}$", '密码长度3到20位字符')
   
2.     register_form = web.form.Form(
   
3.         web.form.Textbox("username", description="用户名"),
   
4.         web.form.Password("password", vpass, description="密　码"),
   
5.         web.form.Password("password2", description="密　码"),
   
6.         web.form.Button("submit", type="submit",html="添加"),
   
7.         validators = [
   
8.             web.form.Validator("两次密码不一致", lambda i: i.password == i.password2)]
   
9.         )

复制代码

我想把验证用的lambda表达式换成自己定义的方法，用于验证输入框中提交的数据在数据库中的重复

1.     client_form = web.form.Form(
   
2.         web.form.Textbox("code",web.form.notnull,description="代码"),
   
3.         web.form.Textbox("name",description="名称"),
   
4.         web.form.Button("submit",type="submit",html="添加"),
   
5.         validators = [
   
6.             web.form.Validator('代码或名称重复', m_account.validclient)]
   
7. 
   
8.         )

复制代码

验证方法m_account.validclient带有参数，按照原有lambda表达式能看出来只能给一个参数，应该是表单对象
可是象上面的方法调用时无论验证方法返回什么值，都不会通过验证。

万能的CU大侠们给看看。难死我了。拜谢了。

hlsd665

自己建个验证类继承原有验证类，解决了，可是又出现数据库提交错误。是查询和提交的时间间隔太短了，还是两次调用数据库时分别建立了两个连接造成的冲突？？？？？？？？
错误代码如下：

1. 0.0 (1): SELECT * FROM c_client WHERE years='2011' ORDER BY code
   
2. 0.0 (2): SELECT * FROM c_client WHERE code='105'
   
3. 0.02 (3): INSERT INTO c_client (code, name, years) VALUES ('105', '3213213', '2011')
   
4. 0.0 (4): SELECT last_insert_rowid();
   
5. Traceback (most recent call last):
   
6.   File "C:\Python26\lib\site-packages\web\application.py", line 242, in process
   
7.     return self.handle()
   
8.   File "C:\Python26\lib\site-packages\web\application.py", line 233, in handle
   
9.     return self._delegate(fn, self.fvars, args)
   
10.   File "C:\Python26\lib\site-packages\web\application.py", line 415, in _delegate
    
11.     return handle_class(cls)
    
12.   File "C:\Python26\lib\site-packages\web\application.py", line 390, in handle_class
    
13.     return tocall(*args)
    
14.   File "F:\workspace\dev\finance.py", line 56, in POST
    
15.     m_account.newclient(client_data.code,client_data.name,year='2011')
    
16.   File "F:\workspace\dev\model\m_account.py", line 12, in newclient
    
17.     dbh.insert('c_client',code=code,name=name,years=year)
    
18.   File "C:\Python26\lib\site-packages\web\db.py", line 744, in insert
    
19.     self.ctx.commit()
    
20.   File "C:\Python26\lib\site-packages\web\db.py", line 504, in commit
    
21.     ctx.db.commit()
    
22. OperationalError: cannot commit transaction - SQL statements in progress
    
23. 
    
24. 127.0.0.1:4275 - - [22/Jan/2011 00:04:04] "HTTP/1.1 POST /finance/clientsetup" - 500 Internal Server Error
    

复制代码

1. #coding:utf-8
   
2. import web
   
3. 
   
4. from model import m_account
   
5. 
   
6. from web import form
   
7. class revalid(form.Validator):
   
8.     def __init__(self,msg):
   
9.         self.msg = msg
   
10.    
    
11.     def valid(self, value):
    
12.         return m_account.recode(value)
    
13.    
    
14. urls = (
    
15.     '/', 'index',
    
16.     '/system','system',
    
17.     '/clientsetup','clientsetup',
    
18. )
    
19. render = web.template.render('templates/finance',base='../base')
    
20. 
    
21. 
    
22. class clientsetup:
    
23.     client_form = web.form.Form(
    
24.         web.form.Textbox("code",web.form.notnull,revalid('no requ'),description="代码"),
    
25.         web.form.Textbox("name",web.form.notnull,description="名称"),
    
26.         web.form.Button("submit",type="submit",html="添加")
    
27.         )
    
28.    
    
29.    
    
30.     def GET(self):
    
31.         clist=m_account.getclientlist('2011')
    
32.         f=self.client_form()
    
33.         return render.allsetup('客户',clist,'添加客户',f)
    
34.     def POST(self):
    
35.         f=self.client_form()
    
36.         clist=m_account.getclientlist('2011')
    
37.         if not f.validates():
    
38.             return render.allsetup('客户',clist,'添加客户',f)
    
39.         else:
    
40.             client_data = web.input()
    
41.             m_account.newclient(client_data.code,client_data.name,year='2011')
    
42.             raise web.seeother('/clientsetup')

复制代码

m_account代码如下：

1. #-*-coding:utf-8-*-
   
2. 
   
3. import web
   
4. 
   
5. import dbcon
   
6. 
   
7. dbh=dbcon.dbs()
   
8. 
   
9. def getclientlist(year):
   
10.     return dbh.select('c_client',where='years=$year',order = 'code',vars=locals())
    
11. def newclient(code,name,year):
    
12.     dbh.insert('c_client',code=code,name=name,years=year)
    
13. def recode(code):
    
14.     return not bool(dbh.select('c_client',where='code=$code',vars=locals()))
    

复制代码