package com.squareup.JooqTest;

import java.sql.Connection;
import java.sql.DriverManager;
import java.time.OffsetDateTime;
import jooqtest.tables.records.T1Record;
import jooqtest.tables.records.T2Record;
import org.jooq.DSLContext;
import org.jooq.Field;
import org.jooq.conf.RenderNameStyle;
import org.jooq.conf.Settings;
import org.jooq.impl.DSL;

import static jooqtest.tables.T1.T1;
import static jooqtest.tables.T2.T2;

public class App {
  public static void main(String[] args) throws Exception {
    App app = new App();
    app.run();
  }

  public void run() throws Exception {
    Settings settings = new Settings();
    settings.setRenderNameStyle(RenderNameStyle.AS_IS);
    settings.withRenderSchema(false);

    int now = (int) OffsetDateTime.now().toEpochSecond();

    try (Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/jooqtest", "root", "")) {
      DSLContext jooq = DSL.using(conn, settings);

      jooq.truncate(T1).execute();
      jooq.truncate(T2).execute();

      jooq.insertInto(T1).set(T1.ID, 1).set(T1.DATE, now).execute();

      T1Record row1 = jooq.selectFrom(T1).fetchOne();
      Field[] fields = row1.fields();

      jooq.insertInto(T2)
          .set(fields[0], row1.getValue(0))
          .set(fields[1], row1.getValue(1)).execute();

      T2Record row2 = jooq.selectFrom(T2).fetchOne();
      System.out.println(row2);
    }
  }
}