Thanks for your response Villas. My reason for this approach is that i have
a lot of code that expects a table object and i am trying to avoid having
to modify it to handle the a different format.
Anthony on Stack Exchange found my error. He said:
"You probably also set DAL(..., lazy_tables=True), in which
case, db.define_table() returns None rather than a Table object, as the
table is not actually created until first accessed via db.tablename.
Given your code, there is no benefit to setting lazy_tables=True, as all
tables are accessed (and therefore created) immediately after definition
anyway."
On Thursday, 16 July 2020 at 03:43:40 UTC+10 villas wrote:
> You don't mention...
>
> - Which DB adapter you are using
> - Why just one of your tables is expected to be an in-memory table and
> the others not
> - Why you don't simply maintain the list of tables in a list(), or
> dict() or some other in-memory structure
>
> In any case, maybe this idea might help...
>
> db = DAL("sqlite://storage.sqlite") # or whichever DB you are using
> dbmemo = DAL("sqlite:memory")
>
> dbmemo.define_table('DatabaseModel', Field('TableName'))
>
> for t in db.tables:
> dbmemo.DatabaseModel.update_or_insert(TableName=t)
>
>
> On Wednesday, 15 July 2020 07:45:36 UTC+1, Andrew Rogers wrote:
>>
>> This code working fine but now it fails because the db.define_table()
>> returns None.
>>
>> table = db.define_table('DatabaseModel', Field('TableName')) # This is
>> not working now
>> for t in db.tables:
>> table.update_or_insert(TableName=t)
>>
>> The only thing that I think I have changed that might have affected it
>> was setting migrate = false in appconfig.ini. I have changed it back but
>> to no avail.
>>
>> What could stop db.define_table from returning a table?
>>
>> (I am using this to create an in-memory table which I populate with a
>> list of actual tables.)
>>
>> Thanks.
>>
>> PS:
>> https://stackoverflow.com/questions/62908908/under-what-circumstances-would-db-define-table-return-none
>>
>
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/8d6e206b-d6dd-4115-9391-4bbd5553a3d9n%40googlegroups.com.
