• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

running of modified sql files from source folder

 
Deepak Devarapally
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I have few sql files. I do run all the sql files daily using ant script.

Instead of running all the scripts daily, I want to run only the modified files (that i pulled from svn) using ant script.

f there are 100 files and 10 file are updated then I need to run only those 10 files.

How can we implement this using ant script.

Thanks
 
William P O'Sullivan
Ranch Hand
Posts: 859
Chrome IBM DB2 Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Looks to me like you would have to call the svn command line or API to determine
which have changed. "Checkout" or update these into a temp folder then iterate
through and execute.

WP
 
Peter Johnson
author
Bartender
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Another option - configure Subversion to retain the file checkin time (by default it sets the last modified time to the checkout time). Then for the <sql> task use a file selector that has a date restriction and select only files with today's date (or something like that).
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic