| /** |
| * 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 com.datatorrent.lib.db.jdbc; |
| |
| import java.sql.Connection; |
| import java.sql.DriverManager; |
| import java.sql.PreparedStatement; |
| import java.sql.ResultSet; |
| import java.sql.SQLException; |
| import java.sql.Statement; |
| import java.util.List; |
| |
| import org.junit.Assert; |
| import org.junit.BeforeClass; |
| import org.junit.Test; |
| |
| import com.google.common.collect.Lists; |
| |
| import com.datatorrent.api.Context.OperatorContext; |
| import com.datatorrent.api.DAG; |
| import com.datatorrent.netlet.util.DTThrowable; |
| |
| import static com.datatorrent.lib.helper.OperatorContextTestHelper.mockOperatorContext; |
| |
| /** |
| * Test for {@link AbstractJdbcNonTransactionableOutputOperator Operator} |
| */ |
| public class JdbcNonTransactionalOutputOperatorTest |
| { |
| public static final String DB_DRIVER = "org.hsqldb.jdbcDriver"; |
| public static final String URL = "jdbc:hsqldb:mem:test;sql.syntax_mys=true"; |
| |
| public static final String TABLE_NAME = "test_event_table"; |
| public static final String APP_ID = "JdbcOperatorTest"; |
| public static final int OPERATOR_ID = 0; |
| |
| public static class TestEvent |
| { |
| int id; |
| |
| TestEvent(int id) |
| { |
| this.id = id; |
| } |
| } |
| |
| @BeforeClass |
| public static void setup() |
| { |
| try { |
| Class.forName(DB_DRIVER).newInstance(); |
| |
| Connection con = DriverManager.getConnection(URL); |
| Statement stmt = con.createStatement(); |
| |
| String createTable = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " (ID INTEGER)"; |
| stmt.executeUpdate(createTable); |
| } catch (Throwable e) { |
| DTThrowable.rethrow(e); |
| } |
| } |
| |
| public static void cleanTable() |
| { |
| try { |
| Connection con = DriverManager.getConnection(URL); |
| Statement stmt = con.createStatement(); |
| |
| String cleanTable = "delete from " + TABLE_NAME; |
| stmt.executeUpdate(cleanTable); |
| } catch (SQLException e) { |
| throw new RuntimeException(e); |
| } |
| } |
| |
| public static class TestOutputOperator extends AbstractJdbcNonTransactionableOutputOperator<TestEvent, JdbcStore> |
| { |
| public static final String INSERT_STMT = "INSERT INTO " + TABLE_NAME + " values (?)"; |
| |
| TestOutputOperator() |
| { |
| cleanTable(); |
| } |
| |
| @Override |
| protected String getUpdateCommand() |
| { |
| return INSERT_STMT; |
| } |
| |
| @Override |
| protected void setStatementParameters(PreparedStatement statement, TestEvent tuple) throws SQLException |
| { |
| statement.setInt(1, tuple.id); |
| } |
| |
| public int getNumOfEventsInStore() |
| { |
| Connection con; |
| try { |
| con = DriverManager.getConnection(URL); |
| Statement stmt = con.createStatement(); |
| |
| String countQuery = "SELECT * FROM " + TABLE_NAME; |
| ResultSet resultSet = stmt.executeQuery(countQuery); |
| int count = 0; |
| while (resultSet.next()) { |
| count++; |
| } |
| return count; |
| } catch (SQLException e) { |
| throw new RuntimeException("fetching count", e); |
| } |
| } |
| } |
| |
| @Test |
| public void testJdbcOutputOperator() |
| { |
| JdbcStore store = new JdbcStore(); |
| store.setDatabaseDriver(DB_DRIVER); |
| store.setDatabaseUrl(URL); |
| TestOutputOperator outputOperator = new TestOutputOperator(); |
| |
| com.datatorrent.api.Attribute.AttributeMap.DefaultAttributeMap attributeMap = new com.datatorrent.api.Attribute.AttributeMap.DefaultAttributeMap(); |
| attributeMap.put(DAG.APPLICATION_ID, APP_ID); |
| OperatorContext context = mockOperatorContext(OPERATOR_ID, attributeMap); |
| outputOperator.setStore(store); |
| |
| outputOperator.setup(context); |
| |
| List<TestEvent> events = Lists.newArrayList(); |
| for (int i = 0; i < 10; i++) { |
| events.add(new TestEvent(i)); |
| } |
| |
| outputOperator.beginWindow(0); |
| for (TestEvent event : events) { |
| outputOperator.input.process(event); |
| } |
| outputOperator.endWindow(); |
| |
| Assert.assertEquals("rows in db", 10, outputOperator.getNumOfEventsInStore()); |
| } |
| } |