Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ElementPathXSD Line NumberDescription
DataFix/3The root element for the data fix
Description/DataFix9A description for the data fix being run
FixSQL/DataFix10The SQL which implements the data fix. It can be multiple statements delimited by a semicolon or slash
BackupSQL/DataFix11

SQL to perform necessary backup of data before executing FixSQL. This

must

can be one

valid SQL statement, not followed

or more statements delimited by a semicolon or slash

Tip

Include ${{FD_PROJECT_VERSION}} in the title of your backup table to easily identify it after execution


ConnectStringProperty/DataFix12The JDBC connection string for the database. The object attribute will be used if property is not specified in file
UserProperty/DataFix13User to connect to database with. The object attribute will be used if property is not specified in file
PasswordProperty/DataFix14Password for the database user. The object attribute will be used if property is not specified in file
Validations/DataFix15The rule(s) used to validate the data fix before committing changes
Validation/DataFix/Validations18A single validation rule
Description/DataFix/Validations/Validation21A description for the validation rule
ValidationSQL/DataFix/Validations/Validation22Select query which is executed before and after the FixSQL is executed, and result is compared with before and after values. This must be one valid SQL statement, not followed by a semicolon
Environment/DataFix/Validations/Validation23The expected results defined by an environment
EnvironmentCode/DataFix/Validations/Validation/Environment26FlexDeploy environment code, or DEFAULT to apply to any deploy environment not explicitly specified
Before/DataFix/Validations/Validation/Environment27Contains results to check before FixSQL is executed
After/DataFix/Validations/Validation/Environment28Contains results to check after FixSQL is executed
UpdateCount/DataFix/Validations/Validation/Environment29Results to compare return of JDBC executeUpdate() of FixSQL. If the FixSQL contains more than one statement, it is the sum of the updated rows
OperatorsN/A42Complex type containing list of accepted operators to be used in validations

...

Code Block
languagexml
themeRDark
titleLine Item Fix
<?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 orderproduct_itemslist set unitlist_price = 100 where product_id = 47809;
			update product_list set list_price = 75 where product_id =    45203;
			update order_items set unit_price = 75100 where product_id = 45203;</FixSQL>47809;
      <BackupSQL>create table order_items_bkp as (select * fromupdate order_items)</BackupSQL> set unit_price = 75 where  <ConnectStringProperty>DATA_FIX_URL_PROPERTY</ConnectStringProperty>
    <UserProperty>DATA_FIX_USER_PROPERTY</UserProperty>
    <PasswordProperty>DATA_FIX_PASSWORD_PROPERTY</PasswordProperty>
    <Validations>
        <Validation>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>
                    <GreaterThan>80</GreaterThan>
                    <LessThan>100</LessThan>
                </UpdateCount>
            </Environment>
            <Environment>
                <EnvironmentCode>default</EnvironmentCode>
<Description>Verify number of rows modified for product with id 47809</Description>       <UpdateCount>
     <ValidationSQL>select count(*) from order_items where list_price = 100 and product_id = 47809</ValidationSQL>    <GreaterThan>87</GreaterThan>
        <Environment>            <LessThan>93</LessThan>
    <EnvironmentCode>DEV</EnvironmentCode>            </UpdateCount>
    <UpdateCount>        </Environment>
        </Validation>
   <GreaterThan>80</GreaterThan>     <Validation>
            <Description>Verify number of <LessThan>100</LessThan>rows modified for product with id 45203</Description>
          </UpdateCount>  <ValidationSQL>select count(*) from order_items where list_price = 75 and product_id = <45203</Environment>ValidationSQL>
            <Environment>
                <EnvironmentCode>default</EnvironmentCode>
                <UpdateCount>
                    <GreaterThan>87<<GreaterThan>120</GreaterThan>
                    <LessThan>93<<LessThan>125</LessThan>
                </UpdateCount>
            </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>
                    <GreaterThan>120</GreaterThan>
                    <LessThan>125</LessThan>
                </UpdateCount>
            </Environment>
        </Validation>
    </Validations>
</DataFix>

...