Records are classes used to do SQL operation. They're basically helpers
where you can construct an object then invoke.
record.store();
record.update();
record.insert() ;
record.refresh();
depending on your use case.
Public is a default schema that every postgres DB has. You can specify
which schema to auto-generate code for. By default any new table goes in
public.
If you don't want to use records you can just easily use the Tables and
other classes to write the SQL manually.
dslContext.insertInto(table, field1, field2).values('hello',
'world').execute();
You could also create a white list of what gets generated to only include
the tables you're interested in.
If you want to be minimalistic, then you should make tell jooq what to
introspect otherwise it'll by default look at everything in the public
catalog and public schema if I'm not mistaken.
public and pg_catalog are usually the default schemas.
https://www.jooq.org/doc/3.9/manual/code-generation/codegen-configuration/
for more info.
specifically the <include> </include> tag.
On Wed, Apr 5, 2017 at 9:18 AM, Anto Aravinth <[email protected]>
wrote:
> Hi,
>
> I'm getting started with Jooq and I did code generation for my database
> (Postgres). I have 4 tables in my database and I expected only 4 classes
> after code generation. However I got many classes for which I need
> clarification:
>
> 1. DefaultCatalog, Keys, Public, Sequences, Tables classes are been
> generated -- Guess these are tables of postgres itself, which I might not
> required. Kindly let me know.
> 2. I could able to see a new package called record, which has 4 classes of
> my table name with suffix "Record". -- Again are these classes are useful
> or even required in my codebase? Whats its usecase?
>
> And also in the code level, I did:
>
> DSLContext create = DSL.using(connection, SQLDialect.POSTGRES);
>
> There were SQLDialect for specific POSTGRES version like 9.4 etc, but what
> version does SQLDIalect.POSTGRES refers?
>
> ` Anto.
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "jOOQ User Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
Thank you
Samir Faci
https://keybase.io/csgeek
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
