Tooltron

"""

  This file is part of Tooltron.

  Tooltron is free software: you can redistribute it and/or modify

  it under the terms of the Lesser GNU General Public License as published by

  the Free Software Foundation, either version 3 of the License, or

  (at your option) any later version.

  Tooltron is distributed in the hope that it will be useful,

  but WITHOUT ANY WARRANTY; without even the implied warranty of

  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

  Lesser GNU General Public License for more details.

  You should have received a copy of the Lesser GNU General Public License

  along with Tooltron.  If not, see <http://www.gnu.org/licenses/>.

  Copyright 2009 Bradford Neuman <bneuman@andrew.cmu.edu>

"""

#!/usr/bin/python

import MySQLdb

import re

import getpass

tools = {

   'Bandsaw':'1',

   'DrillPress':'2',

   'Mill':'3',

   'Lathe':'4',

   'Welder':'5',

   'CircSaw':'6',

   'ChopMiterSaw':'7',

   'JigSaw':'8',

   'Router':'9'}

pw = getpass.getpass("mysql password: ")

db = MySQLdb.connect(host="roboclub8.frc.ri.cmu.edu", user="tooltron", passwd=pw, db="civicrm")

print "connected, now accepting input"

#TODO: errors!

cursor = db.cursor()

qry = "SELECT tools_6 FROM civicrm_value_roboclub_info_2 WHERE card_number_1 = "

while True:

    #    id_s = raw_input("ID# ")

    s = raw_input()

    id = re.search('%([0-9]*)=.*', s)

    if id != None:

        id_s= id.group(1)

        try:

            int(id_s)

        except ValueError: #make sure it's a number to avoid XKCD #327

            print "Error, could not convert '", id_s , "' to an integer"

            continue

        cursor.execute(qry + id_s)

        result = cursor.fetchall()

        for r in result:

            tls = r[0].split("\x01")

            for t in tls:

                if t != '':

                    try:

                        print t, "=", tools[t]

                    except KeyError:

                        print "could not find key!"

print db