# The following pattern is an example of using the Custom Pattern Formatter
# to generate the same JSON output as the Avro Formatter.
#
#

#-----------------------------------------------------------------------------------------------
# Special Attributes Section
#-----------------------------------------------------------------------------------------------

<SPECIAL_ATTRIBUTES>
   <DELIMITER>,</DELIMITER>
   <REPEAT_DELIMITER>,</REPEAT_DELIMITER>
# Handling null values like Avro does - this is the text displayed for a null column value.
   <NULL_REPLACEMENT_VALUE>null</NULL_REPLACEMENT_VALUE>
</SPECIAL_ATTRIBUTES>

#-----------------------------------------------------------------------------------------------
# Column Attributes Section
#-----------------------------------------------------------------------------------------------

<COLUMN_ATTRIBUTES>

# Tagging columns <TAG>

# Excluding columns <EXCLUDE>

# Data Type Swapping <DT_SWAP>

# Date/Time masking <DT_MASK>

# Data type value quoting <DT_QUOTES>
<DT_QUOTES> <data_type>string</data_type>    <quote_character>"</quote_character> </DT_QUOTES>
<DT_QUOTES> <data_type>date</data_type>      <quote_character>"</quote_character> </DT_QUOTES>
<DT_QUOTES> <data_type>time</data_type>      <quote_character>"</quote_character> </DT_QUOTES>
<DT_QUOTES> <data_type>timestamp</data_type> <quote_character>"</quote_character> </DT_QUOTES>
<DT_QUOTES> <data_type>bytes</data_type>     <quote_character>"</quote_character> </DT_QUOTES>

# Enabled or disable allowing quotes around null values. Just explicitly disabled here for example that it can be changed
<DT_QUOTES> <quote_null_values>false</quote_null_values> </DT_QUOTES>

</COLUMN_ATTRIBUTES>

#-----------------------------------------------------------------------------------------------
# Insert Event Section
#-----------------------------------------------------------------------------------------------
<INSERT_EVENT>
{
<REPEAT>
"<column_name>":<NULLABLE_VALUE><BOOLEAN_VALUE>{"<column_type>":<column_value>}</BOOLEAN_VALUE>
</NULLABLE_VALUE>
</REPEAT>
}
</INSERT_EVENT>

#-----------------------------------------------------------------------------------------------
# Update Event Section
#-----------------------------------------------------------------------------------------------
<UPDATE_EVENT>
{
<REPEAT>
"<column_name>":<NULLABLE_VALUE><BOOLEAN_VALUE>{"<column_type>":<column_value>}</BOOLEAN_VALUE>
</NULLABLE_VALUE>
</REPEAT>
}
</UPDATE_EVENT>

#-----------------------------------------------------------------------------------------------
# Delete Event Section
#-----------------------------------------------------------------------------------------------
<DELETE_EVENT>
{
<REPEAT>
"<column_name>":<NULLABLE_VALUE><BOOLEAN_VALUE>{"<column_type>":<column_value>}</BOOLEAN_VALUE>
</NULLABLE_VALUE>
</REPEAT>
}
</DELETE_EVENT>

#-----------------------------------------------------------------------------------------------
# Commit Event Section  (not used)
#-----------------------------------------------------------------------------------------------
#<COMMIT_EVENT>
#</COMMIT_EVENT>