Sully Syed

Sublime Text: Add the ability to get a file’s relative project path to the Command Palette

Often enough when I’m debugging an issue that doesn’t occur the same in the staging or production environment as it does on a development or local environment, like most developers I add debug statements on those environments to catch/view output from various function calls.

Navigating the files in a complex project eats up significant time; since you’ve likely got the file that needs debug statements sitting open locally in Sublime Text, here’s a little Command Palette addition to copy the relative path (to project root) of the current file to your clipboard:

Step #1: Create the Plugin

  1. In Sublime Text, go to Tools > Developer > New Plugin…
  2. Replace the default code with the contents as shown below.
  3. Save the plugin with a name like copy_relative_path.py in your Packages/User directory.
import sublime
import sublime_plugin
import os

class CopyRelativeFilePathCommand(sublime_plugin.TextCommand):
    def run(self, edit):
        window = self.view.window()
        file_path = self.view.file_name()
        project_data = window.project_data()

        if not file_path or not project_data:
            sublime.status_message("No file or project data available.")
            return

        folders = window.folders()
        for folder in folders:
            if file_path.startswith(folder):
                relative_path = os.path.relpath(file_path, folder)
                sublime.set_clipboard(relative_path)
                sublime.status_message(f"Copied: {relative_path}")
                return

        sublime.status_message("File not in project folder.")

Step #2: Add Plugin to Command Palette

  1. Open your User package folder In Sublime Text, go to Preferences > Browse Packages… and open the User folder.
  2. Create a new file named copy_relative_path.sublime-commandswith the contents as shown below.
    • "caption" is what will appear in the Command Palette.
    • "command" must match the name of the command class you defined in your plugin (copy_relative_file_path).
  3. Save the file and restart Sublime Text (or just use the Command Palette).
[
  {
    "caption": "Copy Relative File Path to Project Root",
    "command": "copy_relative_file_path"
  }
]

Sully Syed

Fixing AWS Elastic Beanstalk’s “could not parse environment variables” error for /opt/elasticbeanstalk/bin/get-config

When deploying Laravel and WordPress to AWS Elastic Beanstalk, creating an .env file or just making use of environment variables is a common practice; however, Elastic Beanstalk tends to choke on string values of “null” and often returns the error message could not parse environment variables.

To resolve this issue, run the following command:

/opt/elasticbeanstalk/bin/get-config optionsettings

Look for any string values that seem like they would cause an issue, but especially string values that look like “null”; if found, run using your eb CLI command (assuming REDIS_PASSWORD is at fault):

eb setenv REDIS_PASSWORD=''

Reference:

Sully Syed

Creating another MySQL superuser on Amazon Aurora or Amazon RDS

Normally, creating a second (or third, fourth…) MySQL superuser who has all available database privileges is as simple as executing:

GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'%' IDENTIFIED BY 'password';

However, MySQL database in Amazon RDS and Amazon Aurora only allow one superuser to exist; however, you can neatly replicate the effect of having a superuser (the same full set of privileges) by modifying your SQL query to the following:

GRANT EXECUTE, PROCESS, SELECT, SHOW DATABASES, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, DELETE, CREATE VIEW, INDEX, EVENT, DROP, TRIGGER, REFERENCES, INSERT, CREATE USER, UPDATE, RELOAD, LOCK TABLES, REPLICATION SLAVE, REPLICATION CLIENT, CREATE TEMPORARY TABLES ON *.* TO 'newuser'@'%' WITH GRANT OPTION;

References:

Sully Syed

Google Workspace Group Email Delegates: Sending on behalf of a Group mailing list

