started

Created attachment 64169 [details]
patch for Mac OS X build

Created attachment 64170 [details]
extension for testing - note I had to quit and restart Openoffice after installing the extension for the driver to connect.  This version did not display the driver name in the wizard in OOo 3.1.0, but did in DEV300_m54.  Both versions would open a previ

Hi,

just four remarks:

- its normal that you need to restart the office after installation
- how about sticking to version 0.7.6 as its just a port without different
functionality.
- was it your intention to remove the DriverDisplayName in DataAccess.xcu ?
- did you get the python test skripts to work ?

Bye,

Joerg

@JOERG
>>>- how about sticking to version 0.7.6 as its just a port without different
functionality.
fine with me
>>>- was it your intention to remove the DriverDisplayName in DataAccess.xcu ?
no - I didn't see DriverDisplayName in the original, just DriverPageDisplayName and 
DriverTypeDisplayName.  Can you send/attach an example - perhaps that's why the name doesn't 
appear in the wizard in 3.1.0
>>>- did you get the python test skripts to work ?
no - following is the error - any ideas?
echo $PYTHONPATH
/Developer/OpenOffice.org.app/Contents/basis-link/program
MacBookPro:postgresql MikeS$ dmake runtest "dburl=sdbc:postgresql:dbname=pqtest"dmake: 
Executing shell macro: +$(IFEXIST) $(TRYSDF) $(THEN) echo $(TRYSDF) $(FI)
start test with  dmake runtest dburl=your-url
  e.g. dmake runtest dburl=sdbc:postgresql:dbname=pqtest
   MUST: Create a separate datbases before (here pqtest),
         (SOME TABLES GET DROPPED)
cd ../../unxmacxi.pro/lib && python main.py "sdbc:postgresql:dbname=pqtest"
Traceback (most recent call last):
  File "main.py", line 67, in <module>
    import statement
  File "/Developer/OpenOffice.org.app/Contents/basis-link/program/uno.py", line 257, in _uno_import
    return _g_delegatee( name, *optargs, **kwargs )
  File "/Developer/Projects/ooo/DEV300_m54/connectivity/unxmacxi.pro/lib/statement.py", line 64, in 
<module>
    import ddl
  File "/Developer/OpenOffice.org.app/Contents/basis-link/program/uno.py", line 257, in _uno_import
    return _g_delegatee( name, *optargs, **kwargs )
  File "/Developer/Projects/ooo/DEV300_m54/connectivity/unxmacxi.pro/lib/ddl.py", line 60, in 
<module>
    from com.sun.star.sdbc2 import SQLException
  File "/Developer/OpenOffice.org.app/Contents/basis-link/program/uno.py", line 295, in _uno_import
    raise ImportError( "type "+ name + "." +x + " is unknown" )
ImportError: type com.sun.star.sdbc2.SQLException is unknown
dmake:  Error code 1, while making 'runtest'

Created attachment 64565 [details]
extension built on Tiger, tested on Tiger, Leopard, Snow Leopard

Created attachment 64566 [details]
test results on Tiger, Leopard, and Snow Leopard

Created attachment 64567 [details]
added file needed to run test scripts on Mac OS X

Created attachment 64568 [details]
patch to create mac version dataaccess.xcu and changes to makefile

Tasks left to complete - how to make DataAccess.xcu for all platforms?

Test procedure:
1.  Install extension
2.  make sure postgresql is available, if you need to enter user name or
password add it to the dburl, line 86     dburl = "sdbc:postgresql:dbname=pqtest"
3.  Put all python scripts in Openoffice accessible scripts directory:
    ddl.py	
    preparedstatement.py
    statement.py
    macmain.py  
    metadata.py  
    sdbcx.py	   
    test.py
4.  Start OpenOffice.org from a shell so the script output is visible

Test procedure:
1.  Install extension
2.  make sure postgresql is available, if you need to enter user name or
password add it to the dburl, line 86     dburl = "sdbc:postgresql:dbname=pqtest"
3.  Put all python scripts in Openoffice accessible scripts directory:
    ddl.py	
    preparedstatement.py
    statement.py
    macmain.py  
    metadata.py  
    sdbcx.py	   
    test.py
4.  Start OpenOffice.org from a shell so the script output is visible
    /Applications/OpenOffice.org.app/Contents/MacOS/soffice
5.  Run the runTests script in macmain

I have tested with several OOo versions and several Mac OS X versions - results
attached above.

There was an error reported by Julian Hemmerle where a crash occurred when a
filter was applied.  This was fixed by DEV300_m60, and there is no crash in
000320_m6.  I think the attachment uploaded on Sep 5 should be regarded as a
valid port.

@Joerg - any more to do to get it on the driver page?