<\/span><\/h2>\nLet's play a little with this new script. First let's create a proper development environment with pipenv:<\/p>\n
~\/github\n$ mkdir django-sample\n~\/github\n$ cd django-sample\n~\/github\/django-sample\n$ pipenv --three\nCreating a virtualenv for this project\u2026\nUsing ~\/.pyenv\/versions\/3.6.8\/bin\/python3 (3.6.8) to create virtualenv\u2026\n?Running virtualenv with interpreter ~\/.pyenv\/versions\/3.6.8\/bin\/python3\nAlready using interpreter ~\/.pyenv\/versions\/3.6.8\/bin\/python3\nUsing base prefix '~\/.pyenv\/versions\/3.6.8'\nNew python executable in ~\/.local\/share\/virtualenvs\/django-sample-2uB5phZ-\/bin\/python3\nAlso creating executable in ~\/.local\/share\/virtualenvs\/django-sample-2uB5phZ-\/bin\/python\nInstalling setuptools, pip, wheel...\ndone.\n\nVirtualenv location: ~\/.local\/share\/virtualenvs\/django-sample-2uB5phZ-\nCreating a Pipfile for this project\u2026\n~\/github\/django-sample\n$ pipenv shell\nSpawning environment shell (\/usr\/bin\/zsh). Use 'exit' to leave.\nOK\n. ~\/.local\/share\/virtualenvs\/django-sample-2uB5phZ-\/bin\/activate\n. ~\/.local\/share\/virtualenvs\/django-sample-2uB5phZ-\/bin\/activate\n~\/github\/django-sample\n$ \n<\/pre>\nNow let's install the django module and the dj-database-url library:<\/p>\n
~\/github\/django-sample\n$ pipenv install django dj-database-url django_heroku\nInstalling django\u2026\n-----8<----------8<----------8<----------8<----------8<-----\n----->8---------->8---------->8---------->8---------->8-----\nInstalling collected packages: sqlparse, pytz, asgiref, django\nSuccessfully installed asgiref-3.2.7 django-3.0.5 pytz-2019.3 sqlparse-0.3.1\n\nInstalling django_heroku\u2026\nLooking in indexes: https:\/\/pypi.python.org\/simple\nCollecting django_heroku\n Downloading django_heroku-0.3.1-py2.py3-none-any.whl (6.2 kB)\n-----8<----------8<----------8<----------8<----------8<-----\n----->8---------->8---------->8---------->8---------->8-----\nInstalling collected packages: psycopg2, whitenoise, django-heroku\nSuccessfully installed django-heroku-0.3.1 psycopg2-2.8.5 whitenoise-5.0.1\n\nAdding django to Pipfile's [packages]\u2026\nInstalling dj-database-url\u2026\n-----8<----------8<----------8<----------8<----------8<-----\n----->8---------->8---------->8---------->8---------->8----- (5.5 kB)\nInstalling collected packages: dj-database-url\nSuccessfully installed dj-database-url-0.5.0\n\nAdding dj-database-url to Pipfile's [packages]\u2026\nPipfile.lock not found, creating\u2026\nLocking [dev-packages] dependencies\u2026\nLocking [packages] dependencies\u2026\nUpdated Pipfile.lock (9a4335)!\nInstalling dependencies from Pipfile.lock (9a4335)\u2026\n #### ######################################## 5\/5 \u2014 00:00:00\n~\/github\/django-sample\n$ \n<\/pre>\nNow let's create the django project and it's application<\/p>\n
~\/github\/django-sample\n$ ls \nPipfile Pipfile.lock\n~\/github\/django-sample\n$ django-admin startproject myproject\n~\/github\/django-sample\n$ ls\nmyproject Pipfile Pipfile.lock\n~\/github\/django-sample\n$ mv myproject myproject-delme \n~\/github\/django-sample\n$ mv myproject-delme\/* .\n~\/github\/django-sample\n$ rm -fr myproject-delme \n~\/github\/django-sample\n$ ls\nmanage.py myproject Pipfile Pipfile.lock\n~\/github\/django-sample\n$ python manage.py startapp myapp\n~\/github\/django-sample\n$ ls\nmanage.py myapp myproject Pipfile Pipfile.lock\n~\/github\/django-sample\n$ \n<\/pre>\nI know it looks confusing so let me try to explain. After installing the django module and the dj-database-url library I created a new project using django-admin startproject myproject. This will create a new directory named myproject with all the configuration files. I like to move these files to the current working directory to avoid confusions then using python manage.py startapp myapp to create the application. You can see that the command creates another directory named myapp that contains all the files needed for the application. It is important to have the project and application directory at the same level than the manage.py file or it won't work.<\/p>\n
This is the final tree directory:<\/p>\n
~\/github\/django-sample\n$ tree\n.\n|-- manage.py\n|-- myapp\n| |-- admin.py\n| |-- apps.py\n| |-- __init__.py\n| |-- migrations\n| | `-- __init__.py\n| |-- models.py\n| |-- tests.py\n| `-- views.py\n|-- myproject\n| |-- asgi.py\n| |-- __init__.py\n| |-- settings.py\n| |-- urls.py\n| `-- wsgi.py\n|-- Pipfile\n`-- Pipfile.lock\n\n\n3 directories, 15 files\n~\/github\/django-sample\n$ \n<\/pre>\nNow let's create the postgres database:<\/p>\n
~\/github\/django-sample\n$ sudo bash docker-secure-postgres.sh\nDeleting existing postgres-securesrv container.\nGenerating a RSA private key\n..........................................................................+++++\n...............................................................+++++\nwriting new private key to 'privkey.pem'\n-----\nwriting RSA key\n37f96111773e465bb9d02b52098101c72cff3cc3c1fa92e0f01cc3afa1451cbe\nWaiting for the container to initialize.\nlocalhost:5432 - rejecting connections\nlocalhost:5432 - accepting connections\nCreating sample database.\nCREATE DATABASE?p=755#how-everything-comes-together\nCREATE ROLE\nALTER ROLE\nALTER ROLE\nALTER ROLE\nGRANT\nSample database created successfully\nSave both strings below in your .env file and restart the pipenv environment.\n\nDATABASE_URL=\"postgres:\/\/appusr:+x6odg_mrmvt+ktnd35_9-795@localhost:5432\/appdb\"\nPGPASSWORD=\"1%isf7s9u7xqqplzqwk)wt9z0\"\n~\/github\/django-sample\n$ \n<\/pre>\nSave the DATABASE_URL and the PGPASSWORD variables, we will use them later.<\/p>\n
Finally we will configure the environment for Django to work as expected. Follow these steps:<\/p>\n
\n- At the top of the file myproject\/settings.py file add the following: <\/li>\n<\/ol>\n
import os <--- After this library\nimport dj_database_url\nimport django_heroku\n\n###################################\n## Code and other configurations ##\n###################################\n\n## At the very bottom of the file\nSTATIC_URL = '\/static\/' <--- After this value\n\ndjango_heroku.settings(locals())\n<\/pre>\n\n- In the same file look for the variable SECRET_KEY, save it somewhere else and delete it from the file<\/li>\n
- In the same file also look for the DATABASE variable and change it like this:<\/li>\n<\/ol>\n
# Database\n# https:\/\/docs.djangoproject.com\/en\/3.0\/ref\/settings\/#databases\n\n#DATABASES = {\n# 'default': {\n# 'ENGINE': 'django.db.backends.sqlite3',\n# 'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),\n# }\n#}\n\nDATABASES = {\n 'default': dj_database_url.config()\n}\n<\/pre>\n\n- Add the variables DATABASE_URL, PGPASSWORD and SECRET_KEY to the file .env (if it does not exist create it), it should look like this:<\/li>\n<\/ol>\n
~\/github\/django-sample\n$ cat .env \nDATABASE_URL=\"postgres:\/\/appusr:+x6odg_mrmvt+ktnd35_9-795@localhost:5432\/appdb\"\nPGPASSWORD=\"1%isf7s9u7xqqplzqwk)wt9z0\"\nSECRET_KEY=\"cj4k*%2y%7nz&)3chs*%+ti&o40l)l)jm*^4zk)pkp7tt)cqfn\"\n\n~\/github\/django-sample\n$ \n<\/pre>\nNow restart the python environment. This is important or the environmental variables won't be taken into account. Do it like this:<\/p>\n
~\/github\/django-sample\n$ exit\n~\/github\/django-sample\n$ pipenv shell\nLoading .env environment variables\u2026\nSpawning environment shell (\/usr\/bin\/zsh). Use 'exit' to leave.\nOK\n. ~\/.local\/share\/virtualenvs\/django-sample-2uB5phZ-\/bin\/activate\n. ~\/.local\/share\/virtualenvs\/django-sample-2uB5phZ-\/bin\/activate\n~\/github\/django-sample\n$ env | egrep '(PASS|KEY|URL)'\nDATABASE_URL=postgres:\/\/appusr:+x6odg_mrmvt+ktnd35_9-795@localhost:5432\/appdb\nPGPASSWORD=1%isf7s9u7xqqplzqwk)wt9z0\nSECRET_KEY=7f4d%*zn1f5muug2(eu118++-cm)98gy\n~\/github\/django-sample\n$ \n<\/pre>\nPerfect! At this point you should be able to start your project and initialize your database.<\/p>\n
~\/github\/django-sample\n$ python manage.py migrate \nOperations to perform:\n Apply all migrations: admin, auth, contenttypes, sessions\nRunning migrations:\n Applying contenttypes.0001_initial... OK\n Applying auth.0001_initial... OK\n Applying admin.0001_initial... OK\n Applying admin.0002_logentry_remove_auto_add... OK\n Applying admin.0003_logentry_add_action_flag_choices... OK\n Applying contenttypes.0002_remove_content_type_name... OK\n Applying auth.0002_alter_permission_name_max_length... OK\n Applying auth.0003_alter_user_email_max_length... OK\n Applying auth.0004_alter_user_username_opts... OK\n Applying auth.0005_alter_user_last_login_null... OK\n Applying auth.0006_require_contenttypes_0002... OK\n Applying auth.0007_alter_validators_add_error_messages... OK\n Applying auth.0008_alter_user_username_max_length... OK\n Applying auth.0009_alter_user_last_name_max_length... OK\n Applying auth.0010_alter_group_name_max_length... OK\n Applying auth.0011_update_proxy_permissions... OK\n Applying sessions.0001_initial... OK\n~\/github\/django-sample\n$ python manage.py createsuperuser \nUsername (leave blank to use 'apuente'): apuente\nEmail address: nospam@noserver.com\nPassword: \nPassword (again): \nSuperuser created successfully.\n~\/github\/django-sample\n$ psql $(echo ${DATABASE_URL}) -c \"select id,is_superuser,username,email from auth_user\" \n id | is_superuser | username | email \n----+--------------+----------+-------------------------\n 1 | t | apuente | nospam@noserver.com\n(1 row)\n~\/github\/django-sample\n$ python manage.py runserver\nWatching for file changes with StatReloader\nPerforming system checks...\n\nSystem check identified no issues (0 silenced).\nApril 20, 2020 - 23:24:35\nDjango version 3.0.5, using settings 'myproject.settings'\nStarting development server at http:\/\/127.0.0.1:8000\/\nQuit the server with CONTROL-C.\n<\/pre>\nNow point your browser to http:\/\/127.0.0.1:8000\/admin<\/a>. Profit!<\/p>\n\n<\/div>","protected":false},"excerpt":{"rendered":"
In this post I will explain how to provide a secure postgres server docker container. This is useful when developing certain applications, for example a Django application. You can only run a this script and it will automatically detect if … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,95,94,84,96,4],"tags":[],"class_list":["post-764","post","type-post","status-publish","format-standard","hentry","category-code","category-databases","category-devops","category-docker","category-postgres","category-security"],"_links":{"self":[{"href":"https:\/\/hackarandas.com\/blog\/wp-json\/wp\/v2\/posts\/764","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hackarandas.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hackarandas.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hackarandas.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hackarandas.com\/blog\/wp-json\/wp\/v2\/comments?post=764"}],"version-history":[{"count":20,"href":"https:\/\/hackarandas.com\/blog\/wp-json\/wp\/v2\/posts\/764\/revisions"}],"predecessor-version":[{"id":795,"href":"https:\/\/hackarandas.com\/blog\/wp-json\/wp\/v2\/posts\/764\/revisions\/795"}],"wp:attachment":[{"href":"https:\/\/hackarandas.com\/blog\/wp-json\/wp\/v2\/media?parent=764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hackarandas.com\/blog\/wp-json\/wp\/v2\/categories?post=764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hackarandas.com\/blog\/wp-json\/wp\/v2\/tags?post=764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/hackarandas.com\/blog\/wp-content\/uploads\/2020\/04\/postgres-mac-icon-150x150.jpg\"){kind=icon}