Python archive – Nicolas Kuttler

Emoji command line helper 👾

2020-10-20

I recently played a bit with emojis, the result is this script which lets me search existing emojis and transform strings. It's a trivial Python script that leverages https://github.com/carpedm20/emoji more

Django tarpit for malicious requests

2020-08-10

While checking my logs for this site and seeing the usual malicious requests against every spammers favorite software WordPress I decided to make things a little harder for them with a tarpit. more

Generate authenticator app provisioning URI

2020-07-06

A while ago I published a snippet to generate an OTP auth token from the command line, but I recently got a new phone and had to re-add all my secret keys to a different authenticator app. As I keep all the secret keys backed up I made another script … more

Wagtail query for scheduled pages

2020-05-21

Wagtail has "scheduled" pages that are not yet visible on the site. I think the interface is not ideal as you need to click the Publish button after setting a publication date on the Settings tab. I'm not sure how exactly the data models work, but the actual publication is … more

Create google auth OTP from command line

2020-05-01

I recently added OTP authentication using pam_google_authenticator.so to most of my machines. It's non-trivial to set up, especially if you have system users with limited capabilities that need to be able to log in non-interactively, but all in all it feels good to have a little more security. When logging … more

Run Django tests in the main database

2019-07-27

Recently I started working on a Django project, loaded the prod database into it, and ran the tests. Then the data was gone. I know some people intentionally want to run tests on the "main database", and there is a very simple way to achieve this. Simply inherit from a … more

Stand-alone quodlibet script

2017-05-20

I love quodlibet and have a big collection of music in it. Some time ago I wanted to transcode some big lossless files into the more mobile-friendly ogg format and wanted to query quodlibet for the songs. This is an example of a script that can access the quodlibet database … more

Signed HTTPS URL to AWS S3 using boto

2017-04-10

I needed protected downloads for a project using AWS S3 on a HTTPS Django site. There are various ways to solve this problem, but I thought the most obvious was to offload access control to S3. Boto can generate signed download links that are only valid for a limited time. … more

Django, custom SMTP server for logging only

2016-12-09

One of my client uses google apps, so I use that account to send out mails with Django, which works just fine. However, google silently drops all error mails to the admins, for whatever reason you can't debug and will never hear anything about anyway. As those mails only go … more

Migrating Django projects with fixtures

2014-05-07

When migrating a Django project it's often useful to work with the built-in dumpdata and loaddata management commands. However, this can easily lead to errors like django.db.utils.IntegrityError: Problem installing fixture Could not load foo.Bar(pk=ba): (1062, "Duplicate entry for key 'app_label'"). Such errors indictate that a similar object already exists in … more