@distantnative asked me (well, anyone) to optimize a SQL query which generates an overview of Retour events.
#Programming/SQL
with recursive dates as (
select "2019-10-01" as date
union all
function hexToHsl($hex) { | |
$hex = array($hex[0].$hex[1], $hex[2].$hex[3], $hex[4].$hex[5]); | |
$rgb = array_map(function($part) { | |
return hexdec($part) / 255; | |
}, $hex); | |
$max = max($rgb); | |
$min = min($rgb); | |
$l = ($max + $min) / 2; |
@distantnative asked me (well, anyone) to optimize a SQL query which generates an overview of Retour events.
#Programming/SQL
with recursive dates as (
select "2019-10-01" as date
union all
function release() { | |
composer_json="composer.json" | |
if [[ ! -f "$composer_json" ]]; then | |
echo "❌ ️Error: composer.json file not found." | |
return 1 | |
fi | |
echo "✅ ️Increment composer version" |
Warning Make sure you have the old and new blueprint available when running this command.
Otherwise this command will wipe the currently stored content.
Always make sure to test the command first and have a backup of your content!