briankip

# -*- coding: utf-8 -*-
"""
This script will delete all of the tweets in the specified account.
You may need to hit the "more" button on the bottom of your twitter profile
page every now and then as the script runs, this is due to a bug in twitter.

You will need to get a consumer key and consumer secret token to use this
script, you can do so by registering a twitter application at https://dev.twitter.com/apps

@requirements: Python 2.5+, Tweepy (http://pypi.python.org/pypi/tweepy/1.7.1)

briankip

delete from iblis.testtype_measures where test_type_id = 192;
delete from iblis.testtype_specimentypes where test_type_id = 192;
delete from iblis.test_types where id = 192;
delete from iblis.testtype_measures where test_type_id = 181;
delete from iblis.testtype_specimentypes where test_type_id = 181;
delete from iblis.test_types where id = 181;
delete from iblis.testtype_measures where test_type_id = 184;
delete from iblis.testtype_specimentypes where test_type_id = 184;
delete from iblis.test_types where id = 184;
delete from iblis.testtype_measures where test_type_id = 185;

briankip

BS for mps
GXM
Direct COOMBS test
Full Haemogram
Creatinine
Electrolytes
Urea
HB
RFTS
Pregnancy test

briankip

#!/bin/bash
stty -F /dev/ttyS0 19200 parenb
cat /dev/ttyS0 >| /var/www/celtac/celtac-results.txt

briankip

########################################################################
# Minicom configuration file - use "minicom -s" to change parameters.
pu port             /dev/ttyS0
pu baudrate         9600
pu bits             8
pu parity           N
pu stopbits         1
pu rtscts           No
########################################################################

briankip

#!/usr/bin/env python

import sys
import time
import serial
from threading import Thread

class RawInput:
	"""Gets a single character from standard input.  Does not echo to the screen."""
	def __init__(self):

briankip

#!/bin/bash
nohup cat /dev/ttyS0 > /var/www/sysmex/sysmex.dump

briankip

14/ 7/1617:34 000000000007Zÿÿÿÿÿÿ 3Ý7°ù
9X
WY8Ý-¨g
2q  5.1 2.21  5.5 17.6 79.6 24.9 31.3   88 34.3  8.9 56.8  1.7  0.5  2.9 22.1 55.7 16.8 10.3 30.6 62.5154.9 -----        ++                                       
EdbA"#3DRSNG9)







!8Q_d^P?4) 	



3N^ddYLE</&  &+8EYddddd11
        
 C10                       U£

briankip

-- RUN THESE ONLY ONCE

-- INDEXING TEST TABLE 

-- Helps improve performance

alter table blis_301.test add index (external_lab_no);


-- PRELIMINARY MIGRATION BEFORE MIGRATING REJECTION REASONS AND SPECIMEN

briankip

-- Script to migrate patients data from old-blis to new blis
-- 0 warnings
-- Some records have no calculatable date of birth, I have put the DOB as the timestamp


insert into iblis.patients 
	(patient_number, name, dob, gender, external_patient_number, created_at)

select  patient_id, name, 
	(case WHEN dob = '0000-00-00'