@Mattew J Watts,
#Model
db.define_table('person',
Field('name'),
Field('age'),
Field('country'),
format='%(name)s')
db.define_table('thing',
Field('person_id,'reference preson')
Field('thing_name'),
Field('value'),
Field('location'))
#controller
def import_csv():
form = FORM(DIV(LABEL('file
input',_for='exampleInputFile'),INPUT(_type='file',_name='csvsheet',_id="exampleInputFile"),_class='from-group'),BUTTON('click',_type='submit',_class="btn
btn-default"))
if form.process().accepted:
try:
for i in csv.DictReader(request.vars.csvsheet.file):
# db['things'].insert(person_id= db['person'].insert(**i)
,.........)
a = db['person'].insert(**i)
db['things'].insert(person_id=a,.........)
except:
form.errors.csvfile = 'Invalid file format.'
return locals()
Hope, this will help you!
Best/
On Wed, Aug 1, 2018 at 12:51 AM Anthony <[email protected]> wrote:
> On Tuesday, July 31, 2018 at 2:24:51 PM UTC-4, pbreit wrote:
>>
>> I know db.thing.insert will return the ID of the newly created record and
>> am pretty sure update_or_insert does as well. I'm not exactly sure how you
>> would determine if an update or insert was performed (but perhaps you do
>> not need to know?).
>>
>
> Actually, update_or_insert does *not* return the ID in case of an update.
> If you need the ID, then don't use update_or_insert but instead write your
> own logic (the method is fairly simple -- see
> https://github.com/web2py/pydal/blob/c954d1a22a0b83d90f728a4ab2daaa954e3f16c8/pydal/objects.py#L822
> ).
>
> Anthony
>
> --
> 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.
>
--
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.
