Django Form Label for Many-to-Many with Extra Fields

I'm working on a Django application at work that has several Many-to-Many relationships that have extra fields attached to them. Setting this up using the "through" parameter on the field definition is described in the Django documentation.

My trouble came in when it came time to render this information out to the user in a form so they could update the extra fields.  From the user's perspective the relationship can't be changed, but the extra fields could be.

Extending Django's example usage about band membership, if the user were viewing the information for "The Beatles" and including a formset for all band members the form would normally render something like this:

Group Name: The Beatles
    Group: The Beatles
    Person: Ringo Starr
    Date Joined: 14 August 1962
    Group: The Beatles
    Person: John Lennon
    Date Joined: 01 August 1960

But this is a little obtuse if the purpose of the form is to allow the user to edit the "Date Joined" value for each band member.  We can whittle the form down by telling the formset to only render the "Date Joined" field [by passing fields=('date_joined',) to modelformset_factory], but then we get this:

Group Name: The Beatles
    Date Joined: 14 August 1962
    Date Joined: 01 August 1960

Now we can't tell to which person each date applies.

Adjusting the form so that the label "Date Joined" was instead the appropriate band members name seems like such a simple thing to change.  But I didn't want to hand-write the form as it was already being automatically built and rendered for me using using modelformset_factory and Crispy-Forms.

It took me most of a day to figure it out and in the end it was pretty simple.  I only need to implement a custom Form that overrides the constructor and sets the label using the object instance before it gets thrown away:

class MembershipForm(forms.ModelForm):
    def __init__(self, *args, **kwargs):
        super(MembershipForm, self).__init__(*args, **kwargs)
        if kwargs['instance'] and kwargs['instance'].person:
            self.fields['date_joined'].label = kwargs['instance']
            self.fields['date_joined'].label = 'No Person'
    class Meta:
        model = Membership
        fields = ['date_joined']

And now our output looks something like:

Group Name: The Beatles
    Ringo Starr: 14 August 1962
    John Lennon: 01 August 1960

Since it took me most of a day to figure this out, and I couldn't find anything specifically addressing this on the Internet, I wrote this up so hopefully the next person (or me in the future once I've forgotten this) will have an easier time figuring it out.

2016 Family Adventure - Part 5: Kidcity & CT Science Center

On Monday, the 17th, we took the girls to Kidcity Children's Museum in Middletown.  Mom was watching Ryan again and brought him with us.  It's a pretty impressive set up; intricately designed rooms with almost all of the equipment in proper working order.  The girls couldn't get enough.  We practically had to drag them out after 3.5 hours.


While wandering about in the science-fiction-y space room Corinne wandered off and got herself stuck in an elevator and freaked out.  Grandma rescued her, but now both our kids probably have elevator complexes.

Heather serving up bowls of water vapor at the bar:2016-10-17_13-29-06


Running the cash register:2016-10-17_13-38-37


"I'm a sea creature!"2016-10-17_13-45-39


The Fishery was pretty cool.  The fish have a screw in their mouths, the conveyor belt has magnets to which you can stick the fish.  We spent a lot of time in the Fishery.  Conveyor belts, sorting baskets, slides, elevators--so much fun!2016-10-17_14-06-42 2016-10-17_14-10-25 2016-10-17_14-24-05


Climbing the monkey bars in the sound room:2016-10-17_14-41-11


Riding the see-saw:2016-10-17_14-42-40


The Medieval Room was also really cool: crossbows, a carrot farm, a corn field, a bread oven, a "water" wheel, building blocks!2016-10-17_14-52-32


Heather put on a puppet show for me:2016-10-17_15-30-21


Snack time:2016-10-17_15-59-36


And one tuckered out Heather at the end:2016-10-17_16-56-24


Then on Tuesday we headed up to Hartford to see the Connecticut Science Center.  The school groups and older kids weren't allowed in the water zone, which made it the perfect place for Heather and Corinne.



And Corinne got herself soaking wet by pouring water all over herself.  So Jess bought a "Sweet as Pi" onesy for her to wear the rest of the day.2016-10-18_11-33-16


Apparently you can get a stream of water to shoot up higher if it hits a surface and then spreads out horizontally instead of falling back down on itself.  Who knew?2016-10-18_11-41-02


Heather giving her green-screen weather report:2016-10-18_12-57-45


Driving the ambulance:2016-10-18_13-29-20


Heather got a personal demonstration about inertia and centrifugal forces:2016-10-18_14-04-41


After the school groups leave they open up the dinosaur-bone digging pits:2016-10-18_14-12-52 2016-10-18_14-31-52


Astronaut Heather ready to explore the solar system.2016-10-18_14-49-51


They had an entire exhibit about Leonardo da Vinci's various inventions:2016-10-18_15-25-18 2016-10-18_15-27-40


