[web2py] Standalone DAL, where is the database folder ? and problems caused by

[Stef Mientki]

hello,

the more I get used to the syntax of DAL,
the more I like it, great !

especially, after splitting up the queries and making some helper functions, 
like this
    Module = 'D2_D1'
    Query  = ( DB.Module.id     == DB.PRID_MID.MID  ) & \
             ( DB.Project.id    == DB.PRID_MID.PRID ) & \
             ( DB.Afdeling.id   == DB.Project.AID   ) & \
             ( DB.Module.Module == Module           )
    Select = DB.Project.Name, DB.Afdeling.Name, DB.Project.id
    print Get_Table_Data ( DB, Query, Select )[1:]
    print Get_Single_List ( DB, Query, Select )
    print Get_Data_Dict ( self.DB.Level )

too bad we can't use the normal "and" notation :-(


My question is where is the database folder (it seems to be everywhere ;-) ?
Can it be set explicitly ? 

It seems that the sql-log-file and the .table files are written in the CWD.
As a workaround I now keep track of the cwd,
and if I use "define_table" I first set the cwd to the database directory.
But I assume there are more actions where the cwd need to be set to the 
database folder,
so I expect more problems/

I use the following to create the database:
    Database_Name = r'D:\Data_Python_25\Beheer\ID_TO_Beheer_DAL.db'
    My_DB = DAL ( 'sqlite://' + Database_Name )
 


thanks,
Stef Mientki