Hello Ravi,
> Currently our boolean columns are prefixed with is_. So the pattern matching
> works fine. However, our date columns are named created, approved_on,
> start_date, plan_finish, last_reminded_at etc. I'm having to specify a
> pattern like (?i:.*\.(CREATED|DELETED|.*_DATE|.*_AT|.*_ON)). I think it will
> be better if we can simply specify a database type to be specified.
Yes, that was in the original idea, to be able to force all
occurrences of a SQL data type to be mapped to another type. But I
haven't had the time yet to make this work correctly on all databases.
I'm afraid that some substantial changes to jooq-meta / jooq-codegen
are needed for that.
Anyway, you could query your Oracle (or Postgres, SQL Server)
dictionary views to discover all date / time columns like this:
select owner, table_name, column_name, data_type
from all_tab_cols
where owner = '[your schema name]'
and (data_type = 'DATE'
or data_type like 'TIMESTAMP%'
or data_type like 'INTERVAL%');
