1) "Views" in sqlite:

   sqlite does not have ALTER TABLE ... DROP COLUMN so that explains
the "extra" fields.

2) Thanks for the ipython suggestion and the SQLDB._instances
explanation.
   What I find obscure is the use of SQLBD._instances by itself.
   SQLDB is a class and yes, it has an attribute named _instances, so
far so good.
   Defined databases are instances of SQLDB and I would understand the
use of dbA._instances but SQLDB._instances?.

3) In the meantime to find the defined databases I came up with
something like this:

DBs={}
DBtype=type(SQLDB())
for n in globals():
  if type(globals()[n])==DBtype:
    DBs[n]=globals()[n]

I think I needed something like this a while back...

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to