Interface LoadCSVStatementBuilder

All Superinterfaces:
ExposesCreate, ExposesMatch, ExposesMerge, ExposesReturning, ExposesSubqueryCall, ExposesUnwind, ExposesWith, StatementBuilder

@API(status=STABLE, since="2021.2.1") public interface LoadCSVStatementBuilder extends StatementBuilder
Since:
2021.2.1
Author:
Michael J. Simons
  • Method Details

    • usingPeriodicCommit

      @NotNull @Contract(pure=true) static @NotNull ExposesLoadCSV usingPeriodicCommit(@Nullable @Nullable Integer rate)
      Starts building a LOAD CSV clause by using a periodic commit.
      Parameters:
      rate - The rate to be used. No checks are done on the rate, the database will verify valid values.
      Returns:
      An ongoing definition of a LOAD CSV clause
    • loadCSV

      @NotNull @Contract(pure=true) static @NotNull LoadCSVStatementBuilder.OngoingLoadCSV loadCSV(URI from, boolean withHeaders)
      Starts building a LOAD CSV.
      Parameters:
      from - The URI to load data from. Any uri that is resolvable by the database itself is valid.
      withHeaders - Set to true if the csv file contains header
      Returns:
      An ongoing definition of a LOAD CSV clause
    • withFieldTerminator

      @NotNull @Contract(pure=true) @NotNull StatementBuilder withFieldTerminator(String fieldTerminator)
      Configure a field terminator in case the fields aren't separated with the default ,
      Parameters:
      fieldTerminator - A new field terminator
      Returns:
      A statement builder supporting all available clauses