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

-- 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);

jonasraoni

const comparer = new Intl.Collator('ru', { numeric: true }).compare;
console.log(comparer('ф', 'в')); //returns -1, 0, 1

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

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

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

using System;
using System.Collections.Generic;
using System.Globalization;
using System.Linq;

namespace JonasRaoni
{

jonasraoni

[\x00-\x7F]                         # ASCII
|[\xC2-\xDF][\x80-\xBF]             # non-overlong 2-byte
|\xE0[\xA0-\xBF][\x80-\xBF]         # excluding overlongs
|[\xE1-\xEC\xEE\xEF][\x80-\xBF]{2}  # straight 3-byte
|\xED[\x80-\x9F][\x80-\xBF]         # excluding surrogates
|\xF0[\x90-\xBF][\x80-\xBF]{2}      # planes 1-3
|[\xF1-\xF3][\x80-\xBF]{3}          # planes 4-15
|\xF4[\x80-\x8F][\x80-\xBF]{2}      # plane 16

jonasraoni

const condition = true;

// I don't know why, but adding an if here makes me sad since I started programming :L
condition ? 1 : -1;
// Alternative way 1
(-1) ** condition;
// Alternative way 2
2 * condition - 1;