Anthony,
Thank you, I do not need access to Auth yet. Having stripped the code to
the following:
import os
import sys
import datetime
import calendar
from datetime import date, time
sys.path.append("c:\python27\web2py")
from gluon.sql import *
from gluon.validators import *
module_path =
os.path.abspath(os.path.dirname('C:\\web2py\\applications\\wemanops_test\\databases'))
db_name='storage.sqlite'
db = DAL('sqlite://storage.sqlite', pool_size=1, folder=module_path,
migrate=False, check_reserved=['all'])
from gluon.tools import Crud, Service, PluginManager, prettydate
db.define_table('langu',
Field('langu', 'string'),
format='%(langu)s'
)
print db.tables
i = db(db.langu.id>0).select()
Gives an error : OperationalError: no such table: langu
While the table is seen by print db.tables
Richard D
On Wednesday, October 22, 2014 4:58:59 PM UTC+2, Richard wrote:
>
> Hi,
>
> I want to access an existing database from an outside web2py app script
> because the database must be input to Orange for data mining.
>
> I tried the following defining but dot not get access top the data:
>
> import os
>
> import sys
>
> import datetime
>
> import calendar
>
> from datetime import date, time
>
> import json
>
> import uuid
>
> sys.path.append("c:\python27\web2py")
>
>
> from gluon.sql import *
>
> from gluon.validators import *
>
>
> module_path =
> os.path.abspath(os.path.dirname('C:\\web2py\\applications\\wemanops_test\\databases'))
>
> db_name='storage.sqlite'
>
>
> db = DAL('sqlite://storage.sqlite', pool_size=1, folder=module_path,
> migrate=False, check_reserved=['all'])
>
>
> from gluon.tools import Auth, Crud, Service, PluginManager, prettydate
>
> auth = Auth(db)
>
>
> db.define_table('langu',
>
> Field('langu', 'string'),
>
> format='%(langu)s'
>
> )
>
>
> db.define_table('community',
>
> Field('com_name', 'string', length=15),
>
> Field('address', 'string'),
>
> Field('responsible', 'string'),
>
> Field('latitude', 'string', default=None),
>
> Field('longitude', 'string', default=None),
>
> #User creation can not beadded because mutial dependence of the auth Class
>
> Field('created_date', 'datetime', default=datetime.datetime.now()),
>
> format='%(com_name)s'
>
> )
>
>
> auth.define_tables(username=True, signature=True, migrate=False)
>
>
> print db(db.langu.id>0).select()
>
>
> The error I get is:
>
> Traceback (most recent call last):
>
> File "<console>", line 1, in <module>
>
> File "<string>", line 22, in <module>
>
> File "c:\python27\web2py\gluon\tools.py", line 1268, in __init__
>
> request = current.request
>
> AttributeError: 'thread._local' object has no attribute 'request'
>
>
> What is missing?
>
>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
