Update elasticbeanstalk eb db url with utf8mb4 encoding and utf8mb4_unicode_ci collation - requires manual string edit!

db_url_update_script.sh

#!/bin/bash
set +e
eb use $1
echo $1

eb printenv | grep DATABASE_URL
URL=`eb printenv | grep DATABASE_URL | sed -e 's/^[ \t]*//'`


echo "Using the above URL"
echo " you need to add '?encoding=utf8mb4&collation=utf8mb4_unicode_ci' to the end and format the params properly if others are already there"
echo " Then run eb setenv \"DATABASE_URL=<the-new-url>\""
echo
echo
echo "Template:"
echo "eb setenv \"${URL}    +   ?encoding=utf8mb4&collation=utf8mb4_unicode_ci\""