Class: Google::Apis::BigqueryV2::Routine

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

Overview

A user-defined function or a stored procedure.

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from Core::JsonObjectSupport

#to_json

Methods included from Core::Hashable

process_value, #to_h

Constructor Details

#initialize(**args) ⇒ Routine

Returns a new instance of Routine.



5140
5141
5142
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5140

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

Instance Attribute Details

#argumentsArray<Google::Apis::BigqueryV2::Argument>

Optional. Corresponds to the JSON property arguments



5063
5064
5065
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5063

def arguments
  @arguments
end

#creation_timeFixnum

Output only. The time when this routine was created, in milliseconds since the epoch. Corresponds to the JSON property creationTime

Returns:

  • (Fixnum)


5069
5070
5071
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5069

def creation_time
  @creation_time
end

#definition_bodyString

Required. The body of the routine. For functions, this is the expression in the AS clause. If language=SQL, it is the substring inside (but excluding) the parentheses. For example, for the function created with the following statement: CREATE FUNCTION JoinLines(x string, y string) as (concat(x, "\n", y)) The definition_body is concat(x, "\n", y) (\n is not replaced with linebreak). If language=JAVASCRIPT, it is the evaluated string in the AS clause. For example, for the function created with the following statement: CREATE FUNCTION f() RETURNS STRING LANGUAGE js AS 'return "\n";\n' The definition_body is return "\n";\n Note that both \n are replaced with linebreaks. Corresponds to the JSON property definitionBody

Returns:

  • (String)


5087
5088
5089
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5087

def definition_body
  @definition_body
end

#descriptionString

Optional. [Experimental] The description of the routine if defined. Corresponds to the JSON property description

Returns:

  • (String)


5092
5093
5094
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5092

def description
  @description
end

#etagString

Output only. A hash of this resource. Corresponds to the JSON property etag

Returns:

  • (String)


5097
5098
5099
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5097

def etag
  @etag
end

#imported_librariesArray<String>

Optional. If language = "JAVASCRIPT", this field stores the path of the imported JAVASCRIPT libraries. Corresponds to the JSON property importedLibraries

Returns:

  • (Array<String>)


5103
5104
5105
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5103

def imported_libraries
  @imported_libraries
end

#languageString

Optional. Defaults to "SQL". Corresponds to the JSON property language

Returns:

  • (String)


5108
5109
5110
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5108

def language
  @language
end

#last_modified_timeFixnum

Output only. The time when this routine was last modified, in milliseconds since the epoch. Corresponds to the JSON property lastModifiedTime

Returns:

  • (Fixnum)


5114
5115
5116
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5114

def last_modified_time
  @last_modified_time
end

#return_typeGoogle::Apis::BigqueryV2::StandardSqlDataType

The type of a variable, e.g., a function argument. Examples: INT64: type_kind="INT64" ARRAY: type_kind="ARRAY", array_element_type="STRING" STRUCT>: type_kind="STRUCT", struct_type=fields=[ name="x", type=type_kind="STRING", `name="y", type=`type_kind="ARRAY", array_element_type="DATE" ]` Corresponds to the JSON propertyreturnType`



5128
5129
5130
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5128

def return_type
  @return_type
end

#routine_referenceGoogle::Apis::BigqueryV2::RoutineReference

Required. Reference describing the ID of this routine. Corresponds to the JSON property routineReference



5133
5134
5135
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5133

def routine_reference
  @routine_reference
end

#routine_typeString

Required. The type of routine. Corresponds to the JSON property routineType

Returns:

  • (String)


5138
5139
5140
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5138

def routine_type
  @routine_type
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
5155
5156
5157
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5145

def update!(**args)
  @arguments = args[:arguments] if args.key?(:arguments)
  @creation_time = args[:creation_time] if args.key?(:creation_time)
  @definition_body = args[:definition_body] if args.key?(:definition_body)
  @description = args[:description] if args.key?(:description)
  @etag = args[:etag] if args.key?(:etag)
  @imported_libraries = args[:imported_libraries] if args.key?(:imported_libraries)
  @language = args[:language] if args.key?(:language)
  @last_modified_time = args[:last_modified_time] if args.key?(:last_modified_time)
  @return_type = args[:return_type] if args.key?(:return_type)
  @routine_reference = args[:routine_reference] if args.key?(:routine_reference)
  @routine_type = args[:routine_type] if args.key?(:routine_type)
end