MySQLDbServiceTest.java

package com.emc.ecs.sync.service;

import com.emc.ecs.sync.test.TestConfig;
import org.junit.After;
import org.junit.Assume;
import org.junit.Before;
import org.springframework.jdbc.support.rowset.SqlRowSet;

import java.sql.Timestamp;

public class MySQLDbServiceTest extends SqliteDbServiceTest {
    @Before
    public void setup() throws Exception {
        String mysqlConnectString = TestConfig.getProperties().getProperty(TestConfig.PROP_MYSQL_CONNECT_STRING);
        Assume.assumeNotNull(mysqlConnectString);
        dbService = new MySQLDbService(mysqlConnectString, null, null);
    }

    @After
    public void teardown() throws Exception {
        if (dbService != null) {
            dbService.deleteDatabase();
            dbService.close();
        }
    }

    @Override
    protected long getUnixTime(SqlRowSet rowSet, String field) {
        Timestamp timestamp = rowSet.getTimestamp(field);
        if (timestamp == null) return 0;
        else return timestamp.getTime();
    }
}