*I will put all my tables in one app and call it a day!*
On Friday, July 6, 2012 2:40:32 PM UTC-4, Horus wrote:
>
> Right viniciusban i agree. i don't want to perform joins across
> databases explicitly i have never seen that in SQL
> BUT I can use the user id from the CAS provider to refer to other tables
> in a database
>
> let's say the *CAS* provider has this table called *auth_user* with a
> field called *id*.
> let's say I have another app called *APP1* with a table called* user_exams
> * with a field called *user_id*
>
> To make a relationship I can manually get the id from the auth_user table
> (db.auth_user)
> and then apply it to the user_exams.
>
> the *CAS* provider contains this table
>
> db.define_table('base_tags',
> Field('name', 'string', label='Tag', length=64,
> required=True, notnull=True),
> format='%(name)s'
> )
>
> *APP1* contains a this table
>
> db.define_table('places_tags',
> Field('place_id', db_app1.places, label='Place',
> required=True, notnull=True, writable=False, readable=False),
> Field('tag_id', *db_cas.base_tags*, label='Tag',
> required=True, notnull=True, writable=False, readable=False)
> )
>
> *Are you saying that Web2Py will not get id from base tags and make that
> relationship?*
>
>
>
> On Friday, July 6, 2012 1:56:47 PM UTC-4, viniciusban wrote:
>>
>> Short answer: manually.
>>
>> You cannot connect (join or make a relation) fields among different
>> databases.
>>
>>
>>
>> On 07/06/2012 02:16 PM, Horus wrote:
>> > Yes I understand CAS is for central auth, so i have let the cas
>> provider
>> > be the app that takes care of login, registration, signup, what have
>> > you; as it should
>> > the tables are being created, so I am assuming that the other apps
>> > should be able to access the tables if they exist all in the same
>> database.
>> >
>> > The underlying question, as I had added.
>> > *
>> > how does web2py perform multiple database information exchange?*
>> >
>> >
>> > On Friday, July 6, 2012 12:45:16 PM UTC-4, David Marko wrote:
>> >
>> > Well CAS is for central authentication, not for sharing database
>> > tables ... . The error you got simply says that your second app
>> cant
>> > see tables from cas provider app.
>> >
>>
>>