The sound exhibit was fun too.  Corinne thought the laser harp was a great place to sit (notice the laser beams on her head).2016-10-18_15-50-07

After a long day of fun at the science museum it was back home to play with cousins in the back yard.

2016-10-18_17-15-16 2016-10-18_17-20-38 2016-10-18_17-24-06 2016-10-18_17-24-30

Up next Newport Mansions.


Let's Encrypt Certbot Cron Job

I switched my webservers over to using Let's Encrypt to obtain SSL certificates.  Everything looked great, but the update job would fail to run from Cron.

At first I had no errors to go on because my systems aren't configured with a mail program so Cron couldn't email me the errors.  Rather than configure a mailer, I just piped the output to another log file by creating a folder under /var/log with permissions for my user and then updating cron so that

[command here] >> /var/log/certbot/certbot_cron.log 2>&1

was at the end of the command.  So my full crontab entry is now:

36 2 * * * /home/kyle/certbot-auto renew --quiet --no-self-upgrade >> /var/log/certbot/certbot_cron.log 2>&1

Then I discovered the job was failing because:

sudo: no tty present and no askpass program specified

I have certbot-auto setup from my regular user account, which works great, except for the cron job.  If I put the cronjob in the root's crontab, it doesn't know about the existing configuration in my user account so it tries to start over.

After some digging around and failing to find an exact solution to this problem I managed to get it running and made this post to help the next poor unfortunate soul.

I edited the sudo rules using:

sudo visudo

And added to the end of the file:

kyle ALL=NOPASSWD:SETENV: /home/kyle/.local/share/letsencrypt/bin/letsencrypt, /usr/sbin/service apache2 *

This allows my account to execute the letsencrypt program and control the apache2 service without providing a password.  SETENV allows it to set environment variables.  I added it to get around the error message:

sudo: sorry, you are not allowed to set the following environment variables: CERTBOT_AUTO

I don't know if this is the best way of getting the cronjob to run, but it seems to be working.  It honestly still isn't clear to me if one should just do all the letsencrypt stuff as root or not.  That would probably avoid this issue, but if that's the case they should just say it somewhere.  Instead it works as non-root, but the cronjob to automatically update it doesn't.  And the automatic updating is kind of the point.

I don't know if it makes a difference, but these servers are running Ubuntu 14.04.

Scientific Models

Something I think gets lost in scientific education is what a "model" truly is.  We blur the line between model and reality until we forget that a model is exactly that--a model.

This conflation of terms is understandable when we talk about things we experience in our day-to-day lives.  We say things like, "when I toss a ball it moves in an arc," and not, "we can model the motion of the ball using an arc."  We don't worry about whether the ball actually moves in an arc or not--that distinction isn't particularly meaningful.

But when we start learning about more complex phenomena the distinction between the model and reality can become very important. A model is simply a representation of some process or phenomenon that we observe.  An acceptable model will match the observed behavior in a consistent, coherent manner.  And a good model will allow us to make accurate predictions about future events.

The "accepted" model for an observed behavior tends towards the model that allows us to make the most accurate predictions.  Utility is the lifeblood of models.

But a model, even one that allows us to make very accurate predictions, may not tell us anything about what's really happening.

I stumbled upon an interesting example of this dichotomy between models and reality while reading Blind Watchers of the Sky.  Through the 16th century it was "known" that celestial bodies moved in circles.  This was an accepted fact because celestial bodies were created by God and uncorrupted by man, God is perfect, and circles are the perfect shape.  The celestial bodies clearly moved, so they must move in circles.  This was the dogmatically accepted model of the time.

With crude measurements the concept of the planets moving in perfect circles seemed to fit well enough.  But, eventually measurements got better and it became clear that they couldn't be moving in just simple circles.  Since the perfect aspect couldn't be challenged, the discrepancies were accounted for using epicycles (smaller circles moving along the larger circle) and other such complexity.

The model became more accurate, but was that truly how the heavens functioned?

Eventually Kepler proposed a radically different model.  But rather than what his new model was, the pertinent part is how he presented it.  He essentially said something like, "Hey everyone, look, we all know circles are perfect, and the heavens are perfect because God created them and God is perfect; I'm not saying anything otherwise.  However, I found out that if we model the motion of the planets using ellipses the calculation is easier and the results are more accurate!"

The argument wasn't whether the planets truly moved in circles or ellipses, that was a foregone conclusion at the time.   Instead it was the presentation of a model that allowed for more accurate predictions.  How the planets really moved didn't particularly matter.


An example I like to use to help separate the concepts of models from reality is this:

