DarrenFrenkel

Keybase proof

I hereby claim:

• I am darrenfrenkel on github.
• I am darrenfrenkel (https://keybase.io/darrenfrenkel) on keybase.
• I have a public key ASCqFcHA6cd0askin78JPjvlppHA3AS1VvKkrqfHjuWZzAo

To claim this, I am signing this object:

DarrenFrenkel

## Sync Issues

* Reserved timeslots showing as available (purple slots)
* Some appts for existing patients are showing as available

## Reason for Sync Issues

* Zedmed upgrade
* Change in the HS agent

DarrenFrenkel

import firebirdsql
import sys
import csv

patient_ids = [ "'" + str(row['PATIENT_ID ']) + "'" for row in csv.DictReader(sys.stdin)]
    
conn = firebirdsql.connect(host='127.0.0.1',
        database=r'C:\Users\Penina\Documents\Superplus\Superplus',
        user='SYSDBA',
        password='masterkey')

DarrenFrenkel

Update your database clients or applications to use a new SSL certificate.

Adding Certificate onto Root of Webapp Server

scp ~/Download/rds-combined-ca-bundle.pem username@host:/usr/local/share/ca-certificates/
ssh into webapp server
sudo mv /usr/local/share/ca-certificates/rds-combined-ca-bundle.pem /usr/local/share/ca-certificates/rds-combined-ca-bundle.crt
sudo update-ca-certificates

DarrenFrenkel

Host carina
    Hostname ip-10-0-5-86.ap-southeast-2.compute.internal
    ProxyCommand ssh meteorhosts-gw-ap-southeast-2a.commoncode.com.au nc %h %p

Host vela
    Hostname ip-10-0-4-145.ap-southeast-2.compute.internal
    ProxyCommand ssh meteorhosts-gw-ap-southeast-2a.commoncode.com.au nc %h %p

Host healthsite-web-1.tunnel
    Hostname ip-10-15-2-82.ap-southeast-2.compute.internal

DarrenFrenkel

class RegisterCourt(FormView):
    template_name = "registration/register_courts.html"
    form_class = CourtRegistration

    def get_context_data(self, *args, **kwargs):
        venue_id = self.kwargs.get('venue_id', None)
        form = kwargs.get('form', None)
        courtsignup = True
        try:
            venue = Venue.objects.get(pk=venue_id)