XML files containing one or more data fix sql statements, a sql statement statements to back up data, and validation statements used to determine whether the data fix should be committed or rolled back.
Object Type Identification
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
<?xml version="1.0" encoding="UTF-8"?>
<DataFix xmlns="http://flexagon.com/database/datafix">
<Description>Fix line items for product IDs 47809 and 45203</Description>
<FixSQL>update product_list set list_price = 100 where product_id = 47809;
update product_list set list_price = 75 where product_id = 45203;
update order_items set unit_price = 100 where product_id = 47809;
update order_items set unit_price = 75 where product_id = 45203;</FixSQL>
<BackupSQL>create table order_items_bkp as (select * from order_items);
create table product_list_bkp as (select * from product_list);</BackupSQL>
<ConnectStringProperty>DATA_FIX_URL_PROPERTY</ConnectStringProperty>
<UserProperty>DATA_FIX_USER_PROPERTY</UserProperty>
<PasswordProperty>DATA_FIX_PASSWORD_PROPERTY</PasswordProperty>
<Validations>
<Validation>
<Description>Verify number of rows modified for product with id 47809</Description>
<ValidationSQL>select count(*) from order_items where list_price = 100 and product_id = 47809</ValidationSQL>
<Environment>
<EnvironmentCode>DEV</EnvironmentCode>
<UpdateCount><After>
<GreaterThan>80</GreaterThan>
<LessThan>100</LessThan>
</UpdateCount>After>
</Environment>
<Environment>
<EnvironmentCode>default</EnvironmentCode>
<UpdateCount><After>
<GreaterThan>87</GreaterThan>
<LessThan>93</LessThan>
</UpdateCount>After>
</Environment>
</Validation>
<Validation>
<Description>Verify number of rows modified for product with id 45203</Description>
<ValidationSQL>select count(*) from order_items where list_price = 75 and product_id = 45203</ValidationSQL>
<Environment>
<EnvironmentCode>default</EnvironmentCode>
<UpdateCount><After>
<GreaterThan>120</GreaterThan>
<LessThan>125</LessThan>
</UpdateCount>After>
</Environment>
</Validation>
<Validation>
<Description>Verify total number of rows modified for product with id 45203<modified</Description>
<ValidationSQL>select count(*) from order_items where list_price = 75 and product_id = 45203<<ValidationSQL></ValidationSQL>
<Environment>
<EnvironmentCode>default</EnvironmentCode>
<UpdateCount>
<GreaterThan>120<<GreaterThan>200</GreaterThan>
<LessThan>125<<LessThan>220</LessThan>
</UpdateCount>
</Environment>
</Validation>
</Validations>
</DataFix> |
...