isn't simply that you added test 7 with a NULL into the "updated" field instead of an empty value , i.e. '' ?
On Monday, April 18, 2016 at 4:23:23 PM UTC+2, DenesL wrote: > > Your private test script works fine for me on web2py 2.14.05 with rocket > and ms sqlserver. > > In your post it says "test module" but I have the db & table in the models. > > Denes > > > On Saturday, April 16, 2016 at 12:53:35 AM UTC-4, David wrote: >> >> Let me start by saying Web2py is awesome and I'm excited about the >> capabilities of this program. >> >> I have run into an issue that I will layout here: >> >> Problem Statement: When running web2py with mySQL (XAMPP v3.2.2) and >> running background queries the db().select statement doesn't pull a fresh >> copy, but seems to pulled from a chaced copy of the database. I can >> perform a row.update_record succesfully which, but any new inserts into the >> database from the website don't show in the query. >> >> Background: I had this working with SqlLite, but migrated to mySQL to >> improve the amount of concurrent connections I was making. >> >> I'm running Web2py like this: >> >> web2py.exe -S appname -M -R c:\web2py\applications\appname\private\test.py >> >> -------------------------------- >> -----------test module------------ >> db.define_table('tests', >> Field('test'), #This field I'm adding manually >> Field('updated'), #This field is being updated by the >> script. >> ) >> >> >> >> -------------------------------- >> -----------test.py------------ >> >> >> import time >> count = 0 #Used to show the count >> while True: >> count = count+ 1 >> print 'This is a Test while True:' >> try: >> results = db(db.tests.updated=='').select() >> except: >> print 'Failed to get results' >> if results: >> print 'Test = True' >> print 'Count: %s' % count >> print results >> for row in results: >> print 'Id: %s Test: %s Updated: %s' % (row.id,row.test,row. >> updated) >> row.update_record(updated='Yes') >> db.commit() >> print 'Completed' >> else: >> print 'Test = False' >> print 'Count: %s' % count >> print 'waiting 10' >> print results >> print'All database' >> print db(db.tests.id>0).select() >> time.sleep(10) >> >> >> Steps I'm taking. >> >> >> >> >> >> 1. Add two records to the test database (through the appadmin >> interface) >> >> >> <https://lh3.googleusercontent.com/-gCL70nImHDM/VxEUv8iCJuI/AAAAAAAAAMo/Di2VMOHVpgAPGgNsXchXjQkVkqk7npYigCLcB/s1600/Screen%2BShot%2B2016-04-15%2Bat%2B12.19.37%2BPM.png> >> 2. Starting the python script with :web2py.exe -S appname -M -R >> c:\web2py\applications\appname\private\test.py >> >> >> <https://lh3.googleusercontent.com/-mytT2xS3Kfw/VxEVMMJ6cSI/AAAAAAAAAMw/U289SNl82H45ZDMEsSl9VetaVTV1GhvPACLcB/s1600/Screen%2BShot%2B2016-04-15%2Bat%2B12.21.40%2BPM.png> >> 3. From this point It updates the blank field with a 'Yes'. Then in >> starts looping through and checking if any new records are in the >> database >> and blank >> It does sucesssfully update the record with >> row.update_record(updated='Yes') >> 4. I insert another record Test 7 into the database leaving the >> updated field blank >> 5. The script has continued to run, but never sees the new Test 7. >> It continues to only see the Test 6 as the last record. >> I am able to see the Test 7 from the appadmin interface. >> >> I have checked mysql and caching is turned off. I'm using the default >> config of XAMPP. >> >> Any assistance would be greatly appreciated. I'm starting to feel like >> this might be a bug within Web2py? >> >> >> ------------------------------ >> The information transmitted, including any attachments, is intended only >> for the person or entity to which it is addressed and may contain >> confidential and/or privileged material. Any review, retransmission, >> dissemination or other use of, or taking of any action in reliance upon, >> this information by persons or entities other than the intended recipient >> is prohibited, and all liability arising therefrom is disclaimed. If you >> received this in error, please contact the sender and delete the material >> from any computer. PricewaterhouseCoopers LLP is a Delaware limited >> liability partnership. This communication may come from >> PricewaterhouseCoopers LLP or one of its subsidiaries. >> > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.