批处理脚本：关闭空间和用户输入的某些字符(Batch Script: Closes on space and certain characters from user input)

 我的表单太具体了（它应该是客户端而不是client_id），所以我的工作代码如下所示： 
 
 会议： 
 
from zope.sqlalchemy import ZopeTransactionExtension

DBSession = scoped_session(sessionmaker(extension=ZopeTransactionExtension()))
Base = declarative_base()
 
 模型： 
 
class Client(Base):
     __tablename__ = 'client'
     id = Column(Integer, primary_key=True, nullable=False)
     name = Column(Unicode(48))
     street = Column(Unicode(48))
     city = Column(Unicode(32))
     task = relationship("Task", backref="client")

    @classmethod
    def active(cls):
        return DBSession.query(Client).options(load_only("id", "name")).order_by(sa.desc(Client.name)).filter(Client.status == True)


class Task(Base):
    __tablename__ = 'task'
    id = Column(Integer, primary_key=True, nullable=False)
    name = Column(String(48))
    status = Column(Boolean)
    client_id = Column(Integer, ForeignKey('client.id'))
 
 形成： 
 
def enabled_client():
    return Client.active()

class TaskCreateForm(ModelForm):
    name = TextField('Task name', [validators.Length(min=1, max=48)], filters=[strip_filter])
    status = BooleanField('Status')
    client = QuerySelectField('Client', query_factory=enabled_client, get_label='name', allow_blank=False)
 
 视图： 
 
@view_config(route_name='task_action', match_param='action=create', renderer='arx:templates/task_edit.mako', permission='edit')
def task_create(request):
    task = Task()
    form = TaskCreateForm(request.POST)
    if request.method == 'POST' and form.validate():
        form.populate_obj(task)
        DBSession.add(task)
        return HTTPFound(location=request.route_url('home'))
    return {'form':form, 'action':request.matchdict.get('action')}

My form was too specific (it should be client instead of client_id), so my working code looks like this:
 
Session:
 
from zope.sqlalchemy import ZopeTransactionExtension

DBSession = scoped_session(sessionmaker(extension=ZopeTransactionExtension()))
Base = declarative_base()
 
Model:
 
class Client(Base):
     __tablename__ = 'client'
     id = Column(Integer, primary_key=True, nullable=False)
     name = Column(Unicode(48))
     street = Column(Unicode(48))
     city = Column(Unicode(32))
     task = relationship("Task", backref="client")

    @classmethod
    def active(cls):
        return DBSession.query(Client).options(load_only("id", "name")).order_by(sa.desc(Client.name)).filter(Client.status == True)


class Task(Base):
    __tablename__ = 'task'
    id = Column(Integer, primary_key=True, nullable=False)
    name = Column(String(48))
    status = Column(Boolean)
    client_id = Column(Integer, ForeignKey('client.id'))
 
Form:
 
def enabled_client():
    return Client.active()

class TaskCreateForm(ModelForm):
    name = TextField('Task name', [validators.Length(min=1, max=48)], filters=[strip_filter])
    status = BooleanField('Status')
    client = QuerySelectField('Client', query_factory=enabled_client, get_label='name', allow_blank=False)
 
View:
 
@view_config(route_name='task_action', match_param='action=create', renderer='arx:templates/task_edit.mako', permission='edit')
def task_create(request):
    task = Task()
    form = TaskCreateForm(request.POST)
    if request.method == 'POST' and form.validate():
        form.populate_obj(task)
        DBSession.add(task)
        return HTTPFound(location=request.route_url('home'))
    return {'form':form, 'action':request.matchdict.get('action')}