howto left join table in nette orm

well, the point is the fact, you dont need any join (since you are not filtering by this join).

foreach ($db->table('agency') as $agency) {
 	foreach ($agency->related('agency_photo') as $photo) {
		$photo->server_name;
	}
}

maybe these slides could help you: http://public.skrasek.com/…_2012_04_28/

bestxp wrote:

How can I specify relationships between tables?

Relationships between tables are resolved through database reflection classes (classes implementing interface Nette\Database\IReflection). Default implementation is Nette\Database\Reflection\DiscoveredReflection which is based on foreign keys defined in the database. There is also Nette\Database\Reflection\ConventionalReflection which is based on naming conventions. If neither of these suits your needs, you can always write your own, specialized one.

bestxp wrote:

Or, to manually connect them?

For special queries, you can use methods Nette\Database\Connection::query or Nette\Database\Connection::exec.

You can also use any PDO methods, because Nette\Database\Connection is an extension of PDO.

With this approach however, you will not be able to use advanced features of Nette\Database classes.

bestxp wrote:

something is not clear how to use the interface and where to apply it.
Example of tests / Nette / Database I would like to see me for a class or interface table to implement?

Class Category extends Selection implements iReflection {}?

No, you are not supposed to extend Selection. Either use Nette\Database\Reflection\ConventionalReflection or write your own reflection class like this:

class MyDatabaseReflection implements Nette\Database\IReflection
{
	function getPrimary($table)
	{
		// TODO
	}

	function getHasManyReference($table, $key)
	{
		// TODO
	}


	function getBelongsToReference($table, $key);
	{
		// TODO
	}

	function setConnection(Connection $connection)
	{
	}
}

For more info about these methods, see docblock comments here.

As for where to apply it, add a ‘reflection’ field in your nette.database config:
This would retain the default reflection:

nette:
	database:
		default:
			dsn: ...
			user: ...
			password: ...
			reflection: Nette\Database\Reflection\DiscoveredReflection

So you could put there e.g.:

	reflection: Nette\Database\Reflection\ConventionalReflection

or

	reflection: MyDatabaseReflection

bestxp wrote:

As strange Nette\Database\Connection::query is just a PDO, that is, again, to write queries hands, not analog Selection

It is not a mere PDO, but almost. And yes, you bypass Selection class and its features this way. If you want to keep using these features, you need to use proper reflection class for your database.

Sorry, but I have troubles understanding. What news and categories? Classes have their reflections, but that is something completely different than the database reflection classes we are discussing.

If you could use foreign keys, you would simply use DiscoveredReflection. But since you can't you have to provide the same information through alternate way. Either through ConventionalReflection (if your database uses some common naming conventions) or more specific one (which can e.g. be an extension of ConventionalReflection).

I suggest, you experiment some with ConventionalReflection to see if it is sufficient for you, and if it is not, think about how to extend it.