jonasraoni

-- find missing indexes
SELECT
	conrelid::regclass, conname, reltuples::bigint
FROM
	pg_constraint
JOIN pg_class 
	ON conrelid = pg_class.oid
WHERE 
	contype = 'f'
	AND NOT EXISTS (

jonasraoni

<?php

/**
 * @file classes/migration/upgrade/v3_4_0/I8073_RemoveNotesWithoutQueriesAndRelatedObjects.php
 *
 * Copyright (c) 2014-2022 Simon Fraser University
 * Copyright (c) 2000-2022 John Willinsky
 * Distributed under the GNU GPL v3. For full terms see the file docs/COPYING.
 *
 * @class I8073_RemoveNotesWithoutQueriesAndRelatedObjects

jonasraoni

<?php
print_r(optimizeCountQuery(
	'SELECT (SELECT drop FROM expensive WHERE true = ?) AS subquery
	FROM table
	WHERE (SELECT ?) = param
	ORDER BY not_needed_for_count, drop = ?',
	[true,'param', true]
));

/*

jonasraoni

//+ Jonas Raoni Soares Silva
//@ http://raoni.org

export default class NumericDirective {
    constructor(input, binding) {
        Object.assign(this, {
            input,
            binding
        });
        input.addEventListener('keydown', this);

jonasraoni

export default {
  install: Vue => Vue.filter('format-number', (value, { thousand = ' ', decimal = '.', decimals = null, maxDecimals = decimals, minDecimals = decimals, normalize = true, roundToEven = true } = {}) => {
    value = normalize ? normalizeNumber(value) : `${value != null ? value : ''}`;
    let pieces = value.split('.');
    if (!pieces[0].length) {
      return;
    }

    if (minDecimals > 0) {
      pieces[1] = (pieces[1] = pieces[1] || '').padEnd(minDecimals, '0');

jonasraoni

using System;
using System.Collections;
using System.Collections.Generic;

/// <summary>
/// Extends the Array with the Flatten method
/// </summary>
public static class Flattener {
	/// <summary>
	/// Given a N-dimensional array, flattens it into a new one-dimensional array without modifying the elements' order

jonasraoni

{"lastUpload":"2021-11-02T08:34:50.367Z","extensionVersion":"v3.4.3"}

jonasraoni

export default class TooltipOnOverflowDirective {
  static install (Vue) {
    Vue.directive('tooltip-on-overflow', this.directive);
  }

  static directive = {
    bind (el) {
      for (const event of ['mouseover', 'mouseout']) {
        el.addEventListener(event, TooltipOnOverflowDirective[event]);
      }

jonasraoni

-- Convert
SELECT CONVERT(CAST(CONVERT('São Paulo' USING latin1) AS BINARY) USING utf8) -- São Paulo

-- Our lovely friends celebrate ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö \o/

-- Poor man's bad encoding detection (in my case there was LATIN1 data mixed with UTF8 in the database and I just wanted to find when things started to get mixed up)
-- When trying to convert, normally the amount of characters decrease...
SELECT field
FROM table
WHERE LENGTH(CONVERT(CAST(CONVERT(field USING latin1) AS BINARY) USING utf8)) < LENGTH(field) 

jonasraoni

var value = 0.1230000000000000M;
Console.WriteLine(value);
Console.WriteLine(value / 1.0000000000000000000000000000M);