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.
