I recently wanted to test logging in different users (that didn't exist in the database) and couldn't find a clear answer for how to do so--perhaps this is a sign I am traveling where I shall not! So be it, here is my solution:
import os import subprocess …
A situation arose where I was unable to use nc to send some metrics to a local Graphite server. Thanksfully, Python was installed (albeit, quite a dated version) that allowed me to set up a socket to send the data over the wire.
import commands import socket import …
Objective: Sort dictionary by nested dictionary value
Let's say we want to sort the following JSON by the nested dictionary value of count.
{ "Mail": { "count": 20, "users": ["lukeskywalker", "darthvader"] }, "Droid Sync": { "count": 5, "users": ["lukeskywalker"] } }
Method 1: lambda
…
By default, a ModelForm is populated with all its objects from the database. Sometimes it's desirable to limit these results as they are returned to the view. After setting up our ModelForm (forms.py) there is only one thing we need to do to make this happen. Within our view (views.py), …
Create unicode string "a".
>>> a = u'\u2019' >>> a u'\u2019'
Convert to ASCII string (ASCII is default for Python 2 str()).
>>> str(a) Traceback (most recent call last): File "<stdin>", line 1, in <module> UnicodeEncodeError: 'ascii' codec can't encode character u'\u2019' in position …
Here's the most straightforward and succinct way I've found to mock patch a function that returns different (but specific) results with each call, shamelessly copied from Python Docs:
>>> values = {'a': 1, 'b': 2, 'c': 3} >>> def side_effect(arg): ... return values[arg] ... >>> mock.side_effect = side_effect …
After updating mysql-connector-python to 8.0.11 (released April 19, 2018), I received an "OperationalError: 1043 (08S01): Bad handshake" error when querying a MySQL database. I found that I needed to set 'use_pure: True' in the connection string.
From the MySQL folks:
The C extension …
If you've ever touched a date or time related field via the Django API, you'll have noticed the big warning that the date and/or time is not localized. While the warning is nice there isn't much more in the way of how to localize the time. Here are two ways …
It's easy to forget to update packages after they've been installed as they silently live in the background working as intended. Here are two ways to check what needs updating:
pip list --outdated
Out of the box, pip provides a quick way to query which packages have …
Here's the generalized snippet:
any(dict.get('key') == search_value for dict in list)
A full example:
authors = [ {'author': 'Michael Crichton', title: 'Jurassic Park'}, {'author': 'C.S. Lewis', title: 'Til We Have Faces'} ] if any(book.get('author') == 'Michael Crichton' for book in books): print('Found Michael Crichton!')
…
Using the ManifestStaticFilesStorage storage backend alters the filename of our static files. For example, style.css becomes something like style.3d94ea84cd8a.css. When collectstatic is run and finds a file that has changed, the MD5 portion of the filename will be updated (style.3d94ea84cd8a.css -> style.1d74ea7349df.css). This prevents browsers and other caching technologies (e.g. …
Here's how I set up logging where:
import logging import os # Set up logging logger = logging.getLogger(__file__) handler_kwargs = { 'filename': os.path.join(base_dir, 'file.log'), 'when': 'midnight', 'backupCount': 10 } handler …
Python 2.7 is not provided on CentOS 6 because Yum depends on Python 2.6. Simply installing 2.7 over 2.6 will break Yum. Thankfully, Red Hat provides us with an alternate installation method through their SCL project.
First, get Python 2.7 installed:
https://www.softwarecollections.org/en/scls/rhscl/python27/
Next, add the project path …
Here's a custom manager for a class (Change) that gets all approved changes where "today's date" falls between the Change.start_date and Change.end_date.
# models.py import datetime ... # Custom Change Manager that only pulls active, approved changes class ApprovedChanges(models.Manager): def get_queryset(self): today = datetime.date.today() return super(ApprovedChanges, self).get_queryset().filter( approved=True, …
# Simple List ', '.join([author.name for author in authors]) # Django ', '.join([author.name for author in book.author_set.all()])
Both will output "Author Name, Author 2 Name, ..., Author x Name"
I just started my first Django project with Python 3 in earnest. One of the first things I have noticed is that reload isn't available by default from the Django shell. It needs to be imported:
>>> from importlib import reload >>> reload(<module>)
This became a pretty …
The following code allows us to monkey patch the json() method that is returned by requests.post().
import requests from mock import MagicMock @mock.patch.object(requests, 'post') def my_function(self, post): attrs = {'json.return_value': {'id': 1}} post.return_value = MagicMock(**attrs) r = requests.post() r.json()['id']
Source: https://docs.python.org/dev/library/unittest.mock.htmll#unittest.mock.NonCallableMock
from sqlalchemy.sql import text from sqlalchemy import create_engine import secrets engine = create_engine( 'mssql+pyodbc://{}:{}@MSSQL'.format( secrets.username, secrets.password ) ) conn = engine.connect() s = text("SELECT * FROM users WHERE name = :name") result = conn.execute(s, name=name).fetchall() print result
For further information on installing and configuring unixODBC (requirement for pyodbc) …
#!/usr/bin/python import sys try: hex_val = str(sys.argv[1]) except Exception as e: sys.exit('Please provide a hex code as an argument (e.g. hex2rgb 333333).') r = int(hex_val[0:2], 16) g = int(hex_val[2:4], 16) b = int(hex_val[4:6], 16) print('{}, {}, {}'.format(r, g, b))
Append your ~/.bash_aliases with:
alias hex2rgb="~/bin/hex2rgb.py"
…
import logging logging_config = { 'filename': '/var/log/app_log', 'format': '%(asctime)s [%(levelname)s] %(message)s', 'level': logging.INFO } logging.basicConfig(**logging_config) logging.info('Our logged message.')
This will output the following to /var/log/app_log:
2016-11-21 23:50:53,677 [INFO] Our logged message.
Source: https://docs.python.org/2/howto/logging.html#logging-basic-tutorial
The Old Way
import os os.system('find /home/user/documents -type f -iname "*.doc"')
The New, Recommended Way
import subprocess subprocess.check_call([ 'find', '/home/user/documents', '-type', 'f', '-iname', '*.doc' ])
Bonus Tidbit
At this point, we can incorporate some nice exception handling:
import subprocess try: subprocess.check_call([ …
import json polls = Poll.objects.all() # Convert our QuerySet into a list so polls can be serialized print json.dumps(list(p), indent=2) JsonResponse({'polls': list(polls)})
Source: http://stackoverflow.com/questions/7650448/django-serialize-queryset-values-into-json
import json import psycopg2 from psycopg2.extras import RealDictCursor cursor = conn.cursor(cursor_factory=RealDictCursor) objects = cursor.fetchall() print json.dumps(objects, indent=2) # Django #JsonResponse({'objects': objects})
Source: https://www.peterbe.com/plog/from-postgres-to-json-strings
#!/usr/bin/env python import os os.environ['DJANGO_SETTINGS_MODULE'] = 'mysite.settings' import django django.setup() from app.models import Class # Your scripting here.
Sources:
https://docs.djangoproject.com/en/1.10/intro/tutorial02/#playing-with-the-api
https://docs.djangoproject.com/en/1.10/topics/settings/#on-the-server-mod-wsgi
Set the end date with the current date and time and the start date 1 week prior:
import datetime start_date = datetime.datetime.now() - datetime.timedelta(days=7) end_date = datetime.datetime.now()
class AbstractClass(models.Model): common_attribute = models.CharField() class Meta: abstract = True class SpecializedClass(models.Model): specialized_attribute = models.CharField() class Meta: abstract = True class AnotherSpecializedClass(models.Model): another_specialized_attribute = models.CharField() class Meta: abstract = True class MultipleInheritance(AbstractClass, SpecializedClass): pass class TripleMulitpleInheritance(AbstractClass, SpecializedClass, AnotherSpecializedClass): pass
Sources: https://docs.djangoproject.com/en/1.9/topics/db/models/#abstract-base-classes,
https://docs.djangoproject.com/en/1.9/topics/db/models/#multiple-inheritance
Print all digits in a string as one integer:
>>> string = "a1b2c3" >>> integer = int(filter(str.isdigit, string)) >>> print integer 123 >>> type(integer) <type 'int'>
Or, if you would like a list of all digits:
>>> string = "a1b2c3" >>> import re >>> integer_list …