vyspiansky

MySQL queries for selecting records based on different time criteria using a timestamp integer field named created.

Get records newer than today's 10 AM

SELECT
  *
FROM
  your_table
WHERE

vyspiansky

This technique updates your local branch and then "replays" your changes on top, effectively putting your changes at the head of the branch.

Enable

git config --global pull.rebase true

Disable

vyspiansky

“There are only two hard things in Computer Science: cache invalidation and naming things.”

— Phil Karlton

vyspiansky

-- Remove all watchdog's records from a MySQL table except for the last 500.

DELETE FROM `watchdog`
WHERE wid NOT IN (
    SELECT wid
    FROM (
        SELECT wid
        FROM `watchdog`
        ORDER BY wid DESC
        LIMIT 500

vyspiansky

<?php

use Drupal\Core\Database\Database;
use Drupal\Core\Database\Query\SelectInterface;

/**
 * Returns a plain SQL query from a Select query object.
 */
function get_plain_sql_query(SelectInterface $query): string
{

vyspiansky

.lando.yml

name: "..."
recipe: lamp
config:
  php: "8.1"
  xdebug: false
services:
 appserver:

vyspiansky

Clear cache by specific tags

\Drupal::service('cache_tags.invalidator')->invalidateTags([$tag1, $tag2]);

Clear specific cache like render cache

\Drupal::service('cache.render')->invalidateAll()

vyspiansky

SetEnv APP_ENV prod SetEnv DATABASE_URL 'mysql://user:[email protected]:3306/dbname'

vyspiansky

<?php

declare(strict_types=1);

/*
A pattern with multiple conditions:
- at least one digit.
- at least one lowercase letter (including special Scandinavian characters).
- at least one uppercase letter (including special Scandinavian characters).
- at least one character that is not a letter or a number (including special Scandinavian characters).

vyspiansky

<?php

namespace Drupal\your_module\Controller;

use Symfony\Component\HttpKernel\Exception\AccessDeniedHttpException;

class YourController {
  public function yourPage() {
    // Some logic here...