doctrine / dbal

        $this->_conn->insert("notnull_table", array('id' => 1, 'value' => null));

    }

    public function testInvalidFieldNameException()

    {

        $schema = new \Doctrine\DBAL\Schema\Schema();

        $table = $schema->createTable("bad_fieldname_table");

        $table->addColumn('id', 'integer', array());

        foreach ($schema->toSql($this->_conn->getDatabasePlatform()) as $sql) {

            $this->_conn->exec($sql);

        }

        $this->expectException(Exception\InvalidFieldNameException::class);

        $this->_conn->insert("bad_fieldname_table", array('name' => 5));

    }

    public function testNonUniqueFieldNameException()

    {

        $this->_conn->insert("unique_field_table", array('id' => 5));

    }

    public function testSyntaxErrorException()

    {

        $table = new \Doctrine\DBAL\Schema\Table("syntax_error_table");

        $table->addColumn('id', 'integer', array());

        $table->setPrimaryKey(array('id'));

        $this->_conn->getSchemaManager()->createTable($table);

        $sql = 'SELECT id FRO syntax_error_table';

        $this->expectException(Exception\SyntaxErrorException::class);

        $this->_conn->executeQuery($sql);

    }

    /**

     * @dataProvider getSqLiteOpenConnection