Why do you want to use multiple databases?
Check out this discussion.
http://sqlite.1065341.n5.nabble.com/Foreign-key-on-different-database-possible-td58370.html
On Wednesday, December 11, 2013 11:58:02 PM UTC-5, Copper Lark wrote:
>
> db = DAL('sqlite://storage.sqlite',pool_size=1,check_reserved=['all'])
> from gluon.tools import Auth, Crud, Service, PluginManager, prettydate
>
> auth_db = DAL('sqlite://users.sqlite')
> auth = Auth(auth_db) # Not work! - DAL not found 'user_'
>
> crud, service, plugins = Crud(db), Service(), PluginManager()
>
> ## create all tables needed by auth if not custom tables
> auth.define_tables(username=False, signature=False)
>
> ## configure auth policy
> auth.settings.registration_requires_verification = False
> auth.settings.registration_requires_approval = False
> auth.settings.reset_password_requires_verification = True
>
> db7p = DAL('sqlite://storage.sqlite',
> migrate=False,
> migrate_enabled=False,
> auto_import=True,
> folder="C:/web2py/applications/.../databases",
> )
>
> DAl object not found any others DB objects in many functions (((
> references not worked
> SQLFORM.grid not worked
> FORM not worked
> Here is error in web2py soft - not used other DAL objects
>
> среда, 11 декабря 2013 г., 23:54:43 UTC+4 пользователь Copper Lark написал:
>>
>> cooperate not work in many cases
>>
>> grid = SQLFORM.grid(db7p.deals,
>> left=db7p.deals.on(db.cl_deals.deal_id==db7p.deals.id)) # not work!
>>
>> or in table define:
>>
>> db.define_table('cl_deals',
>> Field('deal_id', db.db7p_deals), # not work!
>> ...
>>
>
--
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/groups/opt_out.
