On Tuesday, May 23, 2017 at 7:28:42 AM UTC-7, Lisandro wrote:
>
> I think I got it solved, I had to use another DAL parameter: table_hash
>
> If you look into databases folder, you will see that every .table file
> begins with a hash.
> That hash was initialy generated by web2py when the tables were created,
> the first time the models were run.
> I think that web2py generates that hash using the connection string
> parameters, such as the db username used for the connection.
>
>
> Anyway, here is what I did in APP2 to be able to connect to the APP1's
> database, using a different db username:
>
>
> # gets the table_hash from the first .table file present in the databases
> folder
> table_hash = None
> databases_folder = CONFIG.path_web2py, 'applications', 'app1', 'databases'
> )
> for tablefile in os.listdir(databases_folder):
> if tablefile.endswith('.table'):
> table_hash = archivo.split('_')[0]
> break
>
> # connects to the DB using auto_import and table_hash
> db_app1 = DAL('postgres://%s:%s@%s/%s' % ('otheruser', 'mypassword',
> 'localhost', 'george'),
> migrate=False,
> folder=databases_folder,
> auto_import=True,
> table_hash=table_hash)
>
>
>
>
> I couldn't find much in the documentation about table_hash:
>
> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#DAL-signature
>
>
Looking in gluon/packages/dal/pydal/base.py, the API documentation shows
table_hash: database identifier with .tables. If your connection hash
change you can still using old .tables if they have
db_hash
as prefix
>
> Maybe some clarification about table_hash needs to be added in the section
> "Using DAL without define tables":
>
> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Using-DAL-without-define-tables
>
I never noticed it in the signature. It doesn't seem to be needed often,
as you seem to be the first to discuss it while I've been reading the list.
> Anyway, I hope this helps if anywan runs into the same.
>
Good to have in the archives.
> Best regards,
> Lisandro.
>
/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.
