Class: Google::Apis::SqladminV1beta4::ImportContext::CsvImportOptions

Inherits:
Object
  • Object
show all
Includes:
Core::Hashable, Core::JsonObjectSupport
Defined in:
lib/google/apis/sqladmin_v1beta4/classes.rb,
lib/google/apis/sqladmin_v1beta4/representations.rb,
lib/google/apis/sqladmin_v1beta4/representations.rb

Overview

Options for importing data as CSV.

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(**args) ⇒ CsvImportOptions

Returns a new instance of CsvImportOptions.



2105
2106
2107
 
# File 'lib/google/apis/sqladmin_v1beta4/classes.rb', line 2105

def initialize(**args)
   update!(**args)
end

Instance Attribute Details

#columns ⇒ Array<String>

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

Returns:

  • (Array<String>) 


2075
2076
2077
 
# File 'lib/google/apis/sqladmin_v1beta4/classes.rb', line 2075

def columns
  @columns
end

#escape_character ⇒ String

Specifies the character that should appear before a data character that needs to be escaped. Corresponds to the JSON property escapeCharacter

Returns:

  • (String) 


2081
2082
2083
 
# File 'lib/google/apis/sqladmin_v1beta4/classes.rb', line 2081

def escape_character
  @escape_character
end

#fields_terminated_by ⇒ String

Specifies the character that separates columns within each row (line) of the file. Corresponds to the JSON property fieldsTerminatedBy

Returns:

  • (String) 


2087
2088
2089
 
# File 'lib/google/apis/sqladmin_v1beta4/classes.rb', line 2087

def fields_terminated_by
  @fields_terminated_by
end

#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. Corresponds to the JSON property linesTerminatedBy

Returns:

  • (String) 


2093
2094
2095
 
# File 'lib/google/apis/sqladmin_v1beta4/classes.rb', line 2093

def lines_terminated_by
  @lines_terminated_by
end

#quote_character ⇒ String

Specifies the quoting character to be used when a data value is quoted. Corresponds to the JSON property quoteCharacter

Returns:

  • (String) 


2098
2099
2100
 
# File 'lib/google/apis/sqladmin_v1beta4/classes.rb', line 2098

def quote_character
  @quote_character
end

#table ⇒ String

The table to which CSV data is imported. Corresponds to the JSON property table

Returns:

  • (String) 


2103
2104
2105
 
# File 'lib/google/apis/sqladmin_v1beta4/classes.rb', line 2103

def table
  @table
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



2110
2111
2112
2113
2114
2115
2116
2117
 
# File 'lib/google/apis/sqladmin_v1beta4/classes.rb', line 2110

def update!(**args)
  @columns = args[:columns] if args.key?(:columns)
  @escape_character = args[:escape_character] if args.key?(:escape_character)
  @fields_terminated_by = args[:fields_terminated_by] if args.key?(:fields_terminated_by)
  @lines_terminated_by = args[:lines_terminated_by] if args.key?(:lines_terminated_by)
  @quote_character = args[:quote_character] if args.key?(:quote_character)
  @table = args[:table] if args.key?(:table)
end