thanks !
On Thu, Nov 18, 2010 at 5:24 PM, mart <[email protected]> wrote:
> Hey,
>
> It took me a few tries before getting this to work. So, I see 2 things
> that you may want to try to look at:
>
> 1) I don't really use windows, but I think the first line is
> problematic. (unless more recent windows versions have gotten smarter
> about slashes?).
>
> >>> dbfolder='C:\web2py\web2py\applications\teqb\databases'
> >>> db = dal.DAL('sqlite://storage', folder=dbfolder)
>
> should be:
>
> >>> dbfolder='C:/web2py/web2py/applications/teqb/databases'
> (or you can escape the back slash (C:\\web2py\\web2py\\...))
>
> 2) I remember importing DAL was a little finicky (sometimes). SO, you
> may want to try drilling down one more level in you import:
>
> instead of
> >>> db = dal.DAL('sqlite://storage', folder=dbfolder)
>
> you may want to try:
> from <yourPath>.gluon.dal import DAL
> >>> db = DAL('sqlite://storage', folder=dbfolder)
>
>
> I do the following without any problems on Mac, linux and windows: I
> have 2 instances of web2py, some both running on the same machine, so
> stand alone is renamed with "blue" prefixes (blueDAL, bluedb,
> blueTHIS, blueTHAT, etc. and gluon is renamed to blueSQL in case they
> run 2 different versions of web2py, I want to quickly and visually set
> them apart when reading script.
>
>
> tail,head = os.path.split(sys.argv[0])
>
> dataFiles = ["storage.sqlite",
> "sql.log"]
> dbFolder = "{0}/blueLite/db_storage".format(tail)
>
> try:
> for f in os.listdir(dbFolder):
> if ".table" in f:
> fTable = "{0}/{1}".format(dbFolder,f)
> os.remove(fTable)
> print("removed {0}".format(fTable))
> for dFile in dataFiles:
> os.remove("{0}/blueLite/db_storage/{1}".format(tail,dFile))
> print("removed {0}/blueLite/db_storage/
> {1}".format(tail,dFile))
> except Exception as errObj:
> print(str(errObj))
>
> from blueLite.pyUtils.sql.blueSQL.dal import DAL as blueDal
> from blueLite.pyUtils.sql.blueSQL.dal import SQLField
> bluedb = blueDal("sqlite://storage.sqlite", folder="{0}/blueLite/
> db_storage".format(tail))
> bluedb.define_table('cmdObjects',
> SQLField('name'),
> SQLField('pyModule'),
> SQLField('pyPath'),
> SQLField('cmdProperties','blob'),
> SQLField('dict_objCmd','blob'),
> SQLField('dfo_objCmd', 'blob'),
> SQLField('etree_objCmd','blob'))
> bluedb.commit()
>
> Then I pass bluedb to all other classes which is why I use the full
> path when pointing to the DB folder (NEVER relative).
> hope it helps.
>
>
> Mart :)
>
> On Nov 18, 9:56 am, Ole Martin Maeland <[email protected]> wrote:
> > Hi Massimo,
> >
> > I have administrator access on the folder. The database is running a
> small
> > web2py application that is crypted. Do I have to pass the crypt string to
> > the db, or do I have to use administrator password in order to access it.
> >
> > I reach it by using SQLite Manager..
> >
> > regards
> > Martin
> >
> >
> >
> > On Thu, Nov 18, 2010 at 3:06 PM, mdipierro <[email protected]>
> wrote:
> > > I think you do not have write access on this file/folder
> >
> > > On Nov 18, 7:36 am, Ole Martin Maeland <[email protected]> wrote:
> > > > Hi,
> >
> > > > I am trying to connect to sqlite db that works fine with a small
> web2py
> > > > applicaiton.
> >
> > > > connection parameters:
> >
> > > > >>> dbfolder='C:\web2py\web2py\applications\teqb\databases'
> > > > >>> db = dal.DAL('sqlite://storage', folder=dbfolder)
> >
> > > > error message:
> >
> > > > Traceback (most recent call last):
> > > > File "<interactive input>", line 1, in <module>
> > > > File "C:\Python27\lib\site-packages\gluon\dal.py", line 2031, in
> > > __init__
> > > > self._logger = Logger(folder)
> > > > File "C:\Python27\lib\site-packages\gluon\dal.py", line 140, in
> > > __init__
> > > > self.file = open(os.path.join(folder,name),'a')
> > > > IOError: [Errno 22] invalid mode ('a') or filename:
> > > > 'C:\\web2py\\web2py\x07pplications\teqb\\databases\\sql.log'
> >
> > > > any ide how I could get this to work?
> >
> > > > regards
> > > > Martin
> >
> > --
> > Hilsen
> > Ole Martin
> > Mob: 95227471
>
--
Hilsen
Ole Martin
Mob: 95227471
