Google Cloud Sql Admin V1 Client - Class SqlCsvExportOptions (0.5.0)

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

Generated from protobuf message google.cloud.sql.v1.ExportContext.SqlCsvExportOptions

Namespace

Google \ Cloud \ Sql \ V1 \ ExportContext

Methods

__construct

Constructor.

Parameters
NameDescription
data array

Optional. Data for populating the Message object.

↳ select_query string

The select query used to extract the 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.

getSelectQuery

The select query used to extract the data.

Returns
TypeDescription
string

setSelectQuery

The select query used to extract the 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