Instructions to connect MySQL

[jatinkatyal13]

We need to provide instructions in our README to connect our application to MySQL backend using the environment variables.

[isaac-philip]

Please provide more information.
Could not find any mysql reference, only sqlite in settings.py

[jatinkatyal13]

In the below code snippet if we are in the development environment we by default use sqlite but we should take this as an input from the environment and hence such changes are needed to be made!

if DEBUG:
    DATABASES = {
        'default': {
            'ENGINE': 'django.db.backends.sqlite3',
            'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
        }
    }
else:
    DATABASES = dj_database_url.config(default=config('DATABASE_URL'))

Library that can be really helpful will be DJ Database Url

[isaac-philip]

So when you say environment,
you wish to parse an Environment Variable DATABASE_URL which would contain the database connection string and the information from that utilizing the dj_database_url library.

Think that makes sense to me, just confirming with you on that above

[jatinkatyal13]

Precisely 🚀

[isaac-philip]

Hello, tried to setup environment locally by following steps in README.md
Failing at
makemigrations

with error that the specific configs are not placed like SECRET_KEY

Please let me know some dummy configs etc and any more information how to setup environment.
Any docker container for the same etc?
Just saying it could really speed up development taking care of various dependencies.

I believe I would need an sqllite db for the application to start and a mysql db for this specific issue.

Thanks for your patience.

[jatinkatyal13]

@isaac-philip Checkout the example .env.sample file! Setting up the environment section of README explains that!
Hope this helps

[isaac-philip]

Thanks I did had a look but couldn't complete, will try in couple of days!

[isaac-philip]

Hello, any updates or modifications needed ?

[isaac-philip]

hello, just asking if not yet merged any modifications needed? Please advise for any direction needed.