On Google Workspace, to allow a User to send an email on behalf of a group (like allowing Sully Syed to send an email from [email protected]), do the following:

  1. Go to Gmail on the web ( https://mail.google.com/mail/u/0/#inbox ) and log in.

  2. Click the gear icon in the upper-right and then click See all settings.

  3. Click Accounts and in the Send Mail As section, click Add another email address.

  4. Enter the name “yllus.com Information” and email address [email protected], leave Treat as an alias checked, and click Next step.

  5. Click the Send Verification button to receive an email confirmation. This message will go to the Group and thus your inbox.

  6. Click the verification link, and click the Confirm button when prompted.

  7. With that all done, do a hard refresh (F5 / Ctrl-R) to reload Gmail. Then start composing an email; you’ll notice you can select either your Gmail account or your Google Group email address as the sender in the From field. This also works when replying to incoming emails.

Source: Sending from a Google Group address in Gmail – Technology Help

Sully Syed

Get your MySQL table sizes in MB via a SQL query

Figuring out what tables are making your database excessively large can be really helpful when working with production database exports and keeping various environments up to date. This SQL query outputs that information for all databases on a given server:

SELECT
	table_schema AS `Database`,
	table_name AS `Table`,
	ROUND(((data_length + index_length) / 1024 / 1024), 2) AS `Size in MB`
FROM information_schema.TABLES
ORDER BY table_schema, (data_length + index_length) DESC;

Reference:

Sully Syed

Generate MySQL INSERT statements for a few existing records

Occasionally, you’ll want to duplicate a couple of records from your production MySQL database for local use without dumping the entire table (which could be huge). As a solution, the mysqldump command allows you to specify a table and a WHERE query for that table, allowing you to select specific record ID #s and retrieve only those records as INSERT statements:

mysqldump -h {host} -P {port} -u {username} -p{password} {database_name} {table_name} --where="ID = 1" --no-create-info --no-create-db

Reference:

Sully Syed

Import Environics demographics data into a SQL database via Laravel CLI command

Environics Analytics provides incredibly useful demographics, psychographics and segmentation data for Canada, but the raw data is challenging if the goal is to use it in a general SQL query: The raw data is in one file, the meanings of the columns are in a ‘metadata’ file, and the data provided doesn’t necessarily just list postal codes but other geographic areas as well.

Linked below is a Laravel CLI command that outputs a .SQL file that will handle the creation and insertion of data and definitions for you. The CLI command is invoked as follows:

php artisan environics_demographics:import {csv_demographics_definitions} {csv_demographics_data} {year_demographics_data} {dir_output_data}

Find the full script on GitHub Gist, or below:

Sully Syed

Merge a PHP array without duplicates (array_merge_recursive_distinct)

Often enough in PHP, you’ll grab objects from a variety of sources and want to merge them into a single array of results. To merge without duplicates, add the following function to your codebase and make use of array_merge_recursive_distinct the same way you would array_merge_recursive:

// From: https://www.php.net/manual/en/function.array-merge-recursive.php#92195
if (! function_exists('array_merge_recursive_distinct')) {
    /**
     * @param array<int|string, mixed> $array1
     * @param array<int|string, mixed> $array2
     *
     * @return array<int|string, mixed>
     */
    function array_merge_recursive_distinct(array &$array1, array &$array2): array
    {
        $merged = $array1;
        foreach ($array2 as $key => &$value) {
            if (is_array($value) && isset($merged[$key]) && is_array($merged[$key])) {
                $merged[$key] = array_merge_recursive_distinct($merged[$key], $value);
            } else {
                $merged[$key] = $value;
            }
        }

        return $merged;
    }
}

Reference:

Sully Syed

Upgrade a deprecated AWS Elastic Beanstalk environment in place using the CLI

When a major PHP version change (eg. 5.7 to 7.0, or 7.0 to 8.0) occurs, Amazon AWS Elastic Beanstalk typically does not allow for automated platform version updates but instead requires the cloning of an interface and a CNAME switch. For less available environments, use the following steps to upgrade-in-place using the AWS command line interface:

  1. Take a look at the list of currently supported PHP platforms on Elastic Beanstalk; you’ll want to decide which Solution Stack Name (eg. “64bit Amazon Linux 2 v3.4.1 running PHP 8.1”) corresponds to the platform you wish to upgrade to.
  2. In the Elastic Beanstalk web configuration page, get the environment ID for the environment you wish to upgrade (eg. “e-jwfjvy57r3”).
  3. Run the aws command to upgrade the environment in place:
    aws elasticbeanstalk update-environment --solution-stack-name "64bit Amazon Linux 2 v3.4.1 running PHP 8.1" --environment-id "e-2iuwivbgzc" --region "ca-central-1"

Reference:

Sully Syed

Regular expressions: Find instances when the string does not equal a certain value

Another typical regex scenario: You’re looking through some data (like a JSON object) and are looking for when a value is actually being set. Let’s say our string contains:

"puttLength": null,

Typically, you’d write a regular expression to capture the <em> tag by writing this:</em>

"puttLength": ((?!null).)*$

The use of ?! is the instruction to make a negative lookahead match, ensuring null does not exist before the line can be returned as a match. A terrific example / tool to test in your browser exists at https://www.regextester.com/15 .