Api-roll 41: 2016-08-26

generated/googleapis/lib/bigquery/v2.dart

 // This is a generated file (see the discoveryapis_generator project).
 
 library googleapis.bigquery.v2;
 
 import 'dart:core' as core;
 import 'dart:collection' as collection;
 import 'dart:async' as async;
 import 'dart:convert' as convert;
 
 import 'package:_discoveryapis_commons/_discoveryapis_commons.dart' as commons;
@@ skipping 2809 matching lines @@
   TableSchema schema;
   /**
    * [Deprecated] The inline schema. For CSV schemas, specify as
    * "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER,
    * baz:FLOAT".
    */
   core.String schemaInline;
   /** [Deprecated] The format of the schemaInline property. */
   core.String schemaInlineFormat;
   /**
+   * [Experimental] Allows the schema of the desitination table to be updated as
+   * a side effect of the load job. Schema update options are supported in two
+   * cases: when writeDisposition is WRITE_APPEND; when writeDisposition is
+   * WRITE_TRUNCATE and the destination table is a partition of a table,
+   * specified by partition decorators. For normal tables, WRITE_TRUNCATE will
+   * always overwrite the schema. One or more of the following values are
+   * specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the
+   * schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the
+   * original schema to nullable.
+   */
+  core.List<core.String> schemaUpdateOptions;
+  /**
    * [Optional] The number of rows at the top of a CSV file that BigQuery will
    * skip when loading the data. The default value is 0. This property is useful
    * if you have header rows in the file that should be skipped.
    */
   core.int skipLeadingRows;
   /**
    * [Optional] The format of the data files. For CSV files, specify "CSV". For
    * datastore backups, specify "DATASTORE_BACKUP". For newline-delimited JSON,
    * specify "NEWLINE_DELIMITED_JSON". For Avro, specify "AVRO". The default
    * value is CSV.
@@ skipping 56 matching lines @@
     }
     if (_json.containsKey("schema")) {
       schema = new TableSchema.fromJson(_json["schema"]);
     }
     if (_json.containsKey("schemaInline")) {
       schemaInline = _json["schemaInline"];
     }
     if (_json.containsKey("schemaInlineFormat")) {
       schemaInlineFormat = _json["schemaInlineFormat"];
     }
+    if (_json.containsKey("schemaUpdateOptions")) {
+      schemaUpdateOptions = _json["schemaUpdateOptions"];
+    }
     if (_json.containsKey("skipLeadingRows")) {
       skipLeadingRows = _json["skipLeadingRows"];
     }
     if (_json.containsKey("sourceFormat")) {
       sourceFormat = _json["sourceFormat"];
     }
     if (_json.containsKey("sourceUris")) {
       sourceUris = _json["sourceUris"];
     }
     if (_json.containsKey("writeDisposition")) {
@@ skipping 38 matching lines @@
     }
     if (schema != null) {
       _json["schema"] = (schema).toJson();
     }
     if (schemaInline != null) {
       _json["schemaInline"] = schemaInline;
     }
     if (schemaInlineFormat != null) {
       _json["schemaInlineFormat"] = schemaInlineFormat;
     }
+    if (schemaUpdateOptions != null) {
+      _json["schemaUpdateOptions"] = schemaUpdateOptions;
+    }
     if (skipLeadingRows != null) {
       _json["skipLeadingRows"] = skipLeadingRows;
     }
     if (sourceFormat != null) {
       _json["sourceFormat"] = sourceFormat;
     }
     if (sourceUris != null) {
       _json["sourceUris"] = sourceUris;
     }
     if (writeDisposition != null) {
@@ skipping 39 matching lines @@
    * usage beyond this tier will fail (without incurring a charge). If
    * unspecified, this will be set to your project default.
    */
   core.int maximumBillingTier;
   /**
    * [Optional] Limits the bytes billed for this job. Queries that will have
    * bytes billed beyond this limit will fail (without incurring a charge). If
    * unspecified, this will be set to your project default.
    */
   core.String maximumBytesBilled;
+  /**
+   * [Experimental] Standard SQL only. Whether to use positional (?) or named
+   * (@myparam) query parameters in this query.
+   */
+  core.String parameterMode;
   /** [Deprecated] This property is deprecated. */
   core.bool preserveNulls;
   /**
    * [Optional] Specifies a priority for the query. Possible values include
    * INTERACTIVE and BATCH. The default value is INTERACTIVE.
    */
   core.String priority;
   /** [Required] BigQuery SQL query to execute. */
   core.String query;
