Skip to content

Instantly share code, notes, and snippets.

bmaiyo briankip

  • Kenya
Block or report user

Report or block briankip

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View delete_all_tweets.py
# -*- 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
briankip / deleteMeasures.sql
Last active Aug 29, 2015
Measures that are tests
View deleteMeasures.sql
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;
View tests-list.txt
BS for mps
GXM
Direct COOMBS test
Full Haemogram
Creatinine
Electrolytes
Urea
HB
RFTS
Pregnancy test
View celtac.sh
#!/bin/bash
stty -F /dev/ttyS0 19200 parenb
cat /dev/ttyS0 >| /var/www/celtac/celtac-results.txt
@briankip
briankip / minicom.conf
Last active Aug 29, 2015
Minicom config file
View minicom.conf
########################################################################
# 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
briankip / baudrate.py
Created Feb 3, 2015
Baudrate detection for serial devices
View baudrate.py
#!/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
briankip / sysmexdeamon.sh
Created Feb 3, 2015
Deamon for the sysmex machine
View sysmexdeamon.sh
#!/bin/bash
nohup cat /dev/ttyS0 > /var/www/sysmex/sysmex.dump
@briankip
briankip / sysmex.txt
Created Feb 3, 2015
Sysmex dump file
View sysmex.txt
14/ 7/1617:34 000000000007Zÿÿÿÿÿÿ 3Ý7°ù9XWY8Ý-¨g2q 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
briankip / migrations.sql
Last active Aug 29, 2015
All migration scripts fro old blis to new blis
View migrations.sql
-- 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
briankip / PatientsTableMigrations.sql
Created Jan 7, 2015
Migration script for the patients table
View PatientsTableMigrations.sql
-- 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'
You can’t perform that action at this time.