Annotation Interface CsvSource
@CsvSource is a repeatable
ArgumentsSource which reads comma-separated values (CSV) from one
or more CSV records supplied via the value() attribute or
textBlock() attribute.
The supplied values will be provided as arguments to the annotated
@ParameterizedClass or
@ParameterizedTest.
The column delimiter (which defaults to a comma (,)) can be customized
via either delimiter() or delimiterString().
By default, @CsvSource uses a single quote (') as its quote
character, but this can be changed via quoteCharacter(). See the
'lemon, lime' examples in the documentation for the value()
and textBlock() attributes. An empty, quoted value ('') results
in an empty String unless the emptyValue() attribute is set;
whereas, an entirely empty value is interpreted as a null reference.
By specifying one or more nullValues() a custom value can be interpreted
as a null reference (see the User Guide for an example). An
ArgumentConversionException is thrown if the target type of a null
reference is a primitive type.
NOTE: An unquoted empty value will always be converted to a
null reference regardless of any custom values configured via the
nullValues() attribute.
Except within a quoted string, leading and trailing whitespace in a CSV
column is trimmed by default. This behavior can be changed by setting the
ignoreLeadingAndTrailingWhitespace() attribute to true.
In general, CSV records should not contain explicit newlines (\n)
unless they are placed within quoted strings. Note that CSV records supplied
via textBlock() will implicitly contain newlines at the end of each
physical line within the text block. Thus, if a CSV column wraps across a
new line in a text block, the column must be a quoted string.
Inheritance
This annotation is inherited to subclasses.
- Since:
- 5.0
- See Also:
-
Optional Element Summary
Optional ElementsModifier and TypeOptional ElementDescriptioncharThe column delimiter character to use when reading the records.The column delimiter string to use when reading the records.The empty value to use when reading the records.booleanControls whether leading and trailing whitespace characters of unquoted CSV columns should be ignored.intThe maximum number of characters allowed per CSV column.String[]A list of strings that should be interpreted asnullreferences.charThe quote character to use for quoted strings.The CSV records to use as the source of arguments, supplied as a single text block; must not be empty.booleanConfigures whether the first CSV record should be treated as header names for columns.String[]The CSV records to use as the source of arguments; must not be empty.
-
Element Details
-
value
String[] valueThe CSV records to use as the source of arguments; must not be empty.Defaults to an empty array. You therefore must supply CSV content via this attribute or the
textBlock()attribute.Each value corresponds to a record in a CSV file and will be split using the specified
delimiter()ordelimiterString(). Note that the first value may optionally be used to supply CSV headers (seeuseHeadersInDisplayName()). Moreover, each specified value must not be blank.If text block syntax is supported by your programming language, you may find it more convenient to declare your CSV content via the
textBlock()attribute.Example
@ParameterizedTest @CsvSource({ "apple, 1", "banana, 2", "'lemon, lime', 0xF1", "strawberry, 700_000" }) void test(String fruit, int rank) { // ... }- See Also:
- Default:
{}
-
textBlock
The CSV records to use as the source of arguments, supplied as a single text block; must not be empty.Defaults to an empty string. You therefore must supply CSV content via this attribute or the
value()attribute.Text block syntax is supported by various languages on the JVM including Java SE 15 or higher. If text blocks are not supported, you should declare your CSV content via the
value()attribute.Each record in the text block corresponds to a record in a CSV file and will be split using the specified
delimiter()ordelimiterString(). Note that the first record may optionally be used to supply CSV headers (seeuseHeadersInDisplayName()).In contrast to CSV records supplied via
value(), a text block can contain comments. Any line beginning with a hash tag (#) will be treated as a comment and ignored. Note, however, that the#symbol must be the first character on the line without any leading whitespace. It is therefore recommended that the closing text block delimiter"""be placed either at the end of the last line of input or on the following line, vertically aligned with the rest of the input (as can be seen in the example below).Java's text block feature automatically removes incidental whitespace when the code is compiled. However other JVM languages such as Groovy and Kotlin do not. Thus, if you are using a programming language other than Java and your text block contains comments or new lines within quoted strings, you will need to ensure that there is no leading whitespace within your text block.
Example
@ParameterizedTest @CsvSource(quoteCharacter = '"', textBlock = """ # FRUIT, RANK apple, 1 banana, 2 "lemon, lime", 0xF1 strawberry, 700_000 """) void test(String fruit, int rank) { // ... }- Since:
- 5.8.1
- See Also:
- Default:
""
-
useHeadersInDisplayName
Configures whether the first CSV record should be treated as header names for columns.When set to
true, the header names will be used in the generated display name for each@ParameterizedClassor@ParameterizedTestinvocation. When using this feature, you must ensure that the display name pattern for@ParameterizedClassor@ParameterizedTestincludes "{arguments}" instead of "{argumentsWithNames}" as demonstrated in the example below.Defaults to
false.Example
@ParameterizedTest(name = "[{index}] {arguments}") @CsvSource(useHeadersInDisplayName = true, textBlock = """ FRUIT, RANK apple, 1 banana, 2 'lemon, lime', 0xF1 strawberry, 700_000 """) void test(String fruit, int rank) { // ... }- Since:
- 5.8.2
- Default:
false
-
quoteCharacter
The quote character to use for quoted strings.Defaults to a single quote (
').You may change the quote character to anything that makes sense for your use case; however, the primary use case is to allow you to use double quotes in
textBlock().- Since:
- 5.8.2
- See Also:
- Default:
'\''
-
delimiter
char delimiterThe column delimiter character to use when reading the records.This is an alternative to
delimiterString()and cannot be used in conjunction withdelimiterString().Defaults implicitly to
',', if neither delimiter attribute is explicitly set.- Default:
'\u0000'
-
delimiterString
String delimiterStringThe column delimiter string to use when reading the records.This is an alternative to
delimiter()and cannot be used in conjunction withdelimiter().Defaults implicitly to
",", if neither delimiter attribute is explicitly set.- Since:
- 5.6
- Default:
""
-
emptyValue
-
nullValues
String[] nullValuesA list of strings that should be interpreted asnullreferences.For example, you may wish for certain values such as
"N/A"or"NIL"to be converted tonullreferences.Please note that unquoted empty values will always be converted to
nullreferences regardless of the value of thisnullValuesattribute; whereas, a quoted empty string will be treated as anemptyValue().Defaults to
{}.- Since:
- 5.6
- Default:
{}
-
maxCharsPerColumn
-
ignoreLeadingAndTrailingWhitespace
Controls whether leading and trailing whitespace characters of unquoted CSV columns should be ignored.Whitespace refers to characters with Unicode code points less than or equal to
U+0020, as defined byString.trim().Defaults to
true.- Since:
- 5.8
- Default:
true
-