+  /** [Experimental] Query parameters for Standard SQL queries. */
+  core.List<QueryParameter> queryParameters;
+  /**
+   * [Experimental] Allows the schema of the desitination table to be updated as
+   * a side effect of the query job. Schema update options are supported in two
+   * cases: when writeDisposition is WRITE_APPEND; when writeDisposition is
+   * WRITE_TRUNCATE and the destination table is a partition of a table,
+   * specified by partition decorators. For normal tables, WRITE_TRUNCATE will
+   * always overwrite the schema. One or more of the following values are
+   * specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the
+   * schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the
+   * original schema to nullable.
+   */
+  core.List<core.String> schemaUpdateOptions;
   /**
    * [Optional] If querying an external data source outside of BigQuery,
    * describes the data format, location and other properties of the data
    * source. By defining these properties, the data source can then be queried
    * as if it were a standard BigQuery table.
    */
   core.Map<core.String, ExternalDataConfiguration> tableDefinitions;
   /**
    * [Experimental] Specifies whether to use BigQuery's legacy SQL dialect for
    * this query. The default value is true. If set to false, the query will use
@@ skipping 45 matching lines @@
     }
     if (_json.containsKey("flattenResults")) {
       flattenResults = _json["flattenResults"];
     }
     if (_json.containsKey("maximumBillingTier")) {
       maximumBillingTier = _json["maximumBillingTier"];
     }
     if (_json.containsKey("maximumBytesBilled")) {
       maximumBytesBilled = _json["maximumBytesBilled"];
     }
+    if (_json.containsKey("parameterMode")) {
+      parameterMode = _json["parameterMode"];
+    }
     if (_json.containsKey("preserveNulls")) {
       preserveNulls = _json["preserveNulls"];
     }
     if (_json.containsKey("priority")) {
       priority = _json["priority"];
     }
     if (_json.containsKey("query")) {
       query = _json["query"];
     }
+    if (_json.containsKey("queryParameters")) {
+      queryParameters = _json["queryParameters"].map((value) => new QueryParameter.fromJson(value)).toList();
+    }
+    if (_json.containsKey("schemaUpdateOptions")) {
+      schemaUpdateOptions = _json["schemaUpdateOptions"];
+    }
     if (_json.containsKey("tableDefinitions")) {
       tableDefinitions = commons.mapMap(_json["tableDefinitions"], (item) => new ExternalDataConfiguration.fromJson(item));
     }
     if (_json.containsKey("useLegacySql")) {
       useLegacySql = _json["useLegacySql"];
     }
     if (_json.containsKey("useQueryCache")) {
       useQueryCache = _json["useQueryCache"];
     }
     if (_json.containsKey("userDefinedFunctionResources")) {
@@ skipping 20 matching lines @@
     }
     if (flattenResults != null) {
       _json["flattenResults"] = flattenResults;
     }
     if (maximumBillingTier != null) {
       _json["maximumBillingTier"] = maximumBillingTier;
     }
     if (maximumBytesBilled != null) {
       _json["maximumBytesBilled"] = maximumBytesBilled;
     }
+    if (parameterMode != null) {
+      _json["parameterMode"] = parameterMode;
+    }
     if (preserveNulls != null) {
       _json["preserveNulls"] = preserveNulls;
     }
     if (priority != null) {
       _json["priority"] = priority;
     }
     if (query != null) {
       _json["query"] = query;
     }
+    if (queryParameters != null) {
+      _json["queryParameters"] = queryParameters.map((value) => (value).toJson()).toList();
+    }
+    if (schemaUpdateOptions != null) {
+      _json["schemaUpdateOptions"] = schemaUpdateOptions;
+    }
     if (tableDefinitions != null) {
       _json["tableDefinitions"] = commons.mapMap(tableDefinitions, (item) => (item).toJson());
     }
     if (useLegacySql != null) {
       _json["useLegacySql"] = useLegacySql;
     }
     if (useQueryCache != null) {
       _json["useQueryCache"] = useQueryCache;
     }
     if (userDefinedFunctionResources != null) {
@@ skipping 348 matching lines @@
   core.List<TableReference> referencedTables;
   /**
    * [Output-only, Experimental] The schema of the results. Present only for
    * successful dry run of non-legacy SQL queries.
    */
   TableSchema schema;
   /** [Output-only] Total bytes billed for the job. */
   core.String totalBytesBilled;
   /** [Output-only] Total bytes processed for the job. */
   core.String totalBytesProcessed;
