-
Window functions in propel?
I think it's not supported by propel orm, but just in case: Is anyone doing window functions (I.E. over()… OVER( partition by…) With propel orm? I didn't find any docu in propel's site (). I can think of a workaround via aggregate columns, but I'd rather not change structure for some calculations. I am trying to skip…
-
How to extends the Propel function according to the standard
Hi Everyone I want to show the custom attribute in the order item corner that look like this one My idea is i will add more column in the table spy_sales_order_item_metadata example column: additional_attributes I see the function that adding data to the table spy_sales_order_item_metadata…
-
Filtering products on specific super attributes?
For context: I'm in the middle of implementing a feature where I have to update the stock for products sharing a specific super-attribute, and that share another super-attribute. I ended up in the SpyStockProduct::doUpdate() method. Example: Product A has superAttribute1 = blue and superAttribute2 = wood Product B has…
-
Persist a product using code
I pass a payload via URL containing th sku of the product and a name for example, I want to query to product table for the product with that sku update the name and save the product any Idea how to do this simple task taking also the store in consideration ?
-
Product-Relation Update taking very long
Hello fellow Sprykees, we are currently investigating an issue in a customer-project. The Jenkins job "product-relation:update" is taking ~11 hours, up from was previously ~5 hours, which is still a long runtime considering no problems in other projects. The command wasn't overwritten, other than 2 indexes on…
-
Is it possible to enable RDS connection encryption in Spryker PaaS?
We are getting a requirement to enable the encrypted connection. I don't see any obvious settings or docs, but I see it would pe possible to provide 'options' to PDO. Would it be acomplishable in default spryker PaaS out of the box (just changing project code)? Or would we need to have infrastructure setup?
-
Keep migrations in repository?
We are about to move to prod. Currently we just use the Spryker default .gitignore setup where migrations are not commited to the repository. I've seen 2 articles that relate to this topic in the docs: I understand it is recommended then to keep migration files for productive systems. Do I just remove migration files from…
-
I have some troubles installing and enabling Merchant portal on my spryker app.
Hello there, I have some troubles installing and enabling Merchant portal on my spryker app. First, I install default B2B-marketplace following this: https://docs.spryker.com/docs/marketplace/dev/setup/202212.0/spryker-marketplace-setup.html (replacing b2c marketplace by b2b marketplace) Then, i follow these instructions :…
-
Error regarding store and queue pool synchronization attribute
Hey Spryker guys While executing propel install command, receiving error regarding store and queue pool synchronization attribute, do anyone have idea of such error cause and resolution for the same Thank you
-
How do I run `docker/sdk console propel:install` for the non-default store also?
Hi, how do I run docker/sdk console propel:install for the non-default store also? The hands-on section of "Extending Spryker Functionality" left my b2c-demo-shop US store somewhat broken, as the changes to database only happened to the DE store. The eu-docker database had the spy_customer table with the added fk_antelope…
-
I need to add unique column to an existing propel entity
I need to add a new column to an existing propel entity. That column needs to be unique. The problem I have is that it will fail when adding the unique index, due to the unique constraints for the existing records will be checked (all the new columns have a default empty string value). How can I add a specific migration or…
-
Error when using an entity from Propel
Hey Sprykers! I’m getting an error when using an entity from Propel: Unable to execute INSERT statement [INSERT INTO spy_hello_world_message_storage (id_hello_world_message_storage, fk_hello_world_message, data, key, created_at, updated_at) VALUES (:p0, :p1, :p2, :p3, :p4, :p5)] FYI: I’m going through this Tutorial:…
-
Trying to remove unique constraint from Propel database column...
Hi all! I’m trying to remove unique constraint from Propel database column. Since Spryker merges the Propel schema into a single schema file, so every unique constraint from the Spryker core schema will end up in the final Propel schema. However, the unique constraint for email in the table spy_customer should be removed…
-
Can you share with me why Spryker choose Propel instead of Doctrine?
Hey guys, Can you share with me why Spryker choose Propel instead of Doctrine?
-
Updating record in database based on id through the propel save operation?
Need clue about the problem. I want to update the record in database based on id through the propel save operation but I am getting this error. Cannot insert a value for auto-increment primary key (pyz_client_record.id)
-
Every time when we run propel install command we are getting this error
We are stuck over this issue, Every time when we run propel install command we are getting this error :- Error - Exception: Class '\Orm\Zed\ProductCountry\Persistence\Map\SpyProductCountryTableMap' not found in /data/vendor/propel/propel/src/Propel/Runtime/Map/DatabaseMap.php (115)
-
Error on Redis integration
Hi Herd… Trying to integrate Redis and getting this error: Propel\Runtime\Exception\RuntimeException - Exception: No connection defined for database "zed". Did you forget to define a connection or is it wrong written? in /data/vendor/propel/propel/src/Propel/Runtime/ServiceContainer/StandardServiceContainer.php (303) Got…
-
Demo data and testing fixture data fails: invalid datetime format?
Hi there, we recently updated our Spryker project, in specific we updated spryker/propel-orm and hence propel/propel from 2.0.0-beta1 to 2.0.0-beta2. Now all our demo data and testing fixture data fails where we have dates like '2050-12-31'. Propel tells us, that this is an invalid datetime format. '2037-12-31' works…
-
Generated orm classes are different from the provided ModelCriteria
Hey there, 3 days ago the propel packages got updated and now using the latest propel/propel. Now the generated orm classes are different from the provided ModelCriteria. Can anyone confirm that?
-
When building propel query, is it possible to get final SQL as string?
When building propel query, is it possible to get final SQL as string?
-
Migrations: custom propel migrations are not populated on PaaS
Hey guys, I have a question regarding migrations. We have the problem, that our custom propel migrations are not populated on PaaS. We have removed https://github.com/spryker-shop/b2b-demo-shop/blob/8c21e264eb4318b6605465762c2ea00413ba8890/config/install/EU/production.yml#L17, but still no Migrations found:…
-
Known memory leak problems with propel 1.x?
Does anyone experience or know about memory leak problems with propel 1.x when handling large amounts of complex join queries during data synchronisation? How do you address these problems? Is it useful to disable the Propel cache using disableInstancePooling() during data export?
-
Question concerning propel-migrations
Hello everyone, a general question concerning propel-migrations, maybe even addressed to spryker-core devs directly: Is there a reason why the default install-scripts of the suites clear all existing migrations in the beginning (see:…
-
Does anyone know how I might achieve something like this using Propel?
Afternoon all! Does anyone know how I might achieve something like this using Propel? SELECT *FROM spy_sales_order ssoLEFT JOIN spy_customer sc ON LOWER(sso.email)=LOWER(sc.email)WHERE sc.customer_reference != sso.customer_referenceAND sso.email is not null; Specifically the LOWER() in the ON criteria. new…
-
Configure propel to create an index for every foreign-key automaticaly?
Do you know if it's possible to configure propel to create an index for every foreign-key automatically when using Postgres?
-
Is there a way to ask for the columns info using the `Propel::getConnection()` ?
Is there a way to ask for the columns info using the Propel::getConnection() ? I tried exec('\d+ table_name'); but it’s not working (it says syntax error). I tried also using this query, but the output is not the columns but metadata that I am not really interested… SELECT *FROM information_schema.columnsWHERE table_schema…
-
After upgrade to 202180.0, error about the loaderScriptDir
Hi guys, I have, after upgrade to 202180.0, always the error about the loaderScriptDir from propel Zed.CRITICAL: Propel\Runtime\Exception\PropelException - Database map was not initialized. Please check the database loader script included by your conf. After propel:install is problem gone. After docker/sdk up i have again…
-
How do I delete rows from one table using another table in WHERE clause?
this might be more a propel question, but how do I delete rows from one table using another table in WHERE clause? use{RelatedTableName} doesn't seem to work here $this->getFactory() ->createSomeQuery() ->useRelatedEntity() ->filterByRelatedEntityColumn($someValue) ->endUse() ->delete(); // doesn't work for me
-
A smart way to “force” some entity to be flagged as “updated” without overriding propel entity?
Hello, is there a smart way to “force” some entity to be flagged as “updated” without overriding the propel entity behaviour at all? For example if we write price data into the storage table, the lastUpdate date is updated in this moment … but if we fetch later the exact price data again, the record is not marked as some…
-
Error when running propel install in the CLI container
Hi guys when I try to run propel install in the CLI container I get this error Any clues?