package testvelosiped;

import java.sql.SQLException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.Random;
import static testvelosiped.Db.getConnection;
import static testvelosiped.Db.prepareStatement;
import static java.lang.System.*;

public class TestVelosiped {

    private static final Random RANDOMIZER = new Random();

    private static final int
//            COUNT = 10_000;
            COUNT = 1_000_000;
    
    private static String modelName = "Какой-нибудь текст";
    private static double height = 2.5, length = 3.2, width = 86, weight = 5.25;

    public static void main(String[] args) throws SQLException {
        Connection connection = getConnection();
        connection.setAutoCommit(false);
        long time = nanoTime();
//        testBatch();
        testNonBatch();
//        testText();
        connection.commit();
        time = nanoTime() - time;

        out.printf("Время %f сек\n", time / 1e9);
    }

    private static void testNonBatch() throws SQLException {
        PreparedStatement psCreate = prepareStatement(
                "INSERT INTO your_schema_name.velosipeds (model_name, height, length, width, weight) " +
                "VALUES (?, ?, ?, ?, ?)");

        for (int i = 0; i < COUNT; ++i) {
            psCreate.setString(1, modelName);
            psCreate.setDouble(2, height);
            psCreate.setDouble(3, length);
            psCreate.setDouble(4, width);
//            psCreate.setDouble(5, weight);
            psCreate.setDouble(5, RANDOMIZER.nextInt(100));
            psCreate.executeUpdate();
        }
    }

    private static void testBatch() throws SQLException {
        PreparedStatement psCreate = prepareStatement(
                "INSERT INTO your_schema_name.velosipeds (model_name, height, length, width, weight) " +
                "VALUES (?, ?, ?, ?, ?)");

        for (int i = 0; i < COUNT; ++i) {
            psCreate.setString(1, modelName);
            psCreate.setDouble(2, height);
            psCreate.setDouble(3, length);
            psCreate.setDouble(4, width);
//            psCreate.setDouble(5, weight);
            psCreate.setDouble(5, RANDOMIZER.nextInt(100));
            psCreate.addBatch();
        }

        psCreate.executeBatch();
    }

    private static void testText() throws SQLException {
        StringBuilder sb = new StringBuilder("BEGIN\n");

        for (int i = 0; i < COUNT; ++i) {
            sb
                    .append("INSERT INTO your_schema_name.velosipeds (model_name, height, length, width, weight) VALUES ('")
                    .append(modelName).append("',")
                    .append(height).append(",")
                    .append(length).append(",")
                    .append(width).append(",")
//                    .append(weight)
                    .append(RANDOMIZER.nextInt(100))
                    .append(");\n");
        }

        sb.append("END;");
        getConnection().prepareCall(sb.toString()).execute();
    }
}