List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| 'Delete button' | 1 |
|
| 'Delete account should throw an exception!' | 1 |
|
| "UPDATE sylius_adjustment SET shipment_id = null, details = '[]'" | 1 |
|
| "UPDATE sylius_adjustment SET shipment_id = $shipmentId, details = '" . $details . "' WHERE id = $adjustmentId" | 1 |
|
| ' SELECT adjustment.id, adjustment.label, tax_rate.code as tax_rate_code, tax_rate.name as tax_rate_name, tax_rate.amount as tax_rate_amount, adjustment.order_id, shipment.id as shipping_id, shipment.method_id, shipping_method.code AS shipment_code FROM sylius_adjustment adjustment LEFT JOIN sylius_shipment shipment ON shipment.order_id = adjustment.order_id LEFT JOIN sylius_shipping_method shipping_method on shipment.method_id = shipping_method.id LEFT JOIN sylius_tax_rate tax_rate on adjustment.label LIKE CONCAT(tax_rate.name, \'%\') WHERE adjustment.type IN ("shipping", "tax") ORDER BY adjustment.type ' | 1 |
|
| 'UPDATE sylius_catalog_promotion SET state = "inactive"' | 1 |
|
| 'UPDATE sylius_channel_pricing SET minimum_price = 0 WHERE minimum_price IS NULL' | 1 |
|
| 'UPDATE sylius_order o SET o.created_by_guest = 0 WHERE o.customer_id IN (SELECT customer_id FROM sylius_shop_user)' | 1 |
|
| 'Update messenger transport table: change queue_name length and add two indexes.' | 1 |
|
| ' 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 ' | 2 |
|
| ' 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 ' | 2 |
|
| 'UPDATE sylius_exchange_rate SET created_at = NOW()' | 2 |
|
| 'UPDATE sylius_channel SET account_verification_required = 1' | 2 |
|
| 'UPDATE sylius_product_option SET position = @row_number := @row_number + 1' | 2 |
|
| '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 |
|
| 'UPDATE sylius_channel SET skipping_shipping_step_allowed = 0' | 2 |
|
| 'UPDATE sylius_product_variant SET shipping_required = 1' | 2 |
|
| "UPDATE sylius_zone SET scope = 'all' WHERE scope IS NULL" | 2 |
|
| "UPDATE sylius_zone SET scope = NULL WHERE scope = 'all'" | 2 |
|
| '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 |
|
| '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 |
|
| 'UPDATE sylius_taxon SET created_at = NOW()' | 2 |
|
| '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 |
|
| '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 |
|
| 'UPDATE sylius_taxon SET enabled = 1' | 2 |
|
| 'UPDATE sylius_product_attribute_value SET locale_code = "' . $defaultLocale . '"' | 2 |
|
| '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 |
|
| '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 |
|
| 'UPDATE sylius_product_variant SET enabled = 1' | 2 |
|
| 'UPDATE sylius_channel SET skipping_payment_step_allowed = 0' | 2 |
|
| 'UPDATE sylius_product_attribute SET configuration = :configuration WHERE id = :id' | 4 |
|