Google Cloud Sql Admin V1 Client - Class SqlCsvImportOptions (0.7.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
NameDescription
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
TypeDescription
string

setTable

The table to which CSV data is imported.

Parameter
NameDescription
var string
Returns
TypeDescription
$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
TypeDescription
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
NameDescription
var string[]
Returns
TypeDescription
$this

getEscapeCharacter

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

Returns
TypeDescription
string

setEscapeCharacter

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

Parameter
NameDescription
var string
Returns
TypeDescription
$this

getQuoteCharacter

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

Returns
TypeDescription
string

setQuoteCharacter

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

Parameter
NameDescription
var string
Returns
TypeDescription
$this

getFieldsTerminatedBy

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

Returns
TypeDescription
string

setFieldsTerminatedBy

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

Parameter
NameDescription
var string
Returns
TypeDescription
$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
TypeDescription
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
NameDescription
var string
Returns
TypeDescription
$this