DatabaseTableConfig for foreign collection

[martinbrylski]

Hi,
I want to create DatabaseTableConfigs for two classes, with a one-to-many relationship:

Take this as example:

class A {
   String uuid;
   Collection<B> bs;
}

class B {
   String uuid;
   A a;
}

I get No fields have a DatabaseField annotation in class B with my current setup and I can not find any help regarding this problem.

I have something like this as my current config:

....
TableUtils.createTable(connectionSource, getATableConfig());
TableUtils.createTable(connectionSource, getBTableConfig());

....

DatabaseTableConfig<A> getATableConfig() {
    List<DatabaseFieldConfig> fieldConfigs = new ArrayList<DatabaseFieldConfig>();

    DatabaseFieldConfig fieldUuid = new DatabaseFieldConfig("uuid");
    fieldUuid.setCanBeNull(false);
    fieldUuid.setId(true);
    fieldConfigs.add(fieldUuid);

   DatabaseFieldConfig fieldBs = new DatabaseFieldConfig("bs");
   fieldBs.setCanBeNull(true);
   fieldBs.setForeignCollection(true);
   fieldBs.setForeignCollectionEager(true);
   fieldBs.setForeignCollectionForeignFieldName("a");
   fieldConfigs.add(fieldBs);

   return new DatabaseTableConfig<>(A.class, fieldConfigs);
}

DatabaseTableConfig<B> getBTableConfig() {
    List<DatabaseFieldConfig> fieldConfigs = new ArrayList<DatabaseFieldConfig>();

    DatabaseFieldConfig fieldUuid = new DatabaseFieldConfig("uuid");
    fieldUuid.setCanBeNull(false);
    fieldUuid.setId(true);
    fieldConfigs.add(fieldUuid);

    DatabaseFieldConfig fieldA = new DatabaseFieldConfig("a");
    fieldA.setCanBeNull(true);
    fieldA.setForeign(true);
    fieldA.setForeignAutoRefresh(true);
    fieldA.setForeignTableConfig(getATableConfig());
    fieldConfigs.add(fieldA);

    return new DatabaseTableConfig<>(B.class, fieldConfigs);
}

[martinbrylski]

It seems there is a circular dependency creating the DatabaseFieldConfig for the foreign collection and the foreign field. They both want to know each others table config. Using a "fake" third table config with less properties it will work.

[j256]

There is a circular dependency but all you have to do is configure the b table config first, without setting the fieldA.setForeignTableConfig(...), then do the a table config and save it in a variable, then go back and call fieldA.setForeignTableConfig(fieldATableConfig).