io.github.shanqiang.sp.dimension.MysqlDimensionTable Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of jstream Show documentation
The newest version!
package io.github.shanqiang.sp.dimension;

import com.mysql.cj.jdbc.MysqlDataSource;
import io.github.shanqiang.table.Type;

import javax.sql.DataSource;
import java.time.Duration;
import java.util.Map;

public class MysqlDimensionTable extends RdsDimensionTable {
    public MysqlDimensionTable(String jdbcUrl,
                               String tableName,
                               String userName,
                               String password,
                               Duration refreshInterval,
                               Map columnTypeMap,
                               String... primaryKeyColumnNames) {
        super(jdbcUrl, tableName, userName, password, refreshInterval, columnTypeMap, primaryKeyColumnNames);
    }

    /**
     *
     * @param jdbcUrl                   jdbc url like: jdbc:mysql://localhost:3306/e-commerce
     * @param userName                  username
     * @param password                  password
     * @param refreshInterval           refresh interval
     * @param sql                       sql to select from mysql
     * @param columnTypeMap             dimension table's columns and their types build by ColumnTypeBuilder
     * @param primaryKeyColumnNames     unique primary key column names
     */
    public MysqlDimensionTable(String jdbcUrl,
                               String userName,
                               String password,
                               Duration refreshInterval,
                               String sql,
                               Map columnTypeMap,
                               String... primaryKeyColumnNames) {
        super(jdbcUrl, userName, password, refreshInterval, sql, columnTypeMap, primaryKeyColumnNames);
    }

    protected DataSource newDataSource() {
        MysqlDataSource dataSource = new MysqlDataSource();
        dataSource.setUrl(url);
        dataSource.setUser(userName);
        dataSource.setPassword(password);
        return dataSource;
    }
}