This one is the easiest of the routes. Specified in article 22.

Requirements:

1. Member is more than 2 months behind on dues.
2. Send reminder that they are behind on dues.
3. Pass resolution at board meeting to dismember them.

Articles don't specify a timeline for the steps but they do have to happen in that order (and it's good idea to leave a decent interval between reminder and actually dismembering folks so they can respond to the reminder).

Swap out dummy list of people to send to for the list from the hub page of folks behind on dues.

#+BEGIN_SRC python
# -*- coding: utf-8 -*-

from email.MIMEText import MIMEText
from localSettings import *
import smtplib
from jinja2 import Environment

email = """
Hello from 57North Hacklab,

Our records don't show any payments from you since {{ last_payment }}. That is long enough ago that you're on the list of people who can have their membership terminated by the board. We're planning to be going through that list at a board meeting {{ meeting }}. 

If you think there should be payment(s) more recently than that: please get in touch (57north-ctte-private@lists.57north.org.uk) with when and how you paid and we can look into why it didn't get recorded. 

We don't like terminating memberships so we haven't since September 2014, this has led to the member list having people on it that we know have moved away, and others that we haven't seen for quite a while. It really is time we cleaned this up.

If you don't want to keep up your membership please let us know at 57north-ctte-private@lists.57north.org.uk

If you do want to continue being a member: please pay. Our preferred mechanism to receive money is via bank transfer (details in hub, or below) or you can give cash to a director. If you won't be able to do that before the meeting, but do intend to be back in the near future: get in touch (57north-ctte-private@lists.57north.org.uk), we can possibly be a bit more flexible.

If you're a bit behind we don't necessarily expect you to pay all of the back dues to avoid having your membership terminated - though if you want to we'll certainly appreciate the money. We are happy to consider you back in "good standing" if you pay for this month and last.

Thanks,
The 57North Hacklab Ltd. board of directors.

Bank transfer details:
Account name:           57North Hacklab Ltd.
Account number:	        11 088 091
Sort code:	        83-15-31
Payment reference:	{{ username }}
Payment:                GBP 20.00 monthly on/soon after the 1st of every month

57North Hacklab Ltd. is a company registered in Scotland (No. SC470230).
57North and 57North Hacklab are trading names of 57North Hacklab Ltd.

"""

dummy = [{'username':'someone', 'email':'someone@example.com', 'last_payment':'None'}]

def send(subject, message, recipient):
    try:
        message = MIMEText(message)
        message['Subject'] = subject
        message['From'] = addr
        message['To'] = recipient
        message['Reply-To'] = '57north-ctte-private@lists.57north.org.uk'
        
        server = smtplib.SMTP(mailserver)
        server.starttls()
        server.login(user, passwd)
        server.sendmail(addr, [recipient, bcc, "57north-ctte-private@lists.57north.org.uk"],
                        message.as_string())
        server.close()
    except Exception, ex:
        print "Failed to send email."
        print ex

if __name__=="__main__":
    for person in dummy:
        print "Emailing ", person['username']
        send("57North membership",
             Environment().from_string(email).render(
                 last_payment=person['last_payment'], username=person['username'],
                 meeting="19:30 Thursday 16th March 2017"),
             person['email'])
#+END_SRC

Article 30 lets the membership expel a member for any reason.

Can only be done at a general meeting.

Notice of resolution to expel them has to be sent to member(s) to be expelled at least 21 days before the meeting, and must specify grounds for expulsion.

Needs a 2/3 majority of those voting at the general meeting.

Member to be expelled gets to be heard on the resolution at the meeting.

Members can be temporarily suspended by the board under article 31.

To update hub that someone has been dismembered add an entry to the dismembered table with their username, timestamp and reason. Leave date_reset and reason_reset blank, these get filled in to undismember them again.

Example script to dismember a list of members:

#+BEGIN_SRC python
from hackhub import get_db
import time

to_dismember = ["someone", "someoneelse"]
reason = "Dues in arrears"
timestamp = int(time.time())

if __name__=="__main__":
    db = get_db()
    cur = db.cursor()
    for u in to_dismember:
        cur.execute("INSERT INTO dismembered (user, timestamp, reason) VALUES (?, ?, ?)", 
        (u, timestamp, reason))
    db.commit()
    db.close()


#+END_SRC