How are you doing the insert? Is it via application code during an HTTP
request, or in the shell or a script. If the latter, you need to call
db.commit() to commit any changes to the database (this is done
automatically in the context of HTTP requests).
Anthony
On Thursday, May 12, 2016 at 4:57:29 AM UTC-4, Sandro Javiel wrote:
>
> Hi all,
>
> My app has model as shown below. If I use appadmin interface I can insert
> on tables which have some onstraints like classroom (fk: professor.id and
> institution.id). However using form
>
> =FORM('Nome da turma:', INPUT(_name='name', requires=IS_NOT_EMPTY()),
> 'Disciplina:',INPUT(_name='subject',
> requires=IS_NOT_EMPTY()),
> T('Professor Id:') ,INPUT(_name='professor_id',
> _id='professor_id', value=professor_id),
> T('Institution Id') ,INPUT(_name='professor_inst_id',
> _id='professor_inst_id', value=professor_inst_id),
> INPUT(_type='submit'))
>
> The line
> db.classroom.insert(institution=request.vars.professor_inst_id,
> professor=request.vars.professor_id, subject=request.vars.subject, name=
> request.vars.name)
>
> produces no error but I have no effect in DB. I would like to understand
> difference between appadmin inserts and the one I just described. Is there
> some way to log every single sql execution? Any other suggestion or
> complain about my code?
>
> Tkx in advance.
>
>
> =====================================
> db.define_table('institution',
> Field('image','blob'),
> Field('country', default='Brasil'),
> Field('name'))
>
> db.define_table('professor',
> Field('username'),
> Field('photo', 'upload'),
> Field('email'),
> Field('name'),
> Field('institution',db.institution))
>
> db.define_table('dog',
> Field('name'),
> Field('photo', 'upload'),
> Field('description', 'text'),
> Field('institution', db.institution),
> Field('professor',db.professor))
>
> db.define_table('config',
> Field('name'),
> Field('ssid'),
> Field('password'),
> Field('institution',db.institution ))
>
>
> db.define_table('classroom',
> Field('institution',db.institution),
> Field('professor', db.professor),
> Field('subject'),
> Field('dog_list'),
> Field('name'))
>
>
> db.define_table('bodypoint',
> Field('institution',db.institution),
> Field('classroom', db.classroom),
> Field('code', default='m'),
> Field('delimiter_chars', default='<>'),
> Field('description','text'),
> Field('name'))
>
> db.define_table('actions',
> Field('institution',db.institution),
> Field('classroom',db.classroom),
> Field('professor', db.professor),
> Field('dog', db.dog),
> Field('query_string'),
> Field('is_active', 'boolean', default=True))
>
> db.professor.institution.requires = IS_IN_DB(db,'institution.id',
> '%(name)s')
> db.dog.institution.requires = IS_IN_DB(db,'institution.id', '%(name)s')
> db.dog.professor.requires = IS_IN_DB(db,'professor.id', '%(name)s')
> db.config.institution.requires = IS_IN_DB(db,'institution.id', '%(name)s')
> db.classroom.institution.requires = IS_IN_DB(db,'institution.id
> ','%(name)s')
> db.classroom.professor.requires = IS_IN_DB(db,'professor.id','%(name)s')
> db.bodypoint.institution.requires = IS_IN_DB(db,'institution.id
> ','%(name)s')
> db.bodypoint.classroom.requires = IS_IN_DB(db,'classroom.id','%(name)s')
> db.actions.institution.requires = IS_IN_DB(db,'institution.id','%(name)s')
> db.actions.professor.requires = IS_IN_DB(db,'professor.id','%(name)s')
> db.actions.classroom.requires = IS_IN_DB(db,'classroom.id','%(name)s')
> db.actions.dog.requires = IS_IN_DB(db,'dog.id','%(name)s')
>
>
>
--
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/d/optout.
