Skip to content

Instantly share code, notes, and snippets.

View ncole458's full-sized avatar

Nicholas Cole ncole458

5 followers · 6 following
View GitHub Profile
@ncole458
ncole458 / django
Created April 20, 2016 05:28
CORS for Django /media (FireFox fix)
# Your Django project's media files - amend as required
location /media {
if ($request_filename ~* ^.*?/([^/]*?)$) {
set $filename $1;
}
if ($filename ~* ^.*?\.(eot)|(ttf)|(woff)$){
add_header Access-Control-Allow-Origin *;
}
alias /django/django_project/media;
@ncole458
ncole458 / django_queryset_group.py
Last active February 8, 2017 03:50
Django Group Multiple Querysets
from itertools import chain
from operator import attrgetter
group1_queryset = group1.objects.all() or filter()
group2_queryset = group2.objects.all() or filter()
result = sorted(
    chain(group1_queryset, group2_queryset),
    key=attrgetter('created'))
    
@ncole458
ncole458 / httpd-app.conf
Created July 13, 2017 05:12
Apache Perms for DRF
# need to add the below or DRF will throw auth errors
WSGIPassAuthorization On
@ncole458
ncole458 / nginx.conf
Last active September 16, 2017 08:04
Enable gzip compression & add expires headers in nginx
# /etc/nginx/nginx.conf
##
# `gzip` Settings
#
#
gzip on;
gzip_disable "msie6";
gzip_vary on;
@ncole458
ncole458 / websockets.html
Created September 28, 2017 05:38
WebSockets Testing
<!DOCTYPE html>
<html lang="en" dir="ltr" class="no-js">
<head>
<title>WebSockets</title>
<script language="javascript" type="text/javascript">
var wsUri = "wss://url.com.au/websockets/";
var output;
@ncole458
ncole458 / django
Last active October 2, 2017 02:48
Full Django>Gunicorn>NGINX Config w/WebSockets
upstream app_server {
server 127.0.0.1:9000 fail_timeout=0;
}
upstream websocket {
server 127.0.0.1:8001 fail_timeout=0;
}
#server {
# listen 80;
@ncole458
ncole458 / gunicorn.conf
Last active October 2, 2017 02:50
Gunicorn for Django/nginx
# gunicorn.conf
description "Gunicorn app server for Django Project"
start on runlevel [2345]
stop on runlevel [!2345]
respawn
setuid username
setgid www-data
@ncole458
ncole458 / urls.py
Created October 17, 2017 03:17
Easy Django static file route for SSL validation etc.
# place file in static root
from django.views.generic.base import RedirectView
from django.contrib.staticfiles.storage import staticfiles_storage
urlpatterns = [
url(r'C798C4F2FDD57D2D63BF76874C080F49.txt', RedirectView.as_view(
url=staticfiles_storage.url('C798C4F2FDD57D2D63BF76874C080F49.txt'),
permanent=True),
@ncole458
ncole458 / default
Created December 11, 2017 03:36
How to get an A rating on Qualys ssllabs.com SSL Report
# full nginx conf for Django w/web-sockets
upstream app_server {
server 127.0.0.1:9000 fail_timeout=0;
}
upstream websocket {
server 127.0.0.1:8002 fail_timeout=0;
}
@ncole458
ncole458 / Postgres Cheatsheet
Last active December 14, 2017 04:29
CLI commands I seem to use sometimes & forget sometimes...
# connect to db
sudo -u postgres psql postgres
# export table as CSV
COPY table_name TO '/tmp/users_export.csv' DELIMITER ',' CSV HEADER;
# create db
CREATE DATABASE <name>;
# create role