Postgres problem with ERXExistsQualifier
Aaron Rosenzweig <[email protected]> Fri, 23 May 2014 18:06:19 -0400
| Newsgroups | gmane.comp.web.webobjects.wonder-disc |
|---|---|
| Message-ID | <[email protected]> |
--===============1015884972343596162== Content-Type: multipart/alternative; boundary="Apple-Mail=_E98DF228-ECAB-4A82-A4D7-97D0E78A6BB8" --Apple-Mail=_E98DF228-ECAB-4A82-A4D7-97D0E78A6BB8 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 Hi WOrriors, We are in the process of moving our app from FrontBase to Postgres. = FrontBase has been great for this app for over 10 years but there are = various reasons for going to Postgres, one of them is so that we can run = the DB on something other than OS X. Current versions of Frontbase are = Mac only. The current version of the ExistsQualifier will fail when you have an = =93int4=94 data type involved in Postgres. It will se the =93t4=94 = inside and think it is something it needs to replace with an =93exists4.=94= =20 To say it another way, the ExistsQualifier asks EOF to generate a sub = qualifier and then does some string replacement. That string replacement = was always pretty hairy. We just cleaned it up with a REGEX so =93now we have two problems=94 ;-)=20= = http://blog.codinghorror.com/regular-expressions-now-you-have-two-problems= / In our Selenium tests the new code works for both Frontbase and = Postgres. We made a pull request here: https://github.com/wocommunity/wonder/pull/581 Thanks! AARON ROSENZWEIG / Chat 'n Bike e: [email protected] t: (301) 956-2319 =09 =09 --Apple-Mail=_E98DF228-ECAB-4A82-A4D7-97D0E78A6BB8 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=windows-1252 <html><head><meta http-equiv=3D"Content-Type" content=3D"text/html = charset=3Dwindows-1252"></head><body style=3D"word-wrap: break-word; = -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">Hi = WOrriors,<div><br></div><div>We are in the process of moving our app = from FrontBase to Postgres. FrontBase has been great for this app for = over 10 years but there are various reasons for going to Postgres, one = of them is so that we can run the DB on something other than OS X. = Current versions of Frontbase are Mac only.</div><div><br></div><div>The = current version of the ExistsQualifier will fail when you have an =93int4=94= data type involved in Postgres. It will se the =93t4=94 inside and = think it is something it needs to replace with an = =93exists4.=94 </div><div><br></div><div>To say it another way, the = ExistsQualifier asks EOF to generate a sub qualifier and then does some = string replacement. That string replacement was always pretty = hairy.</div><div><br></div><div>We just cleaned it up with a REGEX so = =93now we have two problems=94 ;-) </div><div><br></div><div><a = href=3D"http://blog.codinghorror.com/regular-expressions-now-you-have-two-= problems/">http://blog.codinghorror.com/regular-expressions-now-you-have-t= wo-problems/</a></div><div><br></div><div>In our Selenium tests the new = code works for both Frontbase and Postgres.</div><div><br></div><div>We = made a pull request here:</div><div><br></div><div><a = href=3D"https://github.com/wocommunity/wonder/pull/581">https://github.com= /wocommunity/wonder/pull/581</a></div><div><br></div><div>Thanks!</div><di= v><div> <table style=3D"margin-top:0.5em;margin-left:0.5em;margin-bottom:30px;" = border=3D"0"> <tbody><tr> <td colspan=3D"2" style=3D"padding-bottom: 0.3em; "> <span style=3D"font-family:'Trebuchet = MS',helvetica,San-Serif;font-size:11px;color:#888888;line-height:22px"><b = style=3D"color:#11aeab;text-transform:uppercase;letter-spacing:2px">Aaron = Rosenzweig</b> / <a href=3D"http://www.chatnbike.com" = title=3D"visit Chat 'n Bike" style=3D"text-decoration:none; = border-bottom:1px dotted #888888;color:#888888">Chat 'n = Bike</a></span><br> <span style=3D"font-family:'Trebuchet = MS',helvetica,San-Serif;font-size:11px;color:#b2b2b2;"><b = style=3D"color:#888888">e:</b> <a = href=3D"mailto:[email protected]" title=3D"email Aaron" = style=3D"text-decoration:none; border-bottom:1px dotted = #b2b2b2;color:#b2b2b2">[email protected]</a> <b = style=3D"color:#888888">t:</b> (301) 956-2319</span> </td> </tr> <tr> <td> <img = src=3D"http://www.chatnbike.com/WebObjects/FamilyCycleGroupOrder.woa/Conte= nts/WebServerResources/images/chat_n_bike_logo_small.png" alt=3D"Chat 'n = Bike" height=3D"100"> </td> <td> <img = src=3D"http://www.chatnbike.com/WebObjects/FamilyCycleGroupOrder.woa/Conte= nts/WebServerResources/images/dealers/usa.jpg" alt=3D"Chat 'n Bike" = height=3D"100"> </td> </tr> </tbody></table> </div> <br></div></body></html>= --Apple-Mail=_E98DF228-ECAB-4A82-A4D7-97D0E78A6BB8-- --===============1015884972343596162== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline ------------------------------------------------------------------------------ "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs --===============1015884972343596162== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Wonder-disc mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/wonder-disc --===============1015884972343596162==--