Skip to content

Instantly share code, notes, and snippets.

Rafał Lorenz vardius

Block or report user

Report or block vardius

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@vardius
vardius / array_map_keys.php
Created Jun 28, 2019
Applies the callback to the keys of the given array
View array_map_keys.php
<?php
function array_map_keys(callable $callback, array $array) {
return array_merge([], ...array_map(
function ($key, $value) use ($callback) { return [$callback($key) => $value]; },
array_keys($array),
$array
));
}
@vardius
vardius / displayNullColumns.sql
Last active Jan 31, 2018
Display all table/column names where value is a specific string
View displayNullColumns.sql
DELIMITER $$
DROP PROCEDURE IF EXISTS `displayNullColumns`$$
CREATE PROCEDURE `displayNullColumns`()
BEGIN
SET @expression = (
SELECT GROUP_CONCAT(CONCAT('SELECT ', s._column, ' AS _value, \'', s._column, '\' AS _column, \'', s._table, '\' AS _table FROM ', s._table, ' WHERE ', s._column, ' = \'null\'')
SEPARATOR ' UNION ')
FROM (
SELECT DISTINCT
COLUMN_NAME AS `_column`,
@vardius
vardius / checkmark.js
Last active Feb 19, 2016
ES6 Angular OO Aproach
View checkmark.js
/**
* (c) Rafał Lorenz <vardius@gmail.com>
*
* For the full copyright and license information, please view the LICENSE
* file that was distributed with this source code.
*/
'use strict';
//Location in the `filters` directory
//This way `Loader class will find it.
You can’t perform that action at this time.