+  /**
+   * [Output-only, Experimental] Standard SQL only: list of undeclared query
+   * parameters detected during a dry run validation.
+   */
+  core.List<QueryParameter> undeclaredQueryParameters;
 
   JobStatistics2();
 
   JobStatistics2.fromJson(core.Map _json) {
     if (_json.containsKey("billingTier")) {
       billingTier = _json["billingTier"];
     }
     if (_json.containsKey("cacheHit")) {
       cacheHit = _json["cacheHit"];
     }
     if (_json.containsKey("numDmlAffectedRows")) {
       numDmlAffectedRows = _json["numDmlAffectedRows"];
     }
     if (_json.containsKey("queryPlan")) {
       queryPlan = _json["queryPlan"].map((value) => new ExplainQueryStage.fromJson(value)).toList();
     }
     if (_json.containsKey("referencedTables")) {
       referencedTables = _json["referencedTables"].map((value) => new TableReference.fromJson(value)).toList();
     }
     if (_json.containsKey("schema")) {
       schema = new TableSchema.fromJson(_json["schema"]);
     }
     if (_json.containsKey("totalBytesBilled")) {
       totalBytesBilled = _json["totalBytesBilled"];
     }
     if (_json.containsKey("totalBytesProcessed")) {
       totalBytesProcessed = _json["totalBytesProcessed"];
     }
+    if (_json.containsKey("undeclaredQueryParameters")) {
+      undeclaredQueryParameters = _json["undeclaredQueryParameters"].map((value) => new QueryParameter.fromJson(value)).toList();
+    }
   }
 
   core.Map toJson() {
     var _json = new core.Map();
     if (billingTier != null) {
       _json["billingTier"] = billingTier;
     }
     if (cacheHit != null) {
       _json["cacheHit"] = cacheHit;
     }
     if (numDmlAffectedRows != null) {
       _json["numDmlAffectedRows"] = numDmlAffectedRows;
     }
     if (queryPlan != null) {
       _json["queryPlan"] = queryPlan.map((value) => (value).toJson()).toList();
     }
     if (referencedTables != null) {
       _json["referencedTables"] = referencedTables.map((value) => (value).toJson()).toList();
     }
     if (schema != null) {
       _json["schema"] = (schema).toJson();
     }
     if (totalBytesBilled != null) {
       _json["totalBytesBilled"] = totalBytesBilled;
     }
     if (totalBytesProcessed != null) {
       _json["totalBytesProcessed"] = totalBytesProcessed;
     }
+    if (undeclaredQueryParameters != null) {
+      _json["undeclaredQueryParameters"] = undeclaredQueryParameters.map((value) => (value).toJson()).toList();
+    }
     return _json;
   }
 }
 
 class JobStatistics3 {
   /** [Output-only] Number of bytes of source data in a load job. */
   core.String inputFileBytes;
   /** [Output-only] Number of source files in a load job. */
   core.String inputFiles;
   /**
@@ skipping 271 matching lines @@
 
   core.Map toJson() {
     var _json = new core.Map();
     if (projectId != null) {
       _json["projectId"] = projectId;
     }
     return _json;
   }
 }
 
+class QueryParameter {
+  /**
+   * [Optional] If unset, this is a positional parameter. Otherwise, should be
+   * unique within a query.
+   */
+  core.String name;
+  /** [Required] The type of this parameter. */
+  QueryParameterType parameterType;
+  /** [Required] The value of this parameter. */
+  QueryParameterValue parameterValue;
+
+  QueryParameter();
+
+  QueryParameter.fromJson(core.Map _json) {
+    if (_json.containsKey("name")) {
+      name = _json["name"];
+    }
+    if (_json.containsKey("parameterType")) {
+      parameterType = new QueryParameterType.fromJson(_json["parameterType"]);
+    }
+    if (_json.containsKey("parameterValue")) {
+      parameterValue = new QueryParameterValue.fromJson(_json["parameterValue"]);
+    }
+  }
+
+  core.Map toJson() {
+    var _json = new core.Map();
+    if (name != null) {
+      _json["name"] = name;
+    }
+    if (parameterType != null) {
+      _json["parameterType"] = (parameterType).toJson();
+    }
+    if (parameterValue != null) {
+      _json["parameterValue"] = (parameterValue).toJson();
+    }
+    return _json;
+  }
+}
+
+class QueryParameterTypeStructTypes {
+  /** [Optional] Human-oriented description of the field. */
+  core.String description;
+  /** [Optional] The name of this field. */
+  core.String name;
+  /** [Required] The type of this field. */
+  QueryParameterType type;
+
+  QueryParameterTypeStructTypes();
+
+  QueryParameterTypeStructTypes.fromJson(core.Map _json) {
+    if (_json.containsKey("description")) {
+      description = _json["description"];
+    }
+    if (_json.containsKey("name")) {
+      name = _json["name"];
+    }
+    if (_json.containsKey("type")) {
+      type = new QueryParameterType.fromJson(_json["type"]);
+    }
+  }
+
+  core.Map toJson() {
+    var _json = new core.Map();
+    if (description != null) {
+      _json["description"] = description;
+    }
+    if (name != null) {
+      _json["name"] = name;
+    }
+    if (type != null) {
+      _json["type"] = (type).toJson();
+    }
+    return _json;
+  }
+}
+
+class QueryParameterType {
+  /** [Optional] The type of the array's elements, if this is an array. */
+  QueryParameterType arrayType;
+  /**
+   * [Optional] The types of the fields of this struct, in order, if this is a
+   * struct.
+   */
+  core.List<QueryParameterTypeStructTypes> structTypes;
+  /** [Required] The top level type of this field. */
+  core.String type;
+
+  QueryParameterType();
+
+  QueryParameterType.fromJson(core.Map _json) {
+    if (_json.containsKey("arrayType")) {
+      arrayType = new QueryParameterType.fromJson(_json["arrayType"]);
+    }
+    if (_json.containsKey("structTypes")) {
+      structTypes = _json["structTypes"].map((value) => new QueryParameterTypeStructTypes.fromJson(value)).toList();
+    }
+    if (_json.containsKey("type")) {
+      type = _json["type"];
+    }
+  }
+
+  core.Map toJson() {
+    var _json = new core.Map();
+    if (arrayType != null) {
+      _json["arrayType"] = (arrayType).toJson();
+    }
+    if (structTypes != null) {
+      _json["structTypes"] = structTypes.map((value) => (value).toJson()).toList();
+    }
+    if (type != null) {
+      _json["type"] = type;
+    }
+    return _json;
+  }
+}
+
+class QueryParameterValue {
+  /** [Optional] The array values, if this is an array type. */
+  core.List<QueryParameterValue> arrayValues;
+  /**
+   * [Optional] The struct field values, in order of the struct type's
+   * declaration.
+   */
+  core.List<QueryParameterValue> structValues;
+  /** [Optional] The value of this value, if a simple scalar type. */
+  core.String value;
+
+  QueryParameterValue();
+
+  QueryParameterValue.fromJson(core.Map _json) {
+    if (_json.containsKey("arrayValues")) {
+      arrayValues = _json["arrayValues"].map((value) => new QueryParameterValue.fromJson(value)).toList();
+    }
+    if (_json.containsKey("structValues")) {
+      structValues = _json["structValues"].map((value) => new QueryParameterValue.fromJson(value)).toList();
+    }
+    if (_json.containsKey("value")) {
+      value = _json["value"];
+    }
+  }
+
+  core.Map toJson() {
+    var _json = new core.Map();
+    if (arrayValues != null) {
+      _json["arrayValues"] = arrayValues.map((value) => (value).toJson()).toList();
+    }
+    if (structValues != null) {
+      _json["structValues"] = structValues.map((value) => (value).toJson()).toList();
+    }
+    if (value != null) {
+      _json["value"] = value;
+    }
+    return _json;
+  }
+}
+
 class QueryRequest {
   /**
    * [Optional] Specifies the default datasetId and projectId to assume for any
    * unqualified table names in the query. If not set, all table names in the
    * query string must be qualified in the format 'datasetId.tableId'.
    */
   DatasetReference defaultDataset;
   /**
    * [Optional] If set to true, BigQuery doesn't run the job. Instead, if the
    * query is valid, BigQuery returns statistics about the job such as how many
    * bytes would be processed. If the query is invalid, an error returns. The
    * default value is false.
    */
   core.bool dryRun;
   /** The resource type of the request. */
   core.String kind;
   /**
    * [Optional] The maximum number of rows of data to return per page of
    * results. Setting this flag to a small value such as 1000 and then paging
    * through results might improve reliability when the query result set is
    * large. In addition to this limit, responses are also limited to 10 MB. By
    * default, there is no maximum row count, and only the byte limit applies.
    */
   core.int maxResults;
+  /**
+   * [Experimental] Standard SQL only. Whether to use positional (?) or named
+   * (@myparam) query parameters in this query.
+   */
+  core.String parameterMode;
   /** [Deprecated] This property is deprecated. */
   core.bool preserveNulls;
   /**
    * [Required] A query string, following the BigQuery query syntax, of the
    * query to execute. Example: "SELECT count(f1) FROM
    * [myProjectId:myDatasetId.myTableId]".
    */
   core.String query;
+  /** [Experimental] Query parameters for Standard SQL queries. */
+  core.List<QueryParameter> queryParameters;
   /**
    * [Optional] How long to wait for the query to complete, in milliseconds,
    * before the request times out and returns. Note that this is only a timeout
    * for the request, not the query. If the query takes longer to run than the
    * timeout value, the call returns without any results and with the
    * 'jobComplete' flag set to false. You can call GetQueryResults() to wait for
    * the query to complete and read the results. The default value is 10000
    * milliseconds (10 seconds).
    */
   core.int timeoutMs;
@@ skipping 21 matching lines @@
     }
     if (_json.containsKey("dryRun")) {
       dryRun = _json["dryRun"];
     }
     if (_json.containsKey("kind")) {
       kind = _json["kind"];
     }
     if (_json.containsKey("maxResults")) {
       maxResults = _json["maxResults"];
     }
