SQL Inventory

List of all SQL mentioned in the code..

ValueCountFile:Line
'Delete button'
1
  • /src/Sylius/Behat/Page/Admin/Taxon/CreatePage.php
'Delete account should throw an exception!'
1
  • /src/Sylius/Behat/Context/Ui/CustomerContext.php
'
                        UPDATE sylius_order_item
                        INNER JOIN sylius_order ON sylius_order_item.order_id = sylius_order.id
                        INNER JOIN sylius_product_variant ON sylius_order_item.variant_id = sylius_product_variant.id
                        INNER JOIN sylius_product_variant_translation ON sylius_product_variant_translation.translatable_id = sylius_product_variant.id
                        SET sylius_order_item.variant_name = sylius_product_variant_translation.name
                        WHERE sylius_product_variant_translation.locale = sylius_order.locale_code
        '
1
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20170913125128.php
'
                        UPDATE sylius_order_item
                        INNER JOIN sylius_order ON sylius_order_item.order_id = sylius_order.id
                        INNER JOIN sylius_product_variant ON sylius_order_item.variant_id = sylius_product_variant.id
                        INNER JOIN sylius_product ON sylius_product_variant.product_id = sylius_product.id
                        INNER JOIN sylius_product_translation ON sylius_product_translation.translatable_id = sylius_product.id
                        SET sylius_order_item.product_name = sylius_product_translation.name
                        WHERE sylius_product_translation.locale = sylius_order.locale_code

        '
1
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20170913125128.php
'
                        UPDATE sylius_order_item 
                        INNER JOIN sylius_order ON sylius_order_item.order_id = sylius_order.id 
                        INNER JOIN sylius_product_variant ON sylius_order_item.variant_id = sylius_product_variant.id 
                        INNER JOIN sylius_product ON sylius_product_variant.product_id = sylius_product.id  
                        INNER JOIN sylius_product_translation ON sylius_product_translation.translatable_id = sylius_product.id
                        SET sylius_order_item.product_name = sylius_product_translation.name 
                        WHERE sylius_product_translation.locale = sylius_order.locale_code
       
        '
1
  • /app/migrations/Version20170913125128.php
'
                        UPDATE sylius_order_item 
                        INNER JOIN sylius_order ON sylius_order_item.order_id = sylius_order.id 
                        INNER JOIN sylius_product_variant ON sylius_order_item.variant_id = sylius_product_variant.id 
                        INNER JOIN sylius_product_variant_translation ON sylius_product_variant_translation.translatable_id = sylius_product_variant.id
                        SET sylius_order_item.variant_name = sylius_product_variant_translation.name 
                        WHERE sylius_product_variant_translation.locale = sylius_order.locale_code
        '
1
  • /app/migrations/Version20170913125128.php
'UPDATE sylius_product_association_type SET name = (SELECT name FROM sylius_product_association_type_translation WHERE sylius_product_association_type_translation.translatable_id = sylius_product_association_type.id AND sylius_product_association_type_translation.locale = "' . $defaultLocale . '")'
2
  • /app/migrations/Version20161219160441.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20161219160441.php
'UPDATE sylius_product_attribute_value SET locale_code = "' . $defaultLocale . '"'
2
  • /app/migrations/Version20170109143010.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20170109143010.php
'UPDATE sylius_product_variant SET name = (SELECT name FROM sylius_product_variant_translation WHERE sylius_product_variant_translation.translatable_id = sylius_product_variant.id AND sylius_product_variant_translation.locale = "' . $defaultLocale . '")'
2
  • /app/migrations/Version20161214153137.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20161214153137.php
'INSERT INTO sylius_product_variant_translation (translatable_id, name, locale) SELECT id, name, "' . $defaultLocale . '" from sylius_product_variant WHERE sylius_product_variant.name IS NOT null'
2
  • /app/migrations/Version20161214153137.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20161214153137.php
'UPDATE sylius_product_variant
                        JOIN variants_count ON variants_count.product_id = sylius_product_variant.product_id
                        SET position = CASE
                                WHEN variants_count.row_number = 1 THEN (@row_number := -1) + 1
                                WHEN @row_number + 1 < variants_count.row_number then @row_number := @row_number + 1
                                ELSE @row_number := 0
                            END'
2
  • /app/migrations/Version20161223091334.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20161223091334.php
'UPDATE sylius_product_variant SET enabled = 1'
2
  • /app/migrations/Version20200309172908.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20200309172908.php
'UPDATE sylius_channel SET account_verification_required = 1'
2
  • /app/migrations/Version20170220150813.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20170220150813.php
'INSERT INTO sylius_product_association_type_translation (translatable_id, name, locale) SELECT id, name, "' . $defaultLocale . '" from sylius_product_association_type WHERE sylius_product_association_type.name IS NOT null'
2
  • /app/migrations/Version20161219160441.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20161219160441.php
'UPDATE sylius_channel SET skipping_payment_step_allowed = 0'
2
  • /app/migrations/Version20170401200415.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20170401200415.php
'UPDATE sylius_channel SET skipping_shipping_step_allowed = 0'
2
  • /app/migrations/Version20170214104908.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20170214104908.php
'UPDATE sylius_product_option SET position = @row_number := @row_number + 1'
2
  • /app/migrations/Version20161221133514.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20161221133514.php
'UPDATE sylius_channel_pricing, sylius_channel SET sylius_channel_pricing.channel_id = sylius_channel.id WHERE sylius_channel.code = sylius_channel_pricing.channel_code'
2
  • /app/migrations/Version20170223071604.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20170223071604.php
'UPDATE sylius_channel_pricing, sylius_channel SET sylius_channel_pricing.channel_code = sylius_channel.code WHERE sylius_channel.id = sylius_channel_pricing.channel_id'
2
  • /app/migrations/Version20170223071604.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20170223071604.php
'UPDATE sylius_exchange_rate SET created_at = NOW()'
2
  • /app/migrations/Version20170217141621.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20170217141621.php
'UPDATE sylius_product_variant SET shipping_required = 1'
2
  • /app/migrations/Version20170117075436.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20170117075436.php
'UPDATE sylius_taxon SET created_at = NOW()'
2
  • /app/migrations/Version20170327135945.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20170327135945.php
'UPDATE sylius_taxon SET enabled = 1'
2
  • /app/migrations/Version20200325075815.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20200325075815.php
'UPDATE sylius_product_attribute SET configuration = :configuration WHERE id = :id'
4
  • /app/migrations/Version20171003103916.php
  • /app/migrations/Version20171003103916.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20171003103916.php
  • /src/Sylius/Bundle/CoreBundle/Migrations/Version20171003103916.php