java_based_implementation/tests/utils.py

################################################################################
#  Licensed to the Apache Software Foundation (ASF) under one
#  or more contributor license agreements.  See the NOTICE file
#  distributed with this work for additional information
#  regarding copyright ownership.  The ASF licenses this file
#  to you 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.
################################################################################

from java_based_implementation.java_gateway import get_gateway
from java_based_implementation.util.java_utils import to_j_catalog_context


def create_simple_table(warehouse, database, table_name, has_pk, options=None):
    if options is None:
        options = {
            'bucket': '1',
            'bucket-key': 'f0'
        }

    gateway = get_gateway()

    j_catalog_context = to_j_catalog_context({'warehouse': warehouse})
    j_catalog = gateway.jvm.CatalogFactory.createCatalog(j_catalog_context)

    j_schema_builder = (
        gateway.jvm.Schema.newBuilder()
        .column('f0', gateway.jvm.DataTypes.INT())
        .column('f1', gateway.jvm.DataTypes.STRING())
        .options(options)
    )
    if has_pk:
        j_schema_builder.primaryKey(['f0'])
    j_schema = j_schema_builder.build()

    j_catalog.createDatabase(database, True)
    j_identifier = gateway.jvm.Identifier(database, table_name)
    j_catalog.createTable(j_identifier, j_schema, False)