it hard formulate question in title i'll try explain.
i need automatic ui tests application written. these application has big testing database loaded lot of data. hard understand relationships between tables not trivial there foreign keys missing (logic implemented in java application, logic in stored procedures). problem is, can run tests once: after finished, data moved , of data deleted application. need prepare scripts , insert statements before every test.
is possible make such script preparing easier? of course, solution investigate db structure , dependencies (or review application logic in java), take lot of time. cannot save database data , changes after tests finished take lot of time data export/import in sql developer. maybe db administrator have oracle db tools doing this?
i suggest obtain , use testing framework. they're free. java standard junit. pl/sql, utplsql there several others available. using testing framework can insert needed data database @ start of test, run test, , make sure end results expected, clean data can run test again cleanly. requires fair amount of coding make work right, it's easier coding once perform same tasks manually many times over.
share , enjoy.
Comments
Post a Comment