There is a thing on my desk.  I believe I can accurately predict how it will behave if I apply the model "spoon" to it.  I pick this object up and use it to eat soup.  My "spoon" model was accurate.  Jess now comes in the room and asks to use the item and proceeds to use this object in a way that no "spoon" I know of can be used.  She uses this thing to stab food and put it in her mouth.  The way she uses it would be better modeled by what I call a "fork."  So is it a spoon or is it a fork?

I could claim that sometimes it's a fork and sometimes it's a spoon.  That seems rather bizarre, yet it matches my observations.  Sometimes it acts like the things we call "spoons" and sometimes it acts like the things we call "forks."  But that doesn't mean it is both or that it transforms from one to the other.  It is what it is.  It only means that these models can both be useful in describing this thing depending on the circumstances.  However, a more accurate model is to realize it's something else entirely.  We need a new model we'll call "spork."


As one attempts to comprehend modern physics one is forced to separate "model" from "reality" if for no other reason than sanity.  When sub-sub-atomic particles were detected and their properties mapped scientists really just needed words to assign to these things they were observing that could only be indirectly observed.  So we ended up with terms like "spin" where nothing is really spinning, and "color" when nothing emits a visible-light wavelength, and other properties.  Then a fundamental set of 6 particles with various values for those properties was identified and needed names and we ended up with "Up", "Down", "Charm", "Strange", "Top", and "Bottom" quarks.

I don't know what reality really is, but we keep building models with greater and greater accuracy that enable us to better predict future events.  At some level the distinction becomes irrelevant, but that's only true right up until reality does something our model says is impossible.  And then, it's time for a new model.


Most people would understand what is meant by saying one is "in the zone."  The psychological concept goes by "flow."  Quoting from Wikipedia,

Flow is the mental state of operation in which a person performing an activity is fully immersed in a feeling of energized focus, full involvement, and enjoyment in the process of the activity. In essence, flow is characterized by complete absorption in what one does.

Mihály Csíkszentmihályi (yah, I have no idea how to pronounce that) wrote a book about flow and describes 6 required factors to achieve flow (borrowed from Wikipedia):

  1. Intense and focused concentration on the present moment
  2. Merging of action and awareness
  3. A loss of reflective self-consciousness
  4. A sense of personal control or agency over the situation or activity
  5. A distortion of temporal experience
  6. Experience of the activity as intrinsically rewarding

I think programming is uniquely suited to the creation of a state of flow.  When working on a programming problem I inherently become more intensely focused as more and more context is pulled in to my working memory.  All the bits and pieces have to be tracked and accounted for.  The more complex the problem the less room there is for extraneous thoughts.

This all-encompassing aspect of working memory feeds into point 2.  I'm not so much typing at a keyboard as I'm modifying the interconnected pieces of the software as they're held in my working memory.  The typing is more a way to capture the changes as I produce them in my head.  But I'm not thinking about the keyboard in any way, it may as well not exist.

As the construction of the software takes over my mental processes I'm forced into letting go a sense of self-consciousness.  There isn't any room in memory or processing power left to worry about it.  It is during these times that others might interrupt me to inform me that I'm whistling or tapping on my desk or some other thing that's bothering them.  I become completely unaware that I'm doing it.  Having a private office at work really helps in this regard.  When I must maintain self-conscious awareness to be courteous to those around me it inhibits the ability to enter a state of flow.

Programming is entirely about personal control over the situation.  It is the programmer's mind being melded with the limitations of the machine and language.  Once the keyboard and the monitor melt away as mere extensions of one's own thoughts and senses it is simply a matter of solving the problems and verifying the solutions.

The time distortion is one of the most fascinating aspects of flow.  While in flow I can work for hours on something and it will feel like just minutes.  Hunger disappears, emails are ignored, music is unheard.  What I've recently been able to observe is the "awakening" process that occurs at the end of flow.

A few weeks ago I was working on a new feature in one of our applications at work.  I had my browser up to test changes as I went, energetic music was playing, my text editor was opened up with all the needed files loaded.  I loaded all the relevant information into my head and began implementing the solution.

As my commits to version control piled up and the task was completed I was aware of the state of flow ending.  It's very much a let down.  Flow is a heightened state of awareness and efficacy.  Coming out of it feels something like rapidly becoming dumber.

As I came out I became aware of the music playing to the point that it became distracting and turned it off.  I glanced at my email inbox and wondered how that many emails had come in without me noticing.  I noticed the time and realized that it was both after time to head home and that I was really hungry.  And, ultimately, I re-entered reality with almost an awed feeling of having lived in a land where thoughts and actions blurred.  Where my abilities were a cut above the normal day-to-day levels.

Achieving flow is not something that happens daily for me.  It can be weeks between sessions.  But when I can achieve flow it reminds me how enjoyable problem solving can be.  Writing software is the medium, but not the goal.  I believe it's the satisfaction of finding and implementing solutions that drives flow for me.