Page Comparison

XML files containing one or more data fix sql statements, a sql statement to back up data, and validation statements used to determine whether the data fix should be committed or rolled back.

Object Type Identification

If a file has .xml extension, then it is considered a data fix file

File Extensions

Name	Description
.xml	Extensible Markup Language file format used to create common information formats and share both the format and the data using standard ASCII text.

Object Type

Name	Code
Data Fix	DATA_FIX

Object Type Attributes

Name	Code	Description	Required	Default Value	Supported Values
Source	SOURCE	Object source location type	Yes	SCM	SCM
Target Location	TARGET_LOCATION	Path to where the file should be deployed to	No
Database URL Property	DB_URL	Property name for database URL	No	FDJDBC_URL
Database User Property	DB_USER	Property name for database user name	No	FDJDBC_USER
Database Password Property	DB_PASSWORD	Property name for database password	No	FDJDBC_PASSWORD

Data Fix Source Formatting

Tag Name	Required	Description
Description	Yes	A description for the data fix being run
FixSQL	Yes	The SQL which implements the data fix. It can be multiple statements delimited by a semicolon or slash
BackupSQL	Yes	SQL to perform necessary backup of data before executing FixSQL. This must be one valid SQL statement, not followed by a semicolon
ConnectStringProperty	No	The JDBC connection string for the database. The object attribute will be used if property is not specified in file
UserProperty	No	User to connect to database with. The object attribute will be used if property is not specified in file
PasswordProperty	No	Password for the database user. The object attribute will be used if property is not specified in file
Validations	Yes	The rule(s) used to validate the data fix before committing changes
Validation	Yes	A single validation rule. See below for more details

A single validation contains the following:

Tag Name	Required	Description
Description	Yes	A description for the validation rule
ValidationSQL	Yes	Select 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	Yes	The expected results defined by an environment. See below for more details

An environment contains the following:

Tag Name	Required	Description
EnvironmentCode	Yes	FlexDeploy environment code, or DEFAULT to apply to any deploy environment not explicitly specified
Before	No	Contains results to check before FixSQL is executed
After	No	Contains results to check after FixSQL is executed
UpdateCount	No	Results to compare return of JDBC executeUpdate() of FixSQL. If the FixSQL contains more than one statement, it is the sum of the updated rows

The Before, After, and UpdateCount elements may contain one or more of the following operators to compare the result:

...

If more than one of these elements are present, all must evaluate to true for the validation to pass.

Data Fix Source Template

Code Block

language	xml
theme	RDark

<?xml version="1.0" encoding="UTF-8"?>
<DataFix xmlns="http://flexagon.com/database/datafix">
    <Description></Description>
    <FixSQL></FixSQL>
    <BackupSQL></BackupSQL>
    <ConnectStringProperty></ConnectStringProperty>
    <UserProperty></UserProperty>
    <PasswordProperty></PasswordProperty>
    <Validations>
		<!-- Can be one or more -->
        <Validation>
            <Description></Description>
            <ValidationSQL></ValidationSQL>
			<!-- Can be one or more -->
            <Environment> 
                <EnvironmentCode></EnvironmentCode>
                <Before>
                    <Equals></Equals>
                    <NotEquals></NotEquals>
                    <GreaterThan></GreaterThan>
                    <GreaterThanEqual></GreaterThanEqual>
                    <LessThan></LessThan>
                    <LessThanEqual></LessThanEqual>
                </Before>
                <After>
                    <Equals></Equals>
                    <NotEquals></NotEquals>
                    <GreaterThan></GreaterThan>
                    <GreaterThanEqual></GreaterThanEqual>
                    <LessThan></LessThan>
                    <LessThanEqual></LessThanEqual>
                </After>
                <UpdateCount>
                    <Equals></Equals>
                    <NotEquals></NotEquals>
                    <GreaterThan></GreaterThan>
                    <GreaterThanEqual></GreaterThanEqual>
                    <LessThan></LessThan>
                    <LessThanEqual></LessThanEqual>
                </UpdateCount>
            </Environment>
        </Validation>
    </Validations>
</DataFix>

Data Fix Source Examples

The first example is a simple data fix that updates one row of a table, then verifies only the expected row is updated.

...

Versions Compared

Old Version 1

New Version 2

Key