Network.Google.Resource.Spanner.Projects.Instances.Databases.Sessions.ExecuteSQL

Executes an SQL statement, returning all results in a single reply. This method cannot be used to return a result set larger than 10 MiB; if the query yields more data than that, the query fails with a `FAILED_PRECONDITION` error. Operations inside read-write transactions might return `ABORTED`. If this occurs, the application should restart the transaction from the beginning. See Transaction for more details. Larger result sets can be fetched in streaming fashion by calling ExecuteStreamingSql instead.

See: Cloud Spanner API Reference for spanner.projects.instances.databases.sessions.executeSql.

REST Resource

type ProjectsInstancesDatabasesSessionsExecuteSQLResource = "v1" :> (CaptureMode "session" "executeSql" Text :> (QueryParam "$.xgafv" Xgafv :> (QueryParam "upload_protocol" Text :> (QueryParam "access_token" Text :> (QueryParam "uploadType" Text :> (QueryParam "callback" Text :> (QueryParam "alt" AltJSON :> (ReqBody '[JSON] ExecuteSQLRequest :> Post '[JSON] ResultSet))))))))

A resource alias for spanner.projects.instances.databases.sessions.executeSql method which the ProjectsInstancesDatabasesSessionsExecuteSQL request conforms to.

Creating a Request

projectsInstancesDatabasesSessionsExecuteSQL

Arguments

:: ExecuteSQLRequest

pidsesqlPayload

-> Text

pidsesqlSession

-> ProjectsInstancesDatabasesSessionsExecuteSQL

Creates a value of ProjectsInstancesDatabasesSessionsExecuteSQL with the minimum fields required to make a request.

Use one of the following lenses to modify other fields as desired:

• pidsesqlXgafv
• pidsesqlUploadProtocol
• pidsesqlAccessToken
• pidsesqlUploadType
• pidsesqlPayload
• pidsesqlSession
• pidsesqlCallback

data ProjectsInstancesDatabasesSessionsExecuteSQL

Executes an SQL statement, returning all results in a single reply. This method cannot be used to return a result set larger than 10 MiB; if the query yields more data than that, the query fails with a `FAILED_PRECONDITION` error. Operations inside read-write transactions might return `ABORTED`. If this occurs, the application should restart the transaction from the beginning. See Transaction for more details. Larger result sets can be fetched in streaming fashion by calling ExecuteStreamingSql instead.

See: projectsInstancesDatabasesSessionsExecuteSQL smart constructor.

Instances

Eq ProjectsInstancesDatabasesSessionsExecuteSQL

Defined in Network.Google.Resource.Spanner.Projects.Instances.Databases.Sessions.ExecuteSQL

Methods

(==) :: ProjectsInstancesDatabasesSessionsExecuteSQL -> ProjectsInstancesDatabasesSessionsExecuteSQL -> Bool

(/=) :: ProjectsInstancesDatabasesSessionsExecuteSQL -> ProjectsInstancesDatabasesSessionsExecuteSQL -> Bool

Data ProjectsInstancesDatabasesSessionsExecuteSQL

Defined in Network.Google.Resource.Spanner.Projects.Instances.Databases.Sessions.ExecuteSQL

Methods

gfoldl :: (forall d b. Data d => c (d -> b) -> d -> c b) -> (forall g. g -> c g) -> ProjectsInstancesDatabasesSessionsExecuteSQL -> c ProjectsInstancesDatabasesSessionsExecuteSQL

gunfold :: (forall b r. Data b => c (b -> r) -> c r) -> (forall r. r -> c r) -> Constr -> c ProjectsInstancesDatabasesSessionsExecuteSQL

toConstr :: ProjectsInstancesDatabasesSessionsExecuteSQL -> Constr

dataTypeOf :: ProjectsInstancesDatabasesSessionsExecuteSQL -> DataType

dataCast1 :: Typeable t => (forall d. Data d => c (t d)) -> Maybe (c ProjectsInstancesDatabasesSessionsExecuteSQL)

dataCast2 :: Typeable t => (forall d e. (Data d, Data e) => c (t d e)) -> Maybe (c ProjectsInstancesDatabasesSessionsExecuteSQL)

gmapT :: (forall b. Data b => b -> b) -> ProjectsInstancesDatabasesSessionsExecuteSQL -> ProjectsInstancesDatabasesSessionsExecuteSQL

gmapQl :: (r -> r' -> r) -> r -> (forall d. Data d => d -> r') -> ProjectsInstancesDatabasesSessionsExecuteSQL -> r

gmapQr :: (r' -> r -> r) -> r -> (forall d. Data d => d -> r') -> ProjectsInstancesDatabasesSessionsExecuteSQL -> r

gmapQ :: (forall d. Data d => d -> u) -> ProjectsInstancesDatabasesSessionsExecuteSQL -> [u]

gmapQi :: Int -> (forall d. Data d => d -> u) -> ProjectsInstancesDatabasesSessionsExecuteSQL -> u

gmapM :: Monad m => (forall d. Data d => d -> m d) -> ProjectsInstancesDatabasesSessionsExecuteSQL -> m ProjectsInstancesDatabasesSessionsExecuteSQL

