vyspiansky

<?php

/** @var \Drupal\Core\Database\Query\ExtendableInterface $query */
$sql = $query->__toString();
$args = $query->getArguments();

foreach ($args as $placeholder => $value) {
    $quoted = is_numeric($value) ? (string) $value : "'" . addslashes($value) . "'";
    $sql = str_replace($placeholder, $quoted, $sql);
}

vyspiansky

Enable query log temporarily

Inside the MySQL prompt:

SET GLOBAL general_log = 'ON';
SET GLOBAL general_log_file = '/tmp/mariadb_general.log';

Or use one-liner from terminal

vyspiansky

Install PHP 8.4 on macOS (Intel Mac) terminal

Open Zsh configuration file:

nano ~/.zshrc

Scroll to the bottom and paste these exact lines:

vyspiansky

Convert images to JPEG with quality control via macOS Terminal.

Bash script

File ./convert_to_jpeg.sh content:

#!/bin/bash

# This script converts various image types to JPEG with 75% quality.

vyspiansky

To do this we can use debug_backtrace:

// $backtrace = debug_backtrace();
$backtrace = debug_backtrace(DEBUG_BACKTRACE_IGNORE_ARGS, 2);

// $caller = isset($backtrace[1]['function']) ? $backtrace[1]['function'] : 'unknown';
$caller = $backtrace[1]['function'] ?? 'unknown';

vyspiansky

To console.log every argument pushed to Google Tag Manager, use

window.dataLayer = window.dataLayer || [];

// Save the original push method
const originalPush = window.dataLayer.push;

// Monkey patch push
window.dataLayer.push = function() {

vyspiansky

To list mounted volumes use the following command in the Terminal (Applications > Utilities):

ls -la /Volumes/

For instance, our SD card is mounted as NO NAME.

Let's check extended attributes

vyspiansky

-- Top 10 largest tables in a MySQL database
-- MySQL 5.7.29

SELECT 
    table_schema AS `Database`,
    table_name AS `Table`,
    ROUND((data_length + index_length) / 1024 / 1024, 2) AS `Size (MB)`,
    ROUND(data_length / 1024 / 1024, 2) AS `Data Size (MB)`,
    ROUND(index_length / 1024 / 1024, 2) AS `Index Size (MB)`,
    table_rows as 'Rows'

vyspiansky

// Create a request object or parse the URL
$request = \Symfony\Component\HttpFoundation\Request::create($urlWithoutToken);

// or get the current request.
// $request = $event->getRequest();

Add new query parameter to URL

vyspiansky

cURL Multi

Native cURL multi-handle API for parallel requests.

Using separate cURL requests

<?php
// File: separate_curl_requests.php