On Sat, Feb 9, 2013 at 6:28 AM, Niphlod <niph...@gmail.com> wrote:
> dal has no introspection (i.e. it doesn't ask any "schema" information, nor
> it tries to "calculate" it).
>
> until you define your tables (or do DAL(...., auto_import=True)) DAL will
> never know that a table exists.
Unfortunately that didn't work…
In [1]: db = DAL('sqlite://myapp2.sqlite', pool_size=1,
check_reserved=['all'], auto_import=True)
---------------------------------------------------------------------------
TypeError Traceback (most recent call last)
<ipython-input-3-2e594e209033> in <module>()
----> 1 db = DAL('sqlite://myapp2.sqlite', pool_size=1,
check_reserved=['all'], auto_import=True)
web2py\gluon\dal.pyc in __init__(self, uri, pool_size, folder,
db_codec, check_reserved, migrate, fake_migrate, migrate_
enabled, fake_migrate_all, decode_credentials, driver_args,
adapter_args, attempts, auto_import, bigint_id, debug, lazy_tables,
db_uid, do_connect)
7228 if auto_import or dbdict:
7229 self.import_table_definitions(adapter.folder,
-> 7230 items=dbdict["items"])
7231
7232 @property
TypeError: 'NoneType' object has no attribute '__getitem__'
> On Friday, February 8, 2013 5:14:22 PM UTC+1, Alec Taylor wrote:
>>
>> Fully self contained example:
>>
>> >web2py.py -p 80 -S myapp2
>>
>> web2py Web Framework
>> Created by Massimo Di Pierro, Copyright 2007-2013
>> Version 2.4.1-alpha.2+timestamp.2013.02.07.05.36.19
>> Database drivers available: SQLite(sqlite3), MySQL(pymysql),
>> PostgreSQL(pg8000), Oracle(cx_Oracle), MongoDB(pymongo), IMAP(imaplib)
>> Python 2.7.3 (default, Apr 10 2012, 23:24:47) [MSC v.1500 64 bit (AMD64)]
>> Type "copyright", "credits" or "license" for more information.
>>
>> In [1]: db = DAL('sqlite://myapp2.sqlite', pool_size=1,
>> check_reserved=['all'])
>>
>> In [2]: db.tables
>> Out[2]: []
>>
>> In [3]: db.define_table('examples_are_awesome', Field('foo'))
>> Out[3]: <Table examples_are_awesome (id,foo)>
>>
>> In [4]: db.commit() # tried with + without this line
>>
>> In [5]: db.tables
>> Out[5]: ['examples_are_awesome']
>>
>> In [6]: exit
>>
>> >web2py.py -p 80 -S myapp2
>>
>> web2py Web Framework
>> Created by Massimo Di Pierro, Copyright 2007-2013
>> Version 2.4.1-alpha.2+timestamp.2013.02.07.05.36.19
>> Database drivers available: SQLite(sqlite3), MySQL(pymysql),
>> PostgreSQL(pg8000),
>> Oracle(cx_Oracle), MongoDB(pymongo), IMAP(imaplib)
>> Python 2.7.3 (default, Apr 10 2012, 23:24:47) [MSC v.1500 64 bit (AMD64)]
>> Type "copyright", "credits" or "license" for more information.
>>
>> In [1]: db = DAL('sqlite://myapp2.sqlite', pool_size=1,
>> check_reserved=['all'])
>>
>> In [2]: db.tables()
>> Out[2]: []
>>
>> On Sat, Feb 9, 2013 at 3:07 AM, Alec Taylor <alec.t...@gmail.com> wrote:
>> > Experiencing some very strange errors on the latest web2py
>> > (2.4.1-alpha.2+timestamp.2013.02.07.05.36.19).
>> >
>> > In my 'myapp2' application I have created a database, defined as
>> > follows:
>> >
>> > db = DAL('sqlite://mydb2.sqlite', pool_size=1, check_reserved=['all'])
>> >
>> > Now I defined some tables and inserted some data into it. (all from
>> > the \modules folder)
>> >
>> > To confirm the tables and data exists I opened up the 5KB SQLite file
>> > in two different external database programs, including the SQLite
>> > Manager firefox extension.
>> >
>> > It was all there.
>> >
>> > But one of my functions in that same \modules folder couldn't find an
>> > entry in the db (the db DAL object was sent from \controllers though).
>> >
>> > So from my code (and subsequent from $web2py.py -S myapp2) I ran
>> > db.tables and got [].
>> >
>> > The exact same connection string is used throughout my code; so why
>> > isn't this working?
>> >
>> > Thanks for all suggestions,
>> >
>> > Alec Taylor
>> >
>> > PS: Searching my entire web2py directory brought up only one sqlite
>> > file named 'mydb2'
>
> --
>
> ---
> 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 web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
--
---
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
