Skip to content

Instantly share code, notes, and snippets.

View exhuma's full-sized avatar
🐢
Slowly advancing on hobby projects

Michel Albert exhuma

🐢
Slowly advancing on hobby projects
View GitHub Profile
@exhuma
exhuma / README.rst
Created October 26, 2017 13:15
Problem with infinity timestamps in SQLAlchemy?

Problem with infinity timestamps in SQLAlchemy?

I've noticed missing entries in table relationships which are joined using timestamp columns using "infinity" timestamps.

The files below demonstrate this. The example is stipped down to the bare minimum while still reproducing the issue.

Looking at the table data, when joining using name and ts we should get two rows (as seen in the select.sql file below).

But, when running this in Python we run into an issue: The infinity timestamp gets converted to a datetime instance using datetime(1, 1, 1, 0, 0).

@exhuma
exhuma / README.rst
Created October 15, 2017 12:41
Example service which returns a custom media-type with a +json indicator

This service is used as an example to demonstrate the Chromium issue described at https://bugs.chromium.org/p/chromium/issues/detail?id=773654

It does not use any external dependencies. To run this, simply follow theses steps:

go build server.go
./server

This will run a HTTP server on port 8080. To test the issue, open the page with Chromium, open the developer tools network tab and reload the page. Upon loading

@exhuma
exhuma / colorize.py
Created February 22, 2017 10:44
Colorful werkzeug logging
import logging
import re
P_REQUEST_LOG = re.compile(r'^(.*?) - - \[(.*?)\] "(.*?)" (\d+) (\d+|-)$')
LOG = logging.getLogger('werkzeug')
def colorize_werkzeug():
@exhuma
exhuma / description.md
Created February 2, 2017 09:04
flask-exception-problem

I've tried upgrading from Flask 0.10.1 to 0.12 today and ran into a little issue:

I am maintaining a larger application which also provides a JSON API on top of a subset of it's functionalities via Flask. In order to make error handling consistent I defined a simple mixin class:

class RestExceptionMixin(object):
    """
    Mixin for exceptions which can be used in a REST API.
    """
    status_code = 400

Keybase proof

I hereby claim:

  • I am exhuma on github.
  • I am exhuma (https://keybase.io/exhuma) on keybase.
  • I have a public key whose fingerprint is 033C FABB FBCE 2387 C88D E243 8C72 CFB3 4D7E BB44

To claim this, I am signing this object:

@exhuma
exhuma / timed_exec.py
Created September 26, 2016 06:01
Example of running functions at given time intervals.
from time import sleep
import logging
LOG = logging.getLogger(__name__)
def every_5_seconds():
LOG.info('Running every 5')
@exhuma
exhuma / README.md
Created February 26, 2016 07:04
Flask-Security not working with non-standard id attribute

When using a non-standard id attribute, flask-login does not seem to work. See also pallets-eco/flask-security#472

This gist contains two examples. One is working, the other one isn't. To test, run the app and go to http://localhost:5000

Login: admin@example.com Password: admin

When using working.py, you should see an 'OK' message.

When using broken.py the login will simply not work, and you'll be presented with a new login page.

@exhuma
exhuma / list.rst
Last active December 29, 2015 22:30
Total Biscuit GOTY

Total Biscuit - TOP 10 of the Year

10 - Mad Max

  • Open World
  • Car-Shooter

9 - Sunless Sea

#!/bin/bash
#
# Script to find lingering PostgreSQL data files.
#
# Those files can usually be safely removed from disk.
#
# Use at your own risk!
#
# Based on http://dba.stackexchange.com/a/121876/34652
@exhuma
exhuma / 3col.grid
Created November 7, 2015 09:21
GridMove setup for 3 Columns per screen
[Groups]
NumberOfGroups = 9
[1]
TriggerTop = [Monitor1Top]
TriggerRight = [Monitor1Left] + [Monitor1Width] / 3
TriggerBottom = [Monitor1Bottom]
TriggerLeft = [Monitor1Left]
[2]