Examples of org.jooq.DSLContext

org.jooq.DSLContext
diately fetch results after constructing a query create.selectFrom(MY_TABLE).where(MY_TABLE.ID.eq(1)).fetch(); // The above is equivalent to this "non-fluent" style create.fetch(DSL.selectFrom(MY_TABLE).where(MY_TABLE.ID.eq(1)));
The DSL provides convenient constructors to create a {@link Configuration}, which will be shared among all Query objects thus created. Optionally, you can pass a reusable Configuration to the {@link DSL#using(Configuration)}constructor. Please consider thread-safety concerns documented in {@link Configuration}, should you want to reuse the same Configuration instance in various threads and / or transactions. @see DSL @see Configuration @author Lukas Eder

            }
        }
    }


    private final int executeSelectFrom() {
        DSLContext create = create(configuration);
        Result<?> result = create.selectFrom(table(asField())).fetch();
        outValues.put(returnParameter, result);
        return 0;
    }

View Full Code Here


public class Example_1_4_Predicates {


    @Test
    public void run() {
        DSLContext dsl = DSL.using(connection());


        Tools.title("Combine predicates using AND");
        Tools.print(
            dsl.select()
               .from(BOOK)
               .where(BOOK.TITLE.like("%a%").and(BOOK.AUTHOR_ID.eq(1)))
               .fetch()
        );


        /*
        Tools.title("Wrong types in comparison predicate");
        Tools.print(
            dsl.select()
               .from(BOOK)
               .where(BOOK.ID.eq("abc"))
               .fetch()
        );
        */


        Tools.title("Use an IN-predicate");
        Tools.print(
            dsl.select()
               .from(AUTHOR)
               .where(AUTHOR.ID.in(select(BOOK.AUTHOR_ID).from(BOOK)))
               .fetch()
        );

View Full Code Here

        formatInsert(new OutputStreamWriter(stream), table, f);
    }


    @Override
    public final void formatInsert(Writer writer, Table<?> table, Field<?>... f) {
        DSLContext ctx = DSL.using(configuration());


        try {
            for (R record : this) {
                writer.append(ctx.renderInlined(insertInto(table, f).values(record.intoArray())));
                writer.append(";\n");
            }
        }
        catch (java.io.IOException e) {
            throw new IOException("Exception while writing INSERTs", e);

View Full Code Here

  public DSLContext get() {
    if (!isWorking()) {
      begin();
    }


    DSLContext factory = threadFactory.get();
    Preconditions.checkState(null != factory, "Requested Factory outside work unit. "
        + "Try calling UnitOfWork.begin() first, or use a PersistFilter if you "
        + "are inside a servlet environment.");


    return factory;

View Full Code Here

      conn = new DefaultConnectionProvider(jdbcSource.getConnection());
    } catch (SQLException e) {
      throw new RuntimeException(e);
    }
    
    DSLContext jooqFactory;
    if (jooqSettings == null) {
      jooqFactory = DSL.using(conn, sqlDialect);
    } else {
      jooqFactory = DSL.using(conn, sqlDialect, jooqSettings);
    }

View Full Code Here

    threadConnection.set(conn);
    threadFactory.set(jooqFactory);
  }


  public void end() {
    DSLContext jooqFactory = threadFactory.get();
    DefaultConnectionProvider conn = threadConnection.get();
    // Let's not penalize users for calling end() multiple times.
    if (null == jooqFactory) {
      return;
    }

View Full Code Here

    {
        ResultQuery q;


        public void init()
        {
            DSLContext create;
            try {
                create = DSL.using(DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD), JOOQ_DIALECT);
            } catch (SQLException e) {
                throw new RuntimeException("Error initializing jOOQ DSLContext", e);
            }


            q = create.select()
                      .from("post")
                      .where("id = ?", -1) // param needs an initial value, else future calls the bind() will fail.
                      .keepStatement(true);
        }

View Full Code Here

0 1 2

TOP

Related Classes of org.jooq.DSLContext

com.adamlewis.guice.persist.jooq.JooqPersistService

org.jooq.academy.section1.Example_1_3_DMLStatements

org.jooq.academy.section1.Example_1_4_Predicates

org.jooq.academy.section1.Example_1_5_ColumnExpressions

org.jooq.academy.section2.Example_2_1_ActiveRecords

org.jooq.academy.section2.Example_2_2_OptimisticLocking

org.jooq.example.jaxrs.LicenseService

org.jooq.impl.AbstractRoutine

org.jooq.impl.AbstractStoreQuery

org.jooq.impl.ResultImpl

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.