Categories
DevOps django

Authenticated Functional Tests with Selenium and Django

In the Test Driven Development Book for Python and Django by Harry Percival called Obey The Testing Goat, there is a chapter about enhancing the functional test base class and adding pre-authentication so you don’t need to login via the login screen with Selenium. It uses a custom Email Authentication Backend, but I needed to […]

Categories
Database

How to get data from tables in mysql database into a postgres schema?

I’ve had to do a bit of learning and tinkering to figure out how to do this. I now understand why ETL tools and consultants for data migrations and translations are in demand. I’ll even allow use of proprietary GUI based ETL tools. Anyway the backstory is I created a django project initially for MySQL […]

Categories
Database DevOps django

Deploying a django app with dedicated web and db servers

One of the many architectural decisions that will start to impact you when you get to a level where you need to scale is splitting you db and app. Typically we start on a budget and have to share resources but ideally you want to start out separate. The reasons is that the db server […]

Categories
django Multi-tenancy

Functional Tests with Django Tenant Schemas and Selenium

On my journey of adding multi-tenancy to my app, I have used django-tenant-schemas and the testing utilities it provides to make my unit tests work with the tenants or main site. However the functional tests is another kettle of fish as there is not utility to use for them. Functional Tests From the django docs […]

Categories
postgres

Postgres and Django Case Sensitivity

Postgres queries are CaSeSensitivE unlike in MySQL. When a simple Model.objects.get(field=’hello’) would get the record. Using a postgres db you would need to use field__iexact=’hello’ Even unique doesn’t work with different cases with standard postgres. That is why django has the CIText Mixin and postgres has the citext extension. Could be a feature not a […]