On Wednesday, October 31, 2018 at 9:21:57 AM UTC-7, Ben Duncan wrote:
>
> In the books and the online manuals I see foreign key references as ( from
> my table):
>
> db.define_table('gl_chart',
> Field('company_number', 'reference company', ondelete='CASCADE'),
> Field('gl_account_num', type='string', length=20), .....
>
> But the extract_pgsql_models.py does a version like this:
>
> db.define_table('gl_chart',
> Field('company_number', type='reference company', ondelete='CASCADE'),
> Field('gl_account_num', type='string', length=20), ........
>
> Which is correct just the 'reference xyz' or the type='reference xyz' ?
>
> Thanks ...
> Ben Duncan
>
Both are. "type" is the second parameter for Field(), so as long as you
don't give "fieldname" as a named parameter, you can specify "type" as a
positional parameter, or you can specify it (and any following parameters)
as a named parameter. "ondelete" is almost always a named parameter
because of skipping the parameters in between "type" and "ondelete".
/dps
--
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.
