Case with doctrine2, symfony2 and postgresql entities

Question

I have a problem with doctrine2 in symfony2 app with postgres database.

I get error:

SQLSTATE[3F000]: Invalid schema name: 7 ERROR: schema "main" does not exist

Problem is that my schema is Main not main. When I rename it, similar thing happends for table relation:

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "main.brand_brandid_seq" does not exist

Problem is case sensitivity and I guess maybe it have something to do with quoting or some doctrine configuration.

Entity:

namespace MyB\Entity;

/**
 * MyB\Entity\Brand
 *
 * @orm:Table(name="Main.Brand")
 * @orm:Entity
 */
class Brand
{
    /**
     * @var integer $brandid
     *
     * @orm:Column(name="BrandId", type="integer", nullable=false)
     * @orm:Id
     * @orm:GeneratedValue(strategy="SEQUENCE")
     * @orm:SequenceGenerator(sequenceName="Main.Brand_BrandId_seq", allocationSize="1", initialValue="1")
     */
    private $brandid;

    /**
     * @var string $brandname
     *
     * @orm:Column(name="BrandName", type="string", length=32, nullable=false)
     */
    private $brandname;

    /**
     * Set name.
     *
     * @param string $name
     */
    public function setName($name) {
        $this->brandname = $name;
    }
}

Schema:

SET search_path = "Main", pg_catalog;

CREATE SEQUENCE "Brand_BrandId_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


SET default_tablespace = '';

SET default_with_oids = false;


CREATE TABLE "Brand" (
    "BrandId" integer DEFAULT nextval('"Brand_BrandId_seq"'::regclass) NOT NULL,
    "BrandName" character varying(32) NOT NULL
);

Controller:

        $reseller = new \MyB\Entity\Brand();
        $reseller->setName('Sasa');

        $em = $this->get('doctrine.orm.entity_manager');
        $em->persist($reseller);
        $em->flush();

Any idea?

umpirsky · Accepted Answer · 2011-04-12 07:51:54Z

4

Try this

namespace MyB\Entity;

/**
 * MyB\Entity\Brand
 *
 * @orm:Table(name="""Main"".""Brand""")
 * @orm:Entity
 */
class Brand
{
    /**
     * @var integer $brandid
     *
     * @orm:Column(name="""BrandId""", type="integer", nullable=false)
     * @orm:Id
     * @orm:GeneratedValue(strategy="SEQUENCE")
     * @orm:SequenceGenerator(sequenceName="""Main"".""Brand_BrandId_seq""", allocationSize="1", initialValue="1")
     */
    private $brandid;

    /**
     * @var string $brandname
     *
     * @orm:Column(name="""BrandName""", type="string", length=32, nullable=false)
     */
    private $brandname;

    /**
     * Set name.
     *
     * @param string $name
     */
    public function setName($name) {
        $this->brandname = $name;
    }
}

In postgres every word case sensitive must be escape.

edited Apr 12, 2011 at 7:51

umpirsky

10k13 gold badges75 silver badges96 bronze badges

answered Apr 7, 2011 at 5:56

mstrzele

663 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user3132304 · Accepted Answer · 2013-12-24 11:13:08Z

1

When using escaped table names take care about this "bug" : https://github.com/doctrine/doctrine2/pull/615 . Doctrine takes the first character of the table name as aliasprefix and thus a quote is used, crushing all your SQLs

answered Dec 24, 2013 at 11:13

user3132304

111 bronze badge

Comments

mstrzele · Accepted Answer · 2011-04-07 06:59:27Z

0

I write PpSqlBundle but it isn't finished yet, but you could try, I think it should work. It can generate form db same as in symfony. in config.yml you should have:

doctrine:
dbal:
    default_connection: default
    connections:
        default:
            driver:   
            dbname:   
            host:     
            user:     
            password: 
            driverClass: PgSqlBundle\Doctrine\DBAL\Driver\PDOPgSql\Driver # it's important
            logging:

and you should use command

app/console doctrine:mapping:import Yourbundlename annotation

https://github.com/mstrzele/PgSqlBundle

answered Apr 7, 2011 at 6:59

mstrzele

663 bronze badges

28 Comments

umpirsky Over a year ago

Thanks, but it throws: The given 'driverClass' PgSqlBundle\Doctrine\DBAL\Driver\PDOPgSql\Driver has to implement the \Doctrine\DBAL\Driver interface.

mstrzele Over a year ago

And it does. To install you should have i to register namespace:

mstrzele Over a year ago

for example: 'PgSqlBundle' => DIR.'/../src', and register bundle: new PgSqlBundle\PgSqlBundle(),

mstrzele Over a year ago

I use symfony2 pr10 with vendors

umpirsky Over a year ago

Yes, thanks. But there is no gSqlBundle\PgSqlBundle class on github.com/mstrzele/PgSqlBundle.

|

Oladipo · Accepted Answer · 2015-12-02 08:56:00Z

0

If you are using migration files on Laravel. Change Schema::table to Schema::create. This might help someone.

answered Dec 2, 2015 at 8:56

Oladipo

1,6893 gold badges18 silver badges33 bronze badges

Collectives™ on Stack Overflow

Case with doctrine2, symfony2 and postgresql entities

4 Answers 4

Comments

Comments

28 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

28 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related