gmapMp :: MonadPlus m => (forall d. Data d => d -> m d) -> ProjectsInstancesDatabasesSessionsExecuteSQL -> m ProjectsInstancesDatabasesSessionsExecuteSQL

gmapMo :: MonadPlus m => (forall d. Data d => d -> m d) -> ProjectsInstancesDatabasesSessionsExecuteSQL -> m ProjectsInstancesDatabasesSessionsExecuteSQL

Show ProjectsInstancesDatabasesSessionsExecuteSQL

Defined in Network.Google.Resource.Spanner.Projects.Instances.Databases.Sessions.ExecuteSQL

Methods

showsPrec :: Int -> ProjectsInstancesDatabasesSessionsExecuteSQL -> ShowS

show :: ProjectsInstancesDatabasesSessionsExecuteSQL -> String

showList :: [ProjectsInstancesDatabasesSessionsExecuteSQL] -> ShowS

Generic ProjectsInstancesDatabasesSessionsExecuteSQL

Defined in Network.Google.Resource.Spanner.Projects.Instances.Databases.Sessions.ExecuteSQL

Associated Types

type Rep ProjectsInstancesDatabasesSessionsExecuteSQL :: Type -> Type

Methods

from :: ProjectsInstancesDatabasesSessionsExecuteSQL -> Rep ProjectsInstancesDatabasesSessionsExecuteSQL x

to :: Rep ProjectsInstancesDatabasesSessionsExecuteSQL x -> ProjectsInstancesDatabasesSessionsExecuteSQL

GoogleRequest ProjectsInstancesDatabasesSessionsExecuteSQL

Defined in Network.Google.Resource.Spanner.Projects.Instances.Databases.Sessions.ExecuteSQL

Associated Types

type Rs ProjectsInstancesDatabasesSessionsExecuteSQL :: Type

type Scopes ProjectsInstancesDatabasesSessionsExecuteSQL :: [Symbol]

Methods

requestClient :: ProjectsInstancesDatabasesSessionsExecuteSQL -> GClient (Rs ProjectsInstancesDatabasesSessionsExecuteSQL)

type Rep ProjectsInstancesDatabasesSessionsExecuteSQL

Defined in Network.Google.Resource.Spanner.Projects.Instances.Databases.Sessions.ExecuteSQL

type Rep ProjectsInstancesDatabasesSessionsExecuteSQL = D1 (MetaData "ProjectsInstancesDatabasesSessionsExecuteSQL" "Network.Google.Resource.Spanner.Projects.Instances.Databases.Sessions.ExecuteSQL" "gogol-spanner-0.4.0-Gx6Dlj0rchWGrfXCDHk4fo" False) (C1 (MetaCons "ProjectsInstancesDatabasesSessionsExecuteSQL'" PrefixI True) ((S1 (MetaSel (Just "_pidsesqlXgafv") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Xgafv)) :*: (S1 (MetaSel (Just "_pidsesqlUploadProtocol") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Text)) :*: S1 (MetaSel (Just "_pidsesqlAccessToken") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Text)))) :*: ((S1 (MetaSel (Just "_pidsesqlUploadType") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Text)) :*: S1 (MetaSel (Just "_pidsesqlPayload") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 ExecuteSQLRequest)) :*: (S1 (MetaSel (Just "_pidsesqlSession") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Text) :*: S1 (MetaSel (Just "_pidsesqlCallback") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Text))))))

type Scopes ProjectsInstancesDatabasesSessionsExecuteSQL

Defined in Network.Google.Resource.Spanner.Projects.Instances.Databases.Sessions.ExecuteSQL

type Scopes ProjectsInstancesDatabasesSessionsExecuteSQL = "https://www.googleapis.com/auth/cloud-platform" ': ("https://www.googleapis.com/auth/spanner.data" ': ([] :: [Symbol]))

type Rs ProjectsInstancesDatabasesSessionsExecuteSQL

Defined in Network.Google.Resource.Spanner.Projects.Instances.Databases.Sessions.ExecuteSQL

type Rs ProjectsInstancesDatabasesSessionsExecuteSQL = ResultSet

Request Lenses

pidsesqlXgafv :: Lens' ProjectsInstancesDatabasesSessionsExecuteSQL (Maybe Xgafv)

V1 error format.

pidsesqlUploadProtocol :: Lens' ProjectsInstancesDatabasesSessionsExecuteSQL (Maybe Text)

Upload protocol for media (e.g. "raw", "multipart").

pidsesqlAccessToken :: Lens' ProjectsInstancesDatabasesSessionsExecuteSQL (Maybe Text)

OAuth access token.

pidsesqlUploadType :: Lens' ProjectsInstancesDatabasesSessionsExecuteSQL (Maybe Text)

Legacy upload protocol for media (e.g. "media", "multipart").

pidsesqlPayload :: Lens' ProjectsInstancesDatabasesSessionsExecuteSQL ExecuteSQLRequest

Multipart request metadata.

pidsesqlSession :: Lens' ProjectsInstancesDatabasesSessionsExecuteSQL Text

Required. The session in which the SQL query should be performed.

pidsesqlCallback :: Lens' ProjectsInstancesDatabasesSessionsExecuteSQL (Maybe Text)

JSONP