public class GenerateTestData {
        static long all = 20000000;

        public static void main(String[] args) throws Exception {
                Class.forName("com.mysql.jdbc.Driver");

                String url =
            "jdbc:mysql://localhost:3306/oauw";

                Connection con =
                                                         DriverManager.getConnection(
                                                                                 url,"root", "");

                long start = new Date().getTime();

                Random random = new Random();

                int perc = 0;

                Statement statement = con.createStatement();

                // clear dbs
                statement.execute("delete from all_vals");
                statement.execute("delete from i");
                statement.execute("delete from j");
                statement.execute("delete from k");
                statement.execute("delete from x");
                statement.execute("delete from y");
                statement.execute("delete from z");

                // generate the data
                for (long iter = 1; iter <= all; iter++) {
                        int x = random.nextInt();
                        int y = random.nextInt();
                        int z = random.nextInt();
                        int i = random.nextInt();
                        int j = random.nextInt();
                        int k = random.nextInt();

                        statement.execute("insert into all_vals(id, i, j, k, x, y, z)  values ("
                                        +iter+", "+i+", "+j+", "+k+", "+ x+", " + y+ ", "+z+");");

                        statement.execute("insert into x(id, x)  values ("
                                        +iter+", "+ x+");");
                        statement.execute("insert into y(id, y)  values ("
                                        +iter+", "+ y+");");
                        statement.execute("insert into z(id, z)  values ("
                                        +iter+", "+ z+");");
                        statement.execute("insert into i(id, i)  values ("
                                        +iter+", "+ i+");");
                        statement.execute("insert into j(id, j)  values ("
                                        +iter+", "+ j+");");
                        statement.execute("insert into k(id, k)  values ("
                                        +iter+", "+ k+");");

                        if (iter % 1000 == 0) {
                                con.close();
                                con = DriverManager.getConnection(
                                                                                 url,"root", "");
                                statement = con.createStatement();

                                long now = new Date().getTime();

                                long estL = start + (all * (now - start) / iter);

                                Date estTime = new Date(estL);

                                System.out.println("New connection on iter: "+iter+"; estimated finish: "+estTime);
                        }

                        if ((int) ((double)iter / (double)all * 100.0d) != perc) {
                                perc = (int) ((double)iter / (double)all * 100.0d);
                                System.out.println("Done: "+perc+"%");
                        }
                }

                con.close();

        }
}