Skip to content

Instantly share code, notes, and snippets.

foo
-rw-r--r-- 1 mkt_prod mkt_prod 463K Oct 15 03:10 85852c342591491b9debf7a6987ea057
-rw-r--r-- 1 mkt_prod mkt_prod 358K Oct 15 03:10 2767b2c58b4541e59157558d0427692b
-rw-r--r-- 1 mkt_prod mkt_prod 148K Oct 15 03:10 85a9b40c70964c16b11f6c7d3510671d
-rw-r--r-- 1 mkt_prod mkt_prod 158K Oct 15 03:13 73aa71f69c5548e1b4c94c5913db8f7c
-rw-r--r-- 1 mkt_prod mkt_prod 38K Oct 15 03:14 a0a07ec3d2f34ef19d7d274df3701f66
-rw-r--r-- 1 mkt_prod mkt_prod 27K Oct 15 06:45 db1309f5911b475980ef9654fefc6f55
-rw-r--r-- 1 mkt_prod mkt_prod 13K Oct 15 06:46 96dbb569864b454c99107977ff38914f
-rw-r--r-- 1 mkt_prod mkt_prod 27K Oct 15 06:46 fbfcb36402dd4197bc44ca624ec1b667
-rw-r--r-- 1 mkt_prod mkt_prod 14K Oct 15 06:46 092bf4e464e44f03888258c9892ab24b
-rw-r--r-- 1 mkt_prod mkt_prod 26K Oct 15 06:46 1e3c018b1daf4a32a301d909552b5262
[root@mktadm1 olympia]# sudo -u mkt_prod DJANGO_SETTINGS_MODULE=settings_local ../venv/bin/python manage.py update_counts_from_file --date 2015-01-12
Traceback (most recent call last):
File "manage.py", line 93, in <module>
execute_from_command_line(sys.argv)
File "/data/mkt.prod/www/addons.mozilla.org/deploy-olympia-prod-20150115220703-b9225b3424/venv/lib/python2.6/site-packages/django/core/management/__init__.py", line 399, in execute_from_command_line
utility.execute()
File "/data/mkt.prod/www/addons.mozilla.org/deploy-olympia-prod-20150115220703-b9225b3424/venv/lib/python2.6/site-packages/django/core/management/__init__.py", line 392, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/data/mkt.prod/www/addons.mozilla.org/deploy-olympia-prod-20150115220703-b9225b3424/venv/lib/python2.6/site-packages/django/core/management/base.py", line 242, in run_from_argv
self.execute(*args, **options.__dict__)
Host *.mozilla.com
User jthomas
ForwardAgent yes
ServerAliveInterval 10
CERTIFICATE_RE = re.compile(r"-----BEGIN CERTIFICATE-----.+?"
"-----END CERTIFICATE-----", re.S)
paragraph = \
'''
<p>
This is a paragraph.
It has multiple lines.
</p>
<p>
DROP TABLE IF EXISTS auth_user_groups;
DROP TABLE IF EXISTS auth_user_user_permissions;
DROP TABLE IF EXISTS django_admin_log;
DROP TABLE IF EXISTS auth_user;
DROP TABLE IF EXISTS addons_categories;
DROP TABLE IF EXISTS categories;
ALTER TABLE files DROP COLUMN is_packaged;
ALTER TABLE addon_payment_account DROP COLUMN set_price;
@jasonthomas
jasonthomas / -
Last active August 29, 2015 14:25 — forked from anonymous/-
#!/bin/bash
#
# Poor mans Consul bootstrap helper. Originally we created a configuration snippit in
# /etc/consul.d with a retry_join host of an ELB endpoint. Murphy's law means that
# on occasion the ELB will have Consul connecting to itself.
#
# The AWS API is queried for a list of ELBs that we're behind, and then we get the
# IPs of all other ELB backends and attempt to join them.
# Print messages
[jthomas@mktadm1 current]$ ./venv/bin/python ./venv/bin/pip freeze
Babel==0.9.6
Cython==0.21.1
Django==1.7.1
Jinja2==2.7.2
M2Crypto==0.22.3
MarkupSafe==0.18
MySQL-python==1.2.5
Pillow==2.7.0
Pygments==1.5
u'os' is a required property Failed validating u'required' in schema: {u'additionalProperties': False, u'default': {u'devices': [], u'driverVersion': u'', u'driverVersionComparator': u'', u'driverVersionMax': u'', u'feature': u'', u'featureStatus': u'', u'hardware': u'', u'os': u'', u'vendor': u''}, u'definitions': {u'maxVersion': {u'description': u'The maximum version.', u'title': u'Max version', u'type': u'string'}, u'minVersion': {u'description': u'The mininum version.', u'title': u'Min version', u'type': u'string'}}, u'description': u'A graphic driver blocklist entry.', u'properties': {u'blockID': {u'description': u'Original block id, eg. g28', u'pattern': u'^g[0-9]+$', u'title': u'Internal blocklist id', u'type': u'string'}, u'details': {u'properties': {u'bug': {u'type': u'string'}, u'created': {u'format': u'date-time', u'type': u'string'}, u'name': {u'type': u'string'}, u'who': {u'type': u'string'}, u'why': {u'type': u'string'}}, u'title': u'Details', u'type': u'object'}, u'devices': {u'description': u'
@jasonthomas
jasonthomas / bulkaddcerts.py
Created January 3, 2017 18:32 — forked from eviljeff/bulkaddcerts.py
snippet to be run in django-admin shell `./manage.py shell` to bulk add certs from 'certs.txt' file in format [issuer: xx serial: yy].
from olympia.blocklist.models import BlocklistDetail, BlocklistIssuerCert
def addCert(issuer, serial, name, bug):
detail = BlocklistDetail(name=name, why='.', who='.', bug=bug)
detail.save()
cert = BlocklistIssuerCert(issuer=issuer, serial=serial, details=detail)
cert.save()