com.google.cloud.spanner.pgadapter.statements.local.SelectCurrentSchemaStatement Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of google-cloud-spanner-pgadapter Show documentation

The PGAdapter server implements the PostgreSQL wire-protocol, but sends all received statements to a Cloud Spanner database instead of a PostgreSQL database. The Cloud Spanner database must have been created to use the PostgreSQL dialect. See https://cloud.google.com/spanner/docs/quickstart-console#postgresql for more information on how to create PostgreSQL dialect databases on Cloud Spanner.

The newest version!

// Copyright 2022 Google LLC
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
//      http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

package com.google.cloud.spanner.pgadapter.statements.local;

import com.google.api.core.InternalApi;
import com.google.cloud.spanner.ResultSet;
import com.google.cloud.spanner.Struct;
import com.google.cloud.spanner.Type;
import com.google.cloud.spanner.Type.StructField;
import com.google.cloud.spanner.connection.StatementResult;
import com.google.cloud.spanner.pgadapter.statements.BackendConnection;
import com.google.cloud.spanner.pgadapter.statements.BackendConnection.QueryResult;
import com.google.cloud.spanner.pgadapter.statements.ClientSideResultSet;
import com.google.common.collect.ImmutableList;

@InternalApi
public class SelectCurrentSchemaStatement implements LocalStatement {
  public static final SelectCurrentSchemaStatement INSTANCE = new SelectCurrentSchemaStatement();

  private SelectCurrentSchemaStatement() {}

  @Override
  public String[] getSql() {
    return new String[] {
      "select current_schema()",
      "SELECT current_schema()",
      "SELECT CURRENT_SCHEMA()",
      "Select current_schema()",
      "select current_schema",
      "SELECT current_schema",
      "SELECT CURRENT_SCHEMA",
      "Select current_schema",
      "select * from current_schema()",
      "SELECT * FROM current_schema()",
      "SELECT * FROM CURRENT_SCHEMA()",
      "select * from current_schema",
      "SELECT * FROM current_schema"
    };
  }

  @Override
  public StatementResult execute(BackendConnection backendConnection) {
    ResultSet resultSet =
        ClientSideResultSet.forRows(
            Type.struct(StructField.of("current_schema", Type.string())),
            ImmutableList.of(
                Struct.newBuilder()
                    .set("current_schema")
                    .to(backendConnection.getCurrentSchema())
                    .build()));
    return new QueryResult(resultSet);
  }
}