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.
