Skip to content

Instantly share code, notes, and snippets.

from django.contrib import admin
# Register your models here.
from forum.models import Topic
admin.site.register(Topic)
from django.contrib.auth.models import User
from django.db import models
class Topic(models.Model):
title = models.CharField(max_length=30)
created_by = models.ForeignKey(User, on_delete=models.CASCADE)
created_at = models.DateTimeField(auto_now_add=True)
asgiref==3.5.0
attrs==21.4.0
Django==4.0.3
django-debug-toolbar==3.2.4
django-extensions==3.1.5
factory-boy==3.2.1
Faker==13.3.2
iniconfig==1.1.1
packaging==21.3
pluggy==1.0.0
import datetime
import factory.django
import pytest
from freezegun import freeze_time
from django.contrib.auth.models import User
from forum.models import Topic
@markng
markng / gist:4026171
Created November 6, 2012 17:25
wordpress db router
class WordpressRouter(object):
""" Database router - for the moment, everything to default except the wordpress app, which has its own setting """
def db_for_read(self, model, **hints):
if model._meta.app_label == 'wordpress':
return 'wordpress'
return None
def db_for_write(self, model, **hints):
if model._meta.app_label == 'wordpress':
@markng
markng / azsosxmlparse.py
Created April 17, 2012 17:43 — forked from anonymous/azsosxmlparse
election results
import requests
import lxml
from lxml import etree
from decimal import *
from jinja2 import Template
import codecs
r = requests.get('http://www.azsos.gov/ftp/dbelec/detail.xml')
xml_source = r.text
root = etree.fromstring(xml_source)
@markng
markng / part1.py
Created February 25, 2012 04:34
Web Scraping NICAR Python class
import requests
import csv
from pyquery import PyQuery as pq
f = open('strike_all_bills.csv', 'w')
wr = csv.DictWriter(f, ['billno'])
req = requests.get('http://www.azleg.gov/StrikeEverything.asp')
html = pq(req.text)
rows = html('tr.TableHeaderBackground').siblings()
@markng
markng / gist:1849167
Created February 17, 2012 00:28
duct tape to render and upload all tilemill projects automatically
for file in `ls`:; do rm /Users/mng/Documents/MapBox/export/$file.mbtiles; tilemill export $file /Users/mng/Documents/MapBox/export/$file.mbtiles --format=mbtiles --files=/Users/mng/Documents/MapBox; tilemill export $file /Users/mng/Documents/MapBox/export/$file.mbtiles --format=upload --files=/Users/mng/Documents/MapBox; done
@markng
markng / gist:1838431
Created February 15, 2012 19:46
Create TM Projects automatically
import os
from django.conf import settings
from django.core.management.base import NoArgsCommand
from django.template.loader import render_to_string
from prey.models import State
class Command(NoArgsCommand):
"""command for creating templated tilemill projects"""
def handle_noargs(self, *args, **kwargs):
@markng
markng / gist:1148062
Created August 15, 2011 22:40
aside scroller.js
jQuery(document).ready(function() {
var triggers_in_viewport = [];
checkTriggers();
$(window).scroll(function(event) {
checkTriggers();
});
$('aside h3 a').click(function(event) {
showAside($(this).attr('href'));
});