Joint Table not Mapper in Object Class

[Bramiproject]

How to Joint Table multiple object class ?

[mqus]

I'm sorry, I really don't know what you want to do with the little information you gave. Please write more and/or give an example.

[Bramiproject]

In Java / Kotlin Environment to do a Join Table using @Embedded annotation, but if in the Library floor use what annotation to map the Object Class ?

For the ex. in Java :

@Query("SELECT Foo.*, Bar.* FROM Foo INNER JOIN Bar ON Foo.bar = Bar.id")
List<FooAndBar> findAllFooAndBar();

public class FooAndBar {
    @Embedded
    Foo foo;

    @Embedded
    Bar bar;

    //Getter and setter...
}

Please help with this matter..
@mqus @vitusortner

[mqus]

Well, that is easy to answer now :D

Currently, @embedded is not supported, but afaict it will be in the next version, thanks to @hsul4n s work in #328. But his is only a part of the things you will need so you may have to create a @DatabaseView with your query until we fully support arbitrary types as outputs from @Query functions. (Which we currently don't)

I can post an example here when the embedded function was added.

[Bramiproject]

DatabaseView

Well, Thank you @mqus for your information 😃
I will wait for further information 🙏🏻

[Bramiproject]

Hi @mqus,

Please your advice if use @DatabaseView how to using condition on Query in @DatabaseView ?

Ex.
`@DatabaseView(Select * From foo Where id = :id)

class Foo{
int Id;
Foo(Id)
}
`

[mqus]

Parameters won't work in the declaration of a databaseview.

You have to include the parameter you want to compare with (e.g. id) in the select part of the query in the dbview and as a field of the view. You can then use it in the query method in the dao with WHERE id =:id. I'm on my phone right now so I can't show you a detailed example but you can try to take a look into the integration tests in floor/test/integration

[mqus]

Closing as a duplicate of #9 and #94 . Please reopen if you disagree :)