[Zope] Weird SQL Relay conversion error in Zope
Hi, I am working on a web app that interfaces with Microsoft SQL Server from Ubuntu through SQL Relay. I will be getting data from multiple databases. The issue seems to be that either Zope or SQL Relay cannot handle the Decimal type if the value is a null. If I do a query like this: SELECT * from myDatabase I get the following: Site Error An error was encountered while publishing this resource. InvalidOperation Sorry, a site error occurred. Traceback (innermost last): * Module ZPublisher.Publish, line 194, in publish_module_standard * Module Products.PlacelessTranslationService.PatchStringIO, line 34, in new_publish * Module ZPublisher.Publish, line 146, in publish * Module Zope2.App.startup, line 222, in zpublisher_exception_hook * Module ZPublisher.Publish, line 115, in publish * Module ZPublisher.mapply, line 88, in mapply * Module ZPublisher.Publish, line 41, in call_object * Module Shared.DC.ZRDB.Connection, line 115, in manage_test * Module Products.ZSQLRelayDA.db, line 86, in query * Module decimal, line 571, in __new__ * Module decimal, line 2267, in _raise_error InvalidOperation: (Also, the following error occurred while attempting to render the standard error message, please see the event log for full details: '@@plone') If I change it to "SELECT empid, reg from myDatabase" it will work as long as reg is not a NULL. I can get it to work if I use "isnull" functions on all my decimal type fields, but I would like to avoid that. Is this a known issue with a workaround? I am using Zope 2.9.4-final on Ubuntu with SQL Relay 0.39.4. Mike Driscoll Applications Specialist MCIS - Technology Center ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Weird SQL Relay conversion error in Zope
Dieter, Mike Driscoll wrote at 2008-5-9 08:31 -0500: ... I am working on a web app that interfaces with Microsoft SQL Server from Ubuntu through SQL Relay. I will be getting data from multiple databases. The issue seems to be that either Zope or SQL Relay cannot handle the Decimal type if the value is a null. If I do a query like this: ... * Module Products.ZSQLRelayDA.db, line 86, in query * Module decimal, line 571, in __new__ * Module decimal, line 2267, in _raise_error InvalidOperation: (Also, the following error occurred while attempting to render the standard error message, please see the event log for full details: '@@plone') Looks like a bug in "ZSQLRelayDA.db". Apparently, it passes SQL decimal values to Python's "decimal" module -- even if the SQL value is "Null" (almost surely mapped to Python's "None"). For obvious reasons, "decimal" does not like to convert "None" into a "decimal" value. "ZSQLRelayDA.db" should test for "None" and call the "decimal" constructor only for non "None" values. I suspected as much. I mentioned trying SQLAlchemy to my boss and he tried it to see if it could handle this issue and it does. So we'll probably stick with that, but thanks for the clarification. Mike ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Iowa Python Users Group - First Meeting
Hi, I'm not sure how many people on this list are Iowans, but I thought you guys (and girls) would like to know the following: The first meeting date for the Iowa Python Users Group has been decided. Here are the details: Time / Date: Wednesday, Sept. 24 from 7-9 p.m. Location: Marshall County Sheriff's Office, 3rd floor 2369 Jessup Ave Marshalltown, IA 50158 Unofficial website: http://www.ipug.pythonlibrary.org Don't know how to get there? Check out maps.yahoo.com or maps.google.com. The Sheriff's Office is not actually in Marshalltown. If you take Highway 30 East, towards Marshalltown you'll see it on your left. There's a large water tower there and the building is a rusty red color. There are some signs for a Tractor convention there as well. If you're coming from the other direction, then skip ALL the exits and keep driving until the lanes go from 4 lanes to 2. It should be the second right after that. I am still developing the agenda for our first meeting, but here are some of the things we're going to discuss: - What day really works best for meeting? (if you can't make the first one, you can email me your votes!) - Figure out what domain name our group should have - Decide on what Python web framework to use to create said site (which will be a group project) - Try to come up with what format we want our meetings to take. Plone and Zope users are welcome. In fact, anyone who is interested in Python (regardless of their experience with it) is welcome to come. Let your Iowan Python friends know. Questions or ideas? Send them to me. Thanks! Mike Driscoll Applications Specialist MCIS - Technology Center 1 E. Main St. Marshalltown, IA 50158 [EMAIL PROTECTED] 641-844-2802 ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Iowa Python User's Group Meeting (November 3rd)
Hi, The next Iowa Python Users Group (AKA Pyowa) is nearly upon us. We will be meeting November 3rd, from 7-9 p.m. at the following location: Marshall County Sheriff's Office 2369 Jessup Ave Marshalltown, IA 50158 At this meeting, we will be having a Crash Course of sorts for all the new programmers in our group. As anyone who has ever taken a programming course know, it is impossible to teach everything in two hours, so we'll be focusing on tools that will allow our group to help themselves. In other words, we'll be focusing on source code analysis techniques like introspection and how to use IDLE effectively. There will also be a presentation on basic GUI design and also Django. We will have 8 laptops there to use for any new people, pre-loaded with Python 2.5.2 and any additional packages we need for our presentations. You are welcome to bring your own laptop if you want. Be sure to have 2.5 on yours as well as wxPython and the PyWin32 package (if you use Windows). We will have them on USB flash drives should you forget. Free pop and bottled water will be provided. Questions and comments can be directed to mike [at] pythonlibrary [dot] org. Updates can be found at http://www.ipug.pythonlibrary.org --- Mike Driscoll Blog: http://blog.pythonlibrary.org Python Extension Building Network: http://www.pythonlibrary.org ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )