thanks Bruno and Anthony
I get it now.
Does it "reference" work with Postgres?
thanks
Alex
On Tuesday, January 1, 2013 6:32:53 PM UTC-8, Anthony wrote:
>
> db.define_table('PersonSkill',
> Field('person_id','reference Person'),
> Field('skill_id','reference Skill'),
> Field('YearsOfExperience','integer'))
>
> web2py knows the primary key of the referenced table, so you don't have to
> specify the name of that field. Specifying the table name is sufficient.
>
> Anthony
>
> On Tuesday, January 1, 2013 8:46:52 PM UTC-5, Alex Glaros wrote:
>>
>> can you please type out the syntax for me? mine below gets syntax
>> errors. I added the *Person*.id and *Skill*.id so it would know which
>> field in the table to reference
>>
>> db.define_table('PersonSkill',
>> Field('person_id','reference Person.id'),
>> Field('skill_id','reference Skill.id'),
>> Field('YearsOfExperience','integer'))
>>
>> does the reference command work in Postgres?
>>
>> thanks,
>>
>> Alex
>>
>> On Tuesday, January 1, 2013 5:20:01 PM UTC-8, Anthony wrote:
>>>
>>> The name of a reference does not have to be the name of the field it is
>>> referencing -- in fact, usually it is not the same name (in web2py, the
>>> referenced field is typically "id"). In web2py, it is common for the
>>> reference field to simply have the same name as the referenced table,
>>> though some people like to tack "_id" onto the end of the field name. So,
>>> in this case, field names "Person" and "Skill" would be typical, or maybe
>>> "Person_id" and "Skill_id".
>>>
>>> Anthony
>>>
>>> On Tuesday, January 1, 2013 3:46:56 PM UTC-5, Alex Glaros wrote:
>>>>
>>>> what is the syntax for renaming a reference field in order to avoid
>>>> duplicate names in a table?
>>>>
>>>> example:
>>>>
>>>> db.define_table('PersonSkill',
>>>> Field('*id*','reference Person'),
>>>> Field('*id*','reference Skill'),
>>>> Field('YearsOfExperience','integer'))
>>>>
>>>> The "id" field name would be duplicate because it is the same spelling
>>>> in Person Table and Skill Table.
>>>>
>>>> Also, does web2py reference field work in Postgres?
>>>>
>>>> thanks!
>>>>
>>>> Alex Glaros
>>>>
>>>
--
