Get database reflection from Connection instance

Eda

Hi.

In my application I want to work with database structure (foreign keys etc.). Is there any way, how can I get info about database structure from Nette\Connection instance which i have injected into my Presenter?

Is the right way creating of Nette\Database\DiscoveredReflection on my own? Or is there any way to inject IReflection into my Presenter?

Thanks.

Majkl578

See Connection::getReflection().

enumag

In Nette 2.0 there is Connection::getDatabaseReflection() method but it's missing in 2.1. The main reason is that Connection never used reflection directly so it doesn't need reflection.

In my opinion creating your own IReflection service is correct. Keep in mind though that you probably should not use database reflection in presenter directly.

EDIT: @Majkl578: That's 2.0 only and also it's getDatabaseReflection not just getReflection.

hrach

Solution is to rewirte it to use DI(C).
Until that you can use hack like

$connection->table('')->getDatabaseReflection();

See https://api.nette.org/…lection.html#…

hrach

I edited my ealier issue and reopened it :) https://github.com/…e/issues/931

Eda

I am using just Nette 2.1.

Hrach: thx for hack and reopening issue. I am looking forward to real fix :-)