[web2py] Re: How to create specific migrations files per sqlite database in same app
Glad I could help. I found that you better use absolute paths as soon as you want to go down to sub directories. Using '.' as the begin of the path might work, but I have not tested that. -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[web2py] Re: How to create specific migrations files per sqlite database in same app
Yep...that worked. In the meantime I did this per table definition: def migration(table): return '{0}/{1}.table'.format(tenant_folder, table) #In the tables definitions ... migrate=migration('buildings') That worked, but I like your clarification more. Thanks mate. El domingo, 15 de octubre de 2017, 11:23:53 (UTC-5), Bernhard Radermacher escribió: > > Not sure if that's the issue, but first you should use os.path.join to > join every part: > > os.path.join(request.folder, 'databases', 'clients', > 'client_{0}'.format(tenant)) > > otherwise you introduce a OS dependency. > > I would try > > con='sqlite://' + os.path.join(request.folder, 'databases', 'clients', > 'client_{0}'.format(tenant)) > db=DAL(con, pool_size) > i.e. using the complete, absolute path. > > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[web2py] Re: How to create specific migrations files per sqlite database in same app
Not sure if that's the issue, but first you should use os.path.join to join every part: os.path.join(request.folder, 'databases', 'clients', 'client_{0}'.format(tenant)) otherwise you introduce a OS dependency. I would try con='sqlite://' + os.path.join(request.folder, 'databases', 'clients', 'client_{0}'.format(tenant)) db=DAL(con, pool_size) i.e. using the complete, absolute path. -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.