mucaho

Minimum working example for issue described in https://support.google.com/webmasters/thread/171071268?hl=en

Requires installation of Node.js
Put these files into a directory, run npm install to install dependencies
Use ssh -R 80:localhost:8080 localhost.run to setup a temporary tunnel to your local machine, leave that shell open
Copy & paste the publicly accessible tunnel url that will be established, e.g. https://XXX.lhrtunnel.link
Open Google Search Console and create a new URL prefix property with that tunnel link
Use the meta tag verification method and paste it into the project's index.html file's header

A (more) complete cheatsheet for Arel, including NamedFunction functions, raw SQL and window functions.

posts = Arel::Table.new(:posts)
posts = Post.arel_table # ActiveRecord

First creation date: 2025-04-20
Latest update date: 2025-04-24

Changelog

	// ==UserScript==
	// @name YouTube restore video time
	// @namespace Violentmonkey Scripts
	// @match https://.youtube.com/
	// @grant none
	// @version 1.0
	// @author mucaho
	// @description -
	// ==/UserScript==

	module ArelHelpers
	extend self

	def self.included(base)
	base.extend self
	end

	def asterisk(arel_table_or_model)
	arel_table, columns = case arel_table_or_model
	when Arel::Table

	# Instructions for darwin coreutils
	# credits: https://stackoverflow.com/questions/3840908/how-do-i-see-the-differences-between-2-mysql-dumps

	cd /to/appropriate/working/dir

	docker exec -ti mysql5.7 /bin/bash
	> mysqldump --skip-opt DB_NAME > prior.sql
	> exit
	docker cp mysql5.7:/prior.sql prior.sql
	sed -i='' -e "s/[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9] [0-9][0-9]:[0-9][0-9]:[0-9][0-9]/0000-00-00 00:00:00/g" prior.sql