search

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
http://www.ora2pg.com/
GNU General Public License v3.0
978 stars 341 forks source link

added testcase for _convert_function #1686

Closed mgerhardy closed 10 months ago

mgerhardy commented 10 months ago

I do not yet fully understand the needed parameters for the function and this should only serve as a base for further discussions

call this with:

perl -Ilib t/*.t

This would allow users to report failing conversions with simple test cases that everyone can reproduce easily

darold commented 10 months ago

I don't see the interest to do that. Actually users can simply save the PL/SQL DDL code to a file and execute ora2pg on it.

ora2pg -c config/ora2pg.conf -t FUNCTION -i my_fct_file.sql

all my regression test are built based on this king of calls and with a diff on the expected output.

mgerhardy commented 10 months ago

but wouldn't at least be a pipeline useful that executes your regression tests to tell users that they haven't broken anything with their patch?

darold commented 10 months ago

Yes it would, but the problem it that there is non public PL/SQL code in these regression tests so it is kept private.