Jonathon Pemberton jonpemby

## random_string_from_list.sql
select (array['hello', 'world'])[trunc(1 + random() * @len)];

## date_to_input_value.js
document.querySelector('.datepicker').value = (new Date()).toISOString().substr(0, 10);

## scandir.lua
-- Lua implementation of PHP scandir function
-- special thanks to:
-- rhoster (https://stackoverflow.com/users/974053/rhoster)
-- ulmangt (https://stackoverflow.com/users/1212363/ulmangt)
function scandir(directory)
    local i, t, popen = 0, {}, io.popen
    local pfile = popen('ls -a "'..directory..'"')
    for filename in pfile:lines() do
        i = i + 1
        t[i] = filename

## random_string_from_list.sql
select elt(floor(1 + (rand() * @len)), "hello", "world", "this", "is", "a", "random", "list");

## get_required.sql
select * from information_schema.COLUMNS
 where TABLE_SCHEMA = 'schema'
   and TABLE_NAME = 'table'               -- optionally specify the table
   and IS_NULLABLE = 'NO'                 -- optionally set to 'YES' to find nullable columns
   and COLUMN_DEFAULT is null;            -- optionally specify columns without a default

## allEmpty.js
export default (...fields) => [...fields].reduce((sum, { length }) => sum + length, 0) === 0;

## 1-add-macros.php
<?php

namespace App\Providers;

use Illuminate\Http\Request;
use Illuminate\Routing\Route;
use Illuminate\Support\ServiceProvider;
use App\Http\Middleware\CaptureRequestExtension;

class AppServiceProvider extends ServiceProvider

## bash_exit_last_code.sh
#!/usr/bin/env bash

#
# ... commands ...
#

exit $?

## MySQL_InnoDB_Engine_Status.sql
SHOW ENGINE INNODB STATUS;

## collection-peekMap.php
Collection::macro('peekMap', function (callable $callback) {
    $lastValue = null;

    return $this->map(function ($value, $key) use ($callback, $lastValue) {
        $newValue = $callback($value, $key, $lastValue);
        $lastValue = $newValue;

        return $newValue;
    });
});
	-- Lua implementation of PHP scandir function
	-- special thanks to:
	-- rhoster (https://stackoverflow.com/users/974053/rhoster)
	-- ulmangt (https://stackoverflow.com/users/1212363/ulmangt)
	function scandir(directory)
	local i, t, popen = 0, {}, io.popen
	local pfile = popen('ls -a "'..directory..'"')
	for filename in pfile:lines() do
	i = i + 1
	t[i] = filename
	select * from information_schema.COLUMNS
	where TABLE_SCHEMA = 'schema'
	and TABLE_NAME = 'table' -- optionally specify the table
	and IS_NULLABLE = 'NO' -- optionally set to 'YES' to find nullable columns
	and COLUMN_DEFAULT is null; -- optionally specify columns without a default
	<?php

	namespace App\Providers;

	use Illuminate\Http\Request;
	use Illuminate\Routing\Route;
	use Illuminate\Support\ServiceProvider;
	use App\Http\Middleware\CaptureRequestExtension;

	class AppServiceProvider extends ServiceProvider
	Collection::macro('peekMap', function (callable $callback) {
	$lastValue = null;

	return $this->map(function ($value, $key) use ($callback, $lastValue) {
	$newValue = $callback($value, $key, $lastValue);
	$lastValue = $newValue;

	return $newValue;
	});
	});