SchumacherFM

# removes all null, false, "", 0, [], {} and "0001-01-01T00:00:00Z values from a json
# files and writes the data back to the original file via program sponge (brew install moreutils jq)
# date time string because of GoLang empty time encoding 🙈
jsonRemoveEmpty() {
	for file in *.json; do
		cat "$file" | jq 'walk( if type == "object" then with_entries(select(.value != null and .value != false and .value != "" and .value != 0 and .value != [] and .value != {} and .value != "0001-01-01T00:00:00Z") ) else . end)' | sponge "$file"
	done
}

SchumacherFM

package main

import (
	"database/sql"
	"fmt"
	_ "github.com/go-sql-driver/mysql"
	"log"
)

const (

SchumacherFM

Backend Section: Index Management

• Nginx 1.4
• PHP 5.5 FPM

Doc: fastcgi_finish_request

Clicking on one of the Reindex Data links executes the reindex process and immediately shows the URL from action preReindexProcess() but clicking on that link to initiate a new request takes as long as it takes to wait for the reindexing.

So something is still using the same connection and waits to finish the previous request. How to initiate a new request without waiting for the previous one?

SchumacherFM

# ########################################################################
# api2_acl_attribute
# ########################################################################

# IDX_API2_ACL_ATTRIBUTE_USER_TYPE is a left-prefix of UNQ_API2_ACL_ATTRIBUTE_USER_TYPE_RESOURCE_ID_OPERATION
# Key definitions:
#   KEY `IDX_API2_ACL_ATTRIBUTE_USER_TYPE` (`user_type`)
#   UNIQUE KEY `UNQ_API2_ACL_ATTRIBUTE_USER_TYPE_RESOURCE_ID_OPERATION` (`user_type`,`resource_id`,`operation`),
# Column types:
#	  `user_type` varchar(20) not null comment 'type of user'

SchumacherFM

DELETE FROM catalog_category_entity_datetime WHERE `value` IS NULL;
DELETE FROM catalog_category_entity_decimal WHERE `value` IS NULL;
DELETE FROM catalog_category_entity_int WHERE `value` IS NULL;
DELETE FROM catalog_category_entity_text WHERE `value` IS NULL;
DELETE FROM catalog_category_entity_varchar WHERE `value` IS NULL;

DELETE FROM catalog_product_entity_datetime WHERE `value` IS NULL;
DELETE FROM catalog_product_entity_decimal WHERE `value` IS NULL;
DELETE FROM catalog_product_entity_gallery WHERE `value` IS NULL;
DELETE FROM catalog_product_entity_group_price WHERE `value` IS NULL;

SchumacherFM

<?php

$integers = range(100, 1000);

foreach ($integers as &$int) {
    $int = (string)$int;
}

function arrayToInt(array $arr)
{

SchumacherFM

package main

// run with: $ go test --bench=. -test.benchmem .
// @see https://twitter.com/karlseguin/status/524452778093977600
import (
	"math/rand"
	"strconv"
	"testing"
)

SchumacherFM

UPDATE `customer_entity`
SET `email` = concat('test+', entity_id, '@aGmailDomain.com');

UPDATE `customer_entity_varchar`
SET `value` = CONCAT(MD5(concat('qXpassword', entity_id)), ':qX')
WHERE `attribute_id` = 12;

UPDATE `sales_flat_order`
SET customer_email = concat('test+', IFNULL(customer_id, entity_id), '@aGmailDomain.com');

SchumacherFM

After I have seen that some 3rd party modules duplicate the core_url_rewrite table to store there additional category rewrite information in it (1), I came to the conclusion that it should be save to remove the joinLeft() in the flat table classes.

Instead of the joinLeft() you simply refer to the column main_table.url_path as request_path in the tables catalog_category_flat_store_[StoreId]. Please see the new methods.

Downside: To get the correct rewrites in the frontend you need to run the reindex for catalog_category_flat. During this reindex the correct rewrites will be inserted into the column catalog_category_flat_store_X.url_path.

Footnotes:

(1) the join with the core_url_rewrite takes for large product collection really long when you only need the correct rewrite for the categories. This can save per request around ~0.Xsec.

SchumacherFM

SET foreign_key_checks = 0;
TRUNCATE `log_quote`;
TRUNCATE `sales_flat_quote`;
TRUNCATE `sales_flat_quote_address`;
TRUNCATE `sales_flat_quote_address_item`;
TRUNCATE `sales_flat_quote_item`;
TRUNCATE `sales_flat_quote_item_option`;
TRUNCATE `sales_flat_quote_payment`;
TRUNCATE `sales_flat_quote_shipping_rate`;