tajo-core-tests/src/test/java/org/apache/tajo/ws/rs/resources/TestTablesResource.java

/**
 * 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.
 */
package org.apache.tajo.ws.rs.resources;

import org.apache.commons.lang.StringUtils;
import org.apache.tajo.QueryTestCaseBase;
import org.apache.tajo.catalog.TableDesc;
import org.apache.tajo.conf.TajoConf.ConfVars;
import org.apache.tajo.error.Errors.ResultCode;
import org.apache.tajo.plan.serder.PlanGsonHelper;
import org.apache.tajo.schema.IdentifierUtil;
import org.apache.tajo.ws.rs.netty.gson.GsonFeature;
import org.apache.tajo.ws.rs.requests.NewSessionRequest;
import org.apache.tajo.ws.rs.requests.SubmitQueryRequest;
import org.apache.tajo.ws.rs.responses.GetSubmitQueryResponse;
import org.apache.tajo.ws.rs.responses.NewSessionResponse;
import org.glassfish.jersey.client.ClientProperties;
import org.glassfish.jersey.filter.LoggingFilter;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import javax.ws.rs.client.Client;
import javax.ws.rs.client.ClientBuilder;
import javax.ws.rs.client.Entity;
import javax.ws.rs.core.GenericType;
import javax.ws.rs.core.MediaType;
import javax.ws.rs.core.Response;
import javax.ws.rs.core.Response.Status;

import java.net.InetSocketAddress;
import java.net.URI;
import java.util.Collection;
import java.util.List;
import java.util.Map;

import static org.junit.Assert.*;

public class TestTablesResource extends QueryTestCaseBase {
  
  private URI restServiceURI;
  private URI tablesURI;
	private URI queriesURI;
	private URI sessionsURI;

	private Client restClient;
  
  private static final String defaultDatabaseName = "testtablesdb";
	private static final String tajoSessionIdHeaderName = "X-Tajo-Session";

	public TestTablesResource() {
    super(defaultDatabaseName);
  }

  @Before
  public void setUp() throws Exception {
    InetSocketAddress address = testBase.getTestingCluster().getConfiguration().getSocketAddrVar(ConfVars.REST_SERVICE_ADDRESS);
    restServiceURI = new URI("http", null, address.getHostName(), address.getPort(), "/rest", null, null);
    tablesURI = new URI(restServiceURI + "/databases/" + defaultDatabaseName + "/tables");
		queriesURI = new URI(restServiceURI + "/queries");
		sessionsURI = new URI(restServiceURI + "/sessions");
		restClient = ClientBuilder.newBuilder()
        .register(new GsonFeature(PlanGsonHelper.registerAdapters()))
        .register(LoggingFilter.class)
        .property(ClientProperties.FEATURE_AUTO_DISCOVERY_DISABLE, true)
        .property(ClientProperties.METAINF_SERVICES_LOOKUP_DISABLE, true)
        .build();
  }
  
  @After
  public void tearDown() throws Exception {
    restClient.close();
  }

	private SubmitQueryRequest createNewQueryRequest(String query) throws Exception {
		SubmitQueryRequest request = new SubmitQueryRequest();
		request.setQuery(query);
		return request;
	}

	private String generateNewSessionAndGetId() throws Exception {
		NewSessionRequest request = new NewSessionRequest();
		request.setUserName("tajo-user");
		request.setDatabaseName(defaultDatabaseName);

		NewSessionResponse response = restClient.target(sessionsURI)
			.request().post(Entity.entity(request, MediaType.APPLICATION_JSON), NewSessionResponse.class);

		assertNotNull(response);
		assertTrue(ResultCode.OK.equals(response.getResultCode()));
		assertTrue(response.getId() != null && !response.getId().isEmpty());

		return response.getId();
	}

	private void createNewTableForTestCreateTable(String tableName, String sessionId) throws Exception {
		String query = "create table " + tableName + " (column1 text)";
		SubmitQueryRequest queryRequest = createNewQueryRequest(query);

		GetSubmitQueryResponse response = restClient.target(queriesURI)
			.request().header(tajoSessionIdHeaderName, sessionId)
			.post(Entity.entity(queryRequest, MediaType.APPLICATION_JSON),
                    new GenericType<>(GetSubmitQueryResponse.class));

		assertNotNull(response);
		assertEquals(ResultCode.OK, response.getResultCode());
	}

  @Test
  public void testGetAllTable() throws Exception {
    String tableName = "testgetalltable";
		String sessionId = generateNewSessionAndGetId();

		createNewTableForTestCreateTable(tableName, sessionId);

    Map<String, Collection<String>> tables = restClient.target(tablesURI)
        .request().get(new GenericType<>(Map.class));

    List<String> tableNames = (List<String>)tables.get("tables");
    assertNotNull(tableNames);
    assertTrue(!tableNames.isEmpty());

    boolean tableFound = false;
    for (String table: tableNames) {
      if (StringUtils.equalsIgnoreCase(tableName, IdentifierUtil.extractSimpleName(table))) {
        tableFound = true;
        break;
      }
    }
    
    assertTrue(tableFound);
  }
  
  @Test
  public void testGetTable() throws Exception {
    String tableName = "testgettable";
		String sessionId = generateNewSessionAndGetId();

		createNewTableForTestCreateTable(tableName, sessionId);
    
    TableDesc selectedTable = restClient.target(tablesURI)
        .path("/{tableName}").resolveTemplate("tableName", tableName)
        .request().get(new GenericType<>(TableDesc.class));
    
    assertNotNull(selectedTable);
    assertTrue(StringUtils.equalsIgnoreCase(tableName, IdentifierUtil.extractSimpleName(selectedTable.getName())));
  }
  
  @Test
  public void testGetTableNotFound() throws Exception {
    Response response = restClient.target(tablesURI)
        .path("/{tableName}").resolveTemplate("tableName", "TestGetTableNotFound")
        .request().get();
    
    assertNotNull(response);
    assertEquals(Status.NOT_FOUND.getStatusCode(), response.getStatus());
  }
  
  @Test
  public void testDropTable() throws Exception {
    String tableName = "testdroptable";
		String sessionId = generateNewSessionAndGetId();

		createNewTableForTestCreateTable(tableName, sessionId);
    
    TableDesc selectedTable = restClient.target(tablesURI)
        .path("/{tableName}").resolveTemplate("tableName", tableName)
        .request().get(new GenericType<>(TableDesc.class));
    
    assertNotNull(selectedTable);
    assertTrue(StringUtils.equalsIgnoreCase(tableName, IdentifierUtil.extractSimpleName(selectedTable.getName())));
    
    Response response = restClient.target(tablesURI)
        .path("/{tableName}").resolveTemplate("tableName", tableName)
        .request().delete();
    
    assertNotNull(response);
    assertEquals(Status.OK.getStatusCode(), response.getStatus());
  }
  
  @Test
  public void testDropTableNotFound() throws Exception {
    Response response = restClient.target(tablesURI)
        .path("/{tableName}").resolveTemplate("tableName", "TestDropTableNotFound")
        .request().delete();
    
    assertNotNull(response);
    assertEquals(Status.NOT_FOUND.getStatusCode(), response.getStatus());
  }
}