How to use

SQLDataSource

in

com.mtl.hulk.db

@Override
public PreparedStatement prepareStatement(String sql) throws SQLException {
  SqlType sqlType = getSqlType(sql);
  if (sqlType == SqlType.SELECT || sqlType == SqlType.SELECT_FOR_UPDATE) {
    return readDataSources.get((int) Math.random() * readDataSources.size())
        .getConnection().prepareStatement(sql);
  } else if (sqlType == SqlType.INSERT || sqlType == SqlType.UPDATE
      || sqlType == SqlType.DELETE) {
    return writeDataSources.get((int) Math.random() * writeDataSources.size())
        .getConnection().prepareStatement(sql);
  } else {
    throw new SQLException("only select, insert, update, delete sql is supported");
  }
}

@Bean
public HulkDataSource hulkDataSource() {
  List<DataSource> writeDataSources = new ArrayList<>();
  List<DataSource> readDataSources = new ArrayList<>();
  for (PoolProperties properties : properties.getLogMasters()) {
    DataSource writeDataSource = new DataSource();
    writeDataSource.setPoolProperties(properties);
    writeDataSources.add(writeDataSource);
  }
  for (PoolProperties properties : properties.getLogSlaves()) {
    DataSource readDataSource = new DataSource();
    readDataSource.setPoolProperties(properties);
    readDataSources.add(readDataSource);
  }
  return new SQLDataSource(writeDataSources, readDataSources);
}