I'm working on DS-680, which involves problematic SQL syntax. Trying to be a good little 21st-century programmer, I decided to first write a test to drive LogAnalyser and then tackle the SQL problem.
The unit test scaffolding configures for Oracle, apparently for some specific reason that I haven't yet investigated. This makes it difficult to test a problem that appears to be specific to PostgreSQL. So, problem 1: fully testing DBMS-related stuff may require some rethinking so that all brands are covered. And then: unfortunately, H2 doesn't seem to understand some of the functions peculiar to Oracle, such as TO_DATE which is used in the Oracle branch of LogAnalyser.getNumItems(). So, problem 2: we can't completely test against Oracle anyway, and probably have similar quirks to deal with in the Pg branches. I guess what this is telling me is that some testing which intersects the DBMS might want to be put off to integration test, where the weight of cranking up the actual brand-name DBMSs can be made acceptable. I'm just rattling on to capture observations and thoughts, and will work out some other way to try out any work on DS-680. (Well, I did also hope to provoke some thought about improving the test scaffolding.) Another thought: we ought to look at our current minimum DBMS versions and see if we need quite so much brand-specific code. -- Mark H. Wood, Lead System Programmer mw...@iupui.edu Asking whether markets are efficient is like asking whether people are smart.
pgp2bCpVGYgv1.pgp
Description: PGP signature
------------------------------------------------------------------------------ Free Software Download: Index, Search & Analyze Logs and other IT data in Real-Time with Splunk. Collect, index and harness all the fast moving IT data generated by your applications, servers and devices whether physical, virtual or in the cloud. Deliver compliance at lower cost and gain new business insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________ Dspace-devel mailing list Dspace-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-devel
