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

Constructor Details

#initialize(**args) ⇒ Routine

Returns a new instance of Routine.



5314
5315
5316
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5314

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

Instance Attribute Details

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

Optional. Corresponds to the JSON property arguments



5241
5242
5243
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5241

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)


5247
5248
5249
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5247

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)


5261
5262
5263
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5261

def definition_body
  @definition_body
end

#descriptionString

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

Returns:

  • (String)


5266
5267
5268
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5266

def description
  @description
end

#determinism_levelString

Optional. [Experimental] The determinism level of the JavaScript UDF if defined. Corresponds to the JSON property determinismLevel

Returns:

  • (String)


5272
5273
5274
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5272

def determinism_level
  @determinism_level
end

#etagString

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

Returns:

  • (String)


5277
5278
5279
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5277

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>)


5283
5284
5285
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5283

def imported_libraries
  @imported_libraries
end

#languageString

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

Returns:

  • (String)


5288
5289
5290
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5288

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)


5294
5295
5296
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5294

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`



5302
5303
5304
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5302

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



5307
5308
5309
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5307

def routine_reference
  @routine_reference
end

#routine_typeString

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

Returns:

  • (String)


5312
5313
5314
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5312

def routine_type
  @routine_type
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



5319
5320
5321
5322
5323
5324
5325
5326
5327
5328
5329
5330
5331
5332
# File 'generated/google/apis/bigquery_v2/classes.rb', line 5319

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)
  @determinism_level = args[:determinism_level] if args.key?(:determinism_level)
  @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