PostgreSQL stored functions returning dataset's

Code patches written by our users to solve certain "problems" that were not solved, yet.

Moderators: gto, cipto_kh, EgonHugeist, mdaems

Wild_Pointer
Expert Boarder
Expert Boarder
Posts: 159
Joined: 18.03.2008, 13:03
Contact:

PostgreSQL stored functions returning dataset's

Postby Wild_Pointer » 15.07.2010, 07:36

Hello,

I tried to implement the opening of postgresql stored functions. It seems to work ok for me.
On the other hand I'm not sure if ZStoredPorc.ExecProc is working properly for me. Should the output parameter be filled after calling ExecPorc? With what value if the function returns dataset?

Anyway I attach zip file containing diff files to see changes I did and the changed pas files.

Please give me your opinion about the changes I did.

Good luck!
You do not have the required permissions to view the files attached to this post.

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 29.08.2010, 20:38

Hi Wild_Pointer,

I'm back again after a long busy time. I just had a look at this code and I'm very happy somebody wanted to take the challenge!!

I didn't manage to test the stuff yet. A quick compile of the new code showed no compile trouble for delphi < 2009. After a tiny syntax error this could be fixed as well.

Test suite is running now, but this shouldn't be a problem as no tests are activated yet. Did you try activating eventual test suite tests? (Not sure if they exist for stored procs)

SVN rev. 810

Mark
Image

Wild_Pointer
Expert Boarder
Expert Boarder
Posts: 159
Joined: 18.03.2008, 13:03
Contact:

Postby Wild_Pointer » 30.08.2010, 07:16

Hello, mdaems,

I have never used test suite so could you please give some reference how to start that?

Also I wanted to ask if there is a detail documentation on what should happen on ExecPorc method?


Wild_Pointer

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 01.09.2010, 23:12

Wild_Pointer,

Running a fully automated test suite isn't that easy. (alhough I only start the build/build.cmd script here)
Main problem is building the suite and setting the right properties in the settings file.
When using Lazarus here is some more information in this thread
http://zeos.firmos.at/viewtopic.php?t=2358
For Delphi consult the file buildingtests.pdf in the documentation directory of the afficial zeoslib distributions.

Most important steps are building the ZTest*.dpr programs in the package directory for your compiler, editing database/test.properties and running the test project exe's. Exe's must be in directory zeoslib/packages/<compiler>/build so the settings files in the 'database' dir is in the right relative path.

Concerning the ExecProc docs : I'm afraid the Interbase implementation is the best doc available...

Mark
Image

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 08.09.2010, 21:28

UPDATE

I added some thread about running the test suite here : http://zeos.firmos.at/viewtopic.php?t=2951

Mark
Image


Return to “User Patches”

Who is online

Users browsing this forum: No registered users and 1 guest