Questions tagged [pomm]

Pomm is a PHP Object Model Manager framework for the Postgresql relational database.

Pomm is a framework that aims at making the developers able to leverage Postgresql features to shape data the way they want. Unlike ORM, it maps database sets to flexible object oriented entities through a projection control. Special care was given to performances and memory consumption.

More informations available from the main website or the github project

20 questions
2
votes
1 answer

projection pomm many to many

I use pomm in a symfony 3.4 project. Here is my use case. In a model generated from a Pomm command, I have this method implemented: $sql = <<
skyhell
  • 43
  • 7
2
votes
1 answer

Automatically select specific hstore with pomm project

I want select easily multiple row with a specific hstore key. Here "fr" key. You can see the follow structure: +----+----------------+-------------------------+ | id | name_i18n | description_i18n …
1
vote
1 answer

Register custom Pomm converters from a bundle?

The need Automatically add custom converters (coming from a bundle) to an existing session (the default of my application). I don't find a way to achieve this, so I have tried another approach. Context Symfony application with pomm-bundle: ~2.4. My…
DjLeChuck
  • 308
  • 5
  • 17
1
vote
1 answer

No converter registered for type

For the same case, i have an another error : No converter registered for type 'public.group', I have, user, group and user_group tables. $sql = <<
skyhell
  • 43
  • 7
1
vote
1 answer

POMM2 in Symfony3 project, trouble with registering converter

The idea is this. In table 'driver' I have fields that describe 'driver', but I need to store another set of fields about 100 which I didn't need to be table columns. So I decided to store them in Jsonb field. I need to be able to work with this…
1
vote
1 answer

Purge the database data with Pomm

Doctrine provides a simple way to purge a whole database keeping the schema $purger = new ORMPurger($this->getEntityManager()); $purger->purge(); Is there a way to do so with Pomm ? It would be specially useful to reset the test DB between each…
olaurendeau
  • 659
  • 4
  • 12
1
vote
2 answers

Pommbundle Relation with another table

For my project, i use pommbundle for my Symfony project and i have a question: For example : TABLE Catalogue: id = 1 name = test webinfo = 2 TABLE Info : id=1 webid = 2 textinfo = OK textmore = it's…
1
vote
3 answers

group by error with postgres and pomm orm

I want to execute the following SQL query : SELECT date, COUNT(id_customers) FROM event WHERE event_id = 3 GROUP BY date When I try this query in my database, it works perfectly. But in my code I get an error which I can't resolve. I use…
t-n-y
  • 1,201
  • 2
  • 13
  • 27
1
vote
1 answer

Tree structure with hydrated model in Pomm-project

I have simple database table which implements tree structure via parent_id attribute. Something like this: +----+------+-----------+ | id | name | parent_id | +----+------+-----------+ | 1 | test | null | +----+------+-----------+ | 2 | tes2…
0
votes
1 answer

Remaining deprecation notices with Pomm

I use Pomm in the Symfony project in version 3.4. That's my problem, when i execute the PHpunit test from my project, i have a notices on my models files, examples : 1x: The PommProject\SymfonyBridge\PropertyInfo\Extractor\PommExtractor class is…
skyhell
  • 43
  • 7
0
votes
0 answers

PommBundle Multi-insert

I would like to create a complex query with pommbundle for insert multi line in single query it's possible? can you give me a exemple? insert into table values (1,1), (1,2), (1,3), (2,1); Exemple : Actualy i make that : foreach($value['finition']…
0
votes
3 answers

Pomm Bundle same spl_object_hash but object different

I use Pomm bundle for my symfony Project and i have a problem I have create a complex query and my result instance same object with different attributes. It's just for example but this request have relation one -> many I know that this request (1…
0
votes
1 answer

PommBundle Type and request

I have a question about Pommbundle for symfony In my pgsqlServer i have a money type What is the equivant for poombundle mapping? It's possible to give me a document for a type row define in pommbundle? If i want to use a agregat function in sql…
0
votes
1 answer

Set Model attributes in camelCase - Pomm project

I have a table in a PostgreSQL database whose columns are snake_case formatted.Is there a way to retrieve my Model attributes in camelCase ? eg: I have a table user with two columns id_user (primary key) and last_nameWhen I execute a query like the…
Bouss
  • 3
  • 4
0
votes
0 answers

Symfony2 - Pommbundle and userInterface

I use pommbundle with my symfony project and i want to use the symfony security user. It's possible with pommbundle? I have create a entity implement userinterface USER namespace AppBundle\Entity\Model\MyDb1\PublicSchema; use…
1
2