Running Unit Test in DDEV There are 3 ways to run a unit test with composer: 1. Basic Composer PHPUnit...
In backend > Catalog > Manage Categories, we can configure a category page and put it on the main menu. The page...
Add a Custom Column in sales_flat_order_grid by Layout Update skus SKUs skus status Join a Column in...
There are 3 machines: Local Computer Windows OS Development Server Production Server There are 3 repositories upstream, a fork of...
For read and write adapters, fetchOne(), fetchAll(), fetchAssoc(), fetchRow(), fetchCol(), fetchPairs(), see lib\Zend\Db\Adapter\Abstract.php Also, standalone class...
Alter the columns: SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE...
Add Foreign Key /** @var Mage_Core_Model_Resource_Setup $installer */ $installer = $this; $installer->startSetup(); /** @var Varien_Db_Adapter_Pdo_Mysql...
nginx URL rewrite stackoverflow PHP lib M1 Extension and the blog, version 2. API Implementation Doc Client based on ZF1...
There are 2 column types: // lib\Varien\Db\Ddl\Table.php const TYPE_TIMESTAMP = 'timestamp'; // Capable to support date-time from...
This doesn't work: ->addColumn('name', Varien_Db_Ddl_Table::TYPE_TEXT, 200, array( 'nullable' => false, 'collate' => 'utf8mb4_unicode_ci...
Change Text Length /** @var Mage_Core_Model_Resource_Setup $installer */ $installer = $this; $installer->startSetup(); /** @var Varien_Db_Adapter_Pdo_Mysql...
OM uses Zend Version 1.12.16. Adding Another Table to the Query with JOIN Many useful queries involve using a JOIN...
DO NOT use inline translation. The inline translations are stored in the table core_translate. Backup the table, convert all...
See production grade nginx and docker config here. Some notes on this: the PCI work was trial and error, we...
Get the last entry of each applicant in history table: $installer = $this; $db = $installer->getConnection(); $table = $installer->getTable('table/name');
If the custom options of a product are the same across stores, but somehow there are not defaulted to store...
When a block directive, double curly brackets: {{block type="module/block"}} is called in the static block, it is necessary to...
custom module productcoption config.xml 0.0.1 Somemod_ProductCoption Somemod_ProductCoption_Block Somemod_ProductCoption_Block_Adminhtml_ProductEditTabOptions_Option Somemod_ProductCoption_Block_Adminhtml...
How to update a column in main table from another table's column. Reference: Varien_Db_Adapter_Pdo_Mysql::updateFromSeelct...
$collection->addFieldToFilter('field_name', [ ['eq' => 'value1'], ['eq' => 'value2'] ] ); // same as $collection->addFieldToFilter('field_name', ['value1', 'value2']);
condA AND (cond1 OR cond2 OR cond3) $cincId = $session->getCustomerId(); $attributes = array( array('attribute'=>'mc_by', 'eq'=>$clinicId), array('attribute...
Best results in other decks
Performing COUNT(*) on large tables is slow. Sometimes you don’t need the exact number once results exceed a certain...
Flag: --compress=zstd