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 with .xml extension is in the folder specified by the Data Fix Root Source Directory project property, 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 User Property	DB_USER	Property name for database user name	No	FDEBS_DB_USER
Database Password Property	DB_PASSWORD	Property name for database password	No	FDEBS_DB_PASSWORD

Related Project Properties

Name	Code	Description	Default Value
Data Fix Root Source Directory	FDEBS_DATA_FIX_ROOT_SOURCE_DIR	The source directory to recognize files as data fixes	datafix
Data Fix Root Destination Directory	FDEBS_DATA_FIX_DESTINATION_DIR	The destination directory to copy file to. Leave blank to not copy file anywhere

Sample Build Commands

N/A - Build commands not supported for this type.

Sample Deploy Commands

N/A - Deploy commands not supported for this type.

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 APPS_JDBC_URL environment variable will be used if property is not specified in file
UserProperty	No	User to connect to database with. Environment instance property FDEBS_DB_USER will be used if property is not specified in file
PasswordProperty	No	Password for the database user. Environment instance property FDEBS_DB_PASSWORD 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

...

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
title	Basic Data Fix Template
linenumbers	true

<?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 7

New Version 8

Key