Incorrect parsing of DATABASES_URL for Google Cloud MySQL

[danielrsilveira]

I was trying to connect a Django instance to Google Cloud MySQL using django-environ in a codelab, and found an error in the parsing of DATABASES_URL for google cloud.

The url set in .env was:
DATABASE_URL="mysql://djuser:hidden-password@//cloudsql/arvore-codelab:us-central1:mysqlinstance/mydatabase"

Fix in settings.py

# Set this value from django-environ
DATABASES = {"default": env.db()}

print(DATABASES)

if "/" in DATABASES["default"]["NAME"]:
    DATABASES["default"]["HOST"], DATABASES["default"]["NAME"] = DATABASES["default"]["NAME"].rsplit('/', 1)

print(DATABASES)

Log during building in Google Cloud Build:

Step #2: ---------- EXECUTE COMMAND ----------
Step #2: python manage.py migrate
Step #2: {'default': {'NAME': '/cloudsql/arvore-codelab:us-central1:mysqlinstance/mydatabase', 'USER': 'djuser', 'PASSWORD': 'hidden-password', 'HOST': '', 'PORT': '', 'ENGINE': 'django.db.backends.mysql'}}
Step #2: {'default': {'NAME': 'mydatabase', 'USER': 'djuser', 'PASSWORD': 'hidden-password', 'HOST': '/cloudsql/arvore-codelab:us-central1:mysqlinstance', 'PORT': '', 'ENGINE': 'django.db.backends.mysql'}}
Step #2: Operations to perform:
Step #2:   Apply all migrations: admin, auth, contenttypes, myproject, sessions
Step #2: Running migrations:

This issue was discussed here googlecodelabs/feedback#964 (comment), with the help of google codelab team.

Hope this helps improving django-environ.

[iflare3g]

Hello everyone, since it's still opened, I decided to publish my first contribution to django-environ by fixing this issue.
I hope it'll ok 😄

[sergeyklay]

This is resolved in develop branch. Thank you for the report, and for helping us make django-environ better.