A new topic, 'To exute a sql tag (or sql statement) without writing in databasechangelog?', has been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=211.new#newThe text of the topic is shown below:
Is there any way to execute a sql tag (or sql statement) by liquibase without writing a row in the databasechangelog table?
My situation is the next:
I want to execute, more than once, a sql file with the same Author, same ID and same FileName. Sometimes the file is unchanged so I put runAlways="true" in changeSet Tag. Other times the file is changed so a liquibase.exception.ValidationFailedException is launched to the user. To force the execution of the file in validationFailedException case, a user variable is used. If this variable is true, a liquibase xml is exuted previously:
Code:
<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog xmlns="
http://www.liquibase.org/xml/ns/dbchangelog/1.9"
xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="
http://www.liquibase.org/xml/ns/dbchangelog/1.9 http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd">
<changeSet author="${author.name}-Forcing MD5Sum" id="${id.change}" runAlways="true">
<sql>update DATABASECHANGELOG SET MD5SUM=NULL WHERE AUTHOR='${author.name}' AND ID='${id.change}';
</sql>
</changeSet>
</databaseChangeLog>
But I want to execute the <sql> tag that updates the md5sum to null using Liquibase without it writing a row (${Author-name}-Forcing md5Sum, ${id.change}, filename...) in the databasechangelog table.
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0Regards,
The LiquiBase Community Forum Team.
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user
