Have you tried just displaying the form in your view using {{=form}}. Then
add a requires=IS_IN_DB to the fields in your model. I'd do this just to
make sure that SQLFORM.factory is working as expected. Make sense?
http://web2py.com/books/default/chapter/29/07/forms-and-validators#Database-validators
-Jim
On Tuesday, August 21, 2018 at 11:34:23 AM UTC-5, Rodrigo Gomes wrote:
>
> i really think its a bug in form.factory, i tried modify by the controller
> too, like
> form.element(_id=no_table_cities).update(_class="selectpicker")
>
> and no sucess.
>
> terça-feira, 21 de Agosto de 2018 às 13:31:38 UTC-3, Rodrigo Gomes
> escreveu:
>>
>> @auth.requires_login()
>> def students():
>> form = form=SQLFORM.factory(db.person, db.address)
>>
>> cities_list = db(db.cities.id>0).select(db.cities.ALL)
>> address_type_list = db(db.address_type.id>0).select(db.address_type.ALL)
>> person_list = db(db.person.id>0).select(db.person.ALL)
>>
>>
>> if form.process().accepted:
>> id = db.person.insert(**db.person._filter_fields(form.vars))
>> form.vars.person=id
>> id = db.address.insert(**db.address._filter_fields(form.vars))
>> redirect(URL('default','students'))
>> response.flash='Form Submetido com sucesso!'
>> elif form.errors:
>> print(form.errors)
>> print(form.vars)
>> else:
>> print('please fill out the form')
>> return dict(form=form, cities_list=cities_list,
>> address_type_list=address_type_list,
>> person_list=person_list)
>>
>>
>> terça-feira, 21 de Agosto de 2018 às 10:10:39 UTC-3, Peng Wang escreveu:
>>>
>>> How did you define your cities_list?
>>>
>>> On Thursday, August 16, 2018 at 4:39:35 PM UTC-7, Rodrigo Gomes wrote:
>>>>
>>>>
>>>> Good evening, folks, I've come here to unveil a mystery, I'm developing
>>>> an application with web2py, (framework that I use about 3 years ago)
>>>>
>>>> I am using sqlform.factory, passing 2 tables, being that I do this to
>>>> fill in a single form, table, person and address, for better understanding
>>>> follows my controller,
>>>>
>>>>
>>>> @auth.requires_login()
>>>> def students():
>>>> form = form=SQLFORM.factory(db.person, db.address)
>>>>
>>>> if form.process().accepted:
>>>> id = db.person.insert(**db.person._filter_fields(form.vars))
>>>> form.vars.person=id
>>>> id = db.address.insert(**db.address._filter_fields(form.vars))
>>>> response.flash='Form Submetido com sucesso!'
>>>>
>>>> elif form.errors:
>>>> print(form.errors)
>>>> else:
>>>> print('please fill out the form')
>>>>
>>>>
>>>>
>>>>
>>>> if it helps, this is my model, the tables and their relationships,
>>>>
>>>> db.define_table("person",
>>>> Field("name", "string", length=50),
>>>> Field("cpf", "string", length=11),
>>>> Field("birthday", "date", length=11),
>>>> Field("email","string", length=40),
>>>> Field("registration_date","date", length=40)
>>>> )
>>>>
>>>> db.define_table("cities",
>>>> Field("name", "string"),
>>>> Field("state","reference state")
>>>> )
>>>>
>>>> db.define_table("address_type",
>>>> Field("type","string",length=100),
>>>> )
>>>>
>>>> db.define_table("address",
>>>> Field("number","integer"),
>>>> Field("public_place","string"),
>>>> Field("cep","string",length=15),
>>>> Field("complement","string"),
>>>> Field("cities",'reference cities'),
>>>> Field("address_type",'reference address_type'),
>>>> Field("person",'reference person', writable=False,readable=False)
>>>> )
>>>>
>>>>
>>>>
>>>>
>>>> This is my view
>>>>
>>>> <form action="#" class="form-material" enctype="multipart/form-data"
>>>> method="post">
>>>> <div class="form-group">
>>>> <div class="col-md-12 m-b-20">
>>>> <!--form.custom.widget.name -->
>>>> <input class="form-control" id="no_table_name" name="name"
>>>> type="text" placeholder="nome">
>>>> </div>
>>>> <div class="col-md-12 m-b-20">
>>>> <!--form.custom.widget.cpf -->
>>>> <input class="form-control" id="no_table_cpf" name="cpf"
>>>> type="text" placeholder="cpf">
>>>> </div>
>>>>
>>>> <div class="col-md-12 m-b-20">
>>>> <!--form.custom.widget.email -->
>>>> <input class="form-control" id="no_table_email"
>>>> name="email" type="text" placeholder="email">
>>>> </div>
>>>>
>>>> <div class="col-md-12 m-b-20">
>>>> <!-- <select class="form-control generic-widget"
>>>> id="no_table_address_type" name="address_type"><option
>>>> value="">Vazio</option><option value="1">Comercial</option><option
>>>> value="2">Residencial</option></select> -->
>>>>
>>>> <select class="form-control selectpicker"
>>>> id="no_table_address_type" name="address_type" data-style="btn-info
>>>> btn-outline-info">
>>>>
>>>> {{for t in address_type_list:}}
>>>> <option value="{{=t.id}}">{{=t.type}}</option>
>>>> {{pass}}
>>>> </select>
>>>> </div>
>>>> <div class="col-md-12 m-b-20">
>>>> <select id="no_table_cities" name="cities"
>>>> data-style="btn-info btn-outline-info" required>
>>>> {{for city in cities_list:}}
>>>> <option value="{{=city.id}}" >{{=city.name}}</option>
>>>> {{pass}}
>>>> </select>
>>>> </div>
>>>>
>>>> <!--form.custom.end -->
>>>> <div class="hidden">
>>>> {{=form.hidden_fields()}}
>>>> </div>
>>>> </div>
>>>>
>>>> <div class="modal-footer">
>>>> <input class="btn btn-info" type="submit" value="Salvar">
>>>> <button type="button" class="btn btn-default waves-effect"
>>>> data-dismiss="modal">Cancelar</button>
>>>> </div>
>>>> </div>
>>>> </form>
>>>>
>>>>
>>>>
>>>>
>>>> now the problem: this selectpicker, simply my form can not store the
>>>> value of select, when I add this class, I needed it, I do not need it that
>>>> much, but it became a mission to understand what's happening here, I gave
>>>> a
>>>> print em form. vars.cities and she's just like None, help please
>>>>
>>>> <Storage {'name': 'maria', 'cpf': '09102910', 'birthday': None,
>>>> 'email': 'rodg...@gmail.com', 'registration_date' public_place ':' ','
>>>> '' '' '' '' '' '' '' '' '' 'cities': None, 'address_type': None, 'person':
>>>> 4}>
>>>>
>>>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
