Symfony2 (doctrine2) native sql insert

Question

How to insert data in symfony2 doctrine2 on native sql?

My query

insert into propriedades (id,name,descripcion,num_lote,cod_imovel,imovel,convenio,proprietar,cpf,area_ha,perimetro,location,centro) VALUES (nextval('propriedades_id_seq'),'?','?','?','?','?','?','?','?','?','?',ST_GeomFromKML('<Polygon><outerBoundaryIs><LinearRing><coordinates>".$terra['coordinates']."</coordinates></LinearRing></outerBoundaryIs></Polygon>'),ST_Centroid(ST_GeomFromKML('<Polygon><outerBoundaryIs><LinearRing><coordinates>".$terra['coordinates']."</coordinates></LinearRing></outerBoundaryIs></Polygon>')))

Mun Mun Das · Accepted Answer · 2012-09-22 03:02:34Z

8

You have to use $conn->insert('table', $dataArray);. See documentation

answered Sep 22, 2012 at 3:02

Mun Mun Das

15k2 gold badges46 silver badges43 bronze badges

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

4 Comments

Ciro Vargas Over a year ago

this dont work with me, because i use psql in queryes and in insert this had in '', transforming the function in a string

Mun Mun Das Over a year ago

hmm, you can put function strings in a variable then pass it to the $dataArray.

Mun Mun Das Over a year ago

discard previous comment. I misunderstood your problem.

Mun Mun Das Over a year ago

You can try with $conn->executeQuery(). From the doc it looks flexible enough.

Konrad Gałęzowski · Accepted Answer · 2020-11-15 16:44:23Z

In 2020 you can do something like (example query, adapt it to your params):

        $query = "
            INSERT INTO `user_challenges_claimed`
            SET
                `season_id` = :seasonId,
                `user_id` = :userId,
                `interval_type` = :intervalType,
                `is_claimed` = true
            ON DUPLICATE KEY UPDATE 
                `is_claimed` = true
            ;
            ";

        // set query params
        $queryParams = [
          'seasonId'     => $seasonId,
          'userId'       => $userId,
          'intervalType' => $intervalType,
        ];

        // execure query and get result
        $result = $this->manager->getConnection()
          ->executeQuery(
            $query,
            $queryParams
          );

        // clear manager entities
        $this->manager->clear();

        // optional - assert row has been inserted/modified
        if ($result->rowCount() < 1) {
            throw new ChallengeAlreadyClaimedException(
              "[{$seasonId}:{$userId} - {$intervalType}]"
            );
        }

$this->manager is an object implementing EntityManagerInterface (ie EntityManager).

DarkLeafyGreen · Accepted Answer · 2012-09-21 22:39:48Z

0

Usually you do not use what you call native sql in a symfony 2 project but the high level Doctrine ORM layer.

However there is a doctrine dbal layer which enables e.g. mysql queries instead of DQL. Here is the reference

http://symfony.com/doc/2.0/cookbook/doctrine/dbal.html

answered Sep 21, 2012 at 22:39

DarkLeafyGreen

70.6k136 gold badges394 silver badges618 bronze badges

1 Comment

Ciro Vargas Over a year ago

i used the function query() but this dont have statements support, have other function

Collectives™ on Stack Overflow

Symfony2 (doctrine2) native sql insert

3 Answers 3

4 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related