package launchserver.auth.provider;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import launcher.helper.CommonHelper;
import launcher.helper.VerifyHelper;
import launcher.serialize.config.entry.BlockConfigEntry;
import launcher.serialize.config.entry.ListConfigEntry;
import launcher.serialize.config.entry.StringConfigEntry;
import launchserver.auth.AuthException;
import launchserver.auth.MySQLSourceConfig;

public final class MySQLAuthProvider extends AuthProvider {
	private final MySQLSourceConfig mySQLHolder;
	private final String query;
	private final String[] queryParams;

	public MySQLAuthProvider(BlockConfigEntry block) {
		super(block);
		mySQLHolder = new MySQLSourceConfig("authProviderPool", block);

		// Read query
		query = VerifyHelper.verify(block.getEntryValue("query", StringConfigEntry.class),
			VerifyHelper.NOT_EMPTY, "MySQL query can't be empty");
		queryParams = block.getEntry("queryParams", ListConfigEntry.class).
			stream(StringConfigEntry.class).toArray(String[]::new);
	}

	@Override
	public String auth(String login, String password) throws SQLException, AuthException {
		try (Connection c = mySQLHolder.getConnection(); PreparedStatement s = c.prepareStatement(query)) {
			String[] replaceParams = { "login", login, "password", password };
			for (int i = 0; i < queryParams.length; i++) {
				s.setString(i + 1, CommonHelper.replace(queryParams[i], replaceParams));
			}

			// Execute SQL query
			s.setQueryTimeout(MySQLSourceConfig.TIMEOUT);
			try (ResultSet set = s.executeQuery()) {
				return set.next() ? set.getString(1) : authError("Incorrect username or password");
			}
		}
	}

	@Override
	public void close() {
		// Do nothing
	}
}