bytic / database

        static::assertThat($condition, $this->isInstanceOf("Nip\Database\Query\Condition\Condition"));

    }

    public function testNested()

    {

        $this->selectQuery->from("table1");

        $query = $this->connection->newQuery();

        $query->from("table2");

        $query->where("id != 5");

        $this->selectQuery->where("id NOT IN ?", $query);

        static::assertEquals(

            "SELECT * FROM `table1` WHERE id NOT IN (SELECT * FROM `table2` WHERE id != 5)",

            $this->selectQuery->assemble()

        );

    }

    public function testUnion()

    {

        );

    }

    public function testUnion()

    {

        $this->selectQuery->from("table1");

        $query = $this->connection->newQuery();

        $query->from("table2");

        $union = $this->selectQuery->union($query);

        static::assertEquals("SELECT * FROM `table1` UNION SELECT * FROM `table2`", $union->assemble());

    }

    public function testJoinTableName()

    {