+    if (_json.containsKey("parameterMode")) {
+      parameterMode = _json["parameterMode"];
+    }
     if (_json.containsKey("preserveNulls")) {
       preserveNulls = _json["preserveNulls"];
     }
     if (_json.containsKey("query")) {
       query = _json["query"];
     }
+    if (_json.containsKey("queryParameters")) {
+      queryParameters = _json["queryParameters"].map((value) => new QueryParameter.fromJson(value)).toList();
+    }
     if (_json.containsKey("timeoutMs")) {
       timeoutMs = _json["timeoutMs"];
     }
     if (_json.containsKey("useLegacySql")) {
       useLegacySql = _json["useLegacySql"];
     }
     if (_json.containsKey("useQueryCache")) {
       useQueryCache = _json["useQueryCache"];
     }
   }
 
   core.Map toJson() {
     var _json = new core.Map();
     if (defaultDataset != null) {
       _json["defaultDataset"] = (defaultDataset).toJson();
     }
     if (dryRun != null) {
       _json["dryRun"] = dryRun;
     }
     if (kind != null) {
       _json["kind"] = kind;
     }
     if (maxResults != null) {
       _json["maxResults"] = maxResults;
     }
+    if (parameterMode != null) {
+      _json["parameterMode"] = parameterMode;
+    }
     if (preserveNulls != null) {
       _json["preserveNulls"] = preserveNulls;
     }
     if (query != null) {
       _json["query"] = query;
     }
+    if (queryParameters != null) {
+      _json["queryParameters"] = queryParameters.map((value) => (value).toJson()).toList();
+    }
     if (timeoutMs != null) {
       _json["timeoutMs"] = timeoutMs;
     }
     if (useLegacySql != null) {
       _json["useLegacySql"] = useLegacySql;
     }
     if (useQueryCache != null) {
       _json["useQueryCache"] = useQueryCache;
     }
     return _json;
@@ skipping 1002 matching lines @@
     }
     if (useLegacySql != null) {
       _json["useLegacySql"] = useLegacySql;
     }
     if (userDefinedFunctionResources != null) {
       _json["userDefinedFunctionResources"] = userDefinedFunctionResources.map((value) => (value).toJson()).toList();
     }
     return _json;
   }
 }