An operational error indicates the db is reporting that the table doesn't
exist in the database itself (i.e., you have a model of the table, but
there is no such table in the db).
Anthony
On Wednesday, October 22, 2014 1:03:18 PM UTC-4, Richard wrote:
>
> 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.
