Anybody see anything wrong with the second controller below that gets
called by the first one?
The error is that no data gets written to table IdeaComment, but if I
substitute "smartgrid" for "factory", all suggestions instead of just the
one selected in the first controller get displayed, and forces me to
re-choose a suggestion, then it writes it correctly.
No errors displayed when "factory" is used in second controller, but no
record is written.
Controller
@auth.requires_login()
def add_suggestion_comments(): ## This controller selects a suggestion
record (db.Idea) and passes selection to controller comment_on_a_suggestion
below.
db.Suggestion.ideaID.represent = lambda id, r: A(db.Idea(id).ideaTitle,
_href=URL('comment_on_a_suggestion', vars=dict(filter=id)))
query = ((db.Suggestion.ideaID == db.Idea.id))
suggestionList =
SQLFORM.grid(query,create=True,editable=True,deletable=True,
details=True,links_in_grid=True, paginate=10,
fields=[db.Suggestion.ideaID, db.Idea.ideaShortSummary],
maxtextlength={db.Idea.ideaShortSummary:140})
return dict(suggestionList = suggestionList)
@auth.requires_login() ## This controller receives Idea.id parm from
add_suggestion_comments controller above. It then writes user comments to
table db.IdeaComment
def comment_on_a_suggestion():
db.IdeaComment.ideaID.readable = True
db.IdeaComment.ideaID.writable = False
db.auth_user.partyID.readable = db.auth_user.partyID.writable = False
db.IdeaComment.ideaID.default = request.vars.filter
db.IdeaComment.ideaStageID.default = 1 ## make default 'Suggestion'
db.IdeaComment.ideaStageID.readable =
db.IdeaComment.ideaStageID.writable = False
form=SQLFORM.factory(db.IdeaComment)
if form.process().accepted:
response.flash='Thanks for adding a comment to a suggestion.'
return dict(form=form)
Model
db.define_table('IdeaComment', ## lets any registered user make a commment
on suggestion
Field('ideaID','reference Idea'),
Field('partyID','reference Party', label='Commenter', comment='Party that
is commenting'), ## this is commenter. Has to be logged on.
Field('ideaStageID','reference IdeaStageLookupTable', comment='What stage
of the idea do you want to comment on? Suggestion, proposal, effort,
project, program?'),
Field('ideaComment','string', label='Comment', comment='Your comments'),
Field('personClassCode','reference PersonClass', comment='In what capacity
are you making this comment?'))
## ---------------------------------------------------
db.define_table('Idea',
Field('ideaTitle','string', length=140, label='Idea Title', comment='140
characters max'),
Field('ideaShortSummary','string', length=280, label='Summary info',
comment='short summary - 280 characters max'),
Field('ideaStageID','reference IdeaStageLookupTable', label='Idea Stage',
comment='Idea stage may be part of a series of stages of an idea:
Suggestion, Proposal, Effort, Project, and Program. (1) Suggestion - The
first time an idea is presented; the original concept (2) Proposal - a
specific plan to fully implement and idea by a specific party (3) Effort -
the work done on a proposal such as evaluation before the effort is
transformed into a project. It may never transform into a project, in
which case it can be categorized as a task or series of tasks (4) Project -
sequence of tasks, planned from beginning to end, bounded by time, i.e.,
has start and end date, resources, and required results, defined outcome
and "deliverables" (5) Program - a permanent or long-term re-occurring
event, such as the "Head-Start Program" or a warehouse inventory system.'))
## ---------------------------------------------------
db.define_table('Suggestion',
Field('ideaID', 'reference Idea',label='Suggestion Idea ID'), ## not sure
if this should not be objectID: Field('objectID', 'reference
ObjectSuperType'),
Field('objectID', 'reference ObjectSuperType'), ## harmless redundancy, but
keeps my options open
Field('IPcreatedBy','string'),
Field('partyID','reference Party', label='Party making the suggestion'), ##
need to make this limited to what person's party capacities are
Field('personClassCode','string'))
thanks,
Alex Glaros
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
