Database migration workflow sample in XML

database_migration.xml

<db-workflow>
	<defaults>
		<var key="server">test</var>
		<var key="test">${server}_name</var>
	</default>
	<workflows>
		<workflow name="update">
			<vars>
				<ask_for var="server" />
				<ask_for var="user" />
				<ask_for var="password" />
				<ask_for var="database" />
			</vars>
			<actions>
        		  <execute with-compile="true" result-to-var="latest">%sql_script_command SELECT* FROM schema_version</execute>
        		  <execute with-compile="true">handlers/lock_database_template.sql</execute>
		          <execute-dir>handlers/</execute-dir>
		          <execute-dir by-order="true">tables/</execute-dir>
			</action>
		</workflow>
	</workflows>
</db-workflow>