Am working on https://issues.openmrs.org/browse/RA-429 where am supposed to add a changeset in the liquibase file of the referencemetadata module that deletes duplicate concepts, however i realised the the installation doesnt run the liquibase file at all. i decided to try a a very simple changeset
<?xml version="1.0" encoding="UTF-8"?>
<changeSet author = "MUTESASIRA M0ZZY" id="20131010">
<comment>a new table to store multipart files</comment>
<createTable tableName = "facelist_multipart">
<column autoIncrement = "true" name = "multipart_id" type ="int">
<constraints primaryKey="true" nullable="false" />
</column>
<column name ="patient_id" type ="int"/>
</createTable>
</changeSet>
</databaseChangeLog>
here is basically wat i added to the liquibase file
<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd">
<changeSet id="deleting_duplicate_concept" author="Mutesasira">
<preConditions onFail="MARK_RAN">
<sqlCheck expectedResult="2">select count(*) from concept_name where name = 'YES'</sqlCheck>
<sqlCheck expectedResult="2">select count(*) from concept_name where name = 'NO'</sqlCheck>
</preConditions>
<comment>
it checks whether the duplicate concepts exists and deletes one
</comment>
<dropAllForeignKeyConstraints baseTableName="concept"/>
<delete tableName="concept">
<where>concept_id =1</where>
</delete>
</changeSet>
</databaseChangeLog>
here is the the file where am placing the above changeset
but unfortunately wherever i compile the referencemetadata module with those changes in the liquibase file, and i load it in my reference app installation , the module loads succesfuly , the liquibase seems to have no change at all to the database
thats why i wanted to try a basic changeset with no pre-conditions to see if the liqibase will have any effect on the database , after copiling and loading the module again but the same case , so am wondering if i need to add any other configuration in the openmrs/ openmrs-module-referencemetadata for the liquibase to run