Google Cloud Sql Admin V1 Client - Class SqlCsvImportOptions (0.19.0)

Reference documentation and code samples for the Google Cloud Sql Admin V1 Client class SqlCsvImportOptions.

Generated from protobuf message google.cloud.sql.v1.ImportContext.SqlCsvImportOptions

Namespace

Google \ Cloud \ Sql \ V1 \ ImportContext

Methods

__construct

Constructor.

Parameters
Name Description
data array

Optional. Data for populating the Message object.

↳ table string

The table to which CSV data is imported.

↳ columns array

The columns to which CSV data is imported. If not specified, all columns of the database table are loaded with CSV data.

↳ escape_character string

Specifies the character that should appear before a data character that needs to be escaped.

↳ quote_character string

Specifies the quoting character to be used when a data value is quoted.

↳ fields_terminated_by string

Specifies the character that separates columns within each row (line) of the file.

↳ lines_terminated_by string

This is used to separate lines. If a line does not contain all fields, the rest of the columns are set to their default values.

getTable

The table to which CSV data is imported.

Returns
Type Description
string

setTable

The table to which CSV data is imported.

Parameter
Name Description
var string
Returns
Type Description
$this

getColumns

The columns to which CSV data is imported. If not specified, all columns of the database table are loaded with CSV data.

Returns
Type Description
Google\Protobuf\Internal\RepeatedField

setColumns

The columns to which CSV data is imported. If not specified, all columns of the database table are loaded with CSV data.

Parameter
Name Description
var string[]
Returns
Type Description
$this

getEscapeCharacter

Specifies the character that should appear before a data character that needs to be escaped.

Returns
Type Description
string

setEscapeCharacter

Specifies the character that should appear before a data character that needs to be escaped.

Parameter
Name Description
var string
Returns
Type Description
$this

getQuoteCharacter

Specifies the quoting character to be used when a data value is quoted.

Returns
Type Description
string

setQuoteCharacter

Specifies the quoting character to be used when a data value is quoted.

Parameter
Name Description
var string
Returns
Type Description
$this

getFieldsTerminatedBy

Specifies the character that separates columns within each row (line) of the file.

Returns
Type Description
string

setFieldsTerminatedBy

Specifies the character that separates columns within each row (line) of the file.

Parameter
Name Description
var string
Returns
Type Description
$this

getLinesTerminatedBy

This is used to separate lines. If a line does not contain all fields, the rest of the columns are set to their default values.

Returns
Type Description
string

setLinesTerminatedBy

This is used to separate lines. If a line does not contain all fields, the rest of the columns are set to their default values.

Parameter
Name Description
var string
Returns
Type Description
$this