Database Synchronization and UUID's
I am wondering if I need to do searches by uuid's in a different way.
I have been experimenting with them and frequently run into the error -
> KeyError: 'uuid' when attempting to do queries or when trying to
pass them as variables from controllers to views and vice-versa.
At the moment I am working with the example in the book (171-173) and
seem to be getting the same error again with the book example in
addition to one other error:
TypeError: import_from_csv_file() got an unexpected keyword
argument 'unique'
OR
KeyError: 'uuid'
I can eliminate the first error by changing the following line in the
import function:
db.import_from_csv_file(form.vars.data.file,unique=False)
to be
db.import_from_csv_file(form.vars.data.file) #removed unique=False
but then the now dreaded KeyError: 'uuid' shows up again. Here are
some links to my current db.py and default.py which are basically from
the book, although I needed to import some additional modules to get
it working and needed to change "now" to be "request.now" :
db.py
view http://vishpala.com/resources/web2py/db.py/view
download http://vishpala.com/resources/web2py/db.py/at_download/file
default.py
view http://vishpala.com/resources/web2py/default.py/view
download http://vishpala.com/resources/web2py/default.py/at_download/file
This line in the book intrigued me but I was not sure about how to go
about creating an index manually to make searching by uuid's go
faster, especially since I seem to be unable to search by uuid's at
all. I have a feeling it is a formatting issue (standard index int vs
the uuid format which includes dashes.
"Create an index manually to make the search by uuid faster."
I would appreciate any assistance and or suggestions, especially in
regards to a functioning query search by uuid and getting the import
function working.
Web2py rocks!
Cheers,
Christopher Steel
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
