How to use table() in a service?

CZechBoY wrote:

You have to specify typehint

use Nette\Database\Context;

class Article
{
	private $db;

	public function __construct (Context $db)
	{
		$this->db = $db;
	}
}

Your code resulted in Argument 1 passed to App\Presenters\Article::__construct() must be an instance of Nette\Database\Context, instance of Nette\Database\Connection given

So I changed the container and got this error instead

Argument 2 passed to Nette\Database\Context::__construct() must implement interface Nette\Database\IStructure, none given, called in D:\PHP\easyPHP\www\nette-di\app\presenters\MyContainer.php on line 12 and defined

Any idea how to fix it?

Here's the code of MyContainer and Article

<?php

namespace App\Presenters;
use Nette;

class MyContainer extends Nette\DI\Container{

    function createConnection()
    {
        $connection = new Nette\Database\Connection('mysql:host=127.0.0.1;dbname=quickstart', 'root', '');
        $context = new Nette\Database\Context($connection);
        return $context;
    }

    protected function createServiceArticle()
    {
        return new Article($this->createConnection());
    }


}//end class

<?php

namespace App\Presenters;

use Nette\Database\Context;

class Article{
    private $db;

    public function __construct (Context $db)
    {
        $this->db = $db;
    }

    public function returnPosts() {
        return $this->db->table('posts');
    }
}//end class

I went through the quickstart https://doc.nette.org/cs/quickstart and now I'm experimenting with nette so when you ask why I'm not using services I'm not quite sure what you are talking about ;-) All I'm trying to achieve right now is to be able to use ->table() in an object of the Article class instantiated in MyContainer.

After couple of days experimenting with services I decided to gave up using ->table() in a service. The documentation seems to be too concise to be comprehensive for me, but thanks anyway, CZechBoY.

As the page says: “This page is still being prepared” https://doc.nette.org/en/configuring but the section I've read: Custom services probably makes sense for people who have been working with nette for years. But those people probably won't need the documentation. Here's a couple of questions I was faced with.

services:
database: Nette\Database\Connection(%dsn%, %user%, %password%)

should I put it in a config.local.neon? Should I put it in a new neon file and load it? Does it matter or not? Does it connect to database right away or is it still necessary to getService or something else?

How do I access %dsn% ? %parameters.dsn% or just %dsn% ? ne-on.org doesn't say. Does number of “tabs” matter? I have no idea.

A piece of neon code generates a function. But it doesn't say how to use the function – where can I use it? How do I get access to it? Do I have to create an object or not? If yes, which class I should use?

full example – I tried to copy-paste the example in new project and the only thing I got was an error.

Quickstart is pretty sweet. I can use copy & paste. I can try to adapt the code or create something new on my own and see what happens. Quickstart provides you with all the code involved. “Configuring” provides you with random pieces of information taken out of context because you don't know the rest of the code and this fact renders this page as unuseable for people who are learning nette in my opinion.

Documentation written in the style of quickstart would we great.

Edit --------------
Another example

https://doc.nette.org/en/database#…

$database = new Context($connection);

returns error (it asks for context). Is the example wrong or do I need another part of code ommited from the example?

Last edited by netteman (2016-05-23 15:39)