No without editing gluon/sql.py and changing the value of self._db._folder. Or specify the full path to the db file
db=DAL('sqlite:///full_path/db.db') #note /// not // Massimo On Jul 16, 6:45 pm, JohnMc <maruadventu...@gmail.com> wrote: > I am following through on a suggestion Massimo offered to be able to > select particular db's. Essentially the code works quite well in a > test app -- > > # coding: utf8 > # try something like > import os > > def create(): > > files=os.listdir(os.path.join(request.folder,'databases')) > # choose a file, for example > file=files[1] > db=SQLDB('sqlite://%s'+file) > db.define_table('table1', db.Field('field1','string')) > db.define_table('table2', db.Field('field2','string')) > db.define_table('table3', db.Field('field3','string')) > return > > However looking at the process from how the application will operate > the potential is that there could be 100's of separate db's and Nx > that many tables. So I have been exploring the idea of possibly using > subdirectories of 'databases' parent to keep the layout logical. > Something like -- > > ../databases > /smythe2675476 > /harris04204 > /arnold47345 > db.db > 152345123512435145_table1.table > 356783456256745736_table2.table > 789574356737224356_table3.table > ... > ... > > Employing that idea with some test code I can get the db.db to be > created in the appropriate subdirectory. The associated tables however > end up back in the parent dir -- /databases. Is there a workaround? > > Thanks. > > JohnMc --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---