A RetroSearch Logo

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Search Query:

Showing content from https://cloud.google.com/python/docs/reference/bigquery/1.16.0/google.cloud.bigquery.dbapi.Cursor below:

Class Cursor (1.16.0) | Python client library

Class Cursor (1.16.0)

Stay organized with collections Save and categorize content based on your preferences.

DB-API Cursor to Google BigQuery.

Parameter Name Description connection Connection

A DB-API connection to Google BigQuery.

Inheritancebuiltins.object > Cursor

Methods close

No-op.

execute
execute(operation, parameters=None, job_id=None)

Prepare and execute a database operation.

.. note:: When setting query parameters, values which are "text" (unicode in Python2, str in Python3) will use the 'STRING' BigQuery type. Values which are "bytes" (str in Python2, bytes in Python3), will use using the 'BYTES' type.

A ``datetime.datetime`` parameter without timezone information uses
the 'DATETIME' BigQuery type (example: Global Pi Day Celebration
March 14, 2017 at 1:59pm). A ``datetime.datetime`` parameter with
timezone information uses the 'TIMESTAMP' BigQuery type (example:
a wedding on April 29, 2011 at 11am, British Summer Time).

For more information about BigQuery data types, see:
https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types

``STRUCT``/``RECORD`` and ``REPEATED`` query parameters are not
yet supported. See:
https://github.com/GoogleCloudPlatform/google-cloud-python/issues/3524
Parameters Name Description operation str

A Google BigQuery query string.

parameters Mapping[str, Any] or Sequence[Any]

(Optional) dictionary or sequence of parameter values.

job_id str

(Optional) The job_id to use. If not set, a job ID is generated at random.

executemany
executemany(operation, seq_of_parameters)

Prepare and execute a database operation multiple times.

Parameter Name Description operation str

A Google BigQuery query string.

fetchall

Fetch all remaining results from the last execute*() call.

Exceptions Returns Type Description List[tuple] A list of all the rows in the results. fetchmany

Fetch multiple results from the last execute*() call.

.. note:: The size parameter is not used for the request/response size. Set the arraysize attribute before calling execute() to set the batch size.

Parameter Name Description size int

(Optional) Maximum number of rows to return. Defaults to the arraysize property value.

Exceptions Returns Type Description List[tuple] A list of rows. fetchone

Fetch a single row from the results of the last execute*() call.

Exceptions Returns Type Description tuple A tuple representing a row or ``None`` if no more data is available. setinputsizes

No-op.

setoutputsize
setoutputsize(size, column=None)

No-op.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-07-24 UTC.

[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-07-24 UTC."],[],[]]


RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4