Thanks all for the replies, now it make sense.
On Apr 6, 2017 8:17 AM, "Samir Faci" <[email protected]> wrote:
> 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 a topic in the
> Google Groups "jOOQ User Group" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/jooq-user/dgn3W8XosB0/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
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.
