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 \ ImportContextMethods
__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 | |