Agile DB techniques demo (2004).

Not so long time ago I have bought a new book by Scott W. Ambler: Agile Database Techniques: Effective Strategies for the Agile Software Developer and wrote a review of it. In addition to that I decided to create a little clip to demonstrate how those DB and application development techniques work in real life. This seven and a half minutes clip demonstrates how database changes can be made. This is absolutely real development of a second version of a quite big application: I have discovered that couple of table columns are not quite appropriately called and decided to fix it. This is the transcript of what I have done and what you will see in the clip:

• renamed columns in the RDBMS modeling tool DeZign 3.0
• generated DB drop and creation scripts in DeZign;
• fixed a little problem with generated drop script;
• committed changes to CVS;
• updated source tree from CVS on my GNU/Linux station;
• changed column names in that SQL script which populates DB with test data;
• ran Ant script that has executed SQL scripts which:
  • DROP entire DB (~70 tables ) ;
  • Create entire DB (~70 tables ) ;
  • populate DB with test data;
• changed Javadoc comments on a class which are responsible for Hibernate mapping ( @hibernate.property="new_column_name" )
• ran Ant again to do the following:
  • generate new Hibernate mapping files;
  • build project;
  • deploy the web application on locally running Tomcat;
• Checked that everything works fine;

DONE.

Now I welcome you to stand behind me and watch over my shoulders how all that was done. (wmv format, 5.41 MB, 7:29 ):