As of January 1, 2020 this library no longer supports Python 2 on the latest released version. Library versions released prior to that date will continue to be available. For more information please visit Python 2 support on Google Cloud.

Execute Query Metadata

This module provides the SqlType class used for specifying types in ExecuteQuery and some utilities.

The SqlTypes are used in Metadata returned by the ExecuteQuery operation as well as for specifying query parameter types explicitly.

class google.cloud.bigtable.data.execute_query.metadata.Metadata[source]

Bases: object

Base class for metadata returned by the ExecuteQuery operation.

class google.cloud.bigtable.data.execute_query.metadata.ProtoMetadata(columns: Optional[List[Tuple[Optional[str], google.cloud.bigtable.data.execute_query.metadata.SqlType.Type]]] = None)[source]

Bases: google.cloud.bigtable.data.execute_query.metadata.Metadata

Metadata class for the ExecuteQuery operation.

Parameters

columns (List[Tuple[Optional[str], SqlType.Type]]) – List of column metadata tuples. Each tuple contains the column name and the column type.

class google.cloud.bigtable.data.execute_query.metadata.SqlType[source]

Bases: object

Classes denoting types of values returned by Bigtable’s ExecuteQuery operation.

Used in Metadata.

class Array(element_type: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type)[source]

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Array SQL type.

class Bool[source]

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Bool SQL type.

expected_type

alias of bool

class Bytes[source]

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Bytes SQL type.

expected_type

alias of bytes

class Date[source]

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Date SQL type.

expected_type

alias of datetime.date

class Float64[source]

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Float64 SQL type.

expected_type

alias of float

class Int64[source]

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Int64 SQL type.

expected_type

alias of int

class Map(key_type: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type, value_type: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type)[source]

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Map SQL type.

class String[source]

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

String SQL type.

expected_type

alias of str

class Struct(fields: Optional[List[Tuple[Optional[str], google.cloud.bigtable.data.execute_query.values.T]]] = None)[source]

Bases: google.cloud.bigtable.data.execute_query.values._NamedList[google.cloud.bigtable.data.execute_query.metadata.SqlType.Type], google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Struct SQL type.

class Timestamp[source]

Bases: google.cloud.bigtable.data.execute_query.metadata.SqlType.Type

Timestamp SQL type.

Timestamp supports DatetimeWithNanoseconds but Bigtable SQL does not currently support nanoseconds precision. We support this for potential compatibility in the future. Nanoseconds are currently ignored.