oracle - database restore to particular state for testing -


we use oracle(or postgres) database , application server execute integration tests. isolate each test 1 , database schema dropped , re-created before each test.

as see time taking process. application uses 100+ tables. thinking of writing custom sql delete unwanted data each tables. there better way save , restore database state?

( appears dbunit this, have not tried yet. )

a single test involves:

  • create database schema.
  • start app server.
  • start multiple client applications.
  • execute , verify.

we have 5000 odd tests, taking 700 hours or so. (we on grid environment, finishes overnight)

most of tests uses small data sizes, 10 mb.

oracle flashback allows restore table @ specified time point using simple sql query. documentation available here.

i don't know if postgre has similar feature.


Comments

Post a Comment

Popular posts from this blog

c# - IMAP GMAIL getting folder list problem -

i working on imap , trying list of folders in gmail account. i able working yahoo mail, not gmail. here's code: byte[] commandbytes = system.text.encoding.ascii.getbytes((("$ xlist \"\" \"*\" \r\n")).tochararray()); i had tried list well, it's not working. doing wrong? you cannot have space between "*" , trailing \r\n .
Read more

PHP proxy to get XML: problem with URL arguments -

so need retrieve xml public api, app in flash , public service won't implement crossdomain.xml file. found php script online (below) proxy request url. works fine urls like: http://mysite.com/xml_proxy.php?url=http://rss.cnn.com/rss/cnn_topstories.rss but script seems either strip or ignore arguments on url, like: http://mysite.com/xml_proxy.php?url=http://publicapiserver.com?app_id=35235x&app_key=84x i'm php ignorant. there easy way have script process url arguments? much. here script: <?php $post_data = $http_raw_post_data; $header[] = "content-type: text/xml"; $header[] = "content-length: ".strlen($post_data); $ch = curl_init( $_get['url'] ); curl_setopt($ch, curlopt_returntransfer, 1); curl_setopt($ch, curlopt_timeout, 10); curl_setopt($ch, curlopt_httpheader, $header); if ( strlen($post_data)>0 ){ curl_setopt($ch, curlopt_post, 1); curl_setopt($ch, curlopt_postfields, $post_data); } $response = curl_exec($ch...
Read more