SQL Server meta() scannning all catalogs and schemas

[Megan A]

Hi,

It looks like meta() scans all catalogs and all schemas on every call. I'd really like to to only scan one schema. As I don't control the other schemas and it can become a slow query when an unrelated database has lots of tables. Is there a way to say "Only grab metadata from this one schema"? Better yet, "Only grab the metadata for this one table" would be even better.

Thanks,

Megan

[Lukas Eder]

Hi Megan,

Thanks for your message. You can iterate the results and query them from there, such as:

for (Catalog catalog : meta().getCatalogs())

  if (catalog.getName().equals("database_name"))

    for (Schema schema : catalog.getSchemas())

      if (schema.getName().equals("schema_name"))

        for (Table<?> table : schema.getTables())

          doSomething(table);

Starting from jOOQ 3.14, there will also be Meta.filterSchemas() and similar methods to allow for filtering schemas for the entire scope of a Meta reference:

https://www.jooq.org/javadoc/3.14.x/org.jooq/org/jooq/Meta.html#filterSchemas(org.jooq.Meta.Predicate)

I hope this helps,

Lukas

--
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 jooq-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/278a4d71-bedb-4862-b89e-17407db9da37n%40googlegroups.com.

[Megan A]

Yes thank you! I do look forward to filterSchema though.

[Lukas Eder]

Will be released tomorrow, unless any showstoppers show up during the build!

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/aca3a266-2bcb-445e-8108-f1d53adc06cdn%40googlegroups.com.