No problem with web2py 1.91.6 on Windows, SQLite.
Anthony <abasta...@gmail.com> wrote: > You're right, db selects do not appear to be working in the web-based > shell, at least not on Windows using SQLite. Are you sure it used to work > (specifically on Windows) -- I haven't tried it in a while, but I seem to > recall having problems with this a long time ago? I always use a standard > OS shell instead. > > Anthony > > On Thursday, March 15, 2012 3:14:56 PM UTC-4, Stefan Scholl wrote: >> >> Sorry, my "bug report" was a bit short. Was called to a meeting 5 >> minutes earlier than planned. >> >> I tested this with the example app because I wanted a clear test >> case. The bug was first seen in a bigger applicationi(, where I >> wanted to see why the common_filter feature only worked in the >> database admin interface and not in simple queries inside the >> app.) >> >> >> Person and dog inserted via database admin. After that the shell >> from the admin interface was used. The variable dogs was >> undefined after that. And no output with just >> "db().select(db.dog.ALL)". >> >> >> This isn't the case with older versions. I don't know which >> version first had this bug. Maybe I'm the only one using this >> interactive shell on the web interface. >> Somewhere between 1.91.x and 1.99.7 >> >> >> Anthony <abasta...@gmail.com> wrote: >> > >> > Did you do the insert in the shell also? If so, when you do inserts, >> > updates, deletes in the shell, you have to follow with db.commit() in >> order >> > to commit the transaction. This is not necessary in application code >> > because the framework does that automatically at the end of a request. I >> > have also found that in some cases, the web-based shell in admin does >> not >> > work for database transactions, so you may need to use a regular OS >> shell. >> > >> > Anthony >> > >> > On Thursday, March 15, 2012 4:12:10 AM UTC-4, Stefan Scholl wrote: >> >> >> >> web2py 1.99.7 for Windows. >> >> >> >> Example app, inserted 1 person and 1 dog. >> >> >> >> In the shell: >> >> >> >> dogs = db().select(db.dog.ALL) >> >> >> >> >> >> Nothing there. And "dogs" isn't defined. >> >>
